PHP for Beginners: PDO Crash Course

install and configure xampp on a virtual machine, choose PHP 7.4, set up Apache and MySQL with phpMyAdmin, and start the control panel to run the local server.

Install Sublime Text from the official site, complete the setup, and locate the program files directory. Use the left sidebar to view and open project files.

Connect to a database using pdo by initializing host, db name, user, and password. Instantiate the connection and test it with an if condition.

Use a try-catch with PDO to set error mode to exception via PDO::ATTR_ERRMODE and PDO::ERRMODE_EXCEPTION. Show friendly error messages by using getMessage and demonstrate no-error scenarios.

Learn to query data with PDO, write a select statement, fetch results row by row with a while loop, and retrieve titles and bodies from the posts table.

Learn how to retrieve data from a database in PHP using query and fetch, and loop with foreach for multiple rows in a PDO context.

Explore fetching from a PDO statement in PHP using associative arrays, indexes, and objects. Learn when to use associative or object fetch, and rely on the forms returned.

Learn how fetchColumn retrieves a single value from a PDO query by selecting the first column, using a separate connection file, and testing the default index zero.

Learn how to retrieve all data from a PDO statement using fetchAll, iterate results as arrays or objects, and access fields like title and body.

Master prepared statements, which sanitize user input and prevent sql injection by binding values to placeholders and executing secure inserts.

Update and delete records using PDO prepared statements in PHP. Bind parameters and execute update and delete queries on a posts table.

Count the number of rows returned by a SQL query to drive actions, such as printing results or showing no results, and iterate through records as an associative array.

Retrieve the last insert id after inserting records with PDO in PHP, enabling you to reference the newly created row for subsequent database operations.

Demonstrates using transactions in PHP with begin transaction, commit, and rollback, wrapped in a try-catch to handle exceptions and ensure atomic database operations.

Learn how to close the connection in this php pdo crash course by assigning the connection variable or dsn to null, preventing further queries.

Apply the like keyword to search for specific patterns in data, using wildcards to match emails, prepare and execute queries, and fetch matching user records.

The IN keyword lets you fetch specific rows by listing values in a where clause, demonstrated with select all from users where id in (15, 16, 17, 18) using PDO.

Set up a PDO database connection for a simple todos app using MySQL, configuring host, dbname, user, and password, enabling exception mode, and creating the database and tasks table.

Learn to insert data into a database with a PHP form by posting to index.php, requiring a connection, preparing an insert statement, and executing it with input data.

Learn how to insert data with a PDO prepared statement, prevent resubmission by redirecting after post, and pull and display all records from the tasks table in a loop.

Learn how to build a delete page in PHP using PDO, pass the record id via a get parameter, prepare and execute a delete query, and return to the index.

Demonstrates implementing an update flow in a PHP PDO app: build an update page, fetch data by ID, prefill a form, and run an update query to modify a task.