Lynda - Accessing Databases with Object-Oriented PHP Tutorial

Lynda - Accessing Databases with Object-Oriented PHP Tutorial

================
[COVER:]
================



================
[INFO:]
================


Lynda - Accessing Databases with Object-Oriented PHP Tutorial
3h 47m | Intermediate | Jul 07, 2014
Size: 809.136 MB

Now that PHP has true object-oriented capabilities, it's best practice to access databases using PDO (PHP Data Objects) and MySQLi. These methods produce database-neutral code that works with over a dozen systems, including MySQL, SQL Server, PostgreSQL, and SQLite. Learn how to use PDO and MySQLi to perform basic select, insert, update, and delete operations; improve security with prepared statements; and use transactions to execute multiple queries simultaneously. Author David Powers also covers advanced topics like instantiating custom objects, and compares PDO to MySQLi so you can decide which method is right for you.


Topics include:

- Connecting to a database with PDO or MySQLi
- Fetching a result set
- Executing simple non-SELECT queries
- Sanitizing user input
- Binding input and output values
- Passing an array of values to the execute() method
- Working with advanced PDO methods
- Executing a MySQLi transaction
- Freeing resources that are no longer needed
- Submitting multiple queries
- Creating an instance of a class from a result set


Please use 7Zip/WinRAR/Universal Extractor to EXTRACT FILES

If You Like This Torrent Support the Authors by Purchasing It!.. Thanx