Interview question

How do you fetch data using PDO in different formats? PDO में data को अलग-अलग formats में कैसे fetch करें?

Answer

PDO supports several fetch styles controlled by PDO::FETCH_* constants.

Fetch mode	Returns
PDO::FETCH_ASSOC	Associative array with column names as keys
PDO::FETCH_OBJ	Anonymous stdClass object
PDO::FETCH_NUM	Array indexed by column position
PDO::FETCH_CLASS	Instance of a specified class

$stmt = $pdo->query('SELECT * FROM users');
$users = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($users as $user) {
    echo $user['name'];
}

PDO कई fetch styles support करता है PDO::FETCH_* constants के ज़रिए।

$stmt = $pdo->query('SELECT * FROM users');
$users = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($users as $user) {
    echo $user['name'];
}

Was this answer clear?

Related questions