用php变量执行查询

Question

I have to query a DB where i stored credentials for login (for homework). This is my php code but it's not working.

<?php
$user = "cardatabase";
$password = "";
$host = "";
$database = "my_cardatabase";
$connession = mysql_connect($host, $user, $password);
mysql_select_db($database, $connession);


$id = $_REQUEST['id'];
$password = $_REQUEST['password'];

$query = "select Password
          from Client
          where IDClient = '".$id."'";
$result = mysql_query($query, $connession);

echo $result;

            if ($result == $password) {
                echo ok;
            } else {
                echo error;}
mysql_close();
?>

I tried to print the value coming from my html page and it's correct, so there should be a problem with this code but i can't figure it out.

Answer 1

change the following code ::

<?php     
  $connession = mysql_connect($host, $user, $password) or die( mysql_error() . " <br/> could not connect to server");
  mysql_select_db($database, $connessione) or die( mysql_error() . " <br/> could not connect datbase");


  $id = $_REQUEST['id'];
  $password = $_REQUEST['password'];

   $query = "select Password
      from Client
      where IDClient='{$id}'";

   $result = mysql_query($query, $connession) or die(mysql_error());

   if( mysql_num_rows($result) > 0 )  {
       $row = mysql_fetch_array($result) or die(mysql_error());

       $dbPassword = $row['Password'];
       if( strcmp($password, $dbPassword) == 0 )  {
           echo "ok";
       }
       else {
           echo "Error";
       }
   }
   else {
       echo "error";
   }

   mysql_close();
?>