Advertisement
Guest User

Untitled

a guest
Dec 16th, 2016
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.71 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "root";
  4. $password = "";
  5.  
  6. try {
  7. $conn = new PDO("mysql:host=$servername;dbname=social", $username, $password);
  8. // set the PDO error mode to exception
  9. $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  10. //echo "Connected successfully";
  11. }
  12. catch(PDOException $e)
  13. {
  14. echo "Connection failed: " . $e->getMessage();
  15. }
  16.  
  17. class UserLogin {
  18.  
  19. public $id;
  20. public $first;
  21. public $last;
  22. public $email;
  23. public $password;
  24.  
  25. function Login(){
  26. global $conn;
  27. $this->email = $_POST['user_email'];
  28. $this->password = $_POST['user_email'];
  29. $sql = $conn->prepare("SELECT * FROM scusers WHERE scemail =? AND scpass =?");
  30. $sql->execute(array($this->email, $this->password));
  31. while($row = $sql->fetch(PDO::FETCH_ASSOC)){
  32. $this->email = $row['scemail'];
  33. $this->password = $row['scpass'];
  34. }
  35.  
  36. }
  37.  
  38. }
  39.  
  40. <?php
  41. //print_r($_POST);
  42. if(isset($_POST['user_email']) && isset($_POST['user_password'])){
  43. $login = new UserLogin();
  44. $login->email = $_POST['user_email'];
  45. $login->password = $_POST['user_password'];
  46. if($login->Login()){
  47. header("Location:home.php");
  48. }else{
  49. echo "Negative";
  50. }
  51. }
  52. ?>
  53. <body>
  54. <header>
  55.  
  56. <form action="#" method="post">
  57. <div class="col-sm-6">
  58. <div class="row">
  59. <div class="col-sm-5">
  60. <div class="form-group">
  61. <input name="user_email" type="text" class="form-control" placeholder="Email Address">
  62. <div class="login-bottom-text checkbox">
  63. <label>
  64. <input type="checkbox" id="">
  65.  
  66. </label>
  67. </div>
  68. </div>
  69. </div>
  70. <div class="col-sm-5">
  71. <div class="form-group">
  72. <input name="user_password" type="text" class="form-control" placeholder="Password">
  73. <div class="login-bottom-text"><a class="bottom-txt" href="recover_password.php">Forgot your password?</a></div>
  74. </div>
  75. </div>
  76. <div class="col-sm-2">
  77. <div class="form-group">
  78. <button type="submit" value=" Send" class="btn btn-default" id="submit">login</button>
  79. </div>
  80. </div>
  81. </div>
  82. </div>
  83. </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement