PHP 4.0 Bug #10568 Updated: error using ODBC
| From: | hpincheira at fasa dot cl | Date: | Wed, 02 May 2001 12:59:23 +0000 |
| Subject: | PHP 4.0 Bug #10568 Updated: error using ODBC | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-53320@lists.php.net to get a copy of this message | ||
ID: 10568
User Update by: hpincheira@fasa.cl
Old-Status: Feedback
Status: Open
Bug Type: ODBC related
Description: error using ODBC
(Iam using a traductor English/Spanish)
I use the software Microsoft Query for test the DNS connection and it worked very well, but when
I try to enter through php it throws me the mentioned error and not you that it is.
This is a script:
<?php
function a() {
$connect = odbc_connect ( dig , root , cir0921, SQL_CUR_USE_ODBC );
$query = SELECT * FROM local;
$result = odbc_exec($connect, $query);
while(odbc_fetch_row($result)) {
$id=odbc_result($result,1);
$pass=odbc_result($result,2);
echo id:$id,pass:$pass
;
}
odbc_close_all($connect);
return true;
} / / a
?>
<?php
echoLines Before;
$bb = a();
echo Lines Later;
?>
Previous Comments:
---------------------------------------------------------------------------
[2001-05-01 09:59:18] kalowsky@php.net
i'm not sure i understand the error you're receiving. can you please give a sample script
that creates the error?
also, are you sure your SELECT statement works properly?
---------------------------------------------------------------------------
[2001-04-30 18:37:36] hpincheira@fasa.cl
Hello:
I am using a database called " RECITAL ". I am trying to connect myself using ODBC. When
executing the command: odbc_exec($connect, $query) I can revise the connection from the database and
indeed her ago. But then treatment of consenting to the data using any function ODBC, for example:
--------------------------------
odbc_result_all($connect, BGCOLOR = ' #AAFFAA ' border=3 width=30% bordercolordark =
' #FF0000 '");
-------------------------------
and it throws me this error:
---------------------------------
Warning: Not tuples available at this result index in programa/apache c:/archivos
group/apache/htdocs/b.html on line 7
---------------------------------
I need to know if they can help me with this.
thank you.
(the table if it exists, some fields is: nlocal,ncontr)
This is the program php:
---------------------------------------
<?php
function to () {
$connect = odbc_connect (" dig ", " root ", cir0921, " SQL_CUR_USE_ODBC
");
$query = SELECT * local FROM";
$result = odbc_exec($connect, $query);
while(odbc_fetch_row($result)) {
$id=odbc_result($result,1);
$pass=odbc_result($result,2);
echo id:$id,pass:$pass
";
}
odbc_close_all($connect);
return true;
} / / a
?>
<?php
echo"Lines Before";
$bb = a();
echo " Lines Later";
?>
---------------------------------------
---------------------------------------------------------------------------
Full Bug description available at: http://bugs.php.net/?id=10568