Create a MySQL database for testing
- How to do the exercises (use 1.25x speed)
- What is PDO? (use 1.25x speed)
- About your development environment
- Alternative database creation using the terminal
- Creating a database with phpMyAdmin
- Practicing exercise 1 - New database
Connect to a database using the PHP PDO class
- Making a database connection using PDO
- Using individual variables to hold credential values
- Practicing exercise 2 – Connecting to the blogs database
- Result for exercise 2
- Using a try catch statement to handle PDO connection errors
- Discussed code and resources
Basic database querying and browser displaying using PHP
- Creating a new database connection
- Note about the next video
- The two PDO methods for querying a database
- Extracting data from the POD Statement
- Discussed code and resources
- Converting special characters to HTML entities
- Review - Things to know
- Moving SQL statements to variables
- Discussed code and resources
Prepare and execute a MySQL Statement using a PHP PDO object
- Creating a new connection for prepared statements
- Stage 1: Preparing the query
- Stage 2: Executing the query - rowCount
- Discussed code and resources
- Named placeholders
- Submitting the execute function without any arguments. Running multiple queries
- Discussed code and resources
The insert into statement
- Create a new connection file named dbinsert
- Initial Code
- Inserting a new record with Prepared Statements
- Discussed code and resources
- Displaying the number of affected rows
- Displaying content from the last inserted id
- Preparing output with HTML entities
- Discussed code and resources
The SQL update statement via a PDO object
- Initial code for this session
- SQL UPDATE with Prepared Statements
- Final code for this session
The delete statement
- Initial Code
- Deleting a record with Prepared Statements
- Final code for this session
Odds & ends
- Including a single database credential for multiples files
- Hiding a folder from the browser using htaccess
- Resources for this section
- Fetch arguments
- Final code and resources
- Enabling or disabling emulation of prepared statements (part 1)
- Initial code
- Enabling or disabling emulation of prepared statements (part 2)
- Final code and resources
- Bibliography
Thank you
- Thank you
