PHP Accessing Databases with PDO and MySQLi

Overview of PHP database APIs Creating a database source name Connecting to a database with PDO Connecting to a database with MySQLi

Using prepared statements Initializing and preparing a statement Binding parameters and executing a prepared statement Binding input and output values Binding results to variables Passing an array of values to the execute() method

Using transactions Executing a transaction Executing a MySQLi transaction Closing the cursor before running another query Dealing with -commands out of sync- in prepared statements

Fetching a result set Fetching the result Finding the number of results from a SELECT query Getting error messages Getting error messages_2 Freeing resources that are no longer needed Generating an array from a pair of columns Looping directly over a SELECT query Reusing a result set Rewinding the result for reuse Submitting a SELECT query and getting the number of results Using named parameters Using question marks as anonymous placeholders Using real_query() Using the quote() method to sanitize user input Submitting multiple queries Sanitizing user input with real_escape_string() Setting an existing object’s properties with a database result Setting the character set