- 01. Introduction
01_01-Welcome
01_02-What you should know before watching this course
01_03-Using the exercise files
01_04-Setting SQLite permissions
01_05-A quick primer on using PHP objects
Downlaod >> 01. Introduction : Password For 7zip is AlbDll.com
-----------------------------------------------------------
- 02. Why Use Object-Oriented PHP to Access a Database 02_01-Overview of PHP database APIs
02_02-Using prepared statements
02_03-Using transactions
Downlaod >> 02. Why Use Object-Oriented PHP to Access a Database : Password For 7zip is AlbDll.com
-----------------------------------------------------------
- 03. PHP Data Object (PDO) Basics
03_01-Creating a database source name
03_02-Connecting to a database with PDO
03_03-Looping directly over a SELECT query
03_04-Fetching a result set
03_05-Finding the number of results from a SELECT query
03_06-Checking if a SELECT query contains results
03_07-Executing simple non-SELECT queries
03_08-Getting error messages
03_09-Using the quote() method to sanitize user input
Downlaod >> 03. PHP Data Object (PDO) Basics : Password For 7zip is AlbDll.com
-----------------------------------------------------------
- 04. PDO-Prepared Statements and Transactions
04_01-Binding input and output values
04_02-Using named parameters
04_03-Using question marks as anonymous placeholders
04_04-Passing an array of values to the execute() method
04_05-Binding results to variables
04_06-Executing a transaction
04_07-Closing the cursor before running another query
Downlaod >> 04. PDO-Prepared Statements and Transactions: Password For 7zip is AlbDll.com
-----------------------------------------------------------
05_01-Generating an array from a pair of columns
05_02-Setting an existing object`s properties with a database result
05_03-Creating an instance of a specific class with a database result
05_04-Reusing a result set
Downlaod >> 05. Advanced PDO Fetch Methods: Password For 7zip is AlbDll.com
-----------------------------------------------------------
- 06. MySQL Improved Basics
06_01-Connecting to a database with MySQLi
06_02-Setting the character set
06_03-Submitting a SELECT query and getting the number of results
06_04-Fetching the result
06_05-Rewinding the result for reuse
06_06-Handling non-SELECT queries
06_07-Getting error messages
06_08-Sanitizing user input with real_escape_string()
Downlaod >> 06. MySQL Improved Basics: Password For 7zip is AlbDll.com
-----------------------------------------------------------
07_01-Initializing and preparing a statement
07_02-Binding parameters and executing a prepared statement
07_03-Binding output variables
07_04-Executing a MySQLi transaction
07_05-Dealing with commands out of sync in prepared statements
Downlaod >>07. MySQLi Prepared Statements and Transactions: Password For 7zip is AlbDll.com
-----------------------------------------------------------
- 08. Diving Deeper into MySQLi
08_01-Buffered and unbuffered queries
08_02-Using real_query()
08_03-Freeing resources that are no longer needed
08_04-Submitting multiple queries
08_05-Creating an instance of a class from a result set
-----------------------------------------------------------
09_01-PDO and MySQLi compared
-----------------------------------------------------------
Downlaod >> - Exercise Files: Password For 7zip is AlbDll.com
-----------------------------------------------------------
Downlaod All Pacpage >> Accessing Databases with Object-Oriented PHP Tutorial: Password For 7zip is AlbDll.com (If you have error to extract with wirar ,extract with 7zip is Good)