Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $('#submit_log').click(function(e) {
- e.preventDefault();
- username = $('#log_name').val();
- password = $('#log_password').val();
- formData = $('#loginForm').serialize();
- $.ajax({
- type: "POST",
- url: "login.php",
- data: formData,
- beforeSend: function()
- {
- $('.logresult').html('Loading...');
- },
- success: function(response)
- {
- $('.logresult').html('Signing In...');
- window.location = "exporter.php";
- }
- });
- return false;
- });
- session_start();
- require_once ("db.php");
- $db = new MyDB();
- if(isset($_POST['log_name']) && isset($_POST['log_password'])) {
- $username = preg_replace('#[^A-Za-z0-9]#i', '', $_POST['log_name']);
- $password = preg_replace('#[^A-Za-z0-9]#i', '', $_POST['log_password']);
- $sql = $db->prepare("SELECT * FROM users WHERE uname = ?");
- $sql->bindParam(1, $username, SQLITE3_TEXT);
- $ret = $sql->execute();
- $count = $db->prepare("SELECT COUNT(*) as COUNT FROM users WHERE uname = ?");
- $count->bindParam(1, $password, SQLITE3_TEXT);
- $count_ret = $count->execute();
- if (count($count_ret) == 1)
- {
- while ($row = $ret->fetchArray(SQLITE3_ASSOC))
- {
- $id = $row['userid'];
- $regas = $row['regas'];
- $uemail = $row['uemail'];
- $pword = $row['pword'];
- if (password_verify($password, $pword))
- {
- $_SESSION['log_id'] = $id;
- $_SESSION['log_name'] = $username;
- $_SESSION['regas'] = $regas;
- $_SESSION['uemail'] = $uemail;
- //header("Location: index.php?log_id=$id");
- echo "Sigining In...";
- exit();
- }
- else
- {
- echo "Information incorrect";
- exit();
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement