note 42930 added to function.ibase-query
| From: | chrisg at cordell dot com dot au | Date: | Fri, 04 Jun 2004 03:57:30 +0000 |
| Subject: | note 42930 added to function.ibase-query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-70488@lists.php.net to get a copy of this message | ||
Simple function to retrieve the results of an SQL statement into an array, will also cater for BLOB
fields:
function interbase_sql_exec ($sql) {
$dataArr = array();
$host = "svrname:path\filename.GDB";
$username = "whatever";
$password = "******";
$connection = ibase_connect ($host, $username, $password,'ISO8859_1', '100',
'1');
$rid = @ibase_query ($connection, $sql);
if ($rid===false) errorHandle(ibase_errmsg(),$sql);
$coln = ibase_num_fields($rid);
$blobFields = array();
for ($i=0; $i < $coln; $i++) {
$col_info = ibase_field_info($rid, $i);
if ($col_info["type"]=="BLOB") $blobFields[$i] = $col_info["name"];
}
while ($row = ibase_fetch_row ($rid)) {
foreach ($blobFields as $field_num=>$field_name) {
$blobid = ibase_blob_open($row[$field_num]);
$row[$field_num] = ibase_blob_get($blobid,102400);
ibase_blob_close($blobid);
}
$dataArr[] = $row;
}
ibase_close ($connection);
return $dataArr;
}
----
Manual Page -- http://www.php.net/manual/en/function.ibase-query.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+42930
Delete -- http://master.php.net/manage/user-notes.php?action=delete+42930&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+42930&report=yes
Search -- http://master.php.net/manage/user-notes.php