PHP MySQL Query Where x = $variable

Question

I have this code (I know that the email is defined)

 <?php
$con=mysqli_connect($host,$user,$pass,$database);
 if (mysqli_connect_errno($con))
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con,"SELECT `note` FROM `glogin_users` WHERE email = '.$email.'");

while($row = mysqli_fetch_array($result))
echo $row
?>

In my MySQL database I have the following setup (Table name is glogin_users) id email note

I've tried extracting the note text from the database and then echo'ing it but it doesn't seem to echo anything.

Have you checked your error log? What errors do you get? What steps have you taken to troubleshoot this? Have you run the query from the command line? — John Conde, Mar 29 '13 at 12:52
You can also use `complex syntax` - curly brackets around the variable `WHERE email = ' {$emai} ' ");` . http://php.net/manual/en/language.types.string.php#language.types.string.parsing.complex — Dexter, Nov 01 '18 at 04:16

score 41 · Answer 1 · answered Mar 29 '13 at 12:52

41

What you are doing right now is you are adding . on the string and not concatenating. It should be,

$result = mysqli_query($con,"SELECT `note` FROM `glogin_users` WHERE email = '".$email."'");

or simply

$result = mysqli_query($con,"SELECT `note` FROM `glogin_users` WHERE email = '$email'");

answered Mar 29 '13 at 12:52

John Woo

258,903
69
498
492

6

In addition to that - `echo $row` won't yield the expected, as `$row` is an array. It should be `echo $row['note']` – Havelock Mar 29 '13 at 12:55
you're welcome `:D` please also read the comment of @Havelock. – John Woo Mar 29 '13 at 12:59
just 1 more problem. I'm echoing my notes, however there seems to be lots of whitespace before the actual text. I'm not really sure on how to deal with this. – user2224376 Mar 29 '13 at 13:06
2

how about trimming it? `trim($row['note'])` – John Woo Mar 29 '13 at 13:07

score 4 · Answer 2 · edited Apr 23 '14 at 08:35

4

$result = mysqli_query($con,"SELECT `note` FROM `glogin_users` WHERE email = '".$email."'");
while($row = mysqli_fetch_array($result))
echo $row['note'];

edited Apr 23 '14 at 08:35

cyborg86pl

2,597
2
26
43

answered Mar 29 '13 at 13:40

Mucahit Kar

49
2

Raheel Hasan · Answer 3 · 2013-03-29T13:04:00.253

3

You have to do this to echo it:

echo $row['note'];

(The data is coming as an array)

edited Mar 29 '13 at 13:04

answered Mar 29 '13 at 12:55

Raheel Hasan

5,753
4
39
70

1

also, you got wrong use of dot in the query.. – Raheel Hasan Mar 29 '13 at 12:57

PHP MySQL Query Where x = $variable

3 Answers3

Linked