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.
Learning Objectives
Work with a MySQL database with PHP to build applications that depend on a database connection. This course covers all required elements of MySQLi from working with data to security.
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).
