Advertisement
Guest User

Untitled

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