mysqli vs mysql_conn

neridaj

Hello,

In order to use mysql_fetch_assoc, do I need to connect and retrieve data using mysql_conn and subsequent mysql_query, etc to retrieve data? I was getting errors when I tried to use mysqli and a $conn->query scenario to fetch data using mysql_fetch_assoc, saying that the array I was returning was invalid for the object, so I decided to switch to mysql_conn, mysql_query, etc but now I can't get a valid result from the query. Can anyone explain what I'm doing wrong here:

function login($username, $password)
// check username and password with db
// if yes, return true
// else throw exception
{
  // connect to db
  $conn = db_connect();
  $sel_db = mysql_select_db('listingsbox_db');
  if (!sel_db)
  die(mysql_error());
  // check if username is unique
  $result = mysql_query("select * from user 
                         where username='$username'
                         and passwd = sha1('$password')", $conn);
  if (!$result)
	die(mysql_error());
     throw new Exception('Could not log you in. 1'); // THIS IS WHERE IT TERMINATES AND RETURNS TO CALLING FUNCTION BELOW

  if ($result->num_rows>0)
     return true;
  else 
     throw new Exception('Could not log you in. 2');
}
// CALLING FUNCTION IS BELOW
session_start();

//create short variable names
$username = $_POST['username'];
$passwd = $_POST['passwd'];

if ($username && $passwd)
// they have just tried logging in
{
  try
  {
    login($username, $passwd);
    // if they are in the database register the user id
    $_SESSION['valid_user'] = $username;
  }
  catch(Exception $e)
  {
  	echo $e->getMessage();
    // unsuccessful login
    do_html_header('Problem:'); // THIS IS WHAT IS OUTPUT
    echo 'You could not be logged in. 
          You must be logged in to view this page.';
    do_html_url('login.php', 'Login');
    do_html_footer();
    exit;
  }      

}

bpat1434

There are two different MySQL extensions in PHP. There's the older [man]mysql[/man] extension which works with all MySQL extensions. Then there's the newer [man]mysqli[/man] extension which works with newer MySQL versions (4.1 and up) with added feature functionality.

Now, with those, you must use their respective functions:
[man]mysql[/man] extension
[indent]mysql_*[/indent]

[man]mysqli[/man] extension
[indent]mysqli_[/indent]

So you can't mix and match. If you want to use mysqli, use mysqli->fetch_assoc or mysqli_fetch_assoc. If you want to use mysql, use mysql_fetch_assoc.

Also, $result is a MySQL resource, not an actual object that you can run methods on. For an object, you'd have to use [man]mysql_fetch_object/man or use the mysqli extension. So running $result->num_rows>0 is doing nothing.