ibase_name_result
(no version information, might be only in CVS)
ibase_name_result -- Assigns a name to a result set
Description
bool ibase_name_result ( resource result, string name)
This function assigns a name to a result set. This name
can be used later in UPDATE|DELETE ... WHERE CURRENT OF
name statements. Returns TRUE on success or FALSE on failure.
<?php
$result = ibase_query("SELECT field1,field2 FROM table
FOR UPDATE");
ibase_name_result($result, "my_cursor");
$updateqry = ibase_prepare("UPDATE table SET field2
= ? WHERE CURRENT OF my_cursor");
for ($i = 0; ibase_fetch_row($result); ++$i) {
ibase_execute($updateqry, $i);
}
?>
See also ibase_prepare() and ibase_execute().
ibase_num_fields
(PHP 3>= 3.0.7, PHP 4 )
ibase_num_fields -- Get the number of fields in a result
set
Description
int ibase_num_fields ( resource result_id)
Returns an integer containing the number of fields in a
result set.
<?php
$rs = ibase_query("SELECT * FROM tablename");
$coln = ibase_num_fields($rs);
for ($i = 0; $i < $coln; $i++) {
$col_info = ibase_field_info($rs, $i);
echo "name: " . $col_info['name'] . "\n";
echo "alias: " . $col_info['alias'] . "\n";
echo "relation: " . $col_info['relation'] . "\n";
echo "length: " . $col_info['length'] . "\n";
echo "type: " . $col_info['type'] . "\n";
}
?>
See also: ibase_field_info().
|
