What is a possible outcome?

Consider the following table data and PHP code.

What is a possible outcome?

Table data (table name "users" with primary key "id"):

PHP code (assume the PDO connection is correctly established):

$dsn = ‘mysql:host=localhost;dbname=exam’;

$user= ‘username’;

$pass=’********’;

$pdo = new PDO($dsn, $user, $pass);

$cmd = "SELECT name, email FROM users LIMIT 1";

$stmt = $pdo->prepare($cmd);

$stmt->execute();

$result= $stmt->fetchAll(PDO::FETCH_BOTH);

$row= $result[0];
A . The value of $row is ‘array(0 => ‘anna’, 1 => ‘[email protected]’)’.
B . The value of $row is ‘array(‘name’ => ‘anna’, ’email’=> ‘[email protected]’)’.
C . The value of $row is ‘array(0 => ‘anna’, ‘name’ => ‘anna’, 1 => ‘[email protected]’, ’email’ => ‘[email protected]’)’.
D . The value of $result is ‘ array(‘anna’ => ‘[email protected]’)’.

View Answer

Answer: C