有人能帮我做一个搜索页面吗?我喜欢这个页面,它将输出从value1到value2的所有数据。im收到此错误警告:mysql_num_rows()要求参数1为资源,
Search.php表单
<form action="Search.php" method="POST">
<input type="text" name="value1" placeholder="FROM TIME">
<input type="text" name="value2" placeholder="TO TIME">
<input type="submit" value=">>">
</form>
搜索.php
<?php
mysql_connect("localhost","root","") or die("NO connection");
mysql_select_db("ci")or die("No DATABASE");
$value1 =$_POST['value1'];
$value2 =$_POST['value2'];
$output="";
if (isset($_POST ['value1'],$_POST['value2'])){
$result=mysql_query("SELECT * FROM slogs WHERE TIME BETWEEN
".$_POST['value2']." AND ".$_POST['value2']." ");
$count=mysql_num_rows($result);
if($count==0){
$output='You are not a student';
} else{
while($row=mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>".$TIME.=$row['TIME']."</td>";
echo "<td>".$FN.=$row['FN']."</td>";
echo "<td>".$LN.=$row['LN']."</td>";
echo "<td>".$DT.=$row['DT']."</td>";
echo "</tr>";
}
}
}
?>
尝试在查询的值周围添加单引号'
$result=mysql_query("SELECT * FROM slogs WHERE TIME BETWEEN '". $value1 ."' AND '". $value2 ."' ");
您的搜索是在相同的两个值之间选择数据。试试这个:
<?php
mysql_connect("localhost","root","") or die("NO connection");
mysql_select_db("ci")or die("No DATABASE");
$value1 =$_POST['value1'];
$value2 =$_POST['value2'];
$output="";
if (isset($value1,$value2)){
$result=mysql_query("SELECT * FROM slogs WHERE TIME BETWEEN
". $value1 ." AND ". $value2 ." ");
$count=mysql_num_rows($result);
if($count==0){
$output='You are not a student';
} else{
while($row=mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>".$TIME.=$row['TIME']."</td>";
echo "<td>".$FN.=$row['FN']."</td>";
echo "<td>".$LN.=$row['LN']."</td>";
echo "<td>".$DT.=$row['DT']."</td>";
echo "</tr>";
}
}
}
?>