In this video we'll take a look at how to turn the Apache web server and the MySQL database on and off as needed. We'll also take a look at the administrative area of the Apache server to be sure it was installed correctly.
This chapter will introduce you to the environment we will be setting up in order to work with dynamic websites and the topics that will be covered in the course.
Introduction
In this video you'll get a brief introduction to the course and the topics it covers.
Dynamic web page development requires a complete server environment. In this lesson we will install MAMP for the Mac or XAMPP for Windows, both of which allow us to install everything we need for dynamic development in a single package.
In this lesson you'll learn how to install XAMPP on your Windows system. This product allows you to install the Apache Web Server, PHP, and MySQL in a single install.
In this lesson you'll learn how to install MAMP on your Mac system. This product allows you to install the Apache Web Server, PHP, and MySQL in a single install.
In this video we'll take a look at how to turn the Apache web server and the MySQL database on and off as needed. We'll also take a look at the administrative area of the Apache server to be sure it was installed correctly.
This chapter covers PHP coding basics and shows you the various options for previewing your pages within Dreamweaver. You'll learn how to work in PHP and create variables to use in your web pages.
Working with Server-Side Code
In this lesson you'll learn the difference between a PHP page and an HTML page and see how to create a PHP page.
In this chapter you'll learn more about working in dynamic pages and how to pass data from one web page to another. We'll also look at working with dynamic features in Dreamweaver in order to speed up development.
Passing Data Between Pages
HMTL has some limitations that you need to know about. This video discusses those limitations and how to set up coding to allow one page to send information to a second page.
In this video we'll walk through creating a connection to view the course database from within Dreamweaver. We can use this panel to view the details about tables, fields, and table data.
In this video we'll take a look at SQL, the language of the database. You'll learn more about the four basic SQL statements you need to work with a database.
In this lesson you'll learn how to get Dreamweaver to create a query that pulls data out of the database and displays all of the data from that query on your web page.
Server behaviors are a feature built into Dreamweaver to make working with dynamic pages easier. This chapter will show you some server behaviors and how you can use them in your web pages.
Creating Data-Driven Pages
Server behaviors are snippets of code that Dreamweaver can create for you to perform a specific task. In this lesson you'll learn where the Server Behavior panel is located and be introduced to some of the tasks that server behaviors can perform for you.
Dynamic tables in Dreamweaver allow you to easily display query data in tables on your pages. In this lesson you'll learn how to work with this great feature.
Recordset paging allows the user to navigate through database data across multiple pages. Is this video you'll see how easy this feature is to add to your pages and customize as needed.
Dreamweaver offers many features for dynamic development, one of which is the master-detail page set feature. This feature allows us to create one recordset and populate two pages with information from the query.
Forms are the only way to gather data from a user. In this chapter we'll create forms in Dreamweaver and use web-based forms to insert and update data within a database.
Dynamic Forms
Creating a form for a website can involve a number of different pages and should be planned in advance. In this video we'll look over an existing form to determine how we can improve it.
In this video we'll create a form to insert data into a database and use the Insert Record server behavior in Dreamweaver to build the code to add form information to the database.
In this lesson you'll learn how to use a server behavior and Dreamweaver features to modify database data using a form that updates the database with new data.
In this chapter you'll get some closing thoughts from the author and some suggestions on where to go from here.
Conclusion
This course has shown you the many features within Dreamweaver that can help you work with dynamic websites. Once you begin moving into dynamic development, you will want to expand your PHP skills in order to add additional features to your site.
Android
Apple iPad
