Databases and connections to PHP
The course begins with an introduction to relational databases. Students will gain a basic understanding of database concepts, the structure of tables, relationships between tables, and the meaning of key terms such as primary key and foreign key.
An essential part of the course is the comparison between MySQLi and PDO, two common extensions for interacting with MySQL databases in PHP. Participants will learn the advantages and disadvantages of both methods in order to make informed decisions about which method to use in their projects.
Participants will learn how to create and manage database connections. This includes setting up secure connections to the database and handling connection errors.
It also covers basic CRUD operations (Create, Read, Update, Delete) that form the basis for working with databases. Participants will learn how to:
- Insert data into the database (Create)
- Retrieve data from the database (Read)
- Update data in the database (Update)
- Delete data from the database (Delete)
Practical exercises and examples will enable participants to apply these techniques in their own PHP applications.