Advertisement
and_cesbo

PHP DB Request for Astra Auth.

Apr 13th, 2016
363
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.76 KB | None | 0 0
  1. <?php
  2.  
  3. $db_host = "127.0.0.1";
  4. $db_name = "db";
  5. $db_user = "user";
  6. $db_pass = "****";
  7.  
  8. if(!isset($_GET["key"])) {
  9.     header("HTTP/1.0 403 Forbidden");
  10.     echo("Undefined key" . PHP_EOL);
  11.     exit;
  12. }
  13.  
  14. $link = mysqli_connect($db_host, $db_user, $db_pass, $db_name);
  15.  
  16. if(mysqli_connect_errno()) {
  17.     header("HTTP/1.0 403 Forbidden");
  18.     echo(mysqli_connect_error() . PHP_EOL);
  19.     exit;
  20. }
  21.  
  22. $key = mysqli_real_escape_string($link, $_GET["key"]);
  23. $result = mysqli_query($link, "SELECT id FROM users WHERE key='" . $key . "'");
  24. if(!$result || !$result->num_rows) {
  25.     header("HTTP/1.0 403 Forbidden");
  26.     echo("Key not found" . PHP_EOL);
  27.     mysqli_close($link);
  28.     exit;
  29. }
  30.  
  31. echo("Ok");
  32.  
  33. mysqli_free_result($result);
  34. mysqli_close($link);
  35.  
  36. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement