lynda.com - Accessing Databases with Object-Oriented PHP Tutorial

File Name

Size

01. Introduction/01_01-Welcome.mp4

9.5 MB

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

3.1 MB

01. Introduction/01_03-Using the exercise files.mp4

17 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 MB

02. Why Use Object-Oriented PHP to Access a Database/02_01-Overview of PHP database APIs.mp4

11 MB

02. Why Use Object-Oriented PHP to Access a Database/02_02-Using prepared statements.mp4

9.3 MB

02. Why Use Object-Oriented PHP to Access a Database/02_03-Using transactions.mp4

3.8 MB

03. PHP Data Object (PDO) Basics/03_01-Creating a database source name.mp4

4.8 MB

03. PHP Data Object (PDO) Basics/03_02-Connecting to a database with PDO.mp4

31 MB

03. PHP Data Object (PDO) Basics/03_03-Looping directly over a SELECT query.mp4

15 MB

03. PHP Data Object (PDO) Basics/03_04-Fetching a result set.mp4

36 MB

03. PHP Data Object (PDO) Basics/03_05-Finding the number of results from a SELECT query.mp4

32 MB

03. PHP Data Object (PDO) Basics/03_06-Checking if a SELECT query contains results.mp4

16 MB

03. PHP Data Object (PDO) Basics/03_07-Executing simple non-SELECT queries.mp4

15 MB

03. PHP Data Object (PDO) Basics/03_08-Getting error messages.mp4

32 MB

03. PHP Data Object (PDO) Basics/03_09-Using the quote() method to sanitize user input.mp4

15 MB

04. PDO-Prepared Statements and Transactions/04_01-Binding input and output values.mp4

5.2 MB

04. PDO-Prepared Statements and Transactions/04_02-Using named parameters.mp4

44 MB

04. PDO-Prepared Statements and Transactions/04_03-Using question marks as anonymous placeholders.mp4

11 MB

04. PDO-Prepared Statements and Transactions/04_04-Passing an array of values to the execute() method.mp4

24 MB

04. PDO-Prepared Statements and Transactions/04_05-Binding results to variables.mp4

36 MB

04. PDO-Prepared Statements and Transactions/04_06-Executing a transaction.mp4

26 MB

04. PDO-Prepared Statements and Transactions/04_07-Closing the cursor before running another query.mp4

21 MB

05. Advanced PDO Fetch Methods/05_01-Generating an array from a pair of columns.mp4

10 MB

05. Advanced PDO Fetch Methods/05_02-Setting an existing object`s properties with a database result.mp4

14 MB

05. Advanced PDO Fetch Methods/05_03-Creating an instance of a specific class with a database result.mp4

20 MB

05. Advanced PDO Fetch Methods/05_04-Reusing a result set.mp4

34 MB

06. MySQL Improved Basics/06_01-Connecting to a database with MySQLi.mp4

18 MB

06. MySQL Improved Basics/06_02-Setting the character set.mp4

4.3 MB

06. MySQL Improved Basics/06_03-Submitting a SELECT query and getting the number of results.mp4

19 MB

06. MySQL Improved Basics/06_04-Fetching the result.mp4

25 MB

06. MySQL Improved Basics/06_05-Rewinding the result for reuse.mp4

14 MB

06. MySQL Improved Basics/06_06-Handling non-SELECT queries.mp4

22 MB

06. MySQL Improved Basics/06_07-Getting error messages.mp4

23 MB

06. MySQL Improved Basics/06_08-Sanitizing user input with real_escape_string().mp4

14 MB

07. MySQLi Prepared Statements and Transactions/07_01-Initializing and preparing a statement.mp4

19 MB

07. MySQLi Prepared Statements and Transactions/07_02-Binding parameters and executing a prepared statement.mp4

26 MB

07. MySQLi Prepared Statements and Transactions/07_03-Binding output variables.mp4

23 MB

07. MySQLi Prepared Statements and Transactions/07_04-Executing a MySQLi transaction.mp4

32 MB

07. MySQLi Prepared Statements and Transactions/07_05-Dealing with commands out of sync in prepared statements.mp4

24 MB

08. Diving Deeper into MySQLi/08_01-Buffered and unbuffered queries.mp4

9.4 MB

08. Diving Deeper into MySQLi/08_02-Using real_query().mp4

27 MB

08. Diving Deeper into MySQLi/08_03-Freeing resources that are no longer needed.mp4

4.0 MB

08. Diving Deeper into MySQLi/08_04-Submitting multiple queries.mp4

27 MB

08. Diving Deeper into MySQLi/08_05-Creating an instance of a class from a result set.mp4

15 MB

09. Conclusion/09_01-PDO and MySQLi compared.mp4

7.4 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.0 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.4 kB

Exercise Files/ch02/02_09/pdo_quote_end.php

1.4 kB

Exercise Files/ch03/03_02/pdo_named.php

2.3 kB

Exercise Files/ch03/03_02/pdo_named_end.php

2.7 kB

Exercise Files/ch03/03_03/pdo_anonymous.php

2.7 kB

Exercise Files/ch03/03_03/pdo_anonymous_end.php

2.7 kB

Exercise Files/ch03/03_04/pdo_anonymous_execute.php

2.7 kB

Exercise Files/ch03/03_04/pdo_anonymous_execute_end.php

2.6 kB

Exercise Files/ch03/03_04/pdo_named_execute.php

2.7 kB

Exercise Files/ch03/03_04/pdo_named_execute_end.php

2.7 kB

Exercise Files/ch03/03_05/pdo_output.php

2.7 kB

Exercise Files/ch03/03_05/pdo_output_end.php

2.9 kB

Exercise Files/ch03/03_06/pdo_transaction.php

749 B

Exercise Files/ch03/03_06/pdo_transaction_end.php

1.7 kB

Exercise Files/ch03/03_06/transfer.txt

519 B

Exercise Files/ch03/03_07/pdo_check_balance.php

2.3 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.3 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.3 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.1 kB

Exercise Files/ch04/04_04/pdo_reuse.php

1.0 kB

Exercise Files/ch04/04_04/pdo_reuse_end.php

1.1 kB

Exercise Files/ch04/04_04/pdo_scrollable.php

1.3 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.1 kB

Exercise Files/ch05/05_04/mysqli_fetch_row.php

1.0 kB

Exercise Files/ch05/05_05/mysqli_reuse.php

1017 B

Exercise Files/ch05/05_05/mysqli_reuse_end.php

1.0 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.4 kB

Exercise Files/ch05/05_08/mysqli_escape_end.php

1.4 kB

Exercise Files/ch06/06_01/mysqli_statement.php

2.4 kB

Exercise Files/ch06/06_01/mysqli_statement_end.php

2.7 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.9 kB

Exercise Files/ch06/06_04/mysqli_transaction.php

822 B

Exercise Files/ch06/06_04/mysqli_transaction_end.php

1.9 kB

Exercise Files/ch06/06_04/transfer.txt

553 B

Exercise Files/ch06/06_05/mysqli_check_balance.php

2.5 kB

Exercise Files/ch06/06_05/mysqli_check_balance_end.php

2.6 kB

Exercise Files/ch07/07_02/mysqli_real_query.php

1.3 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.3 kB

Exercise Files/ch07/07_04/query.txt

201 B

Exercise Files/ch07/07_05/Car.php

1.3 kB

Exercise Files/ch07/07_05/Car_end.php

1.3 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.5 kB

Exercise Files/sqlite/oophp.db

10 kB

Exercise Files/styles/styles.css

940 B