Advertisement
Guest User

login.php

a guest
Mar 25th, 2015
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.80 KB | None | 0 0
  1. //this is  my login page script
  2. <?php
  3. $con=mysqli_connect("localhost","root","","test");
  4. if (mysqli_connect_errno())
  5.   {
  6.   echo "Failed to connect to MySQL: " . mysqli_connect_error();
  7.   }else{
  8.   }
  9. if(isset($_POST["submit"])){
  10.  
  11. if(!empty($_POST['uemail']) && !empty($_POST['pass'])) {
  12.                    
  13.     $email=mysqli_real_escape_string($con, $_POST['uemail']);
  14.     $pass=$_POST['pass'];
  15.     $query=mysqli_query($con,"SELECT * FROM login WHERE email='".$email."' AND password='".$pass."'");
  16.     $numrows=mysqli_num_rows($query);
  17.     if($numrows!=0)
  18.     {
  19.     while($row=mysqli_fetch_assoc($query))
  20.     {
  21.     $dbuseremail=$row['email'];
  22.     $dbpassword=$row['password'];
  23.     $dbfirstname=$row['firstname'];
  24.     $dblastname=$row['lastname'];
  25.  
  26.     }
  27.  
  28.     if($email == $dbuseremail && $pass == $dbpassword)
  29.     {
  30.     session_start();
  31.     $_SESSION['sess_user']=$dbfirstname;
  32.     $_SESSION['sess_email']=$dbuseremail;
  33.     $_SESSION['sess_luser']=$dblastnamename;
  34.     $_SESSION['sess_gender']=$dbgender;
  35.  
  36.     /* Redirect browser */
  37.     header("Location: home1.php");
  38.     }
  39.     } else {
  40.     echo "Invalid Email or password!";
  41.     }
  42.  
  43. } else {
  44.     echo "<center>All fields are required!</center>";
  45. }
  46. }
  47. mysqli_close($con);
  48. ?>
  49. <html>
  50. <head>
  51. <meta name="viewport" content="width=device-width, initial-scale=1">
  52. <title>Login</title>
  53.  
  54. </head>
  55. <body>
  56. <div id="login_form">
  57. <form action="" method="POST" autocomplete="off">
  58.     <fieldset>
  59.         <h3>Login Form</h3>
  60.        
  61.             Email:<br />  <input id="textdecor" type="email" name="uemail"placeholder="email@" size="35"> <br /><br />
  62.             Password:<br />  <input id="textdecor" type="password" name="pass" placeholder="xcz5v5x " size="35"><br />  <br />
  63.         <input type="submit"  id="sumbit_buttom"    value="Login" name="submit" />
  64.         <p><a href="regis.php">Register</a> | <a href="log.php">Login</a></p>
  65.     </fieldset>
  66. </form>
  67.  
  68. </div>
  69. </body>
  70. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement