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

Web development tutorial

MySQLi Server Behaviors series

Tutorial created by Kate Ford

Categories: MySQLi Server Behaviors, Dreamweaver, PHP

rating

In the WebAssist MySQLi Server Behavior series, you will find an overview of four in-depth tutorials to help you transition to MySQLi so that your websites with custom database driven pages will continue to work when the next version of PHP is released. The following tutorials in the MySQLi Server Behaviors series demonstrate how to insert, update, and delete records, add user authentication, record count, pagination links, and show if statements. Additionally, you will learn to use WebAssist's Data Modeling interface and Query Builder tool.

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

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

Sign in to add comments
rating
rating

: 1 Year, 3 Months, 3 Weeks, 1 Day, 7 Hours, 44 Minutes ago

So far....none of this works for me. But, it is probably me.

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.