PHP connections to MySQL

Learn to connect PHP applications to MySQL databases using procedural and object-oriented code, create databases and tables, and perform insert, select, update, and delete queries.

Set up a local PHP development environment with Apache and MySQL using Apache Friends, enabling localhost access and phpMyAdmin to manage databases.

Set up a local Apache and MySQL environment, verify phpMyAdmin access, then create a settings file with four DB connection variables (host, user, password, database) for a new database.

Establish a PHP database connection using mysqli_connect, organize credentials in a settings file, and handle connection errors for reliable database access.

Create a new database with a setup script, establish a connection, and run a create database query to name it, such as my test.

Create a table named courses with id as an auto-incrementing primary key and a title column of varchar(255); use phpMyAdmin to run the query and prepare for data insertion.

Insert data into the courses table with PHP by setting column values, executing the insert query, and verifying results before preparing for select queries.

Select all from the courses table, output each row id, title, and lessons to the page, and use where, limit, and order by to refine results, then close the connection.

Learn to delete rows from a database using delete from table where id, targeting with a unique id, and test the queries before moving to object oriented connections.