What's the problem with this mysql query in php?

Question

I have a problem but i don't know where is a mistake?

private function getUsersPasswordByEmail($email){

        $stmt = $this->con->prepare("SELECT 'password' FROM 'user' WHERE 'email' = ?");
        $stmt->bind_param("s", $email);
        $stmt->execute();
        $stmt->bind_result($password);
        $stmt->fetch();
        return $password;}

error is in this line -

$stmt->bind_param("s", $email);

Details Type: Error Message: Call to a member function bind_param() on bool File: C:\xampp\htdocs\MyApi\includes\DbOperations.php Line: 63

error means what? Please [edit] your question and add the complete error message! — Ocaso Protal, Jul 10 '19 at 08:11
its may be `"SELECT password FROM user WHERE email = ?"`, why you are you using `single quotes` in name of columns and tablename — Rakesh Jakhar, Jul 10 '19 at 08:13
@ArtOsi > Right, I thought it was like PDO ('s' then had to be an identifier, not a type!). — Abrikot, Jul 10 '19 at 08:15
@RakeshJakhar I first try without a quotes, but it's not working — Radenko Kozomara, Jul 10 '19 at 08:15
Possible duplicate of [When to use single quotes, double quotes, and backticks in MySQL](https://stackoverflow.com/questions/11321491/when-to-use-single-quotes-double-quotes-and-backticks-in-mysql) — Dharman, Jul 10 '19 at 08:20
@showdev now error is that password do not match, but i use good password... — Radenko Kozomara, Jul 10 '19 at 08:21
That sounds like a separate issue. You might try debugging by outputting your variable values and see if they are what you expect. — showdev, Jul 10 '19 at 08:24

LIGHT · Accepted Answer · 2019-07-10T08:20:09.350

0

Try using ` backtick instead of ' single quote

$stmt = $this->con->prepare("SELECT `password` FROM `user` WHERE `email` = ?");
$stmt->bind_param("s", $email);

edited Jul 10 '19 at 08:20

answered Jul 10 '19 at 08:15

LIGHT

5,604
10
35
78

now error is { "error": true, "message": "Invalid credential" } that means - password do not match, but i use good password – Radenko Kozomara Jul 10 '19 at 08:19
@MichaelDodd, I am using backtick ` instead of `'` in the query above – LIGHT Jul 10 '19 at 08:20
2

@RadenkoKozomara, Query is being executed. Now, there is nothing wrong with the code above. If its still bugging you, you need to ask another question – LIGHT Jul 10 '19 at 08:24
i think you're right, problem is in some other place... Thank you everyone! – Radenko Kozomara Jul 10 '19 at 08:27

What's the problem with this mysql query in php?

1 Answers1