Font size
WorksheetsConnecting to a Database using PHP
Total questions: 9
Worksheet time: 5mins
What does the mysqli_connect command do?
It connects to the web server
It connects to the email server
It connects to the database server
Choose the correct way to use the mysqli_connect() command.
$servername - Address of the Target Database Server
$databasename - Name of the Target Database
$username - User Name
$password - User's Password
mysqli_connect($username, $password, $servername, $databasename)
mysqli_connect($databasename, $servername, $username, $password, )
mysqli_connect($servername, $databasename, $username, $password)
mysqli_connect($servername, $username, $password, $databasename)
In the code above what is the $dbconnection used for?
It is used to check if the connection was false
It is used to store the connection to the database
It is used to check if the connection was successful
It is used to store the database
I have written the following SQL command, what is the command I need to execute to run the SQL?
$sql = "SELECT name, phone, email FROM tblmembers"
mysqli_fetch_assoc($sql)
mysqli_query($dbconnection, $sql);
mysqli_fetch_assoc($dbconnection, $sql)
mysqli_query($sql);
What do you get when you execute the mysqli_query command?
Selected Records from the Web Server
Selected Records from the Database
If the page was successfully loaded
If the query was successfully executed
The above Code has been executed and results in the table have been retrieved
How can I get the Phone number in the results?
$row[2]
$row["Phone"]
$result["Phone"]
$result[2]
Results in the Table above have been retrieved using sqli_query and saved in the $result variable
What will the code output to the HTML page?
Alice John James
$row["regname"] $row["regname"] $row["regname"]
Alice
John
James
$row["regname"]
$row["regname"]
$row["regname"]
Given $results in the table above
$x = mysqli_num_rows($result)
What is the value of x?
3
1
2
4
Which is the correct order for these commands to appear in a typical PHP page
1 - mysqli_query
2 - mysqli_num_rows
3 - mysqli_connect
4 - mysqli_fetch_assoc
3, 2, 1, 4
1, 2, 3, 4
3, 1, 2, 4
3, 2, 4, 1
