|
|
 |
XLIV. InterBase-Funktionen
InterBase ist eine bekannte Datenbank, die von Borland/Inprise
stammt. Weitere Informationen zu InterBase finden sie unter
. Wichtig: InterBase
befindet sich gerade auf dem Weg zum Open Source!
Anmerkung:
Umfassende Unterst�tzung f�r InterBase 6 wurde in PHP 4.0
eingef�hrt.
User Contributed Notes
InterBase-Funktionen |
 |
johan at essay dot org
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 !
|
|
theynich_s at yahoo dot com
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>
|
|
interbase at almico dot com
05-Sep-2002 09:24 |
|
If you are using VirtualHosts with Apache, you might find useful the
following directive:
php_flag magic_quotes_sybase on
Use it
in any VirtualHost and it will be set locally to that VirtualHost without
interfering with any global setting.
This is an
example:
<VirtualHost 555.666.777.888>
ServerName
www.samplehost.com
DirectoryIndex index.php index.htm
php_flag
magic_quotes_sybase on
</VirtualHost>
|
|
lars at dybdahl dot net
20-Sep-2002 02:32 |
|
It is not possible to use interbase/firebird without initiating
transactions. It seems that transactions are not automatically committed
or rolled back at the end of a script, so remember to end all interbase
enabled scripts with ibase_rollback() or ibase_commit().
Worse is,
that if you use ibase_pconnect (recommended), transactions survive from
one request to the next. So that if you don't rollback your transaction at
the end of the script, another user's request might continue the
transaction that the first request opened.
This has two
implications:
1) Clicking refresh in your browser won't make you see
newer data, because you still watch data from the same transaction.
2)
Some php scripts might fail occassionally and not fail in other occasions,
depending on with apache server thread and thereby which transaction they
start using.
Unfortunately, there is no such thing as
if
(ibase_intransaction()) ibase_rollback();
so be sure that ALL your
scripts end with an ibase_rollback() or ibase_commit();
|
|
al2925DONTSPAMME at mail dot ru
05-Mar-2003 09:24 |
|
You should better use gds32.dll provided with that version of
Firebird/Interbase you're going to connect to.
|
|
|
|
| |
PHP Handbuch
Funktionsreferenz
Apache
ifxus_write_slob