pdo_pgsql2.htm
 
Script :

<?php
$user="manas237";
$pwd ="pwmanas237";
// function
function readData($dbh) {
echo "This table has duplciate data <br/>";
$sql = 'SELECT DISTINCT fname, lname, dob FROM birthdays ORDER BY fname';
echo "query used <br/> :". $sql."<br/>";
try {
$stmt = $dbh->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL));
print "<br/> <span class='t1'>fname , \t lname , \t dob </span>";
$stmt->execute();

while ($row = $stmt->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_NEXT)) {
$data = $row[0] . ",\t " . $row[1] . ",\t" . $row[2] ;
print "<br/>";
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 "<br/> with user : ". $user ."and pwd ".$pwd;
echo "<br/>";
readData($db);
}
catch(PDOException $e)
{
echo $e->getMessage();
}
?>