ID: 10302
User Update by: [EMAIL PROTECTED]
Status: Open
Bug Type: ODBC related
Operating system: winnt4sp6
PHP Version: 4.0.4pl1
Description: odbc_tables()
Update:
The same script works fine using the CGI interface.
If I select the reload page button on the browser, it works using ISAPI about 1 in 5
times!
Previous Comments:
---------------------------------------------------------------------------
[2001-05-16 02:51:32] [EMAIL PROTECTED]
I have just updated php to 4.0.5 with the same results.
I also added odbc_error() and odbc_errormsg() after the
'SORRY . I Cant't Get The Table Details' message, and they return empty stings.
Thanks
John
---------------------------------------------------------------------------
[2001-04-23 12:27:53] [EMAIL PROTECTED]
code example:-
<?php
$dsn="php"; // System DSN
$user="GUEST";
$passwd="";
$db = odbc_connect($dsn,$user,$passwd);
if(!$db) {
echo "SORRY: could not connect to database<br>";
die();
}
//------------------------------------------------
// get table list
//------------------------------------------------
$table_list=array();
$result = odbc_tables($db);
if($result) {
$count=0;
// debug lines
echo odbc_num_rows($result) . " Tables found <br>";
odbc_result_all($result);
// end debug
while(($report = odbc_fetch_row($result))) {
$row[$count] = odbc_result($result,3);
$count++;
}
if($count > 0) {
sort($row);
for(reset($row);$table_list[]=current($row);next($row)) { }
} else {
echo "SORRY. I Can't Get The Table Details<br>";
die();
}
}
//-------------------------------------------------
// get field names
//-------------------------------------------------
if(!$tables)
$tables=$table_list[0];
$result = odbc_columns($db,"","","$tables");
if($result) {
$row=array();
$count=0;
while(($report = odbc_fetch_row($result))) {
$row[$count] = odbc_result($result,4);
$count++;
}
if($count > 0) {
sort($row);
for(reset($row);$columns[]=current($row);next($row)) {}
} else {
echo "SORRY. I Can't Get The Field Details<br>";
die();
}
}
odbc_close($db);
odbc_num_rows() returns a count of tables in the database,
odbc_results_all() returns no rows,
odbc_fetch_row() returns false.
---------------------------------------------------------------------------
[2001-04-18 21:37:34] [EMAIL PROTECTED]
can you please provide a sample script on how to reproduce this?
---------------------------------------------------------------------------
[2001-04-12 10:47:08] [EMAIL PROTECTED]
I think this may have been an issue in a previous release but I am still having it in
this version.
after calling odbc_tables() I can not get the results using odbc_fetch_row() or
odbc_result_all(), but odbc_num_rows() does return the number of tables in the
database.
The system is using the precomplied version downloaded from zend with the default
php.ini file. Oh and in ISAPI mode!
Thanks
---------------------------------------------------------------------------
Full Bug description available at: http://bugs.php.net/?id=10302
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
