我需要显示特定的记录,记录存在于db中,但什么也没显示。这是我的代码。
$con=mysqli_connect("localhost","root","","test") or die("Connecting to MySQL failed");
$name=$_POST['uname'];
$query = "SELECT * FROM officedb WHERE name='.$name.'";
$data=mysqli_query($con,$query);
while($row=mysqli_fetch_array($data)){
echo $row['name'];
echo $row['lname'];
echo $row['department'];
}
您认为$name
变量错误,只需更改:
$query = "SELECT * FROM officedb WHERE name='.$name.'";
有了这个:
$query = "SELECT * FROM officedb WHERE name = '$name'";
您的查询如下:
SELECT * FROM officedb WHERE name = '.test.'
更改后,我建议查询应为:
SELECT * FROM officedb WHERE name = 'test'
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句