I want to do is make a login system using ajax and pdo w/ button as submiter. My problem is when i click the button to execute nothing happens. There is no error in the console. I see in the network its sends the username and password data to user.php but after that nothing realy happens in the index.php.
index.php
<html lang="en">
<head>
<script src="bootstrap/js/jquery-1.11.0.min.js"></script>
<script type="text/javascript">
$(document).ready(function() {
$('#myLogin').submit(function() {
var username = $('#user').val();
var password = $('#pass').val();
$.ajax({
data: {
username : username, password : password
},
type: "POST",
url: 'user.php',
success: function(data)
{
$('#show').html(data);
}
});
return false;
});
});
</script>
</head>
<body>
<div id="show"></div>
<form id="myLogin">
Username: <input type="text" name="user" id="user" /><br />
Password: <input type="password" name="pass" id="pass" /><br />
<button type="submit" name="login" id="login">Login</Button>
</form>
</body>
</html>
user.php
<?php
include_once('connection.php');
class User{
private $db;
public function __construct(){
$this->db = new Connection();
$this->db = $this->db->dbConnect();
}
public function Login($user, $pass){
if(!empty($user) && !empty($pass)){
$st = $this->db->prepare("SELECT * from users WHERE username=? AND password=?");
$st->bindParam(1, $user);
$st->bindParam(2, $pass);
$st->execute();
if($st->rowCount() == 1){
echo "User verifies, Access granted";
} else {
echo "Incorrect Username or Password";
}
}else{
echo "Please enter Username and Password";
}
}
}
?>
connection.php
<?php
class Connection{
public function dbConnect(){
return new PDO('mysql:host=localhost; dbname=test', 'root', '');
}
}
?>
