Checking against data in mySQL

[markad]

Hi,

I need to construct a PHP script that submits data posted from a web form and checks it against existing data in a mySQL database to see if it matches then echo's back a message to the user saying whether its a match or not.

I've got the query; $guessquery = "SELECT * FROM guesses WHERE guess..etc

Could I use a session to indicate the data inputted by the user? Also where would I go from there? Thats abouts as far as i've got!

Any help appreciated, thanks.

[usedtire]

/*print the form */
?>

<form method="post"><input type="hidden" name="complete" value=1>
<input type="text" name=guess value="your guess">
<input type="submit" value="submit">
</form>

<?
/*query the database */
if ($_REQUEST['complete'] == 1)
  {
   $query = mysql_query("select * from login where username = '".$_REQUEST['guess']."'");
   $result = mysql_num_rows($query);
   if ($result != 0) /*check your results */
    {
     echo "You have found your result.";
 
    }
   else
    echo 'Guess again';
  }
?>

There are cleaner ways to do it I am sure, but this is basically what you asked for.

You will obviously need to connect to your database.

[markad]

Hi, thanks for your reply script works well. All I want to do with it now is pass the results of that query to another page. How it works is the customer submits their guess, they then can get taken to a payments page, submit their card details, and these are validated and returned together with the charge. So I want the result of the guess query to come up on this same page. Would I just use the name of the form from the guess i.e. 'complete', as in the form below then do; $complete = $POST['complete'];? Thanks.

[usedtire]

I would recommend that you use sessions or maybe someone else would recommend an better way.

Sessions are simple enough. If you are going to be passing the same variable around alot then you should use them.

session_start(); #required for you to use sessions, recommeded to be the first line of your code

$_SESSION['complete'] = $POST['complete'];

You are passing your HTML post to a PHP session. And that's it. Use this object as you would any other.