Why is my SQL statement not returning results?

Question

The desired statement is:

SELECT `id` FROM `user` WHERE `email`='aaa@aaa.com'

...which returns a single cell as results.

My PDO prepared statement doesn't return anything. What am I missing?

$email = "aaa@aaa.com";

$statement = $db->prepare("SELECT `id` FROM `user` WHERE `email`=':email;'");
$statement->execute(['email' => $email]);               
$user = $statement->fetch();
echo $user;

Don't add quotes with prepared statements. `WHERE \`email\` = :email;` — Siyual, Jan 12 '17 at 16:42
Also remove the ; from :email; it should be :email without the ; in your query — Bolli, Jan 12 '17 at 16:44
Shouldn't it also be `execute([':email' => $email])` (with the `:`) in the execute statement? (even though it was the prepare he had issues with right now). — M. Eriksson, Jan 12 '17 at 16:48

score 1 · Answer 1 · answered Jan 12 '17 at 16:44

1

Quote should not be used in :email

$statement = $db->prepare("SELECT `id` FROM `user` WHERE `email`=:email");

as said by @siyual

answered Jan 12 '17 at 16:44

Vishwa Ratna

5,567
5
33
55

score 1 · Accepted Answer · answered Jan 12 '17 at 16:56

1

Try this:

$email = "aaa@aaa.com";

$stmt = $db->prepare("SELECT `id` FROM `user` WHERE `email`=:email");
$stmt->bindParam(':email', $email, PDO::PARAM_STR);
$stmt->execute();
$row = $stmt->fetchAll(PDO::FETCH_ASSOC);
if (!empty($row)) {
    print_r($row);
}else{
    echo 'no result :/';
}

answered Jan 12 '17 at 16:56

Bolli

4,974
6
31
47

Ah thanks, this returned "no result", so there might be some issue with my connection or something cause I do get results when I do it in mysqlworkbench. – Heraclitus Jan 12 '17 at 17:02
I just realized there was a problem with my database selection, I get results now! – Heraclitus Jan 12 '17 at 17:04
Perfect! I was just about to ask you about that :) – Bolli Jan 12 '17 at 17:04

score -1 · Answer 3 · answered Jan 12 '17 at 16:44

-1

use it like this:

$statement = $db->prepare("SELECT `id` FROM `user` WHERE `email`=:email;"); 

$statement->execute(['email' => $email]);

also, make sure that

$db->prepare('select 1');

returns a valid query result.

answered Jan 12 '17 at 16:44

Giorgos Yiakoumettis

97
7

I don't understand how the second portion has any relation to the question. – Siyual Jan 12 '17 at 16:46
$test=$db->prepare('select 1'); $test1 = $test->fetch(); echo $test1; – Heraclitus Jan 12 '17 at 16:47
This doesn't return anything – Heraclitus Jan 12 '17 at 16:47
@Heraclitus - You need to execute the statement, as well – M. Eriksson Jan 12 '17 at 16:50
My bad I forgot, thanks @MagnusEriksson – Heraclitus Jan 12 '17 at 16:51
@Siyual second portion will ensure that there are no connection issues to the database. if you get a result with 1 as value ensures that there is no problem with the database connection. – Giorgos Yiakoumettis Jan 19 '17 at 18:04

Why is my SQL statement not returning results?

3 Answers3