close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Server Behavior Interfaces

Quickly generate MySQLi code in Dreamweaver

MySQLi Query Builder

Server behaviors are no longer built into the newer versions of Dreamweaver, making it difficult to create and maintain PHP websites. Additionally, the old Dreamweaver versions produce MySQL code, which is now deprecated.

The MySQLi Server Behaviors extension helps you generate streamlined MySQLi functionality so you can continue building PHP websites. This Dreamweaver extension includes the following interfaces:

 
 
arrow downMySQLi 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.

MySQLi User Interface

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 »

MySQLi User Interface


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 »

MySQLi Data Modeling
 
arrow downRepeat 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.

MySQLi User Interface
 
arrow downInsert, 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.

MySQLi User Interface
 
arrow downRecord 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.

MySQLi User Interface
 
arrow downRecordset 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.

MySQLi User Interface
 
arrow downShow 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.


MySQLi User Interface
 
arrow downUser 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.

MySQLi User Interface

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.