PHP&MySQL

A _______ is special software that knows how to respond to requests for web pages.

• web browser

• web server

• web client

• web database

What is HTML stands for?

• Hyperlink Transfer Protocol

• Hypertext Markup Language

• How To Make Lumpia

• Hypertext Transfer Potocol

_______ is a popular and powerful language used for programming server-side programs

• CSS

• HTML

• Mysql

• PHP

______ is a popular and free database system that can store information and then integrate with PHP to create a fully functional web application.

• Mysql

• MS ACCESS

• Logbook

• MSQL

______ is used for web programming to enhance or add to the user experience when using a web page.

• CSS

• Javascript

• PHP

• Bootstrap

______are expressions that PHP tests or evaluates to see whether they are true or false.

• Looping

• Switch

• Conditions

• Break

.....is a value which represents the current date and time of the system

• DateTime

• Day-Month-Year

• CURRENT_TIMESTAMP

• Current-Date

Which of the following PHP functions is used to establish a connection to a MySQL database?

• connect_mysql()

• db_connect()

• mysql_connect()

• mysqli_connect()

Which of the following is the correct syntax to select all records from a table called users in MySQL?

• SELECT * FROM users;

• SELECT all FROM users;

• GET * FROM users;

• SELECT all users FROM *;

What will the following MySQL query do?

SELECT COUNT(*) FROM orders WHERE order_date BETWEEN '2023-01-01' AND '2023-12-31';

• Count the number of orders placed in January 2023

• Count the total number of orders placed in 2023

• Count the number of orders that have no date assigned

• Retrieve all orders placed in 2023