Accessing Databases with Object-Oriented PHP - Lynda

seeders: 1
leechers: 8
Added on February 3, 2016 by vintage81in Other > Tutorials
Torrent verified.



Accessing Databases with Object-Oriented PHP - Lynda (Size: 863.66 MB)
 01_02-What you should know before watching this course.mp43.07 MB
 01_03-Using the exercise files.mp416.67 MB
 01_04-Setting SQLite permissions.mp42.7 MB
 01_05-A quick primer on using PHP objects.mp410.03 MB
 01_01-Welcome.mp49.54 MB
 02_01-Overview of PHP database APIs.mp411.29 MB
 02_02-Using prepared statements.mp49.32 MB
 02_03-Using transactions.mp43.78 MB
 03_01-Creating a database source name.mp44.79 MB
 03_02-Connecting to a database with PDO.mp431.36 MB
 03_03-Looping directly over a SELECT query.mp414.94 MB
 03_04-Fetching a result set.mp435.93 MB
 03_05-Finding the number of results from a SELECT query.mp432.19 MB
 03_06-Checking if a SELECT query contains results.mp415.66 MB
 03_07-Executing simple non-SELECT queries.mp414.81 MB
 03_08-Getting error messages.mp432.52 MB
 03_09-Using the quote() method to sanitize user input.mp415.31 MB
 04_02-Using named parameters.mp444.01 MB
 04_01-Binding input and output values.mp45.22 MB
 04_03-Using question marks as anonymous placeholders.mp411.38 MB
 04_04-Passing an array of values to the execute() method.mp423.54 MB
 04_05-Binding results to variables.mp435.92 MB
 04_06-Executing a transaction.mp426.21 MB
 04_07-Closing the cursor before running another query.mp421.22 MB
 05_01-Generating an array from a pair of columns.mp410.11 MB
 05_02-Setting an existing object`s properties with a database result.mp414.41 MB
 05_03-Creating an instance of a specific class with a database result.mp420.31 MB
 05_04-Reusing a result set.mp433.63 MB
 06_01-Connecting to a database with MySQLi.mp417.67 MB
 06_02-Setting the character set.mp44.33 MB
 06_03-Submitting a SELECT query and getting the number of results.mp418.56 MB
 06_04-Fetching the result.mp424.93 MB
 06_05-Rewinding the result for reuse.mp414.34 MB
 06_06-Handling non-SELECT queries.mp421.99 MB
 06_07-Getting error messages.mp423.08 MB
 06_08-Sanitizing user input with real_escape_string().mp413.58 MB
 07_01-Initializing and preparing a statement.mp419.4 MB
 07_02-Binding parameters and executing a prepared statement.mp426.39 MB
 07_03-Binding output variables.mp423.08 MB
 07_04-Executing a MySQLi transaction.mp431.63 MB
 07_05-Dealing with commands out of sync in prepared statements.mp424.52 MB
 08_01-Buffered and unbuffered queries.mp49.42 MB
 08_02-Using real_query().mp427.08 MB
 08_03-Freeing resources that are no longer needed.mp44.03 MB
 08_04-Submitting multiple queries.mp427.21 MB
 08_05-Creating an instance of a class from a result set.mp415.01 MB
 09_01-PDO and MySQLi compared.mp47.37 MB
 phpinfo.php22 bytes
 pdo_connect.php275 bytes
 pdo_test.php372 bytes
 pdo_test_end.php503 bytes
 pdo_loop.php662 bytes
 pdo_loop_end.php879 bytes
 pdo_fetch.php700 bytes
 pdo_fetchAll.php587 bytes
 pdo_fetchAll_end.php657 bytes
 pdo_fetchColumn.php754 bytes
 pdo_fetchColumn_end.php755 bytes
 pdo_fetch_end.php860 bytes
 pdo_rowcount.php923 bytes
 pdo_checkrow.php919 bytes
 pdo_checkrow_end.php1.04 KB
 exec_delete.php224 bytes
 exec_delete_end.php301 bytes
 exec_insert.php341 bytes
 exec_insert_end.php389 bytes
 query_insert.php285 bytes
 query_insert_end.php350 bytes
 pdo_error.php897 bytes
 pdo_quote.php1.35 KB
 pdo_quote_end.php1.4 KB
 pdo_named.php2.32 KB
 pdo_named_end.php2.74 KB
 pdo_anonymous.php2.75 KB
 pdo_anonymous_end.php2.71 KB
 pdo_anonymous_execute.php2.71 KB
 pdo_anonymous_execute_end.php2.62 KB
 pdo_named_execute.php2.74 KB
 pdo_named_execute_end.php2.71 KB
 pdo_output.php2.75 KB
 pdo_output_end.php2.94 KB
 pdo_transaction.php749 bytes
 pdo_transaction_end.php1.74 KB
 transfer.txt519 bytes
 pdo_check_balance.php2.27 KB
 pdo_check_balance_end.php2.3 KB
 pdo_array.php242 bytes
 pdo_array_end.php308 bytes
 car.php1.34 KB
 fetch_into.php338 bytes
 fetch_into_end.php589 bytes
 Select.txt212 bytes
 car.php1.34 KB
 fetch_class.php530 bytes
 fetch_class_end.php663 bytes
 pdo_resubmit.php1.13 KB
 pdo_reuse.php1.04 KB
 pdo_reuse_end.php1.12 KB
 pdo_scrollable.php1.26 KB
 mysqli_test.php356 bytes
 mysqli_test_end.php505 bytes
 mysqli_num_rows.php767 bytes
 mysqli_num_rows_end.php986 bytes
 mysqli_fetch_all.php465 bytes
 mysqli_fetch_array.php507 bytes
 mysqli_fetch_assoc.php952 bytes
 mysqli_fetch_assoc_end.php1.06 KB
 mysqli_fetch_row.php1.04 KB
 mysqli_reuse.php1017 bytes
 mysqli_reuse_end.php1.03 KB
 mysqli_delete.php327 bytes
 mysqli_insert.php303 bytes
 mysqli_insert_end.php481 bytes
 mysqli_error.php909 bytes
 mysqli_error_end.php981 bytes
 mysqli_escape.php1.39 KB
 mysqli_escape_end.php1.44 KB
 mysqli_statement.php2.42 KB
 mysqli_statement_end.php2.71 KB
 mysqli_statement.php2.7 KB
 mysqli_statement_end.php2.9 KB
 mysqli_statement.php2.9 KB
 mysqli_statement_end.php2.89 KB
 mysqli_transaction.php822 bytes
 mysqli_transaction_end.php1.89 KB
 transfer.txt553 bytes
 mysqli_check_balance.php2.51 KB
 mysqli_check_balance_end.php2.61 KB
 mysqli_real_query.php1.27 KB
 mysqli_real_query_end.php1.3 KB
 mysqli_multi.php482 bytes
 mysqli_multi_end.php1.33 KB
 QUERY.txt201 bytes
 car.php1.34 KB
 Car_end.php1.34 KB
 mysqli_class.php492 bytes
 mysqli_class_end.php492 bytes
 mysqli_class_stmt.php774 bytes
 oophp.db10 KB
 styles.css940 bytes
 oophp.sql8.52 KB


Description

As requested here: Thread: Official Tutorial Request thread (Torrents only)

Accessing Databases with Object-Oriented PHP
3h 47m
Intermediate
Jul 07, 2014

Now that PHP has true object-oriented capabilities, it's best practice to access databases using PDO (PHP Data Objects) and MySQLi. These methods produce database-neutral code that works with over a dozen systems, including MySQL, SQL Server, PostgreSQL, and SQLite. Learn how to use PDO and MySQLi to perform basic select, insert, update, and delete operations; improve security with prepared statements; and use transactions to execute multiple queries simultaneously. Author David Powers also covers advanced topics like instantiating custom objects, and compares PDO to MySQLi so you can decide which method is right for you.

Topics include:

Connecting to a database with PDO or MySQLi
Fetching a result set
Executing simple non-SELECT queries
Sanitizing user input
Binding input and output values
Passing an array of values to the execute() method
Working with advanced PDO fetch methods
Executing a MySQLi transaction
Freeing resources that are no longer needed
Submitting multiple queries
Creating an instance of a class from a result set

Sharing Widget


Download torrent
863.66 MB
seeders:1
leechers:8
Accessing Databases with Object-Oriented PHP - Lynda