itetcboo
-
Posts
5 -
Joined
-
Last visited
Never
Posts posted by itetcboo
-
-
Thanks for your answer,
I have put the code like this (entire code):
<?php if ($conn_access = odbc_connect ( "gestoria", "", "")) { echo "Conectado correctamente" . "<BR>"; $ssql = "select numero_expediente from expedientes where numero_expediente=1"; echo "<BR>" . $ssql . "<BR>"; if (odbc_error()) { echo odbc_errormsg($conn_access); } if($rs_access = odbc_exec ($conn_access, $ssql)){ echo "La sentencia se ejecuto correctamente"; $fila = odbc_fetch_row($rs_access,1); echo $fila; echo "<br>" . $fila->numero_expediente; }else{ //la sentencia no era correcta echo "Error al ejecutar la sentencia SQL"; } } else{ if (odbc_error()) { echo odbc_errormsg($conn_access); } echo "Error en la conexion con la base de datos"; } ?>
but nothing appears in the screen, just blank.. any other suggestion?
Thanks.
-
225 views and no one comment?
-
No1 can help me a little bit?
-
Hi all!
I have a mdb db, which I can access through odbc via php, but I can only make sql sentences like select * from mytable.
If I add a WHERE clause or something else, I get a blank page.
I have created a simple index.php with this code:
<?php if ($conn_access = odbc_connect ( "gestoria", "", "",SQL_CUR_USE_ODBC)) { echo "Conectado correctamente" . "<BR>"; $ssql = "select * from expedientes where numero_expediente=1"; echo "<BR>" . $ssql . "<BR>"; if($rs_access = odbc_exec ($conn_access, $ssql)){ echo odbc_num_rows($rs_access); echo "sql sentence succesfull"; while ($fila = odbc_fetch_object($rs_access)){ $fila = odbc_fetch_object($rs_access); echo "<br>" . $fila->numero_expediente; } }else{ echo "error trying to execute SQL"; } } else{ echo "Error conexion with db"; } ?>
any help please?
10x in advance
Blank results when adding any clause to sql sentence in php + odbc + msaccess
in Other RDBMS and SQL dialects
Posted
it seems a problem with suhosin patch, I'm trying to disable it....
I'll continue reporting you
Thanks so much.