用php+mysql一个名片库程序

用php+mysql一个名片库程序，有分类查找，分页功能。

第一步：按下列代表先做个静态页面。

第三步：查找执行程序
<?php

if (!isset($show)) $show=0;

{

if($query1=="查找")

{

$db=mysql_connect("localhost","用户名","密码");
$dbname=mysql_select_db("库文件名",$db);
mysql_query('select * from 表文件名',$db);
$limit=2; //一页显示几条内容。

//global $query,$queryyy,$quer;
switch($inout)

{

case "N":
//按姓名查找
$query="select * from card where name like '%$keyword%'";

$queryyy = "select * from card where name like '%$keyword%' order by id desc limit $show, $limit";

break;

case "C":
//按地区查找
$query="select * from card where address like '%$keyword%' order by id desc";

$queryyy = "select * from card where address like '%$keyword%' order by id desc limit $show, $limit";           

break;

case "A":
// 按职务查找
$query="select * from card where zw like '%$keyword%' order by id desc";

$queryyy = "select * from card where zw like '%$keyword%' order by id desc limit $show, $limit";
break;

}
$result1=mysql_query($query);
$total=mysql_num_rows($result1); //总的符合条件的记录数

$quer=mysql_query($queryyy,$db);
$pages=ceil($total/$limit);
}
}

?>

你查找的关键字是：:

<?

echo "

 echo "</font>]页 </div>   
</td>   

while ($row = mysql_fetch_array($quer))
{

echo "

      </td>   
    </tr>   
    <tr>    
      <td colspan='2'>    
        <ul>   
          <li><span class='pp10'>电话：$row[tel]</span></li>   
          <li><span class='pp10'>传真：$row[fax]</span></li>   
          <li><span class='pp10'>网址：$row[http]</span></li>   
          <li><span class='pp10'>电子信箱：$row[eamil]</span></li>   
          <li><span class='pp10'>地址：$row[address]</span></li>   
          <li><span class='pp10'>邮编：$row[yb]</span></li>   
          <li><span class='pp10'>BP:$row[bp]</span></li>   
        </ul>   
      </td>   
    </tr>   
  </table>   
</td>   

print "<a href="$PHP_SELF?show=$i&$parameter"><b> $i</b></a>$nbsp";