用php+mysql一个名片库程序

用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给我。  【正文版权归作家与奥索网共通具有，如需连载，请证明作家及根源】