fail to get result using variable in php

ycm · #1 (**permalink**) 04-13-10, 03:12 AM

Hi,

I am writing a code below, where it get the variable $nvesel from a form name login_page.php,
the issue here, if the nvesel is hardcode, the query can run correctly, but when using the variable
it failed to give any output. Pls can someone help? Im still new in this php thing. FYI, im using oracle db.

PHP Code:


			
#get data from login_page.php
$nvesel=$_POST["vesel"];
$kata_laluan=$_POST["pwd"];
#$nvesel=JHF1074T;  / if hardcode, this query can run

#check if data exist
$query_vesel= "SELECT no_vesel,kata_laluan from STATUS_PENGGUNA where no_vesel=$nvesel"; 

# perform the query 
$result = odbc_exec($connect, $query_vesel);

# fetch the data from the database 
while(odbc_fetch_row($result))
{ $no_vesel = odbc_result($result, 1); $id_pemilik = odbc_result($result, 2); 
print("$no_vesel $id_pemilik\n"); }

job0107 · #2 (**permalink**) 04-13-10, 07:55 AM

You will need to post your form.

ycm · #3 (**permalink**) 04-14-10, 01:12 AM

sorry, i dont get you. u want to see my form, is it?

HTML Code:

<body>
<form id="form1" name="login" method="post" action="check.php">
  <p>NO VESEL:
    <input type="text" name="vesel" id="vesel" />
</p>
  <p>KATA LALUAN:
    <input type="text" name="pwd" id="pwd" />
</p>
  <p>
    <input type="submit" name="hantar" id="hantar" value="HANTAR" />
  </p>
</form>
</body>

job0107 · #4 (**permalink**) 04-14-10, 08:27 AM

Assuming your form is in login_page.php and your query code is in check.php, then the data from the form should be getting to the query ok.

You might try quoting the variable in your query.
Unquoted variables will work if they are strictly numeric.
But your variable contains alpha-numeric characters.

PHP Code:


			
#get data from login_page.php
$nvesel=$_POST["vesel"];
$kata_laluan=$_POST["pwd"];
#$nvesel=JHF1074T;  / if hardcode, this query can run

#check if data exist
$query_vesel= "SELECT no_vesel,kata_laluan from STATUS_PENGGUNA where no_vesel='$nvesel'";

# perform the query
$result = odbc_exec($connect, $query_vesel);

# fetch the data from the database
while(odbc_fetch_row($result))
{ $no_vesel = odbc_result($result, 1); $id_pemilik = odbc_result($result, 2);
print("$no_vesel $id_pemilik\n"); }