UC知道为什么简单的PHP例子错误
来源：百度知道 编辑：UC知道 时间：2024/06/15 10:49:52
例子：<html>
<body>
<form method="post" action="<? $PHP_SELF ?>">
输入家庭成员姓名<input type="text" name = "name">
<input type = "submit">
</form>
<?php
$link=mysql_connect("localhost","root","123456");
mysql_select_db("my_family")or die("不能连接");
$result=mysql_query("select * from family where age ="张三"");
while($rs=mysql_fetch_object($result))
{
echo $rs->age;
}
mysql_free_result($result);
?>
</body>
</html>
数据库有两个字段，name和age,查询语句没问题，而且如果把age作查询条件也能输出，但为什么这样就是错误呢？
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in D:\p8-server\DedeAMPZ\WebRoot\Default\workplace\myFamily\index.php on line 14
Warning: mysql_free_resul
<body>
<form method="post" action="<? $PHP_SELF ?>">
输入家庭成员姓名<input type="text" name = "name">
<input type = "submit">
</form>
<?php
$link=mysql_connect("localhost","root","123456");
mysql_select_db("my_family")or die("不能连接");
$result=mysql_query("select * from family where age ="张三"");
while($rs=mysql_fetch_object($result))
{
echo $rs->age;
}
mysql_free_result($result);
?>
</body>
</html>
数据库有两个字段，name和age,查询语句没问题，而且如果把age作查询条件也能输出，但为什么这样就是错误呢？
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in D:\p8-server\DedeAMPZ\WebRoot\Default\workplace\myFamily\index.php on line 14
Warning: mysql_free_resul
$result=mysql_query("select * from family where age ="张三"");
改为
$result=mysql_query("select * from family where `name` ='张三'");
注意有些mysql服务器需要在值前加`
如图。
$result=mysql_query("select * from family where age ="张三"");
改为
$result=mysql_query('select * from family where age =&quo