<table width="100%" border="1" cellpadding="0"  cellspacing="0">             //建表

     <tr>                                   //表头

          <td>AreaCode</td>

         <td>AreaName</td>

         <td>ParentAreaCode</td>

         <td>Root</td>

         <td>Zone</td>

     </tr>

 <?php

 include("../dbda.class.php");            //引入数据库类

 include("../page.class.php");            //引入分页类

 $db= new dbda();

 $sqlall = "select count(*) from chinastates ".$tj;    //写sql语句，并拼上查询条件（$tj 会在下面给出）

 $attrall = $db->Query($sqlall);

 $total = $attrall[0][0];

 $page = new Page($total,20,$fytj,true);

 $limit = $page->limit;

 $sql = "select * from chinastates ".$tj.$limit;     ////写sql语句，并拼上查询条件（$tj 会在下面给出）

 $attr = $db->Query($sql);

 foreach($attr as $v)

 {

     echo "<tr>

         <td>{$v[0]}</td>

         <td>{$v[1]}</td>

         <td>{$v[2]}</td>

         <td>{$v[3]}</td>

         <td>{$v[4]}</td>

     </tr>";

 }

 ?>

 </table>

 <?php

     echo "<div>".$page->fpage()."</div>";     //分页列表

 ?>

<?php

$name = "";

$fytj = "";

if(!empty($_POST["name"]))               //判断是否为空，也就是判断是否有提交值

{

    $name = $_POST["name"];

    $fytj = " name={$name}";

}

if(!empty($_GET["name"]))                //判断是否为空，也就是判断是否有提交值

{

    $name = $_GET["name"];

    $fytj = " name={$name}";

}

$tj = " where AreaName like '%{$name}%' ";    //查询条件

?>

<br />

<form action="text.php" method="post">    //用post方法传值

    <div>

    请输入：

    <input type="text" name="name" value="" />

    <input type="submit" value="查询" />

    </div>

</form>

<?php

$name = "";

$fytj = "";

if(!empty($_POST["name"]))

{

    $name = $_POST["name"];

    $fytj = " name={$name}";

}

if(!empty($_GET["name"]))

{

    $name = $_GET["name"];

    $fytj = " name={$name}";

}

$tj = " where AreaName like '%{$name}%' ";

?>

<br />

<form action="text.php" method="post">

    <div>

    请输入：

    <input type="text" name="name" value="" />

    <input type="submit" value="查询" />

    </div>

</form>