";
//$sql = 'SELECT eid, fname, lname FROM Emp1 ORDER BY eid';
//$sql = 'SELECT DISTINCT * FROM Emp1 ORDER BY fname';
$sql = 'SELECT DISTINCT * FROM emp1 ORDER BY fname';
echo "query used
:". $sql."
";
try {
$stmt = $dbh->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL));
$stmt->execute();
if($stmt){ echo "executed"; }
while ($row = $stmt->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_NEXT)) {
$data = $row[0] . ",\t " . $row[1] . ",\t" . $row[2] . ",\t" . $row[3]. ",\t" . $row[4];
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();
}
?>