用php+mysql一个名片库程序，有分类查找，分页功能。 第一步：按下列代表先做个静态页面。 <form method="post" action="find1.php" name="card" onSubmit="return card_Validator(this)">           <table width="400" border="0" cellspacing="0" cellpadding="0" class="p10">             <tr>                <td colspan="2" height="79">                  <table width="280" border="0" cellspacing="0" cellpadding="0" class="p10">                   <tr>                      <td colspan="3" height="37">输入关键字： <input type="text" name="keyword" class="c3a">                     </td>                   </tr>                   <tr>                      <td>                        <input type="radio" name="inout" value="N" checked>                       按姓名</td>                     <td>                        <input type="radio" name="inout" value="C">                       按地区</td>                     <td>                        <input type="radio" name="inout" value="A">                       按职位</td>                   </tr>                 </table>               </td>             </tr>             <tr>                <td colspan="2" height="47">                  <input type="submit" name="query1" value="查找">                 <input type="reset" name="Submit2" value="清除">               </td>             </tr>           </table>         </form> 第二步：如下建库。 id  int(4)    否    auto_increment   http  varchar(25)    否 name  varchar(50)    否       email  varchar(50)    否       gs  varchar(200)    否       address  varchar(200)    否        yb  varchar(20)    否       zw  varchar(100)    否       tel  varchar(20)    否       fax  varchar(20)    否       bp  varchar(20)    否       第三步：查找执行程序 <?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);   }   } ?>   <p><font color="#FF0000" face="宋体" size="3"><strong><span style="font-size: 12pt"><font size="4" color="#000000">你查找的关键字是：</font></span></strong></font>:<font color=red><? echo $keyword;?></font></p>         <?  echo "<table width="400" border="0" cellspacing="0" cellpadding="0" align="center">   <tr>     <td width="314">       <div align="center">查找名片如下: 共有[<font color=red>";       echo $total;        echo "</font>]张名片</div>     </td>     <td width="86">       <div align="right">共分[<font color=red>";       echo $pages;      echo "</font>]页 </div>     </td>   </tr> </table>"; while ($row = mysql_fetch_array($quer)) { echo "<table width="440" border="1" cellspacing="0" cellpadding="0" height="175" align="center" bordercolordark="#eeeeee" bordercolorlight="#666666">     <tr>     <td>       <table width="380" border="0" cellspacing="0" cellpadding="0" align="center" bgcolor="#eeeeee">         <tr>            <td colspan="2" height="53">              <div align="center" class="pp13"><font color="#000000">$row[gs]</font></div>           </td>         </tr>         <tr>            <td height="35" colspan="2" align=center>       <b class="pp13">$row[name] <span class="pp9">$row[zw] <br>               </span></b>               <hr color="#FFCC00" noshade size="1">           </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>   </tr>   </table><br>";         } $vor = $show + $limit; $back = $show - $limit; print "<center>"; print "<table width="455" border="0" bordercolor="#FFCC33" cellspacing="0" align="center" >"; print "<tr  height="20" bgcolor="#FFD6AC"><td width="350" >"; for ($i=1;$i<=$pages;$i++) {     $new_offset=$limit*($i-1);     $parameter="query1=$query1&keyword=$keyword&inout=$inout";               print "<a href="$PHP_SELF?show=$i&$parameter"><b> $i</b></a>$nbsp"; } print "</td><td width="45" >"; //显示上一页 if ($show - $limit >= 0) { print " <a href="$PHP_SELF?show=$back&$parameter">上一页</a>"; } print "</td><td width="45">"; //显示下一页 if (($show + $limit) < $total) { print "<a href="$PHP_SELF?show=$vor&$parameter">下一页</a> "; } print "</td><td width="60">"; //显示全部留言 //print "<a href="$PHP_SELF?show=all.&$parameter">全部名片</a> "; print "</td></tr></table>"; print "</center>"; ?> 若有问题请mailto:lyjrich@sina.com,这个程序有个问题如果要显示全部名片的话，我这个程序还没有实现此功能，如果你知道在这个程序里怎样显示全部名片的话希望能发mail给我。  【本文版权归作者与奥索网共同拥有，如需转载，请注明作者及出处】