AWS, JavaScript, React - Deploy Web Apps on the Cloud - Testing MariaDB Connection from PHP (Part 1)

This tutorial covers the basics of interacting with a database using PHP. It starts with an introduction to PHP and databases, followed by setting up a Mariadb database and creating a user. The tutorial then demonstrates how to connect to the database, create tables, and insert data using SQL commands. Finally, it verifies the data insertion by retrieving and displaying the data from the database.

Why is it important for PHP scripts to interact with databases in web applications?

• To enhance the visual design of the website

• To store and manage user data effectively

• To increase the speed of the website

• To reduce the cost of web hosting

What is the first step in setting up a new MariaDB database?

• Logging in as the root user

• Inserting sample data

• Creating a new table

• Creating a new database

Why should you avoid executing instructions to MariaDB as the root user?

• It is slower than using a non-root user

• It requires more memory

• It can lead to security vulnerabilities

• It is not supported by MariaDB

What command is used to log into MariaDB with a specific user?

• create database

• sudo mariadb

• mysql -u username -p

• grant all privileges

What is the purpose of the 'GRANT ALL' command in MariaDB?

• To create a new database

• To delete a user

• To give a user full privileges on a database

• To reset the database

What is the primary key in a database table?

• A column that stores only numeric data

• A column that uniquely identifies each row

• A column that is always empty

• A column that can have duplicate values

What does the 'AUTO_INCREMENT' attribute do in a table column?

• Automatically changes the data type

• Automatically increases the value of the column for each new row

• Automatically deletes duplicate entries

• Automatically encrypts the data

Which SQL command is used to insert data into a table?

• INSERT

• UPDATE

• SELECT

• DELETE

How can you confirm that data has been successfully inserted into a table?

• By using the CREATE command

• By using the UPDATE command

• By using the SELECT command

• By using the DELETE command

What does the SQL SELECT statement do?

• It creates a new table

• It updates data in a table

• It retrieves data from a table

• It deletes data from a table