my life would suck without you 用php+mysql一個名片庫程序-php教程-PHP中文網

my life would suck without you 用php+mysql一個名片庫程序

WBOY

發布： 2016-07-29 08:34:33

原創

886 人瀏覽過

用php+mysql一個名片庫程序，有分類查找，分頁功能。
第一步：按下列代表先做個靜態頁面。

   37">輸入關鍵字：




                      按姓名 >

               table>

      ue="A">
                      按職位

             "query1" value="查找">
                {
$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 "

        ；


        ;