如何从数据库中搜索用户输入名称。示例 [e-mail]。它应该搜索数据库中的 [e-mail] 并给我 abc 的详细信息

Question

//where "candi_s_by_mail" is my field id, "cand_mail" is my db column and $cand_mail is varibale where i have stored field user input data. 
if(isset($_POST['candi_s_by_mail']))
{
  $sql="SELECT  * FROM candidate WHERE cand_mail=$candmail";
  echo "Selected candidate mail details";
}
$result = mysql_query($sql) or die(mysql_error());; 
echo "in result";
while($row=mysql_fetch_array($result))
{ 
  $FirstName  =$row['cand_fname']; 
  $LastName=$row['cand_lname']; 
  $Mail=$row['cand_mail'];  
}

我想查询我的搜索，因为当用户输入字符或文本时，它应该只显示

Answer 1

根据

我们的讨论 $_POST['candi_s_by_mail'] 是一个文本，所以我们需要像这样编写查询

SELECT * FROM candidate WHERE cand_mail='$candmail';

字符串或文本应用引号书写。