Lynda com Accessing Databases with Object Oriented PHP Tutorial

/01. Introduction/

01_01-Welcome.mp4

01_02-What you should know before watching this course.mp4

01_03-Using the exercise files.mp4

01_04-Setting SQLite permissions.mp4

01_05-A quick primer on using PHP objects.mp4

/02. Why Use Object-Oriented PHP to Access a Database/

02_01-Overview of PHP database APIs.mp4

02_02-Using prepared statements.mp4

02_03-Using transactions.mp4

/03. PHP Data Object (PDO) Basics/

03_01-Creating a database source name.mp4

03_02-Connecting to a database with PDO.mp4

03_03-Looping directly over a SELECT query.mp4

03_04-Fetching a result set.mp4

03_05-Finding the number of results from a SELECT query.mp4

03_06-Checking if a SELECT query contains results.mp4

03_07-Executing simple non-SELECT queries.mp4

03_08-Getting error messages.mp4

03_09-Using the quote() method to sanitize user input.mp4

/04. PDO-Prepared Statements and Transactions/

04_01-Binding input and output values.mp4

04_02-Using named parameters.mp4

04_03-Using question marks as anonymous placeholders.mp4

04_04-Passing an array of values to the execute() method.mp4

04_05-Binding results to variables.mp4

04_06-Executing a transaction.mp4

04_07-Closing the cursor before running another query.mp4

/05. Advanced PDO Fetch Methods/

05_01-Generating an array from a pair of columns.mp4

05_02-Setting an existing object`s properties with a database result.mp4

05_03-Creating an instance of a specific class with a database result.mp4

05_04-Reusing a result set.mp4

/06. MySQL Improved Basics/

06_01-Connecting to a database with MySQLi.mp4

06_02-Setting the character set.mp4

06_03-Submitting a SELECT query and getting the number of results.mp4

06_04-Fetching the result.mp4

06_05-Rewinding the result for reuse.mp4

06_06-Handling non-SELECT queries.mp4

06_07-Getting error messages.mp4

06_08-Sanitizing user input with real_escape_string().mp4

/07. MySQLi Prepared Statements and Transactions/

07_01-Initializing and preparing a statement.mp4

07_02-Binding parameters and executing a prepared statement.mp4

07_03-Binding output variables.mp4

07_04-Executing a MySQLi transaction.mp4

07_05-Dealing with commands out of sync in prepared statements.mp4

/08. Diving Deeper into MySQLi/

08_01-Buffered and unbuffered queries.mp4

08_02-Using real_query().mp4

08_03-Freeing resources that are no longer needed.mp4

08_04-Submitting multiple queries.mp4

08_05-Creating an instance of a class from a result set.mp4

/09. Conclusion/

09_01-PDO and MySQLi compared.mp4

/Exercise Files/ch01/

phpinfo.php

/Exercise Files/ch02/02_02/

pdo_connect.php

pdo_test.php

pdo_test_end.php

/Exercise Files/ch02/02_03/

pdo_loop.php

pdo_loop_end.php

/Exercise Files/ch02/02_04/

pdo_fetch.php

pdo_fetch_end.php

pdo_fetchAll.php

pdo_fetchAll_end.php

pdo_fetchColumn.php

pdo_fetchColumn_end.php

/Exercise Files/ch02/02_05/

pdo_rowcount.php

/Exercise Files/ch02/02_06/

pdo_checkrow.php

pdo_checkrow_end.php

/Exercise Files/ch02/02_07/

exec_delete.php

exec_delete_end.php

exec_insert.php

exec_insert_end.php

query_insert.php

query_insert_end.php

/Exercise Files/ch02/02_08/

pdo_error.php

/Exercise Files/ch02/02_09/

pdo_quote.php

pdo_quote_end.php

/Exercise Files/ch03/03_02/

pdo_named.php

pdo_named_end.php

/Exercise Files/ch03/03_03/

pdo_anonymous.php

pdo_anonymous_end.php

/Exercise Files/ch03/03_04/

pdo_anonymous_execute.php

pdo_anonymous_execute_end.php

pdo_named_execute.php

pdo_named_execute_end.php

/Exercise Files/ch03/03_05/

pdo_output.php

pdo_output_end.php

/Exercise Files/ch03/03_06/

pdo_transaction.php

pdo_transaction_end.php

transfer.txt

/Exercise Files/ch03/03_07/

pdo_check_balance.php

pdo_check_balance_end.php

/Exercise Files/ch04/04_01/

pdo_array.php

pdo_array_end.php

/Exercise Files/ch04/04_02/

Car.php

fetch_into.php

fetch_into_end.php

select.txt

/Exercise Files/ch04/04_03/

Car.php

fetch_class.php

fetch_class_end.php

/Exercise Files/ch04/04_04/

pdo_resubmit.php

pdo_reuse.php

pdo_reuse_end.php

pdo_scrollable.php

/Exercise Files/ch05/05_01/

mysqli_test.php

mysqli_test_end.php

/Exercise Files/ch05/05_03/

mysqli_num_rows.php

mysqli_num_rows_end.php

/Exercise Files/ch05/05_04/

mysqli_fetch_all.php

mysqli_fetch_array.php

mysqli_fetch_assoc.php

mysqli_fetch_assoc_end.php

mysqli_fetch_row.php

/Exercise Files/ch05/05_05/

mysqli_reuse.php

mysqli_reuse_end.php

/Exercise Files/ch05/05_06/

mysqli_delete.php

mysqli_insert.php

mysqli_insert_end.php

/Exercise Files/ch05/05_07/

mysqli_error.php

mysqli_error_end.php

/Exercise Files/ch05/05_08/

mysqli_escape.php

mysqli_escape_end.php

/Exercise Files/ch06/06_01/

mysqli_statement.php

mysqli_statement_end.php

/Exercise Files/ch06/06_02/

mysqli_statement.php

mysqli_statement_end.php

/Exercise Files/ch06/06_03/

mysqli_statement.php

mysqli_statement_end.php

/Exercise Files/ch06/06_04/

mysqli_transaction.php

mysqli_transaction_end.php

transfer.txt

/Exercise Files/ch06/06_05/

mysqli_check_balance.php

mysqli_check_balance_end.php

/Exercise Files/ch07/07_02/

mysqli_real_query.php

mysqli_real_query_end.php

/Exercise Files/ch07/07_04/

mysqli_multi.php

mysqli_multi_end.php

query.txt

/Exercise Files/ch07/07_05/

Car.php

Car_end.php

mysqli_class.php

mysqli_class_end.php

mysqli_class_stmt.php

/Exercise Files/

oophp.sql

/Exercise Files/sqlite/

oophp.db

/Exercise Files/styles/

styles.css

Total files 141