PHP and MySQL Tutorial Series (Part 2)

Click here for part 1 of this series.

Get Request

Shows how to pass data between pages or with different parameters.

PHP and MySQL 7 - Get Request from ObjectGraph LLC on Vimeo.

Post Request

Shows how to submit data by passing values between two scripts or within one script. Uses a form as an example.

PHP and MySQL 8 - Post Request from ObjectGraph LLC on Vimeo.

Secure Coding

Explains how to avoid security and validation issues in PHP using htmlspecialchars and is_numeric.

PHP and MySQL 9 - Secure Coding from ObjectGraph LLC on Vimeo.

JSON

Shows how to create a dictionary and retrieve data using a lightweight JSON format. Also shows how the JSON View plugin creates an easy-to-read format.

PHP and MySQL 10 - JSON Web Service from ObjectGraph LLC on Vimeo.

Database Query

Shows how to access a database from a PHP program by connecting to the database with a connection string, getting results with a query, displaying results, and closing the connection. Also introduces a PHP library called PDO (PHP Data Object).

PHP and MySQL 11 - Database Query from ObjectGraph LLC on Vimeo.

Update, Insert, and Delete

Shows how to update database data from a PHP program using exec.

PHP and MySQL 12 - Update, Insert and Delete from ObjectGraph LLC on Vimeo.

Query and Input

Introduces providing parameters as dynamic input from the URL (instead of hard coding the parameters) to plug into a query.

PHP and MySQL 13 - Query and Input from ObjectGraph LLC on Vimeo.

SQL Injection and Secure Coding

Explains why it is important to avoid harmful SQL injection to make your query more secure.

PHP and MySQL 14 - SQL Injection and Secure Coding from ObjectGraph LLC on Vimeo.

Binding Parameter and Secure Coding

Expands on queries by using prepare, bindParam, execute, and fetchAll functions to avoid SQL injection. Also explains how to avoid the default key value pair duplication that occurs when using PDO by passing PDO::FETCH_ASSOC to the function.

PHP and MySQL 15 - Binding Parameter and Secure Coding from ObjectGraph LLC on Vimeo.

Creating Web Service

Shows how to construct a simple web service to retrieve data in JSON format. Also explains how you can use the JSON output on the client side.

PHP and MySQL 16 - Creating Web Service from ObjectGraph LLC on Vimeo.

Closing Comment

Concludes PHP and MySQL lessons.

PHP and MySQL 17 - Closing Comment from ObjectGraph LLC on Vimeo.