【php开源代码栏目提醒】:本文主要为网学会员提供show_new.php,希望对需要show_new.php网友有所帮助,学习一下!
<html>
<HEAD>
<STYLE> <!-- A{text-decoration:none} --> </STYLE>
</HEAD>
<body>
<H2><font face="标楷体" size="6" color="#000080">车辆检索 </font></H2>
<p align='left'><b>新进车辆一览</b></p></h4>
<?
$link=mysql_connect('localhost','root','123456');
mysql_select_db('wouc');
//将日期转为字串,提前三个月作为新车搜寻
$now_Y=date("Y");
$now_n=date("n");
$now_j=date("j");
if($now_n==3){
$now_Y-=1;
$now_n=12;
}
else if($now_n==2){
$now_Y-=1;
$now_n=11;
}
else if($now_n==1){
$now_Y-=1;
$now_n=10;
}
else
$now_n-=3;
$now_Y*=10000;
$now_n*=100;
$now_date=$now_Y+$now_n+$now_j;
//echo $now_date;
$str="select * from car_info where ci_state=0 and buy_date > '".$now_date."';";
$result=
mysql_query($str,$link);
//echo "str=".$str."<br>";
?>
<p align='left' style='line-height: 0%'>
[<a href='..\show.php'>二手车辆一览 </a>]
[<a href='.\show_new.php'> 新进车辆 </a>]
[<a href='.\show_hot.php'> 热门车辆 </a>]
[<a href='.\show_pic.php'> 图片预览 </a>]
</p>
<form name='z' action='..\detial.php' method='post'>
<table border=1 bordercolor='pink'><tr>
<td><font color="#000080">勾选</font></td> <td>
<font color="#000080">编号</font></td> <td>
<font color="#000080">厂牌</font></td> <td>
<font color="#000080">车款</font></td> <td>
<font color="#000080">排气量</font></td><td><font color="#000080">车种</font></td>
<td><font color="#000080">出厂日期</font></td> <td>
<font color="#000080">订价</font></td> <td>
<font color="#000080">人气</font></td></tr>
<?
$total=0;
while ($row = my
sql_fetch_array ($result , MYSQL_NUM)) {
echo "<tr>";
echo "<td><input type='radio' name='msg[]' value='$row[0]'></td>";
echo "<td>".$row[0]."</td>";
echo "<td>".$row[2]."</td>";
echo "<td>".$row[4]."</td>";
echo "<td>".$row[1]."</td>";
echo "<td>".$row[3]."</td>";
echo "<td>".$row[5]."</td>";
echo "<td>".$row[6]."</td>";
echo "<td>".$row[11]."</td>";
echo "</tr>";
$total++;
}
echo "</table><br>";
echo "现有车辆一共".$total."笔<br>";
echo "<br>";
?>
<input type = 'submit' value ='检视勾选之项目'>
<input type ='reset' value ='取消选择'>
</forrm>
<?
mysql_close($link);
?>
<p align='left' style='line-height: 0%'>
[<a href='..\show.php'>二手车辆一览 </a>]
[<a href='.\show_new.php'> 新进车辆 </a>]
[<a href='.\show_hot.php'> 热门车辆 </a>]
[<a href='.\show_pic.php'> 图片预览 </a>]
</p>
</body>
</html>