如图片所示,要求输入数字后点击查询可以在上面显示出查询到的内容.
( 图片地址:http://hiphotos.baidu.com/zhidao/abpic/item/aec379314ec30c40ebc4af94.jpg?t=1304389706111
百度的地址,引用不过来.... )但是现在的点查询没反应,不显示内容
其中conn.php内容如下:
<?php$conn = @mysql_connect("localhost","root","root") or die ("错误");
mysql_select_db("db",$conn);
mysql_query("set names 'GBK'");
?>其中index.php如下:
<?php
include 'conn.php';
if (isset($_POST['submit'])){
$num=$_POST['num'];
$sql="SELECT `num` FROM test WHERE num='.$num.'";
$tt=mysql_query($sql);
if($tt){
$row = mysql_fetch_assoc($tt);
echo "num:".$row[num]."</br>";
}else{
return false;
}
}
?>
<form action="index.php" method="post">
输入条形码:<input type="text" size="13" name="num">
<input type="submit" name="submit" value="查询">
</form>
究竟是哪里错了呢
( 图片地址:http://hiphotos.baidu.com/zhidao/abpic/item/aec379314ec30c40ebc4af94.jpg?t=1304389706111
百度的地址,引用不过来.... )但是现在的点查询没反应,不显示内容
其中conn.php内容如下:
<?php$conn = @mysql_connect("localhost","root","root") or die ("错误");
mysql_select_db("db",$conn);
mysql_query("set names 'GBK'");
?>其中index.php如下:
<?php
include 'conn.php';
if (isset($_POST['submit'])){
$num=$_POST['num'];
$sql="SELECT `num` FROM test WHERE num='.$num.'";
$tt=mysql_query($sql);
if($tt){
$row = mysql_fetch_assoc($tt);
echo "num:".$row[num]."</br>";
}else{
return false;
}
}
?>
<form action="index.php" method="post">
输入条形码:<input type="text" size="13" name="num">
<input type="submit" name="submit" value="查询">
</form>
究竟是哪里错了呢
include 'conn.php';
if (isset($_POST['submit'])){
$num=$_POST['num'];
$sql="SELECT `num` FROM test WHERE num='.$num.'";
//$tt=mysql_query($sql);
if ($tt = mysql_query($sql)) {
$row = mysql_fetch_assoc($tt);
echo "num:".$row[num]."</br>";
}else{
echo mysql_error();
}
}
//改为
echo "num:".$row['num']."<br />";
改为:
$sql="SELECT `num` FROM test WHERE num='$num'";//把点去掉
改为
$sql="SELECT num FROM test WHERE num='".$num."'";
error_reporting(E_ALL);
如果还是不输出错误信息的话,修改php.ini:
display_errors = On
重启Web服务再看一下。