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