作者targa123 (神族之主)
看板PHP
标题[请益] 请问一个增加页码的问题???
时间Sun Jan 7 01:10:27 2007
程式码如下,
不好意思有点长,
<?
session_register("show2");
$tabname=$_POST["select"];
if (!empty($tabname))
{
switch ($tabname){
case "v1":
$tabname = "airplane";
echo "<table border=1>
<tr>
<td>编号</td>
<td>最大座位数</td>
<TD>飞机名字</td>
</tr>";
break;
case "v2":
$tabname = "airplanetype";
echo "<table border=1>
<tr>
<td>飞机名字</td>
<td>最大座位数</td>
<TD>所属公司</td>
</tr>";
break;
case "v3":
$tabname = "airport";
echo "<table border=1>
<tr>
<td>机场代码</td>
<td>机场名</td>
<TD>城市</td>
<td>国家<td>
</tr>";
break;
case "v4":
$tabname = "canland";
echo "<table border=1>
<tr>
<td>机场代码</td>
<td>种类<td>
</tr>";
break;
case "v5":
$tabname = "fare";
echo "<table border=1>
<tr>
<td>班机号码</td>
<td>乘客编号</td>
</tr>";
break;
case "v6":
$tabname = "flight";
echo "<table border=1>
<tr>
<td>班次编号</td>
<TD>航线种类</td>
</tr>";
break;
case "v7":
$tabname = "flightleg";
echo "<table border=1>
<tr>
<td>航班编号 </td>
<td>航程编号 </td>
<TD>出境机场代码 </td>
<td>出境时间 </td>
<td>入境机场代码 </td>
<td>入境时间</td>
</tr>";
break;
case "v8":
$tabname = "leginstance";
echo "<table border=1>
<tr>
<td>机场代码 </td>
<td>飞机编号 </td>
<TD> 日期</td>
<td>控位数 </td>
<td>入境时间 </td>
<td>出境时间</td>
</tr>";
break;
case "v9":
$tabname = "seat";
echo "<table border=1>
<tr>
<td>机场代码 </td>
<td>飞机编号 </td>
<td>日期</td>
<td>座位编号 </td>
<td>顾客姓名</td>
<td>顾客电话 </td>
</tr>";
break;
}
$_SESSION["tabname"]=$tabname;
$sql="SELECT * FROM $tabname";
$result = mysql_query($sql,$link);
$total_fields=mysql_num_fields($result);
echo "</tr>";
while($row = mysql_fetch_row($result))
{
echo "<tr>";
for($i=0;$i <= $total_fields-1;$i++)
{
if (empty($row[$i]) != false )
{
$row[$i]=0;
}
echo "<td>". $row[$i]. "</td>";
$id=$row[0];
}
echo "<td><a href='update.php?act=edit&id=$id'><img src='photo/button_edit.png' alt='修改'></td>";
echo "<td><a href='update.php?act=del&id=$id'><img src='photo/button_drop.png' alt='删除'></td>";
echo "</tr>";
}
echo "</table>";
mysql_free_result($result);
mysql_close($link);
}//if end
else{
echo "<div class='div14'><div>";
}
?>
不知道这如果想增加页码,
变成一页10笔资料
应该要如何增加呢???
拜托各位大人了...
THX!
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 210.203.30.92
1F：推 italk:SQL先抓出总数，再用 limit $第几页,10 去做 01/09 09:58