0

Here is my code

/* Create a new mysqli object with database connection parameters */
   $mysqli = new mysql('localhost', 'username', 'password', 'db');

   if(mysqli_connect_errno()) {
      echo "Connection Failed: " . mysqli_connect_errno();
      exit();
   }

   /* Create a prepared statement */
   if($stmt = $mysqli -> prepare("SELECT priv FROM testUsers WHERE username=?
   AND password=?")) {

      /* Bind parameters
         s - string, b - boolean, i - int, etc */
      $stmt -> bind_param("ss", $user, $pass);

      /* Execute it */
      $stmt -> execute();

      /* Bind results */
      $stmt -> bind_results($result);

      /* Fetch the value */
      $stmt -> fetch();

      echo $user . "'s level of priviledges is " . $result;

      /* Close statement */
      $stmt -> close();
   }

   /* Close connection */
   $mysqli -> close();

?>

Getting error
Fatal error: Class 'mysql' not found in C:\xampp\htdocs\mysqli\connection.php on line 3

how to resolve this.?

hope for valid reply

2
Contributors
1
Reply
2
Views
8 Years
Discussion Span
Last Post by pritaeas
0
$mysqli = new mysql('localhost', 'username', 'password', 'db');

you're missing an 'i'

$mysqli = new mysqli('localhost', 'username', 'password', 'db');
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.