I have a problem using PDO statement when run sql query for getting existing user its not working

Asked May 31 '20 at 11:37

Active May 31 '20 at 11:43

Viewed 19 times

This is my code and its not giving me result. It is returning me false value while there is data with same credentials inside database. I tried everything but it is not working.

private function isUserExist($email_id, $user_id){

  $stmt = $this->conn->prepare("SELECT id FROM users WHERE `email_id` = ? AND `unique_user_id` = ?");
  $stmt->bindParam(1, $email_id);
  $stmt->bindParam(2, $user_id);
  $stmt->execute();
  return $stmt->fetch() > 0;
}

edited May 31 '20 at 11:43

Dave

5,108
16
30
40

asked May 31 '20 at 11:37

vishal kumar

What's the point in using two conditions? Isn't email_id or $user id alone enough? – Your Common Sense May 31 '20 at 11:46
Before return do print_r($stmt->errorInfo()) , maybe there is a problem. – Fran Cerezo May 31 '20 at 11:49
@FranCerezo don't do that. It will be embarrassing when your site goes live – Your Common Sense May 31 '20 at 11:50
I am talking on local, of course. – Fran Cerezo May 31 '20 at 11:53
@FranCerezo don't do that either. It would be silly to rewrite your code every time from live to local back and forth. – Your Common Sense May 31 '20 at 12:53
@YourCommonSense well, I check that too by using only email_id and its not working. – vishal kumar May 31 '20 at 13:03
What rewriting? This person looks like needs easy advise while developing. – Fran Cerezo May 31 '20 at 13:05
@FranCerezo every "easy advise" ends up in the production code, so one must be accurate giving them away. – Your Common Sense May 31 '20 at 13:08
@vishal so ether there is an error or there is no data to match your criteria. check errors, the input data and your database. Refer to the linked answer for the details. – Your Common Sense May 31 '20 at 13:09

I have a problem using PDO statement when run sql query for getting existing user its not working

0 Answers0