Advertisement
Guest User

Untitled

a guest
Aug 1st, 2017
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.87 KB | None | 0 0
  1. $('#submit_log').click(function(e) {
  2. e.preventDefault();
  3. username = $('#log_name').val();
  4. password = $('#log_password').val();
  5. formData = $('#loginForm').serialize();
  6. $.ajax({
  7. type: "POST",
  8. url: "login.php",
  9. data: formData,
  10. beforeSend: function()
  11. {
  12. $('.logresult').html('Loading...');
  13. },
  14. success: function(response)
  15. {
  16. $('.logresult').html('Signing In...');
  17. window.location = "exporter.php";
  18. }
  19. });
  20. return false;
  21. });
  22.  
  23. session_start();
  24. require_once ("db.php");
  25. $db = new MyDB();
  26.  
  27. if(isset($_POST['log_name']) && isset($_POST['log_password'])) {
  28. $username = preg_replace('#[^A-Za-z0-9]#i', '', $_POST['log_name']);
  29. $password = preg_replace('#[^A-Za-z0-9]#i', '', $_POST['log_password']);
  30.  
  31. $sql = $db->prepare("SELECT * FROM users WHERE uname = ?");
  32. $sql->bindParam(1, $username, SQLITE3_TEXT);
  33. $ret = $sql->execute();
  34.  
  35. $count = $db->prepare("SELECT COUNT(*) as COUNT FROM users WHERE uname = ?");
  36. $count->bindParam(1, $password, SQLITE3_TEXT);
  37. $count_ret = $count->execute();
  38.  
  39. if (count($count_ret) == 1)
  40. {
  41. while ($row = $ret->fetchArray(SQLITE3_ASSOC))
  42. {
  43. $id = $row['userid'];
  44. $regas = $row['regas'];
  45. $uemail = $row['uemail'];
  46. $pword = $row['pword'];
  47.  
  48. if (password_verify($password, $pword))
  49. {
  50.  
  51. $_SESSION['log_id'] = $id;
  52. $_SESSION['log_name'] = $username;
  53. $_SESSION['regas'] = $regas;
  54. $_SESSION['uemail'] = $uemail;
  55. //header("Location: index.php?log_id=$id");
  56. echo "Sigining In...";
  57. exit();
  58. }
  59. else
  60. {
  61. echo "Information incorrect";
  62. exit();
  63. }
  64. }
  65. }
  66. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement