Tags
Language
Tags
March 2024
Su Mo Tu We Th Fr Sa
25 26 27 28 29 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31 1 2 3 4 5 6

Lynda - Accessing Databases with Object-Oriented PHP

Posted By: U.N.Owen
Lynda - Accessing Databases with Object-Oriented PHP

Lynda - Accessing Databases with Object-Oriented PHP | 872MB
Duration: 3h 48m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 44.1KHz 1ch
Genre: eLearning | Level: Intermediate | Language: English

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.

* 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 fetch 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

Lynda - Accessing Databases with Object-Oriented PHP

No mirrors below please.
Download @Uploaded.net: Folder

Mirror @OBoom: Folder