Font size
WorksheetsConnecting to a Database using PHP (Part 2)
Total questions: 9
Worksheet time: 5mins
The aim of this code is to connect to a Database. Replace the COMMAND_A with the correct command.
mysqli_connect_error
mysqli_query
mysqli_connect
mysqli_fetch_row
The aim of this code is to connect to a Database. Replace the COMMAND_B with the correct command.
mysqli_connect_error
mysqli_query
mysqli_connect
mysqli_fetch_row
You have created the following user for your MySQL database located on "localhost"
Which of the following commands will connect successfully?
mysqli_connect(
"newuser",
"123",
"localhost",
"dbstudents");
mysqli_connect(
"localhost",
"newuser",
"123",
"dbstudents");
mysqli_connect(
"localhost",
"dbstudents",
"newuser",
"123");
mysqli_connect(
"localhost",
"newuser",
"123");
The result of the mysqli_connect() function is very useful.
What can you use $result to do?
Check if result is FALSE:
if ($result == FALSE)
Check if the connection is successful:
if ($result == FALSE)
Execute a SQL query:
mysqli_query
($result, $sql)
Get the number of results in a SQL query:
mysqli_num_rows
($result)
Why is it important to have this line of code?
include_once "1_Connect_DB.php";
It includes the code from another PHP file which connects to the database
It includes the code from another PHP file which creates a new database
It includes the code from another PHP file which enables the code to run error-free
It includes the code from another PHP file which allows
What does the following code do?
$result = mysqli_query($A, $B);
It creates a new query connection to the database to get a result
It makes use of PHP to get a result from the database
It makes use of a query to the database to get a result
It makes use of a database connection to execute an SQL statement
What should be the variable $A?
$result = mysqli_query($A, $B);
*HINT: it was created using the mysqli_connect command
$A should be the method you wish to connect to the database
$A should be the database connection
$A should be the SQL statement that you want to execute
$A should be the results of the SQL query that you want to execute
The table shows the results of the query to the database.
echo mysqli_num_rows($result);
What is the result of the code above?
1
2
3
4
What is the result of the following code?
while ($row = mysqli_fetch_assoc($result)) {
echo $row["Taste"];
echo "<br>";
}
Sour
Sweet
Bitter
1
2
3
Apple
Orange
Bittergourd
1 Apple Sour
2 Orange Sweet
3 Bittergourd Bitter
