Skip to content

Lynda Com - Accessing Databases with Object-Oriented PHP Tutorial

Unverified source. This magnet is from an unverified source. The content may be unsafe or mislabeled. Proceed with caution.
Title: Lynda Com - Accessing Databases with ObjectGroup: NOGRPSource: Lynda.Com
Info Hash
5FF571024AA1139C811A0B06F49AC06B724E5F40
Source
Unverified
Total Size
863.66 MB
Total Files
100
Seeders
1
Leechers
0
Health
1.00
Score
2
Type
Bookware

File List

FileSize
01. Introduction/01_01-Welcome.mp49.54 MB
01. Introduction/01_02-What you should know before watching this course.mp43.07 MB
01. Introduction/01_03-Using the exercise files.mp416.67 MB
01. Introduction/01_04-Setting SQLite permissions.mp42.7 MB
01. Introduction/01_05-A quick primer on using PHP objects.mp410.03 MB
02. Why Use Object-Oriented PHP to Access a Database/02_01-Overview of PHP database APIs.mp411.29 MB
02. Why Use Object-Oriented PHP to Access a Database/02_02-Using prepared statements.mp49.32 MB
02. Why Use Object-Oriented PHP to Access a Database/02_03-Using transactions.mp43.78 MB
03. PHP Data Object (PDO) Basics/03_01-Creating a database source name.mp44.79 MB
03. PHP Data Object (PDO) Basics/03_02-Connecting to a database with PDO.mp431.36 MB
03. PHP Data Object (PDO) Basics/03_03-Looping directly over a SELECT query.mp414.94 MB
03. PHP Data Object (PDO) Basics/03_04-Fetching a result set.mp435.93 MB
03. PHP Data Object (PDO) Basics/03_05-Finding the number of results from a SELECT query.mp432.19 MB
03. PHP Data Object (PDO) Basics/03_06-Checking if a SELECT query contains results.mp415.66 MB
03. PHP Data Object (PDO) Basics/03_07-Executing simple non-SELECT queries.mp414.81 MB
03. PHP Data Object (PDO) Basics/03_08-Getting error messages.mp432.52 MB
03. PHP Data Object (PDO) Basics/03_09-Using the quote() method to sanitize user input.mp415.31 MB
04. PDO-Prepared Statements and Transactions/04_01-Binding input and output values.mp45.22 MB
04. PDO-Prepared Statements and Transactions/04_02-Using named parameters.mp444.01 MB
04. PDO-Prepared Statements and Transactions/04_03-Using question marks as anonymous placeholders.mp411.38 MB
04. PDO-Prepared Statements and Transactions/04_04-Passing an array of values to the execute() method.mp423.54 MB
04. PDO-Prepared Statements and Transactions/04_05-Binding results to variables.mp435.92 MB
04. PDO-Prepared Statements and Transactions/04_06-Executing a transaction.mp426.21 MB
04. PDO-Prepared Statements and Transactions/04_07-Closing the cursor before running another query.mp421.22 MB
05. Advanced PDO Fetch Methods/05_01-Generating an array from a pair of columns.mp410.11 MB
05. Advanced PDO Fetch Methods/05_02-Setting an existing object`s properties with a database result.mp414.41 MB
05. Advanced PDO Fetch Methods/05_03-Creating an instance of a specific class with a database result.mp420.31 MB
05. Advanced PDO Fetch Methods/05_04-Reusing a result set.mp433.63 MB
06. MySQL Improved Basics/06_01-Connecting to a database with MySQLi.mp417.67 MB
06. MySQL Improved Basics/06_02-Setting the character set.mp44.33 MB
06. MySQL Improved Basics/06_03-Submitting a SELECT query and getting the number of results.mp418.56 MB
06. MySQL Improved Basics/06_04-Fetching the result.mp424.93 MB
06. MySQL Improved Basics/06_05-Rewinding the result for reuse.mp414.34 MB
06. MySQL Improved Basics/06_06-Handling non-SELECT queries.mp421.99 MB
06. MySQL Improved Basics/06_07-Getting error messages.mp423.08 MB
06. MySQL Improved Basics/06_08-Sanitizing user input with real_escape_string().mp413.58 MB
07. MySQLi Prepared Statements and Transactions/07_01-Initializing and preparing a statement.mp419.4 MB
07. MySQLi Prepared Statements and Transactions/07_02-Binding parameters and executing a prepared statement.mp426.39 MB
07. MySQLi Prepared Statements and Transactions/07_03-Binding output variables.mp423.08 MB
07. MySQLi Prepared Statements and Transactions/07_04-Executing a MySQLi transaction.mp431.63 MB
07. MySQLi Prepared Statements and Transactions/07_05-Dealing with commands out of sync in prepared statements.mp424.52 MB
08. Diving Deeper into MySQLi/08_01-Buffered and unbuffered queries.mp49.42 MB
08. Diving Deeper into MySQLi/08_02-Using real_query().mp427.08 MB
08. Diving Deeper into MySQLi/08_03-Freeing resources that are no longer needed.mp44.03 MB
08. Diving Deeper into MySQLi/08_04-Submitting multiple queries.mp427.21 MB
08. Diving Deeper into MySQLi/08_05-Creating an instance of a class from a result set.mp415.01 MB
09. Conclusion/09_01-PDO and MySQLi compared.mp47.37 MB
Exercise Files/ch01/phpinfo.php22 B
Exercise Files/ch02/02_02/pdo_connect.php275 B
Exercise Files/ch02/02_02/pdo_test.php372 B
Exercise Files/ch02/02_02/pdo_test_end.php503 B
Exercise Files/ch02/02_03/pdo_loop.php662 B
Exercise Files/ch02/02_03/pdo_loop_end.php879 B
Exercise Files/ch02/02_04/pdo_fetch.php700 B
Exercise Files/ch02/02_04/pdo_fetch_end.php860 B
Exercise Files/ch02/02_04/pdo_fetchAll.php587 B
Exercise Files/ch02/02_04/pdo_fetchAll_end.php657 B
Exercise Files/ch02/02_04/pdo_fetchColumn.php754 B
Exercise Files/ch02/02_04/pdo_fetchColumn_end.php755 B
Exercise Files/ch02/02_05/pdo_rowcount.php923 B
Exercise Files/ch02/02_06/pdo_checkrow.php919 B
Exercise Files/ch02/02_06/pdo_checkrow_end.php1.04 KB
Exercise Files/ch02/02_07/exec_delete.php224 B
Exercise Files/ch02/02_07/exec_delete_end.php301 B
Exercise Files/ch02/02_07/exec_insert.php341 B
Exercise Files/ch02/02_07/exec_insert_end.php389 B
Exercise Files/ch02/02_07/query_insert.php285 B
Exercise Files/ch02/02_07/query_insert_end.php350 B
Exercise Files/ch02/02_08/pdo_error.php897 B
Exercise Files/ch02/02_09/pdo_quote.php1.35 KB
Exercise Files/ch02/02_09/pdo_quote_end.php1.4 KB
Exercise Files/ch03/03_02/pdo_named.php2.32 KB
Exercise Files/ch03/03_02/pdo_named_end.php2.74 KB
Exercise Files/ch03/03_03/pdo_anonymous.php2.75 KB
Exercise Files/ch03/03_03/pdo_anonymous_end.php2.71 KB
Exercise Files/ch03/03_04/pdo_anonymous_execute.php2.71 KB
Exercise Files/ch03/03_04/pdo_anonymous_execute_end.php2.62 KB
Exercise Files/ch03/03_04/pdo_named_execute.php2.74 KB
Exercise Files/ch03/03_04/pdo_named_execute_end.php2.71 KB
Exercise Files/ch03/03_05/pdo_output.php2.75 KB
Exercise Files/ch03/03_05/pdo_output_end.php2.94 KB
Exercise Files/ch03/03_06/pdo_transaction.php749 B
Exercise Files/ch03/03_06/pdo_transaction_end.php1.74 KB
Exercise Files/ch03/03_06/transfer.txt519 B
Exercise Files/ch03/03_07/pdo_check_balance.php2.27 KB
Exercise Files/ch03/03_07/pdo_check_balance_end.php2.3 KB
Exercise Files/ch04/04_01/pdo_array.php242 B
Exercise Files/ch04/04_01/pdo_array_end.php308 B
Exercise Files/ch04/04_02/Car.php1.34 KB
Exercise Files/ch04/04_02/fetch_into.php338 B
Exercise Files/ch04/04_02/fetch_into_end.php589 B
Exercise Files/ch04/04_02/select.txt212 B
Exercise Files/ch04/04_03/Car.php1.34 KB
Exercise Files/ch04/04_03/fetch_class.php530 B
Exercise Files/ch04/04_03/fetch_class_end.php663 B
Exercise Files/ch04/04_04/pdo_resubmit.php1.13 KB
Exercise Files/ch04/04_04/pdo_reuse.php1.04 KB
Exercise Files/ch04/04_04/pdo_reuse_end.php1.12 KB
Exercise Files/ch04/04_04/pdo_scrollable.php1.26 KB
Exercise Files/ch05/05_01/mysqli_test.php356 B

Trackers

No trackers found.