PHP and MySQL

After our introductive PHP language guide, let's dig deeper into database access and data extraction. So, here's a complete guide with practical examples to examine and understand the fundamental functions for the interaction between PHP and MySQL, using the PDO and MySQLi extensions.

Introduction: MySQL functions, MySQLi and PDO

MySQLi extension

PDO extension

  • PDO introduction
  • PDO vs. MySQLi
  • PDO: development environment setup
  • Connection to MySQL database with PDO
  • PDO: database write operations
  • PDO: database data extraction
  • PDO: transaction

A complete application with MySQLi

  • PHP and MySQLi: database table and connection
  • PHP and MySQLi: form and data insertion
  • PHP and MySQLi: data extraction and pagination
  • PHP and MySQLi: detail, update and delete records

A complete application with PDO

  • PHP and PDO: database table and connection
  • PHP and PDO: records list and pagination
  • PHP and PDO: detail, update and delete records

Create a CMS with PHP and PDO

  • CMS with PHP and PDO: tables creation
  • CMS with PHP and PDO: create a table for data structure
  • CMS with PHP and PDO: PHP class for data management
  • CMS with PHP and PDO: data extraction
  • CMS with PHP and PDO: news page
  • CMS with PHP and PDO: new record insertion
  • CMS with PHP and PDO: form creation methods, text inputs
  • CMS with PHP and PDO: form creation methods, textarea and select/li>
  • CMS with PHP and PDO: database data insertion
  • CMS with PHP and PDO: error, password and validation management
  • CMS with PHP and PDO: detail and delete records

Export and import data

  • PHP and MySQL: export data in CVS format
  • PHP and MySQL: import data from CVS format