note 33820 added to function.ibase-fetch-row
| From: | gurroa at gurroa dot cz | Date: | Tue, 08 Jul 2003 17:41:57 +0000 |
| Subject: | note 33820 added to function.ibase-fetch-row | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-51718@lists.php.net to get a copy of this message | ||
I had some troubles with moving php application from one dbase to another. From SyBase to Interbase.
Especially with missing function "ibase_num_rows($result)".
These are functions that helped me.
<?php
...
$dbh = ibase_connect ($host, $username, $password);
...
$ar_count_queries = array();
function ibasequery($query) {
$cquery = preg_replace("/SELECT(.*?)FROM(.*?)/","SELECT COUNT(*) FROM
\\2",$query);
if ($cquery != $query) {
$crow=get_object_vars( ibase_fetch_object( ibase_query( $GLOBALS["dbh"], $cquery ) ) );
}
@$res = ibase_query($GLOBALS["dbh"],$query);
if (isset($res)) {
if (isset($crow)) {
$GLOBALS["ar_count_queries"][$res] = $radcountselect["COUNT"];
}
return $res;
}
return false;
}
function ibasenumrows($result) {
return $GLOBALS["ar_count_queries"][$res];
}
function ibasefetchrow($result) {
return get_object_vars(ibase_fetch_object($result));
}
// example
$result = ibasequery("SELECT * FROM TABLE");
$numrows = ibasenumrows($result);
echo "Number of rows: $numrows.\nContent: \n";
while ($onerow = ibasefetchrow($res)) {
foreach($onerow as $key => $value) {
echo $key.": ".$value.", ";
}
echo "\n";
}
?>
Gurroa
----
Manual Page -- http://www.php.net/manual/en/function.ibase-fetch-row.php
Edit Note -- http://master.php.net/manage/user-notes.php?action=edit+33820
Delete Note -- http://master.php.net/manage/user-notes.php?action=delete+33820&report=yes
Reject Note -- http://master.php.net/manage/user-notes.php?action=reject+33820&report=yes