Accessing Databases with Object-Oriented PHP Tutorial

- 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. Advanced PDO Fetch Methods

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. MySQLi Prepared Statements and Transactions


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 

 Downlaod >>08. Diving Deeper into MySQLi:  Password For 7zip is AlbDll.com

-----------------------------------------------------------

- 09. Conclusion


09_01-PDO and MySQLi compared

 Downlaod >>09. Conclusion:  Password For 7zip is AlbDll.com

-----------------------------------------------------------

 -  Exercise Files

 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)