QUESTION 58
Consider the following table data and PHP code. What is a possible outcome?
Table data (table name "users" with primary key "id"):
id name email
--- ---- -----
1 anna alpha@example.com
2 betty beta@example.org
3 clara gamma@example.net
5 sue sigma@example.info

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];

Question

QUESTION 58
Consider the following table data and PHP code. What is a possible outcome?
Table data (table name "users" with primary key "id"):
id name email
--- ---- -----
1 anna alpha@example.com
2 betty beta@example.org
3 clara gamma@example.net
5 sue sigma@example.info

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];

Accepted Answer

C. The value of $row is array(0 => 'anna', 'name' => 'anna', 1 => 'alpha@example.com', 'email' => 'alpha@example.com').

Answer

A. The value of $row is array(0 => 'anna', 1 => 'alpha@example.com').

Answer

B. The value of $row is array('name' => 'anna', 'email' => 'alpha@example.com').

Answer

D. The value of $result is array('anna' => 'alpha@example.com').

QUESTION 58 Consider the following table data and PHP code. What is a possible outcome? Table data (table name "users" with primary key "id"): id name email --- ---- ----- 1 anna [email protected] 2…

Question

Options

How the community answered

Topics

Community Discussion