Advertisement
Guest User

Untitled

a guest
Apr 24th, 2014
43
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.29 KB | None | 0 0
  1. include('mysql/database.php');
  2. $dbcheck_email_validation=$_POST["email_validation_ajax"];
  3. $dbcheck_email_validation=htmlspecialchars($dbcheck_email_validation);
  4. $dbcheck_email_validation=mysql_real_escape_string($dbcheck_email_validation);
  5. $sql_query = "SELECT * FROM users WHERE email = ?";
  6. $query = $create_pdo->prepare($sql_query);
  7. $query->execute(array($dbcheck_email_validation));
  8. $query->setFetchMode(PDO::FETCH_ASSOC);
  9. $row_from_query = $query->fetch();
  10. $dbcheck_email_validation_assoc=$row_from_query['email'];
  11. echo json_encode($dbcheck_email_validation_assoc);
  12.  
  13. Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1045] Access denied for user ''@'localhost' (using password: NO)' in /home/letsrate/public_html/favorit/ajax/ajax_email_validation.php:6Stack trace:#0 /home/letsrate/public_html/favorit/ajax/ajax_email_validation.php(6): PDO->__construct('mysql:host=;dbn...', NULL, NULL)#1 {main} thrown in /home/letsrate/public_html/favorit/ajax/ajax_email_validation.php on line 6
  14.  
  15. $dbcheck_email_validation=mysql_real_escape_string($dbcheck_email_validation);
  16.  
  17. include('mysql/database.php');
  18. $query = $create_pdo->prepare("SELECT email FROM users WHERE email = ?");
  19. $query->execute(array($_POST["email_validation_ajax"]));
  20. echo json_encode($query->fetchColumn());
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement