Advertisement
Guest User

Untitled

a guest
May 13th, 2017
68
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.     //Start the session
  3.     session_start();
  4.    
  5.     //Get userName and Password from login form.
  6.     if(isset($_POST['userName']) && $_POST['password']){
  7.         $userName = $_POST['userName'];
  8.         $password = $_POST['password'];  
  9.     }
  10.    
  11.     //Set strings for host, user, password and database name for access to
  12.     //the database.
  13.     $dbHost='localhost';
  14.     $dbUser ='root';
  15.     $dbPassword='';
  16.     $dbName='DainDevOnline';
  17.    
  18.     //Connect to the database server.
  19.     $dbCon = @mysql_connect($dbHost, $dbUser, $dbPassword);
  20.         if(!$dbCon){
  21.             echo("<p>Cannot conect to the database server.</p>");
  22.             exit();
  23.         }
  24.    
  25.     //Connect to the database.
  26.     mysql_select_db($dbName, $dbCon);
  27.     if(!@mysql_select_db($dbName)){
  28.         echo("Cannot locate ".$dbName." database.</p>");
  29.         exit();
  30.     }
  31.     //Query to see if userName and password match.
  32.     $query_login = "SELECT * FROM user WHERE userName =
  33.                    '$userName' AND password = '$password'";
  34.     $result_login = mysql_query($query_login) or die
  35.                     ("Cannot verify user because: ".mysql_error());
  36.    
  37.     //Verification of user login.
  38.     if(mysql_num_rows($result_login)==1){
  39.         $_SESSION = true;
  40.        
  41.         //Send user to logged in page.  
  42.         header('Location: welcome.php');
  43.     }else{
  44.         $oops = 'Ooops you enter something wrong.';
  45.    
  46.     }
  47.     echo $oops;
  48. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement