String variable in wpdb query does not work

Question

I can't get results from such query:

$email = $_POST['email'];
$result = $wpdb->get_row("SELECT * FROM hp_tempusers WHERE email = %", $email);

It's always empty. But if I make:

$email = '[email protected]';

everything will work. I can't find the mistake and I will be very pleasant for any help.

thanks! but it still returns null. it's not the first time I face this problem. — www
– www, Commented Mar 13, 2017 at 15:54
try this $result = $wpdb->get_row("SELECT * FROM hp_tempusers WHERE email = '$email', ARRAY_A); — Cr1xus
– Cr1xus, Commented Mar 13, 2017 at 15:56

www · Accepted Answer · 2017-03-13 17:02:39Z

1

Found a solution. This code works:

$result = $wpdb->get_row($wpdb->prepare("SELECT * FROM hp_users WHERE user_email = %s", $my_email));

Other ways do not work with dynamic string variables

answered Mar 13, 2017 at 17:02

www

357 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

www Over a year ago

it does not matter what table and column. it did not work. and it could not work. i tried many tables and methods until understood how to do it. so i don't understand your irritation. if you don't want to waist time just relax

Pranav C Balan · Accepted Answer · 2017-03-14 03:47:37Z

0

Use placeholder %s for string instead of % with $wpdb->prepare method.

$email = $_POST['email']; 
$result = $wpdb->get_row(
    $wpdb->prepare("SELECT * FROM hp_tempusers WHERE email = %s", $email)
);

Or simply use the variable within the string.

$email = $_POST['email']; 
$result = $wpdb->get_row("SELECT * FROM hp_tempusers WHERE email = '{$email}'");

edited Mar 14, 2017 at 3:47

answered Mar 13, 2017 at 15:39

Pranav C Balan

115k25 gold badges173 silver badges195 bronze badges

4 Comments

www Over a year ago

thanks! but it's just mistake in my question. the problem is, this code $wpdb->get_row("SELECT * FROM hp_tempusers WHERE email = %s", $email); returns null

Pranav C Balan Over a year ago

@www : try $result = $wpdb->get_row("SELECT * FROM hp_tempusers WHERE email ={$email}");

www Over a year ago

the same. Null. i think, something wrong with the string. because if i send 1 and select id, it works

www Over a year ago

the answer is to use $wpdb->prepare() in this case, otherwise it will not work

Collectives™ on Stack Overflow

String variable in wpdb query does not work

2 Answers 2

1 Comment

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related