Advertisement
Guest User

Untitled

a guest
Jun 25th, 2017
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.95 KB | None | 0 0
  1. <?php
  2. session_start();
  3. require_once('connect.php');
  4. if(isset($_POST) & !empty($_POST)){
  5.     $username = mysqli_real_escape_string($connection, $_POST['username']);
  6.     $password = md5($_POST['password']);
  7.  
  8.     $sql = "SELECT * FROM `login` WHERE username='$username' AND password='$password'";
  9.     $result = mysqli_query($connection, $sql);
  10.     $count = mysqli_num_rows($result);
  11.     if($count == 1){
  12.         $_SESSION['username'] = $username;
  13.     }else{
  14.         $fmsg = "Invalid Username/Password";
  15.     }
  16. }
  17. if(isset($_SESSION['username'])){
  18.     $smsg = "User already logged in";
  19. }
  20.  
  21.  
  22. ?>
  23. <!DOCTYPE html>
  24. <html>
  25. <head>
  26.     <title>User Login in PHP & MySQL</title>
  27.     <!-- Latest compiled and minified CSS -->
  28.     <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" >
  29.  
  30.     <!-- Latest compiled and minified JavaScript -->
  31.     <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" ></script>
  32.  
  33.     <link rel="stylesheet" type="text/css" href="styles.css">
  34. </head>
  35. <body>
  36. <div class="container">
  37.       <?php if(isset($smsg)){ ?><div class="alert alert-success" role="alert"> <?php echo $smsg; ?> </div><?php } ?>
  38.       <?php if(isset($fmsg)){ ?><div class="alert alert-danger" role="alert"> <?php echo $fmsg; ?> </div><?php } ?>
  39.       <form class="form-signin" method="POST">
  40.         <h2 class="form-signin-heading">Please Register</h2>
  41.         <div class="input-group">
  42.           <span class="input-group-addon" id="basic-addon1">@</span>
  43.           <input type="text" name="username" class="form-control" placeholder="Username" required>
  44.         </div>
  45.         <label for="inputPassword" class="sr-only">Password</label>
  46.         <input type="password" name="password" id="inputPassword" class="form-control" placeholder="Password" required>
  47.         <button class="btn btn-lg btn-primary btn-block" type="submit">Login</button>
  48.         <a class="btn btn-lg btn-primary btn-block" href="register.php">Register</a>
  49.       </form>
  50. </div>
  51. </body>
  52. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement