note 33653 added to ref.ibase
| From: | felixlee at singnet dot com dot sg | Date: | Thu, 03 Jul 2003 04:33:21 +0000 |
| Subject: | note 33653 added to ref.ibase | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-51396@lists.php.net to get a copy of this message | ||
Here's an example for getting results back from stored procedure in firebird.
The example make use of the stored procedure in Employee.gdb and the show_langs procedure.
$host = 'localhost:X:/firebird/examples/Employee.gdb';
$username='SYSDBA';
$password='masterkey';
$dbh = ibase_connect ( $host, $username, $password ) or die ("error in db connect");
$stmt="Select * from SHOW_LANGS('SRep',4,'Italy')";
$query = ibase_prepare($stmt);
$rs=ibase_execute($query);
$row = ibase_fetch_row($rs);
echo $row[0];
/* free result */
ibase_free_query($query);
ibase_free_result($rs);
/* close db */
ibase_close($dbh);
?>
----
Manual Page -- http://www.php.net/manual/en/ref.ibase.php
Edit Note -- http://master.php.net/manage/user-notes.php?action=edit+33653
Delete Note -- http://master.php.net/manage/user-notes.php?action=delete+33653&report=yes
Reject Note -- http://master.php.net/manage/user-notes.php?action=reject+33653&report=yes