Connecting to a Database using PHP (Part 2)

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