";
$sql = 'SELECT DISTINCT fname, lname, dob FROM birthdays ORDER BY fname';
echo "query used
:". $sql."
";
try {
$stmt = $dbh->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL));
print "
fname , \t lname , \t dob ";
$stmt->execute();
while ($row = $stmt->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_NEXT)) {
$data = $row[0] . ",\t " . $row[1] . ",\t" . $row[2] ;
print "
";
print $data;
}
$stmt = null;
}
catch (PDOException $e) {
print $e->getMessage();
}
}
//
try {
$db = new PDO("pgsql:dbname=pgsdemo1;host=localhost", $user, $pwd );
echo "PDO connection object created";
echo "
with user : ". $user ."and pwd ".$pwd;
echo "
";
readData($db);
}
catch(PDOException $e)
{
echo $e->getMessage();
}
?>