|
|
 |
XLIV. InterBase functionsBevezet�s
InterBase is a popular database put out by Borland/Inprise. More
information about InterBase is available at . Oh, by the way, InterBase
just joined the open source movement!
Megjegyz�s:
Full support for InterBase 6 was added in PHP 4.0.
This database uses a single quote (') character for escaping, a
behavior similar to the Sybase database, add to your
php.ini the following directive:
El�re defini�lt �lland�k
Az itt list�zott �lland�kat ez a kiterjeszt�s
defini�lja, �s csak akkor el�rhet�ek, ha az adott
kiterjeszt�s be van ford�tva a PHP-be, vagy
dinamikusan bet�lt�tt.
User Contributed Notes
InterBase functions |
  |
[email protected]
07-Aug-2000 02:24 |
|
For those who have problem with returning values from Stored Procedures in
PHP-Interbase, I have found a solution. Use a select sentence like
this:
select * from sp_prodecure(param, ...)
However, it is
important that the procedure has a SUSPEND statement or else the procedure
won't return any values.
But the "message length" (see
above note) bug that you encounter when you try to execute a procedure
should be fixed !
|
|
[email protected]
11-May-2002 06:16 |
|
Hello PHP Mania,
i have made a paging for PHP with Interbase......
:)
i hope it usefull and work....:)
it`s a litle bit of
example :
<?
$connection = ibase_connect($yourdb, $user,
$password);
$filename = BASENAME(__FILE__);
$strsql = "Your
SQL";
$result = ibase_query($connection, $strsql);
function
ibase_num_rows($query) { //I have pick it from [email protected]
$i
= 0;
while (ibase_fetch_row($query)) {
$i++;
}
return
$i;
}
$nrow = ibase_num_rows($result);//sum of row
$strSQL =
"your SQL";
$result = ibase_query($connection,
$strSQL);
if (!isset($page))
$page = 1;
$$i =
0;
$recperpage = 4;
$norecord = ($page - 1) * $recperpage;
if
($norecord){
$j=0;
while($j < $norecord and list($code,
$name)= ibase_fetch_row($result)){
$j++;
}
}
echo
"<table>";
while (list($code, $name)=
ibase_fetch_row($result) and $i < $recperpage){
?>
<tr>
<td width="5%"><? echo $code;
?></td>
<td><? echo $name;
?></td>
</tr>
<?
$i++;
}
$incr =
$page + 1;
if ($page > 1) $decr = $page - 1;
$numOfPage =
ceil($nrow/$recperpage);
?>
<tr>
<td
colspan="3" align="center"><?if ($page <=
1)
echo "<span>Prev</span>";
else
echo "<a
href=".$filename."?page=".$decr.">Prev</a>";
?>
<?if
($page == $numOfPage)
echo
"<span>Next</span>";
else
echo
"<a
href=".$filename."?page=".$incr.">Next</a>";?>
</td>
</tr>
</table>
|
|
|
|
| |
ifxus_write_slob