Help in PHP access to database

[Ricardo Bassoi]

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

[Ricardo Bassoi]

Sorry ,

The attachment is not so good !

Regards

[Ricardo Bassoi]

Hi Again,

I??ll try the last time

[Ricardo Bassoi]

function HTML_Head() {
echo "



";
}

function HTML_Form() {

function ABRE_CL() {

$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 "Descri????o"

echo "$desc
";
}

;

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

echo "

Por favor insira os seus dados para o Workload


First Name:

Teste:re

Teste de Sele????o:

ABRE_CL();
?>




Last Name:

Phone Number:

";

}

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

function HTML_Foot() {
echo "";
}

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

?>

[benoit Bruckert]

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

[benoit Bruckert]

Or better :
instead of :
echo "

Por favor insira os seus dados para o Workload


First Name:

Teste:re

Teste de Sele????o:

ABRE_CL();
?>




Last Name:

Phone Number:

";
do :
?>

Por favor insira os seus dados para o Workload


First Name:

Teste:re

Teste de Sele????o:

ABRE_CL();
?>




Last Name:

Phone Number:

[Ricardo Bassoi]

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

[benoit Bruckert]

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

ACTION=\"DataAccess.php3\">
Por favor insira os seus dados para o Workload


First Name:

Teste:re

Teste de SeleC'C#o:
";
/* ABRE_CL();
/* ?> */
echo "



Last Name:

Phone Number:

";

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

[Ricardo Bassoi]

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

Regards

Bassoi

[benoit Bruckert]

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 "



";
}

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 "

ACTION=\"DataAccess.php3\">
Por favor insira os seus dados para o Workload


First Name:

Teste:re

Teste de SeleC'C#o:
";
/* ABRE_CL();
/* ?> */
echo "



Last Name:

Phone Number:

";

}

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...

[benoit Bruckert · Accepted solution]

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