Subject | Iterating through results. |
---|---|
Author | Uwe Oeder |
Post date | 2004-10-07T11:34:48Z |
I am using Apache 2.0.52 , PHP 5.0.2 , Firebird 1.5.1
I am using the php_interbase.dll extension.
Question 1 :
Is there any newer version or a .dll specific for firebird ?
I prepard the following query:
$DBHandle = ibase_connect ($host,$username,$password) or
die ("error in db connect") ;
$SQLStmt = "SELECT CountryName FROM Country ORDER BY CountryName" ;
$SQLQuery = ibase_prepare($SQLStmt) ;
$SQLData = ibase_execute($SQLQuery) ;
$TotalCountry = ibase_affected_rows() ;
echo "TotalCountrys = " . $TotalCountry ;
for ($Countrys = 1 ; $Countrys <= $TotalCountrys ; $Country++)
{
$row = ibase_fetch_row($SQLData) ;
echo $row[0] ;
}
Question 2 :
There should be more than 50 records displaying but interbase/firebird
reports 0 were affected.
How do I iterate through the resultset of a query ?
Question 3 :
Where can I find all the functions available to me ?
Mr. U. Oeder
Head of IT Departement
Creative-Logic
1 Dr Michael de Kock St.
Northern Industrial Area
Windhoek
Namibia
P.O. Box 9274
Phone : 061-262 941
Fax : 061-262 130
Email : uweo@...
----------
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.768 / Virus Database: 515 - Release Date: 9/22/2004
[Non-text portions of this message have been removed]
I am using the php_interbase.dll extension.
Question 1 :
Is there any newer version or a .dll specific for firebird ?
I prepard the following query:
$DBHandle = ibase_connect ($host,$username,$password) or
die ("error in db connect") ;
$SQLStmt = "SELECT CountryName FROM Country ORDER BY CountryName" ;
$SQLQuery = ibase_prepare($SQLStmt) ;
$SQLData = ibase_execute($SQLQuery) ;
$TotalCountry = ibase_affected_rows() ;
echo "TotalCountrys = " . $TotalCountry ;
for ($Countrys = 1 ; $Countrys <= $TotalCountrys ; $Country++)
{
$row = ibase_fetch_row($SQLData) ;
echo $row[0] ;
}
Question 2 :
There should be more than 50 records displaying but interbase/firebird
reports 0 were affected.
How do I iterate through the resultset of a query ?
Question 3 :
Where can I find all the functions available to me ?
Mr. U. Oeder
Head of IT Departement
Creative-Logic
1 Dr Michael de Kock St.
Northern Industrial Area
Windhoek
Namibia
P.O. Box 9274
Phone : 061-262 941
Fax : 061-262 130
Email : uweo@...
----------
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.768 / Virus Database: 515 - Release Date: 9/22/2004
[Non-text portions of this message have been removed]