Lynda Com - Accessing Databases with Object-Oriented PHP Tutorial
File List
| File | Size |
|---|---|
| 01. Introduction/01_01-Welcome.mp4 | 9.54 MB |
| 01. Introduction/01_02-What you should know before watching this course.mp4 | 3.07 MB |
| 01. Introduction/01_03-Using the exercise files.mp4 | 16.67 MB |
| 01. Introduction/01_04-Setting SQLite permissions.mp4 | 2.7 MB |
| 01. Introduction/01_05-A quick primer on using PHP objects.mp4 | 10.03 MB |
| 02. Why Use Object-Oriented PHP to Access a Database/02_01-Overview of PHP database APIs.mp4 | 11.29 MB |
| 02. Why Use Object-Oriented PHP to Access a Database/02_02-Using prepared statements.mp4 | 9.32 MB |
| 02. Why Use Object-Oriented PHP to Access a Database/02_03-Using transactions.mp4 | 3.78 MB |
| 03. PHP Data Object (PDO) Basics/03_01-Creating a database source name.mp4 | 4.79 MB |
| 03. PHP Data Object (PDO) Basics/03_02-Connecting to a database with PDO.mp4 | 31.36 MB |
| 03. PHP Data Object (PDO) Basics/03_03-Looping directly over a SELECT query.mp4 | 14.94 MB |
| 03. PHP Data Object (PDO) Basics/03_04-Fetching a result set.mp4 | 35.93 MB |
| 03. PHP Data Object (PDO) Basics/03_05-Finding the number of results from a SELECT query.mp4 | 32.19 MB |
| 03. PHP Data Object (PDO) Basics/03_06-Checking if a SELECT query contains results.mp4 | 15.66 MB |
| 03. PHP Data Object (PDO) Basics/03_07-Executing simple non-SELECT queries.mp4 | 14.81 MB |
| 03. PHP Data Object (PDO) Basics/03_08-Getting error messages.mp4 | 32.52 MB |
| 03. PHP Data Object (PDO) Basics/03_09-Using the quote() method to sanitize user input.mp4 | 15.31 MB |
| 04. PDO-Prepared Statements and Transactions/04_01-Binding input and output values.mp4 | 5.22 MB |
| 04. PDO-Prepared Statements and Transactions/04_02-Using named parameters.mp4 | 44.01 MB |
| 04. PDO-Prepared Statements and Transactions/04_03-Using question marks as anonymous placeholders.mp4 | 11.38 MB |
| 04. PDO-Prepared Statements and Transactions/04_04-Passing an array of values to the execute() method.mp4 | 23.54 MB |
| 04. PDO-Prepared Statements and Transactions/04_05-Binding results to variables.mp4 | 35.92 MB |
| 04. PDO-Prepared Statements and Transactions/04_06-Executing a transaction.mp4 | 26.21 MB |
| 04. PDO-Prepared Statements and Transactions/04_07-Closing the cursor before running another query.mp4 | 21.22 MB |
| 05. Advanced PDO Fetch Methods/05_01-Generating an array from a pair of columns.mp4 | 10.11 MB |
| 05. Advanced PDO Fetch Methods/05_02-Setting an existing object`s properties with a database result.mp4 | 14.41 MB |
| 05. Advanced PDO Fetch Methods/05_03-Creating an instance of a specific class with a database result.mp4 | 20.31 MB |
| 05. Advanced PDO Fetch Methods/05_04-Reusing a result set.mp4 | 33.63 MB |
| 06. MySQL Improved Basics/06_01-Connecting to a database with MySQLi.mp4 | 17.67 MB |
| 06. MySQL Improved Basics/06_02-Setting the character set.mp4 | 4.33 MB |
| 06. MySQL Improved Basics/06_03-Submitting a SELECT query and getting the number of results.mp4 | 18.56 MB |
| 06. MySQL Improved Basics/06_04-Fetching the result.mp4 | 24.93 MB |
| 06. MySQL Improved Basics/06_05-Rewinding the result for reuse.mp4 | 14.34 MB |
| 06. MySQL Improved Basics/06_06-Handling non-SELECT queries.mp4 | 21.99 MB |
| 06. MySQL Improved Basics/06_07-Getting error messages.mp4 | 23.08 MB |
| 06. MySQL Improved Basics/06_08-Sanitizing user input with real_escape_string().mp4 | 13.58 MB |
| 07. MySQLi Prepared Statements and Transactions/07_01-Initializing and preparing a statement.mp4 | 19.4 MB |
| 07. MySQLi Prepared Statements and Transactions/07_02-Binding parameters and executing a prepared statement.mp4 | 26.39 MB |
| 07. MySQLi Prepared Statements and Transactions/07_03-Binding output variables.mp4 | 23.08 MB |
| 07. MySQLi Prepared Statements and Transactions/07_04-Executing a MySQLi transaction.mp4 | 31.63 MB |
| 07. MySQLi Prepared Statements and Transactions/07_05-Dealing with commands out of sync in prepared statements.mp4 | 24.52 MB |
| 08. Diving Deeper into MySQLi/08_01-Buffered and unbuffered queries.mp4 | 9.42 MB |
| 08. Diving Deeper into MySQLi/08_02-Using real_query().mp4 | 27.08 MB |
| 08. Diving Deeper into MySQLi/08_03-Freeing resources that are no longer needed.mp4 | 4.03 MB |
| 08. Diving Deeper into MySQLi/08_04-Submitting multiple queries.mp4 | 27.21 MB |
| 08. Diving Deeper into MySQLi/08_05-Creating an instance of a class from a result set.mp4 | 15.01 MB |
| 09. Conclusion/09_01-PDO and MySQLi compared.mp4 | 7.37 MB |
| Exercise Files/ch01/phpinfo.php | 22 B |
| Exercise Files/ch02/02_02/pdo_connect.php | 275 B |
| Exercise Files/ch02/02_02/pdo_test.php | 372 B |
| Exercise Files/ch02/02_02/pdo_test_end.php | 503 B |
| Exercise Files/ch02/02_03/pdo_loop.php | 662 B |
| Exercise Files/ch02/02_03/pdo_loop_end.php | 879 B |
| Exercise Files/ch02/02_04/pdo_fetch.php | 700 B |
| Exercise Files/ch02/02_04/pdo_fetch_end.php | 860 B |
| Exercise Files/ch02/02_04/pdo_fetchAll.php | 587 B |
| Exercise Files/ch02/02_04/pdo_fetchAll_end.php | 657 B |
| Exercise Files/ch02/02_04/pdo_fetchColumn.php | 754 B |
| Exercise Files/ch02/02_04/pdo_fetchColumn_end.php | 755 B |
| Exercise Files/ch02/02_05/pdo_rowcount.php | 923 B |
| Exercise Files/ch02/02_06/pdo_checkrow.php | 919 B |
| Exercise Files/ch02/02_06/pdo_checkrow_end.php | 1.04 KB |
| Exercise Files/ch02/02_07/exec_delete.php | 224 B |
| Exercise Files/ch02/02_07/exec_delete_end.php | 301 B |
| Exercise Files/ch02/02_07/exec_insert.php | 341 B |
| Exercise Files/ch02/02_07/exec_insert_end.php | 389 B |
| Exercise Files/ch02/02_07/query_insert.php | 285 B |
| Exercise Files/ch02/02_07/query_insert_end.php | 350 B |
| Exercise Files/ch02/02_08/pdo_error.php | 897 B |
| Exercise Files/ch02/02_09/pdo_quote.php | 1.35 KB |
| Exercise Files/ch02/02_09/pdo_quote_end.php | 1.4 KB |
| Exercise Files/ch03/03_02/pdo_named.php | 2.32 KB |
| Exercise Files/ch03/03_02/pdo_named_end.php | 2.74 KB |
| Exercise Files/ch03/03_03/pdo_anonymous.php | 2.75 KB |
| Exercise Files/ch03/03_03/pdo_anonymous_end.php | 2.71 KB |
| Exercise Files/ch03/03_04/pdo_anonymous_execute.php | 2.71 KB |
| Exercise Files/ch03/03_04/pdo_anonymous_execute_end.php | 2.62 KB |
| Exercise Files/ch03/03_04/pdo_named_execute.php | 2.74 KB |
| Exercise Files/ch03/03_04/pdo_named_execute_end.php | 2.71 KB |
| Exercise Files/ch03/03_05/pdo_output.php | 2.75 KB |
| Exercise Files/ch03/03_05/pdo_output_end.php | 2.94 KB |
| Exercise Files/ch03/03_06/pdo_transaction.php | 749 B |
| Exercise Files/ch03/03_06/pdo_transaction_end.php | 1.74 KB |
| Exercise Files/ch03/03_06/transfer.txt | 519 B |
| Exercise Files/ch03/03_07/pdo_check_balance.php | 2.27 KB |
| Exercise Files/ch03/03_07/pdo_check_balance_end.php | 2.3 KB |
| Exercise Files/ch04/04_01/pdo_array.php | 242 B |
| Exercise Files/ch04/04_01/pdo_array_end.php | 308 B |
| Exercise Files/ch04/04_02/Car.php | 1.34 KB |
| Exercise Files/ch04/04_02/fetch_into.php | 338 B |
| Exercise Files/ch04/04_02/fetch_into_end.php | 589 B |
| Exercise Files/ch04/04_02/select.txt | 212 B |
| Exercise Files/ch04/04_03/Car.php | 1.34 KB |
| Exercise Files/ch04/04_03/fetch_class.php | 530 B |
| Exercise Files/ch04/04_03/fetch_class_end.php | 663 B |
| Exercise Files/ch04/04_04/pdo_resubmit.php | 1.13 KB |
| Exercise Files/ch04/04_04/pdo_reuse.php | 1.04 KB |
| Exercise Files/ch04/04_04/pdo_reuse_end.php | 1.12 KB |
| Exercise Files/ch04/04_04/pdo_scrollable.php | 1.26 KB |
| Exercise Files/ch05/05_01/mysqli_test.php | 356 B |
Trackers
No trackers found.