public
Last active

fetch one row complete , observe that column name is uppercase and reponse in my case from the firebird server is 42

  • Download Gist
pdo_fetch_one_row_firebird.php
PHP
1 2 3 4 5 6 7 8
<?php
$str_conn="firebird:host=localhost;dbname=/var/lib/firebird/2.5/data/employee.fdb;charset=UTF8";
$connection = new PDO($str_conn, "sysdba", "masterkey");
$sql = 'select count(*) from employee';
$count = $connection->query($sql);
$row=$count->fetch();
echo $row['COUNT'];
?>

Please sign in to comment on this gist.

Something went wrong with that request. Please try again.