my life would suck without you A business card library program using php+mysql

Use php+mysql to create a business card library program with classification search and paging functions.
Step one: Make a static page first according to the following representation.

                                                                                                     0 "class =" p10 "& gt;
& lt; tr & gt;
& lt; td colorpan =" 2 "head =" 79 "& gt;
& lt; table width =" 280 "border =" 0 "0" CELLSPACING = "0" Cel. lpadding ="0" class="p10">
                                                                                                                                                                               class="c3a">
                                                                                                                                                            By name ;
                                                                                                                                                                                input type="radio" name="inout" value="A">
                                                                            
  
                                                                                                                                            
                                                               Step: Create a database as follows.
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)    否       
第三步：查找执行程序
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 "