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 => ‘alpha@example.com’)’.
B . The value of $row is ‘array(‘name’ => ‘anna’, ’email’=> ‘alpha@example.com’)’.
C . The value of $row is ‘array(0 => ‘anna’, ‘name’ => ‘anna’, 1 => ‘alpha@example.com’, ’email’ => ‘alpha@example.com’)’.
D . The value of $result is ‘ array(‘anna’ => ‘alpha@example.com’)’.
Answer: C