Advertisement
Guest User

Untitled

a guest
Oct 11th, 2016
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.25 KB | None | 0 0
  1. //login
  2.     if($_GET["func"]=="login")
  3.     {
  4.         $connect = new mysqli($dbhost, $dbusername, $dbpassword, $dbname);
  5.         if ($connect->connect_errno!=0) {
  6.             echo "Error: ".$connect->connect_errno." Description: ".$connect->connect_error;
  7.         }
  8.         else {
  9.             $login = $_POST["user"];
  10.             $password = $_POST["passwd"];
  11.  
  12.             $query = "SELECT username, level FROM users WHERE username='$login' AND password='md5($password)'";
  13.  
  14.             if ($stmt = $connect->prepare($query)) {
  15.                 $stmt->execute();
  16.                 $stmt->bind_result($username, $password);
  17.                 while ($stmt->fetch()) {
  18.                      echo "{";
  19.                      echo '"username": "' . $username . '",';
  20.                      echo "}";
  21.                 }
  22.                  /* close statement */
  23.                 $stmt->close();
  24.             }
  25.             $connect->close(); 
  26.         }
  27.     }
  28.  
  29.  
  30. //register
  31.     if($_GET["func"]=="register") {
  32.         $connect = new mysqli($dbhost, $dbusername, $dbpassword, $dbname);
  33.         if($connect->connect_errno!=0) {
  34.             echo "Error: ".$connect->connect_errno." Descruption: ".$connect->connect_error;
  35.         }
  36.         else {
  37.             $login = $_POST["user"];
  38.             $password = md5($_POST["passwd"]);
  39.  
  40.  
  41.             $sql = "INSERT INTO users VALUES(NULL, '$login', '$password')";
  42.  
  43.             if($result = $connect->query($sql)) {}
  44.                
  45.             else {
  46.                 echo "ERROR";
  47.             }
  48.             $connect->close();
  49.         }
  50.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement