PHP MySQL Query Where x variable

Question

I have this code  I know that the email is defined     lt  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   gt    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

User · Answer

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'");

User · Answer

result   mysqli query  con  SELECT  note  FROM  glogin users  WHERE email       email       while  row   mysqli fetch array  result   echo  row  note

User · Answer

You have to do this to echo it   echo  row  note       The data is coming as an array

[php] PHP MySQL Query Where x = $variable

Examples related to php

Examples related to mysql

Examples related to variables

Examples related to where