Consider the following table data and PHP code. What is the 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
4 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 * FROM users WHERE id = :id';
$stmt = $pdo-prepare($cmd);
$id = 3;
$stmt-bindParam('id', $id);
$stmt-execute();

$stmt-bindColumn(3, $result);
$srow = $stmt-fetch(PDO::FETCH_BOUND);

Question

Consider the following table data and PHP code. What is the 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
4 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 * FROM users WHERE id = :id';
$stmt = $pdo->prepare($cmd);
$id = 3;
$stmt->bindParam('id', $id);
$stmt->execute();

$stmt->bindColumn(3, $result);
$srow = $stmt->fetch(PDO::FETCH_BOUND);

Accepted Answer

D. The value of $result will be 'gamma@example.net'.

Answer

A. The database will return no rows.

Answer

B. The value of $srow will be an array.

Answer

C. The value of $result will be empty.

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

Question

Options

How the community answered

Topics

Community Discussion