Server Behavior Interfaces

MySQLi recordset interfaces

Create MySQLi recordsets using an interface nearly identical to Dreamweaver's deprecated MySQL simple and advanced recordset interfaces. Select your database connection and build basic queries in simple mode or build complex, custom queries in advanced mode. The interface will generate a MySQLi recordset on your PHP page for you.

In the advanced recordset mode above, you can click on the Query Builder button and enter an interface never before available in Dreamweaver. The all new Query Builder will launch, helping you to create complex queries without hand coding, simply by drawing database relationships in a diagram. Instead of writing your SQL manually, drag and drop tables and connections; click checkboxes to add columns; and click to bind values to WHERE clauses. You can also use the advanced builder at the bottom of the Query Builder interface to click on a SQL statement should you want to make further edits.

Note: The Query Builder requires Dreamweaver CS6 or newer.

Watch video demonstrating how to use the MySQLi Query Builder and Data Modeling tool »

A stand alone data modeling interface is also available to set up joins, which will be automatically applied whenever you add tables in your MySQLi recordsets.

Note: The Data Modeling interface requires Dreamweaver CS6 or newer.

Watch video demonstrating how to use the MySQLi Query Builder and Data Modeling tool »

Repeat region

Choose your MySQLi recordset to display a specific set of results on a PHP page. You can specify how many records to display to a user at a time.

Insert, update, delete records

Use the data management server behaviors to allow users to insert, update or delete data in your database from a PHP page. From the individual insert, update and delete interfaces, you can choose a trigger, such as a form post, and specify how to manipulate records in your database.

Example: You may have a form on your user profile page, where the user can update their contact information. In Dreamweaver, you would open the update record server behavior interface and specify that the submit button should trigger specific columns to be updated for a specific record. The MySQLi code would be generated on your PHP page. When the user visits their profile page, edits the form and clicks submit, your database would automatically get updated.

Record count

Choose your MySQLi recordset to display record numbers on a result page. You can display a starting record number, ending record number or the total number of records returned from a query.

Recordset paging

Create links on your PHP page to create navigation on a results page, allowing users to page through results returned from your MySQLi recordset. Add Move to First Page, Move to Last Page, Move to Next Page and Move to Previous Page links.

Show if regions

Select something on your PHP page and use the Show If server behaviors to show an element, specific data or some region based on your MySQLi recordset. Options include: Show If First Page, Last Page, Not First Page and Not Last Page, as well as Show if Recordset Is Empty and Show if Recordset Is Not Empty.

Example: You have a recordset created that returns product details based on the product ID in the URL. If the recordset is empty (say, that product ID doesn't exist), you may want to show the user a specific message that the product doesn't exist and give them a continue shopping link, whereas if the recordset is not empty (product ID exists), you want to display the product image and details.

User authentication

The MySQLi user authentication server behaviors allow you to generate code on a PHP page to log in or log out users stored in your database. You can also check if a username exists with the Check New Username server behavior and you can restrict access to a specific page based on user credentials.