MySQL 4.1.3 Database(or higher) and PHP 5 Are Required For This Course

Getting Started with MySQLi + PHP Programming
• What is a MySQL Database? And why would I use it?
• PHPMyAdmin: MySQL Database Management Software
• Creating a MySQL Database On Your Host Web Server
• MySQL Data Types
• MYSQL_* vs. MYSQLI_*
• Back Up or Manually Make Copy of MySQL Databases Just in Case You Lose It

Basics of Interacting with Your MySQL Database Through PHP Script
• Connecting to Your MySQL Databases Using mysqli_ for PHP 5 and Higher
• Closing a MySQL Connection
• Creating Tables Through Script
• Inserting Information into a MySQL Database
• Output or Retrieve Database Information
• Modify Existing Database Information
• Freeing or Closing Query Result Sets

MySQL Query Examples and Data Requests
• Obtain a Table Row Count
• Obtain a Table Row Count From a Query Result Set
• Using LIMIT to Obtain a Specific Result Set
• Using the WHERE Clause with SELECT to Target Data
• Selecting Individual Fields for Optimized Queries
• Show Alternate Field if Target Field is Empty



You are now ready to follow all of the video tutorials for PHP and MySQL