note 113237 added to class.pdostatement
| From: | luis-m-cardoso at ext dot ptinovacao dot pt | Date: | Mon, 16 Sep 2013 14:53:54 +0000 |
| Subject: | note 113237 added to class.pdostatement | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-196271@lists.php.net to get a copy of this message | ||
Solved ;)
<?php
$host = "yourHost";
$user = "yourUser";
$pass = "yourPass";
$db = "yourDB";
$cursor = "cr_123456";
try
{
$dbh = new PDO("pgsql:host=$host;port=5432;dbname=$db;user=$user;password=$pass");
echo "Connected<p>";
}
catch (Exception $e)
{
echo "Unable to connect: " . $e->getMessage() ."<p>";
}
$dbh->beginTransaction();
$query = "SELECT yourFunction(0::smallint,'2013-08-01 00:00','2013-09-01
00:00',1::smallint,'$cursor')";
$dbh->query($query);
$query = "FETCH ALL IN \"$cursor\"";
echo "begin data<p>";
foreach ($dbh->query($query) as $row)
{
echo "$row[0] $row[1] $row[2] <br>";
}
echo "end data";
?>
----
Server IP: 69.147.83.199
Probable Submitter: 188.82.142.237
----
Manual Page -- http://php.net/manual/en/class.pdostatement.php
Edit -- https://master.php.net/note/edit/113237
Del: integrated -- https://master.php.net/note/delete/113237/integrated
Del: useless -- https://master.php.net/note/delete/113237/useless
Del: bad code -- https://master.php.net/note/delete/113237/bad+code
Del: spam -- https://master.php.net/note/delete/113237/spam
Del: non-english -- https://master.php.net/note/delete/113237/non-english
Del: in docs -- https://master.php.net/note/delete/113237/in+docs
Del: other reasons-- https://master.php.net/note/delete/113237
Reject -- https://master.php.net/note/reject/113237
Search -- https://master.php.net/manage/user-notes.php