【php开源代码栏目提醒】:网学会员鉴于大家对php开源代码十分关注,论文会员在此为大家搜集整理了“show_hot.php”一文,供大家参考学习
<html>
<HEAD>
<STYLE> <!-- A{text-decoration:none} --> </STYLE>
</HEAD>
<body>
<H2><font face="标楷体" size="6" color="#000080">车辆检索 <br></font>
<font size="4" face="标楷体">热门车辆一览</font></H2>
</h4>
<?
$link=mysql_connect('localhost','root','123456');
mysql_select_db('wouc');
$str="select * from car_info where ci_hot > 100/ci_price*500000;";
$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>
<?//echo date("j, n, Y H:i:s", time());?>
<form name='z' action='..\detial.php' method='post'>
<table border=1 bordercolor='#FF9933'><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 = mysql_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>
上一篇:
show_exc.php
下一篇:
4种小菜缓解孕妈咪不适