A business card library program using php+mysql_PHP tutorial

Use php+mysql to create a business card library program with classification search and paging functions.

Step 1: Make a static page first according to the following representation.

          
              
              
            
              
              
            
          

  
                
                    
                    
                  
                    
                    
                    
                    
                  
                

输入关键字：
按姓名	按地区	按职位

              

        

第二步：如下建库。
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 "
  
    
    
  

查找名片如下: 共有[";       echo $total;        echo "]张名片

共分[";       echo $pages;      echo "]页

";

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

echo "    


    
  
  

      
          
          
        
          
          
        
          
          
        
      

  
            

$row[gs]

          

  
     $row[name] $row[zw]

              
              

---

          

  
            

              
• 电话：$row[tel]

              
• 传真：$row[fax]

              
• 网址：$row[http]

              
• 电子信箱：$row[eamil]

              
• 地址：$row[address]

              
• 邮编：$row[yb]

              
• BP:$row[bp]

            

          

    

";

        
}

$vor = $show + $limit;
$back = $show - $limit;
print "";

print "";
print "

"; for ($i=1;$i<=$pages;$i++) {     $new_offset=$limit*($i-1);     $parameter="query1=$query1&keyword=$keyword&inout=$inout";                 print " $i$nbsp"; } print "

"; //显示上一页 if ($show - $limit >= 0) { print " 上一页"; } print "

"; //显示下一页 if (($show + $limit) < $total) { print "下一页 "; } print "

"; //Show all comments //print "All business cards "; print "

";
print "";
?>
If you have any questions, please mailto:lyjrich@sina.com. There is a problem with this program. If you want to display all business cards, my program has not implemented this function. If you know how to display it in this program, If you have all the business cards, I hope you can send them to me via email.

[The copyright of this article is jointly owned by the author and Oso.com. If you need to reprint, please indicate the author and source]

http://www.bkjia.com/PHPjc/316731.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/316731.htmlTechArticleA business card library program using php+mysql, with classification search and paging functions. Step 1: Make a static page first according to the following representation. form method=post action=find1.php name=card onSubmit=return...