colap Posted April 11, 2014 Share Posted April 11, 2014 <?php require_once 'functions.php'; $dbh = mysql_connection(); $email_token = $_REQUEST['email_token']; $objDateTime = new DateTime('NOW'); $current_datetime = $objDateTime->format("Y-m-d H:i:s"); $statement = $dbh->prepare("select * from p_users where email_token=:email_token and email_token_expiry>:current_datetime"); $result = $statement->execute(array(':email_token'=>$email_token, ':current_datetime'=>$current_datetime) ); $rc = $statement->rowCount(); From database: mysql> select id,username,email,email_token,email_token_expiry from p_users; +----+----------+----------------------+-------------+---------------------+ | id | username | email | email_token | email_token_expiry | +----+----------+----------------------+-------------+---------------------+ | 7 | abc | abc@yahoo.com | krl5g085wy | 2014-04-12 08:18:33 | +----+----------+----------------------+-------------+---------------------+ 1 row in set (0.00 sec) What can be the reason to get zero row? How can i debug pdo statement? Quote Link to comment Share on other sites More sharing options...
tunage Posted April 11, 2014 Share Posted April 11, 2014 what does 'select * from p_users;' say? Is there only one record in the db? Quote Link to comment Share on other sites More sharing options...
colap Posted April 11, 2014 Author Share Posted April 11, 2014 what does 'select * from p_users;' say? Is there only one record in the db? Yes, there is only one row/record for this table. Quote Link to comment Share on other sites More sharing options...
mac_gyver Posted April 11, 2014 Share Posted April 11, 2014 what does using var_dump($email_token); show? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.