Advertisement
Guest User

Untitled

a guest
May 14th, 2017
537
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.45 KB | None | 0 0
  1. <?php
  2. error_reporting(E_ALL);
  3. if(isset($_POST['username'])){
  4.     $dbHost = "localhost";        //Location Of Database usually its localhost
  5.     $dbUser = "root";            //Database User Name
  6.     $dbPass = "";            //Database Password
  7.     $dbDatabase = "game";    //Database Name
  8.     $email = 'Rdogg999@hotmail.com';
  9.    
  10.     $db = mysql_connect($dbHost,$dbUser,$dbPass)or die("Error connecting to database.");
  11.     mysql_select_db($dbDatabase, $db)or die("Couldn't select the database.");
  12.     $pass = md5($_POST['password']);
  13.     $sql= mysql_query("SELECT * FROM users WHERE username={$_POST['username']} AND password={$pass}");
  14.     if($sql){
  15.         $row = mysql_fetch_array($sql);
  16.         if($row){    //If there is a row start a session with values, then transfer to the users page
  17.             session_start();
  18.             $_SESSION['username'] = $row['username'];
  19.             $_SESSION['id'] = $row['id'];
  20.             $_SESSION['logged'] = TRUE;
  21.             header("Location: index.php");
  22.         }else{    //If there isn't a row return the user to a login page
  23.             header("Location: login.php");
  24.             exit;
  25.         }
  26.     }else{
  27.         // There was some sort of error, check your email
  28.         mail($email, 'MySQL Error', mysql_error());
  29.         header("Location: login.php");
  30.         exit;
  31.     }
  32. }else{    //If the form button wasn't submitted go to the index page, or login page
  33.     header("Location: index.php");    
  34.     exit;
  35. }
  36. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement