Insert, Delete data & using Images

Which of the following actions is essential to set up for storing images on a website?

• Create a dedicated folder for images on the server.

• Store images directly in the database.

• Use CSS to style the images.

• Save images as text in the database.

In PHP, which SQL statement is used to add a new record entry into the database?

• SELECT

• DELETE

• INSERT

• UPDATE

When adding an image to a table, how should the image data typically be stored?

• Store the full image in the database as binary data.

• Store only the image name and extension in a text field.

• Store the image as part of the PHP code.

• Embed the image in HTML.

What is the main purpose of the "addrecord.php" file?

• Display a list of records.

• Insert a new record entry into the database.

• Delete an existing record.

• Display the total number of records.

When preparing an INSERT query, what placeholder is used for the text data?

• :id

• :date

• :text

• :title

What is the function of bindValue() in the addrecord.php file?

• It deletes data from the database.

• It connects PHP to MySQL.

• It binds the value from the form input to the SQL query.

• It outputs form data to HTML.

In addrecord.php, which SQL command should be used to retrieve the current date automatically?

• DATE_NOW()

• CURDATE()

• GETDATE()

• CURRENT_TIMESTAMP()

Which of the following describes the purpose of deleterecord.php?

• It lists all records from the database.

• It allows users to delete specific records.

• It updates record content.

• It displays records with images.

How is the record ID typically passed to deleterecord.php?

• Via a hidden form element.

• Through an HTTP GET request.

• Using a CSS class.

• Directly through JavaScript.

In PHP, which method executes a prepared SQL statement?

• bindValue()

• execute()

• commit()

• prepare()