Connecting to a Database using PHP

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