| | 01_02-What you should know before watching this course.mp4 | 3.07 MB |
| | 01_03-Using the exercise files.mp4 | 16.67 MB |
| | 01_04-Setting SQLite permissions.mp4 | 2.7 MB |
| | 01_05-A quick primer on using PHP objects.mp4 | 10.03 MB |
| | 01_01-Welcome.mp4 | 9.54 MB |
| | 02_01-Overview of PHP database APIs.mp4 | 11.29 MB |
| | 02_02-Using prepared statements.mp4 | 9.32 MB |
| | 02_03-Using transactions.mp4 | 3.78 MB |
| | 03_01-Creating a database source name.mp4 | 4.79 MB |
| | 03_02-Connecting to a database with PDO.mp4 | 31.36 MB |
| | 03_03-Looping directly over a SELECT query.mp4 | 14.94 MB |
| | 03_04-Fetching a result set.mp4 | 35.93 MB |
| | 03_05-Finding the number of results from a SELECT query.mp4 | 32.19 MB |
| | 03_06-Checking if a SELECT query contains results.mp4 | 15.66 MB |
| | 03_07-Executing simple non-SELECT queries.mp4 | 14.81 MB |
| | 03_08-Getting error messages.mp4 | 32.52 MB |
| | 03_09-Using the quote() method to sanitize user input.mp4 | 15.31 MB |
| | 04_02-Using named parameters.mp4 | 44.01 MB |
| | 04_01-Binding input and output values.mp4 | 5.22 MB |
| | 04_03-Using question marks as anonymous placeholders.mp4 | 11.38 MB |
| | 04_04-Passing an array of values to the execute() method.mp4 | 23.54 MB |
| | 04_05-Binding results to variables.mp4 | 35.92 MB |
| | 04_06-Executing a transaction.mp4 | 26.21 MB |
| | 04_07-Closing the cursor before running another query.mp4 | 21.22 MB |
| | 05_01-Generating an array from a pair of columns.mp4 | 10.11 MB |
| | 05_02-Setting an existing object`s properties with a database result.mp4 | 14.41 MB |
| | 05_03-Creating an instance of a specific class with a database result.mp4 | 20.31 MB |
| | 05_04-Reusing a result set.mp4 | 33.63 MB |
| | 06_01-Connecting to a database with MySQLi.mp4 | 17.67 MB |
| | 06_02-Setting the character set.mp4 | 4.33 MB |
| | 06_03-Submitting a SELECT query and getting the number of results.mp4 | 18.56 MB |
| | 06_04-Fetching the result.mp4 | 24.93 MB |
| | 06_05-Rewinding the result for reuse.mp4 | 14.34 MB |
| | 06_06-Handling non-SELECT queries.mp4 | 21.99 MB |
| | 06_07-Getting error messages.mp4 | 23.08 MB |
| | 06_08-Sanitizing user input with real_escape_string().mp4 | 13.58 MB |
| | 07_01-Initializing and preparing a statement.mp4 | 19.4 MB |
| | 07_02-Binding parameters and executing a prepared statement.mp4 | 26.39 MB |
| | 07_03-Binding output variables.mp4 | 23.08 MB |
| | 07_04-Executing a MySQLi transaction.mp4 | 31.63 MB |
| | 07_05-Dealing with commands out of sync in prepared statements.mp4 | 24.52 MB |
| | 08_01-Buffered and unbuffered queries.mp4 | 9.42 MB |
| | 08_02-Using real_query().mp4 | 27.08 MB |
| | 08_03-Freeing resources that are no longer needed.mp4 | 4.03 MB |
| | 08_04-Submitting multiple queries.mp4 | 27.21 MB |
| | 08_05-Creating an instance of a class from a result set.mp4 | 15.01 MB |
| | 09_01-PDO and MySQLi compared.mp4 | 7.37 MB |
| | phpinfo.php | 22 bytes |
| | pdo_connect.php | 275 bytes |
| | pdo_test.php | 372 bytes |
| | pdo_test_end.php | 503 bytes |
| | pdo_loop.php | 662 bytes |
| | pdo_loop_end.php | 879 bytes |
| | pdo_fetch.php | 700 bytes |
| | pdo_fetchAll.php | 587 bytes |
| | pdo_fetchAll_end.php | 657 bytes |
| | pdo_fetchColumn.php | 754 bytes |
| | pdo_fetchColumn_end.php | 755 bytes |
| | pdo_fetch_end.php | 860 bytes |
| | pdo_rowcount.php | 923 bytes |
| | pdo_checkrow.php | 919 bytes |
| | pdo_checkrow_end.php | 1.04 KB |
| | exec_delete.php | 224 bytes |
| | exec_delete_end.php | 301 bytes |
| | exec_insert.php | 341 bytes |
| | exec_insert_end.php | 389 bytes |
| | query_insert.php | 285 bytes |
| | query_insert_end.php | 350 bytes |
| | pdo_error.php | 897 bytes |
| | pdo_quote.php | 1.35 KB |
| | pdo_quote_end.php | 1.4 KB |
| | pdo_named.php | 2.32 KB |
| | pdo_named_end.php | 2.74 KB |
| | pdo_anonymous.php | 2.75 KB |
| | pdo_anonymous_end.php | 2.71 KB |
| | pdo_anonymous_execute.php | 2.71 KB |
| | pdo_anonymous_execute_end.php | 2.62 KB |
| | pdo_named_execute.php | 2.74 KB |
| | pdo_named_execute_end.php | 2.71 KB |
| | pdo_output.php | 2.75 KB |
| | pdo_output_end.php | 2.94 KB |
| | pdo_transaction.php | 749 bytes |
| | pdo_transaction_end.php | 1.74 KB |
| | transfer.txt | 519 bytes |
| | pdo_check_balance.php | 2.27 KB |
| | pdo_check_balance_end.php | 2.3 KB |
| | pdo_array.php | 242 bytes |
| | pdo_array_end.php | 308 bytes |
| | car.php | 1.34 KB |
| | fetch_into.php | 338 bytes |
| | fetch_into_end.php | 589 bytes |
| | Select.txt | 212 bytes |
| | car.php | 1.34 KB |
| | fetch_class.php | 530 bytes |
| | fetch_class_end.php | 663 bytes |
| | pdo_resubmit.php | 1.13 KB |
| | pdo_reuse.php | 1.04 KB |
| | pdo_reuse_end.php | 1.12 KB |
| | pdo_scrollable.php | 1.26 KB |
| | mysqli_test.php | 356 bytes |
| | mysqli_test_end.php | 505 bytes |
| | mysqli_num_rows.php | 767 bytes |
| | mysqli_num_rows_end.php | 986 bytes |
| | mysqli_fetch_all.php | 465 bytes |
| | mysqli_fetch_array.php | 507 bytes |
| | mysqli_fetch_assoc.php | 952 bytes |
| | mysqli_fetch_assoc_end.php | 1.06 KB |
| | mysqli_fetch_row.php | 1.04 KB |
| | mysqli_reuse.php | 1017 bytes |
| | mysqli_reuse_end.php | 1.03 KB |
| | mysqli_delete.php | 327 bytes |
| | mysqli_insert.php | 303 bytes |
| | mysqli_insert_end.php | 481 bytes |
| | mysqli_error.php | 909 bytes |
| | mysqli_error_end.php | 981 bytes |
| | mysqli_escape.php | 1.39 KB |
| | mysqli_escape_end.php | 1.44 KB |
| | mysqli_statement.php | 2.42 KB |
| | mysqli_statement_end.php | 2.71 KB |
| | mysqli_statement.php | 2.7 KB |
| | mysqli_statement_end.php | 2.9 KB |
| | mysqli_statement.php | 2.9 KB |
| | mysqli_statement_end.php | 2.89 KB |
| | mysqli_transaction.php | 822 bytes |
| | mysqli_transaction_end.php | 1.89 KB |
| | transfer.txt | 553 bytes |
| | mysqli_check_balance.php | 2.51 KB |
| | mysqli_check_balance_end.php | 2.61 KB |
| | mysqli_real_query.php | 1.27 KB |
| | mysqli_real_query_end.php | 1.3 KB |
| | mysqli_multi.php | 482 bytes |
| | mysqli_multi_end.php | 1.33 KB |
| | QUERY.txt | 201 bytes |
| | car.php | 1.34 KB |
| | Car_end.php | 1.34 KB |
| | mysqli_class.php | 492 bytes |
| | mysqli_class_end.php | 492 bytes |
| | mysqli_class_stmt.php | 774 bytes |
| | oophp.db | 10 KB |
| | styles.css | 940 bytes |
| | oophp.sql | 8.52 KB |