Online PHP editor | output for 1sLR3H

@ 2025-10-18T12:52:32Z

<?php
error_reporting(E_ALL);
$db = new PDO("sqlite::memory:");
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$expectedFetchMode = \PDO::FETCH_OBJ;
$db->setAttribute(\PDO::ATTR_DEFAULT_FETCH_MODE, $expectedFetchMode);

print "Original (expected):\n";
$stmt = $db->query("SELECT 'v1' AS c1, 'v2' AS c2");
print_r($stmt->fetch());

print "\nPDOStatement::setFetchMode:\n";
$stmt = $db->query("SELECT 'v1' AS c1, 'v2' AS c2");
$stmt->setFetchMode(\PDO::FETCH_DEFAULT);
print_r($stmt->fetch());

print "\nPDOStatement::fetch:\n";
$stmt = $db->query("SELECT 'v1' AS c1, 'v2' AS c2");
print_r($stmt->fetch(\PDO::FETCH_DEFAULT));

print "\nPDOStatement::fetchAll:\n";
$stmt = $db->query("SELECT 'v1' AS c1, 'v2' AS c2");
print_r($stmt->fetchAll(\PDO::FETCH_DEFAULT));

print "\nPDO::setAttribute:\n";
try {
    $db->setAttribute(\PDO::ATTR_DEFAULT_FETCH_MODE, \PDO::FETCH_DEFAULT);
} catch (ValueError $e) {
    print "Could not set fetch mode using PDO::setAttribute: ". $e->getMessage() ."\n";
}

if ($db->getAttribute(\PDO::ATTR_DEFAULT_FETCH_MODE) !== $expectedFetchMode) {
    print __LINE__ ." Fetch mode changed\n";
}

print "Done!\n";

Output for 8.5.0 - 8.5.3: Original (expected): stdClass Object ( [c1] => v1 [c2] => v2 ) PDOStatement::setFetchMode: Fatal error: Uncaught ValueError: PDOStatement::fetch(): Argument #1 ($mode) must be a bitmask of PDO::FETCH_* constants in /in/1sLR3H:16 Stack trace: #0 /in/1sLR3H(16): PDOStatement->fetch() #1 {main} thrown in /in/1sLR3H on line 16
Process exited with code 255.
Output for 8.1.34, 8.2.30, 8.3.5 - 8.3.30, 8.4.9 - 8.4.14, 8.4.16 - 8.4.18: Original (expected): stdClass Object ( [c1] => v1 [c2] => v2 ) PDOStatement::setFetchMode: Array ( [c1] => v1 [0] => v1 [c2] => v2 [1] => v2 ) PDOStatement::fetch: stdClass Object ( [c1] => v1 [c2] => v2 ) PDOStatement::fetchAll: Array ( [0] => stdClass Object ( [c1] => v1 [c2] => v2 ) ) PDO::setAttribute: Could not set fetch mode using PDO::setAttribute: Fetch mode must be a bitmask of PDO::FETCH_* constants Done!
Output for 8.4.15: /bin/php-8.4.15: /usr/lib/libm.so.6: version `GLIBC_2.38' not found (required by /bin/php-8.4.15) /bin/php-8.4.15: /usr/lib/libm.so.6: version `GLIBC_2.35' not found (required by /bin/php-8.4.15) /bin/php-8.4.15: /usr/lib/libc.so.6: version `GLIBC_2.34' not found (required by /bin/php-8.4.15) /bin/php-8.4.15: /usr/lib/libc.so.6: version `GLIBC_2.38' not found (required by /bin/php-8.4.15)
Process exited with code 1.

preferences:dark modelive previewkey bindings