Accessing Databases with Object Oriented PHP Tutorial Lynda | 1C149FFF0A52429062279C48C0E3E5D7C1228542

Accessing Databases with Object Oriented PHP Tutorial Lynda

Name	Accessing Databases with Object-Oriented PHP Tutorial - Lynda	DOWNLOAD Copy Link
Total Size	905.6 MB
Total Files	141
Hash	1C149FFF0A52429062279C48C0E3E5D7C1228542

/04. PDO-Prepared Statements and Transactions/
04_02-Using named parameters.mp4	46.2 MB
04_01-Binding input and output values.mp4	5.5 MB
04_03-Using question marks as anonymous placeholders.mp4	11.9 MB
04_04-Passing an array of values to the execute() method.mp4	24.7 MB
04_05-Binding results to variables.mp4	37.7 MB
04_06-Executing a transaction.mp4	27.5 MB
04_07-Closing the cursor before running another query.mp4	22.3 MB
/01. Introduction/
01_02-What you should know before watching this course.mp4	3.2 MB
01_03-Using the exercise files.mp4	17.5 MB
01_04-Setting SQLite permissions.mp4	2.8 MB
01_05-A quick primer on using PHP objects.mp4	10.5 MB
01_01-Welcome.mp4	10.0 MB
/02. Why Use Object-Oriented PHP to Access a Database/
02_01-Overview of PHP database APIs.mp4	11.8 MB
02_02-Using prepared statements.mp4	9.8 MB
02_03-Using transactions.mp4	4.0 MB
/03. PHP Data Object (PDO) Basics/
03_01-Creating a database source name.mp4	5.0 MB
03_02-Connecting to a database with PDO.mp4	32.9 MB
03_03-Looping directly over a SELECT query.mp4	15.7 MB
03_04-Fetching a result set.mp4	37.7 MB
03_05-Finding the number of results from a SELECT query.mp4	33.8 MB
03_06-Checking if a SELECT query contains results.mp4	16.4 MB
03_07-Executing simple non-SELECT queries.mp4	15.5 MB
03_08-Getting error messages.mp4	34.1 MB
03_09-Using the quote() method to sanitize user input.mp4	16.1 MB
/05. Advanced PDO Fetch Methods/
05_01-Generating an array from a pair of columns.mp4	10.6 MB
05_02-Setting an existing object`s properties with a database result.mp4	15.1 MB
05_03-Creating an instance of a specific class with a database result.mp4	21.3 MB
05_04-Reusing a result set.mp4	35.3 MB
/06. MySQL Improved Basics/
06_01-Connecting to a database with MySQLi.mp4	18.5 MB
06_02-Setting the character set.mp4	4.5 MB
06_03-Submitting a SELECT query and getting the number of results.mp4	19.5 MB
06_04-Fetching the result.mp4	26.1 MB
06_05-Rewinding the result for reuse.mp4	15.0 MB
06_06-Handling non-SELECT queries.mp4	23.1 MB
06_07-Getting error messages.mp4	24.2 MB
06_08-Sanitizing user input with real_escape_string().mp4	14.2 MB
/07. MySQLi Prepared Statements and Transactions/
07_01-Initializing and preparing a statement.mp4	20.3 MB
07_02-Binding parameters and executing a prepared statement.mp4	27.7 MB
07_03-Binding output variables.mp4	24.2 MB
07_04-Executing a MySQLi transaction.mp4	33.2 MB
07_05-Dealing with commands out of sync in prepared statements.mp4	25.7 MB
/08. Diving Deeper into MySQLi/
08_01-Buffered and unbuffered queries.mp4	9.9 MB
08_02-Using real_query().mp4	28.4 MB
08_03-Freeing resources that are no longer needed.mp4	4.2 MB
08_04-Submitting multiple queries.mp4	28.5 MB
08_05-Creating an instance of a class from a result set.mp4	15.7 MB
/09. Conclusion/
09_01-PDO and MySQLi compared.mp4	7.7 MB
/Exercice Files/ch01/
phpinfo.php	0.0 KB
/Exercice Files/ch02/02_02/
pdo_connect.php	0.3 KB
pdo_test.php	0.4 KB
pdo_test_end.php	0.5 KB
/Exercice Files/ch02/02_03/
pdo_loop.php	0.7 KB
pdo_loop_end.php	0.9 KB
/Exercice Files/ch02/02_04/
pdo_fetch.php	0.7 KB
pdo_fetchAll.php	0.6 KB
pdo_fetchAll_end.php	0.7 KB
pdo_fetchColumn.php	0.8 KB
pdo_fetchColumn_end.php	0.8 KB
pdo_fetch_end.php	0.9 KB
/Exercice Files/ch02/02_05/
pdo_rowcount.php	0.9 KB
/Exercice Files/ch02/02_06/
pdo_checkrow.php	0.9 KB
pdo_checkrow_end.php	1.1 KB
/Exercice Files/ch02/02_07/
exec_delete.php	0.2 KB
exec_delete_end.php	0.3 KB
exec_insert.php	0.3 KB
exec_insert_end.php	0.4 KB
query_insert.php	0.3 KB
query_insert_end.php	0.4 KB
/Exercice Files/ch02/02_08/
pdo_error.php	0.9 KB
/Exercice Files/ch02/02_09/
pdo_quote.php	1.4 KB
pdo_quote_end.php	1.4 KB
/Exercice Files/ch03/03_02/
pdo_named.php	2.4 KB
pdo_named_end.php	2.8 KB
/Exercice Files/ch03/03_03/
pdo_anonymous.php	2.8 KB
pdo_anonymous_end.php	2.8 KB
/Exercice Files/ch03/03_04/
pdo_anonymous_execute.php	2.8 KB
pdo_anonymous_execute_end.php	2.7 KB
pdo_named_execute.php	2.8 KB
pdo_named_execute_end.php	2.8 KB
/Exercice Files/ch03/03_05/
pdo_output.php	2.8 KB
pdo_output_end.php	3.0 KB
/Exercice Files/ch03/03_06/
pdo_transaction.php	0.7 KB
pdo_transaction_end.php	1.8 KB
transfer.txt	0.5 KB
/Exercice Files/ch03/03_07/
pdo_check_balance.php	2.3 KB
pdo_check_balance_end.php	2.4 KB
/Exercice Files/ch04/04_01/
pdo_array.php	0.2 KB
pdo_array_end.php	0.3 KB
/Exercice Files/ch04/04_02/
Car.php	1.4 KB
fetch_into.php	0.3 KB
fetch_into_end.php	0.6 KB
select.txt	0.2 KB
/Exercice Files/ch04/04_03/
Car.php	1.4 KB
fetch_class.php	0.5 KB
fetch_class_end.php	0.7 KB
/Exercice Files/ch04/04_04/
pdo_resubmit.php	1.2 KB
pdo_reuse.php	1.1 KB
pdo_reuse_end.php	1.1 KB
pdo_scrollable.php	1.3 KB
/Exercice Files/ch05/05_01/
mysqli_test.php	0.4 KB
mysqli_test_end.php	0.5 KB
/Exercice Files/ch05/05_03/
mysqli_num_rows.php	0.8 KB
mysqli_num_rows_end.php	1.0 KB
/Exercice Files/ch05/05_04/
mysqli_fetch_all.php	0.5 KB
mysqli_fetch_array.php	0.5 KB
mysqli_fetch_assoc.php	1.0 KB
mysqli_fetch_assoc_end.php	1.1 KB
mysqli_fetch_row.php	1.1 KB
/Exercice Files/ch05/05_05/
mysqli_reuse.php	1.0 KB
mysqli_reuse_end.php	1.1 KB
/Exercice Files/ch05/05_06/
mysqli_delete.php	0.3 KB
mysqli_insert.php	0.3 KB
mysqli_insert_end.php	0.5 KB
/Exercice Files/ch05/05_07/
mysqli_error.php	0.9 KB
mysqli_error_end.php	1.0 KB
/Exercice Files/ch05/05_08/
mysqli_escape.php	1.4 KB
mysqli_escape_end.php	1.5 KB
/Exercice Files/ch06/06_01/
mysqli_statement.php	2.5 KB
mysqli_statement_end.php	2.8 KB
/Exercice Files/ch06/06_02/
mysqli_statement.php	2.8 KB
mysqli_statement_end.php	3.0 KB
/Exercice Files/ch06/06_03/
mysqli_statement.php	3.0 KB
mysqli_statement_end.php	3.0 KB
/Exercice Files/ch06/06_04/
mysqli_transaction.php	0.8 KB
mysqli_transaction_end.php	1.9 KB
transfer.txt	0.6 KB
/Exercice Files/ch06/06_05/
mysqli_check_balance.php	2.6 KB
mysqli_check_balance_end.php	2.7 KB
/Exercice Files/ch07/07_02/
mysqli_real_query.php	1.3 KB
mysqli_real_query_end.php	1.3 KB
/Exercice Files/ch07/07_04/
mysqli_multi.php	0.5 KB
mysqli_multi_end.php	1.4 KB
query.txt	0.2 KB
/Exercice Files/ch07/07_05/
Car.php	1.4 KB
Car_end.php	1.4 KB
mysqli_class.php	0.5 KB
mysqli_class_end.php	0.5 KB
mysqli_class_stmt.php	0.8 KB
/Exercice Files/
oophp.sql	8.7 KB
/Exercice Files/sqlite/
oophp.db	10.2 KB
/Exercice Files/styles/
styles.css	0.9 KB
Total files 141