Course Overview
The course teaches MySQLi, a way to connect to databases within PHP. It covers connecting to the database, and using all the features required to build fast, scalable applications that use a database connection. It covers essential concepts like security, and best practices with using the data retrieved from the database.
Benefits of MySQLi
An object-oriented interface
Support for prepared statements
Support for multiple statements
Support for transactions
Enhanced debugging support
Embedded server support
A knowledge of PHP and MySQL is recommended for this course.
Target Audience
Anyone with basic knowledge of PHP, database experience not required but is helpful, as this is demonstrated.
Requirements
The learner will require a webserver (Apache or Nginx) with PHP 4.1 or greater (although a higher, preferably the latest version, is better), and MySQL installed.
Students will also require database management software such as Sequel Pro (Mac), HeidiSQL (Windows) or MySQL workbench (Linux).