Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $username = $_POST['username'];
- $password = $_POST['password'];
- //Database Vars
- $host = "localhost";
- $database = "ajax-login";
- $username = "root";
- $password = "root";
- $db = new PDO("mysql:host=$host;dbname=$database", $username, $password);
- $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- //Statement
- $stmt = $db->prepare("SELECT * FROM users WHERE username = :username AND password = :password");
- $stmt->bindParam(':username', $username, PDO::PARAM_STR);
- $stmt->bindParam(':password', $password, PDO::PARAM_STR);
- //Query
- $stmt->execute();
- //Get results
- if($data = $stmt->fetch()) {
- echo "worked";
- } else {
- echo"meh :/";
- }
- //Encode in JSON
- /* json_encode($data); */
- ?>
Add Comment
Please, Sign In to add comment