LEARN MySQL

Introduction to MySQL Programming With PHP

   • What is a MySQL Database? And why would I use it?
   • PHPMyAdmin: MySQL Database Management Software
   • Creating a MySQL Database In Your Hosting Control Panel
   • MySQL Data Types
   • Back Up or Manually Make Copy of MySQL Databases Just in Case

Basics of Interacting with Your MySQL Database Through PHP Script

   • Connecting to Your Database
   • Closing a MySQL Connection
   • Creating Tables Through Script
   • Insert Information into a MySQL Database
   • Output or Retrieve Database Information
   • Update Existing Database Information
   • Freeing Result Sets for Large Data Queries

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


Don't forget all of the video tutorials we have for PHP and MySQL

Or you may sample the new improved MySQLi_ family of functions below.

LEARN HOW TO USE THE MySQLi FUNCTIONS
MySQL 4.1.3 Database(or higher) and PHP 5 Are Required


What Is the Difference Between mysql_ and mysqli_

   • mysql_* vs. mysqli_*

Basics of Interacting Using MySQLi

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

MySQLi Query Examples and Data Requests

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