Build a simple recordset Dreamweaver and PHP


show more Building a simple recordset provides you with in-depth training on Business. Taught by David Gassner as part of the Dreamweaver with PHP and MySQL show less
please wait ...

Building a simple recordset

Once you have defined a database connection, you're ready to retrieve data from your MySQL database. Dreamweaver makes it easy to build simple SQL statements to do this work for you. SQL stands for Structured Query Language, and it's the standard that's used to communicate with the database from any application environment. To get started with SQL, open any PHP file. I am working with the file simplers.php, which you'll find in the root folder of this site. In the Bindings panel, there is a Plus button that lets you create what Dreamweaver refers to as a binding.

A binding is a definition of dynamic data. I'll click the Plus button and choose Recordset (Query). The Recordset dialog box has two modes: Simple and Advanced. If this is the first time you've used this dialog, you'll see the Simple version. You enter the name of the recordset, select a connection, choose a table in that database, and then supply other parameters. There is a button labeled Advanced, and w...

Building a simple recordset
Video duration: 4m 31s 4h 55m Intermediate Updated Jun 12, 2012

Viewers:

Building a simple recordset provides you with in-depth training on Business. Taught by David Gassner as part of the Dreamweaver with PHP and MySQL

Subjects:
Business Developer Web
Software:
Dreamweaver
Author:
please wait ...