Advertisement
Guest User

Untitled

a guest
Feb 29th, 2016
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.72 KB | None | 0 0
  1. <?php
  2. $response = array();
  3. if ( !isset($_POST['email'], $_POST['password']) ) {
  4.     $response['error'] = array(
  5.         'msg'=>'missing POST parameter.',
  6.         'details' => 'Recognized parameters were: '.join(', ', array_keys($_POST))
  7.     );
  8. }
  9. else { 
  10.     $user = "root";
  11.     $pass = "";
  12.     $db = "uopuser";
  13.     $con=mysqli_connect("localhost", $user, $pass, $db);
  14.    
  15.     if ( !$con ) {
  16.         $response['error'] = array('error'=>'could not connect to database');
  17.     }
  18.     else if ( !($statement=mysqli_prepare($con, "SELECT fname, lname, email, `password` FROM User WHERE email = ? AND password = ?")) ) {
  19.         $response['error'] = array('error'=>'could not prepare database query');
  20.     }
  21.     else if ( !mysqli_stmt_bind_param($statement, "ss", $_POST["email"], $_POST["password"]) ) {
  22.          $response['error'] = array('error'=>'could bind parameters to statement');
  23.     }
  24.     else if ( !mysqli_stmt_execute($statement) ) {
  25.         $response['error'] = array('error'=>'could execute database statement');
  26.     }
  27.     else if ( !mysqli_stmt_store_result($statement) ) {
  28.         $response['error'] = array('error'=>'could not store database results');
  29.     }
  30.     else if ( !mysqli_stmt_bind_result($statement, $fname, $lname, $email, $password) ) {
  31.         $response['error'] = array('error'=>'could not bind database results');
  32.     }
  33.     else {
  34.         $result = mysqli_stmt_fetch($statement);
  35.         if ( false===$result ) {
  36.             $response['error'] = array('error'=>'error while fetching database results');
  37.         }
  38.         else if ( is_null($result) ) {
  39.             $response['result'] = NULL; // no such user in database
  40.         }
  41.         else {
  42.             $response['result'] = array(
  43.                 'fname'=>$fname,
  44.                 'lname'=>$lname,
  45.                 'email'=>$email,
  46.                 'password'=>$password
  47.             );
  48.         }
  49.     }
  50. }
  51. header('Content-type: application/json');
  52. echo json_encode($response);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement