topic Re: Help in PHP access to database in Operating System - HP-UX

Help in PHP access to database

Ricardo Bassoi — Thu, 31 Jul 2003 20:58:18 GMT

Hi All,

I??m new at PHP and I found some problems trying to pass a call to a function ( ABRE_CL() ) inside the option fied in the form.
Somebody can help ?

Regards

Bassoi

Re: Help in PHP access to database

Ricardo Bassoi — Thu, 31 Jul 2003 21:00:05 GMT

Sorry ,

The attachment is not so good !

Regards

Re: Help in PHP access to database

Ricardo Bassoi — Thu, 31 Jul 2003 21:01:15 GMT

Hi Again,

I??ll try the last time

Re: Help in PHP access to database

Ricardo Bassoi — Thu, 31 Jul 2003 21:02:14 GMT

Re: Help in PHP access to database

benoit Bruckert — Fri, 01 Aug 2003 08:39:33 GMT

Hi Bassoi,
You should just change in your call :
hth
Benoit

Re: Help in PHP access to database

benoit Bruckert — Fri, 01 Aug 2003 08:44:54 GMT

Or better :
instead of :
echo "

";
do :
?>

Re: Help in PHP access to database

Ricardo Bassoi — Fri, 01 Aug 2003 10:13:05 GMT

Sorry,

I did what you told me but didn??t work. We have no result inside
the form.
If I call the function ABRE_CL () from outside the form it works fine !

What can I do ?

Regards,

Bassoi

Re: Help in PHP access to database

benoit Bruckert — Fri, 01 Aug 2003 11:59:38 GMT

hi ,
I try this time , here's the solution :
echo "

";

nota :
You cannot include a second php call (Tell me if it's ok...
regards
Benoit

Re: Help in PHP access to database

Ricardo Bassoi — Fri, 01 Aug 2003 12:34:23 GMT

I tried it again but it didn??t work !!!

Regards

Bassoi

Re: Help in PHP access to database

benoit Bruckert — Fri, 01 Aug 2003 14:41:08 GMT

what's your error ??
I made it works on my side !
Warning,
I have disabled the odbc functions (I don't have odbc built in),
here is the full source i used :

function HTML_Head() {
echo "

Processing Form

";
}

function HTML_Form() {

function ABRE_CL() {
echo "toto
";
return;
$cnx = odbc_connect( 'Workload' , '', '' );
if (!$cnx) {
Error_handler( "Error in odbc_connect" , $cnx );
}

$cur= odbc_exec( $cnx, "select * from Clientes" );
if (!$cur) {
Error_handler( "Error in odbc_exec( no cursor returned ) " , $cnx );
}
$nbrow=0; //Local variable to count number of rows

// fetch the succesive result rows
while( odbc_fetch_row( $cur ) ) {
$nbrow++;
$desc= odbc_result( $cur, 2 ); // get the field "DescriC'C#o"

echo "$desc
";
}

;

// close the connection. important if persistent connection are "On"
odbc_close( $cnx);
}

echo "

";

}

function HTML_Existing() {
echo "Database Workload OK";
}

function HTML_Foot() {
echo "";
}

HTML_Head();
HTML_Form();
HTML_Existing();
HTML_Foot();

?>

cut and paste it in a test.php file and try to access to it.
You should also see the source html file generated by php (view source in your browser), you can have interrested information...

Re: Help in PHP access to database

benoit Bruckert — Fri, 01 Aug 2003 14:54:28 GMT

Hi again,
I read a little more your script, you have also a trouble in the pure html side
:
If your connection to odbc is ko, you can see it by viewing the source of the html page.
if it's ok, then, change this line :
echo "$desc
";
to
echo "$desc";

to make a test (without odbc connection), from my previous sample, change :
echo "toto
";
to
echo "toto
";
echo "toto2
" ;

it should work !!
check also your odbc conectivity..
If you are running on HPUX (this is the name of this forum), I'm sure you can build php with odbc support (it's a WIN32 feature).

hope that help
Benoit