MySQLi Server Behaviors series

Tutorial created by Ray Borduin, WebAssist

Categories: MySQLi Server Behaviors, Dreamweaver, PHP

4 ratings | Sign in to rate this tutorial | View comments

MySQLi Server Behaviors series

1. Insert, update, and delete records: In the first tutorial of the MySQLi Server Behaviors series, you will learn about the data management interface that allows users to insert, update, and delete data in a database from a PHP page. From the individual insert, update, and delete interfaces, users can choose a trigger, such as a form post, and specify how to manipulate records in a database.
   
   
   
   
   Learn more at Insert, update, and delete records with MySQLi Server Behaviors.
   
   
2. User authentication: In the second tutorial of the MySQLi Server Behaviors series, you will learn about the MySQLi user authentication interface that allows users to generate code on a PHP page to log in or log out users stored in the database. Users can also check if a username exists with the Check New Username server behavior and restrict access to a specific page based on user credentials.
   
   
   
   
   Learn more at User authentication with MySQLi Server Behaviors.
   
   
3. Data Modeling and Query Builder: In the third tutorial of the MySQLi Server Behaviors series, you will learn about the stand alone Data Modeling interface that allows users to set up joins which will be automatically applied whenever tables are added in the MySQLi recordsets. The Query Builder tool allows users to drag and drop database tables onto a grid and create relationships between database tables to create advanced SQL statements.
   
   
   
   
   Watch video demonstration of MySQLi Data Modeling and Query Builder tool.
   
   
4. Getting started guide: In the Getting started guide for MySQLi Server Behaviors, you will learn how to generate a simple results page by creating a recordset, adding a binding to a PHP page, and wrapping a repeat region around that binding. Then you'll be walked through adding a record count, pagination links, and show if statement. Once you understand the concepts, you can build on your knowledge to create custom database driven pages for your website.
   
   
   
   
   Learn more at Getting started with MySQLi Server Behaviors.

Reviews and comments

Comments will be sent to the author of this tutorial and may not be answered immediately. For general help from WebAssist, please visit technical support.

4 ratings | Sign in to rate this tutorial