PHP and odbc help

josephp

I am not sure whether my first thread went. i got an error.
so i am posting again,
i am in a urgent need for a PHP code.
i am using PHp and OdBC conenctivity, not mysql.
i have designed a form which has drop down box(list menu).
list of four options say monitor, cpu , HD and RAm , all these options have individual tables in MSACCESS.
when the user selects the option ,data shud be retrived from the table and displayed in the webpage.
kindly help me to code this.
i am new to PHP.
🙁
thank u in advance.

LordShryku

Well, you should reference the manual on php.net for help with the commands. But first you would setup you connect string:

$connect = odbc_connect( 'SYSTEM_DSN' , 'USER', 'PASSWORD' );

//then setup your cursor
$cur= odbc_exec( $connect, "select * from $table" );

//then setup your loop
$nbrow=0;
while( odbc_fetch_row($cur) ) {
$nbrow++;
$output = odbc_result($cur, 1);

//echo the output with a new line after each one
echo $output;
echo "<br>";

//close your connection
odbc_close($connect);

All other HTML formatting you can add in there somewhere, but that's the basics. Enjoy 🙂

josephp

Lordshruku
thank u so much and i will try ,
any other ideas.

josephp

can i use if statement .
i have set values inmy form say
cpu 0

monitor 1
HD 2
so in teh program am i supposed to use these values ,
shud i include the above code in every option coz i retrive data from individual tables.
i have 3 tables , one for eah option.
thank u
😕

LordShryku

So if you're pulling three fields, setup a variable for each one during your loop....

//then setup your loop
$nbrow=0;
while( odbc_fetch_row($cur) ) {
$nbrow++;
$cpu = odbc_result($cur, 1);
$monitor = odbc_result($cur, 2);
$hd = odbc_result($cur, 3);

//echo the output with a new line after each one
echo "CPU: " . $cpu . "<br>";
echo "MONITOR: " . $monitor . "<br>";
echo "HD: " . $hd . "<br>";

josephp

Thanks .
But it is not just three fields. three diff tables namely cpu,monitor and ram.
am i correct in the flow of database. is it possible to get from three tables.
each option chosen links toa particular tables and retrieves data and prints in the website.

😕

LordShryku

You can do that. You will just have to repeat this process for each table.