Download link
File List
-
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
Exercise Files/ch05/05_01/mysqli_test_end.php 505 B
Exercise Files/ch05/05_03/mysqli_num_rows.php 767 B
Exercise Files/ch05/05_03/mysqli_num_rows_end.php 986 B
Exercise Files/ch05/05_04/mysqli_fetch_all.php 465 B
Exercise Files/ch05/05_04/mysqli_fetch_array.php 507 B
Exercise Files/ch05/05_04/mysqli_fetch_assoc.php 952 B
Exercise Files/ch05/05_04/mysqli_fetch_assoc_end.php 1.06 KB
Exercise Files/ch05/05_04/mysqli_fetch_row.php 1.04 KB
Exercise Files/ch05/05_05/mysqli_reuse.php 1017 B
Exercise Files/ch05/05_05/mysqli_reuse_end.php 1.03 KB
Exercise Files/ch05/05_06/mysqli_delete.php 327 B
Exercise Files/ch05/05_06/mysqli_insert.php 303 B
Exercise Files/ch05/05_06/mysqli_insert_end.php 481 B
Exercise Files/ch05/05_07/mysqli_error.php 909 B
Exercise Files/ch05/05_07/mysqli_error_end.php 981 B
Exercise Files/ch05/05_08/mysqli_escape.php 1.39 KB
Exercise Files/ch05/05_08/mysqli_escape_end.php 1.44 KB
Exercise Files/ch06/06_01/mysqli_statement.php 2.42 KB
Exercise Files/ch06/06_01/mysqli_statement_end.php 2.71 KB
Exercise Files/ch06/06_02/mysqli_statement.php 2.7 KB
Exercise Files/ch06/06_02/mysqli_statement_end.php 2.9 KB
Exercise Files/ch06/06_03/mysqli_statement.php 2.9 KB
Exercise Files/ch06/06_03/mysqli_statement_end.php 2.89 KB
Exercise Files/ch06/06_04/mysqli_transaction.php 822 B
Exercise Files/ch06/06_04/mysqli_transaction_end.php 1.89 KB
Exercise Files/ch06/06_04/transfer.txt 553 B
Exercise Files/ch06/06_05/mysqli_check_balance.php 2.51 KB
Exercise Files/ch06/06_05/mysqli_check_balance_end.php 2.61 KB
Exercise Files/ch07/07_02/mysqli_real_query.php 1.27 KB
Exercise Files/ch07/07_02/mysqli_real_query_end.php 1.3 KB
Exercise Files/ch07/07_04/mysqli_multi.php 482 B
Exercise Files/ch07/07_04/mysqli_multi_end.php 1.33 KB
Exercise Files/ch07/07_04/query.txt 201 B
Exercise Files/ch07/07_05/Car.php 1.34 KB
Exercise Files/ch07/07_05/Car_end.php 1.34 KB
Exercise Files/ch07/07_05/mysqli_class.php 492 B
Exercise Files/ch07/07_05/mysqli_class_end.php 492 B
Exercise Files/ch07/07_05/mysqli_class_stmt.php 774 B
Exercise Files/oophp.sql 8.52 KB
Exercise Files/sqlite/oophp.db 10 KB
Exercise Files/styles/styles.css 940 B
Download Info
-
Tips
“lynda.com - Accessing Databases with Object-Oriented PHP Tutorial” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.
-
DMCA Notice and Takedown Procedure
If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.