国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

Home Backend Development PHP Tutorial 用php+mysql一個(gè)名片庫程序_PHP

用php+mysql一個(gè)名片庫程序_PHP

Jun 01, 2016 pm 12:42 PM
class limit business card program

用php+mysql一個(gè)名片庫程序,有分類查找,分頁功能。

第一步:按下列代表先做個(gè)靜態(tài)頁面。


??????????
??????????????
??????????????
????????????
??????????????
??????????????
????????????
??????????
??
????????????????
????????????????????
????????????????????
??????????????????
????????????????????
????????????????????
????????????????????
????????????????????
??????????????????
????????????????
輸入關(guān)鍵字:

????????????????????
??
??????????????????????
??????????????????????按姓名
??
??????????????????????
??????????????????????按地區(qū)
??
??????????????????????
??????????????????????按職位

??????????????
??
????????????????
????????????????
??????????????

????????

第二步:如下建庫。
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)????否???????

第三步:查找執(zhí)行程序

if (!isset($show)) $show=0;

{???




if($query1=="查找")

{

$db=mysql_connect("localhost","用戶名","密碼");
$dbname=mysql_select_db("庫文件名",$db);
mysql_query('select * from 表文件名',$db);
$limit=2; //一頁顯示幾條內(nèi)容。

//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":
???//按地區(qū)查找
$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":??
??// 按職務(wù)查找
???$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); //總的符合條件的記錄數(shù)??

$quer=mysql_query($queryyy,$db);
$pages=ceil($total/$limit);
??}
??}

?>
???
??

你查找的關(guān)鍵字是:: echo $keyword;?>


????????????????????
????????
??




echo "
??
????
????
??

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

????

??????
共分[";
??????echo $pages;
???????
?????echo "
]頁

????
";

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

echo "????
??

????
??
??

??????
??????????
??????????
????????
??????????
??????????
????????
??????????
??????????
????????
??????
??
????????????
$row[gs]

??????????
??
?????$row[name] $row[zw]

??????????????

??????????????

????????
??????????
??
????????????

    ??????????????
  • 電話:$row[tel]

  • ??????????????
  • 傳真:$row[fax]

  • ??????????????
  • 網(wǎng)址:$row[http]

  • ??????????????
  • 電子信箱:$row[eamil]

  • ??????????????
  • 地址:$row[address]

  • ??????????????
  • 郵編:$row[yb]

  • ??????????????
  • BP:$row[bp]

  • ????????????

??????????

????

";
??
????????
}

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

print "";
print "
";
for ($i=1;$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) {
print "下一頁 ";
}
print "
";
//顯示全部留言
//print "全部名片 ";
print "
";
print "
";
?>
若有問題請(qǐng)mailto:lyjrich@sina.com,這個(gè)程序有個(gè)問題如果要顯示全部名片的話,我這個(gè)程序還沒有實(shí)現(xiàn)此功能,如果你知道在這個(gè)程序里怎樣顯示全部名片的話希望能發(fā)mail給我。??

【本文版權(quán)歸作者與奧索網(wǎng)共同擁有,如需轉(zhuǎn)載,請(qǐng)注明作者及出處】????
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undress AI Tool

Undress AI Tool

Undress images for free

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to make Google Maps the default map in iPhone How to make Google Maps the default map in iPhone Apr 17, 2024 pm 07:34 PM

The default map on the iPhone is Maps, Apple's proprietary geolocation provider. Although the map is getting better, it doesn't work well outside the United States. It has nothing to offer compared to Google Maps. In this article, we discuss the feasible steps to use Google Maps to become the default map on your iPhone. How to Make Google Maps the Default Map in iPhone Setting Google Maps as the default map app on your phone is easier than you think. Follow the steps below – Prerequisite steps – You must have Gmail installed on your phone. Step 1 – Open the AppStore. Step 2 – Search for “Gmail”. Step 3 – Click next to Gmail app

How to open a website using Task Scheduler How to open a website using Task Scheduler Oct 02, 2023 pm 11:13 PM

Do you frequently visit the same website at about the same time every day? This can lead to spending a lot of time with multiple browser tabs open and cluttering the browser while performing daily tasks. Well, how about opening it without having to launch the browser manually? It's very simple and doesn't require you to download any third-party apps, as shown below. How do I set up Task Scheduler to open a website? Press the key, type Task Scheduler in the search box, and then click Open. Windows On the right sidebar, click on the Create Basic Task option. In the Name field, enter the name of the website you want to open and click Next. Next, under Triggers, click Time Frequency and click Next. Select how long you want the event to repeat and click Next. Select enable

How to write a simple countdown program in C++? How to write a simple countdown program in C++? Nov 03, 2023 pm 01:39 PM

C++ is a widely used programming language that is very convenient and practical in writing countdown programs. Countdown program is a common application that can provide us with very precise time calculation and countdown functions. This article will introduce how to use C++ to write a simple countdown program. The key to implementing a countdown program is to use a timer to calculate the passage of time. In C++, we can use the functions in the time.h header file to implement the timer function. The following is the code for a simple countdown program

Clock app missing in iPhone: How to fix it Clock app missing in iPhone: How to fix it May 03, 2024 pm 09:19 PM

Is the clock app missing from your phone? The date and time will still appear on your iPhone's status bar. However, without the Clock app, you won’t be able to use world clock, stopwatch, alarm clock, and many other features. Therefore, fixing missing clock app should be at the top of your to-do list. These solutions can help you resolve this issue. Fix 1 – Place the Clock App If you mistakenly removed the Clock app from your home screen, you can put the Clock app back in its place. Step 1 – Unlock your iPhone and start swiping to the left until you reach the App Library page. Step 2 – Next, search for “clock” in the search box. Step 3 – When you see “Clock” below in the search results, press and hold it and

Identity matrix program in C language Identity matrix program in C language Aug 30, 2023 am 10:45 AM

Given a square matrix M[r][c], where "r" is a certain number of rows and "c" are columns such that r=c, we have to check if "M" is the identity matrix. Identity matrix Identity matrix is ??also known as identity matrix of size nxn square matrix in which the integer value of diagonal elements is 1 and the integer value of non-diagonal elements is 0 like the example given below-$$I1=\ begin{bmatrix}1\end{bmatrix},\I2=\begin{bmatrix}1&0\0&1\end{bmatrix},\I3=\begin{bmatrix}1&0&0\0&1&0\0&amp

Can't allow access to camera and microphone in iPhone Can't allow access to camera and microphone in iPhone Apr 23, 2024 am 11:13 AM

Are you getting "Unable to allow access to camera and microphone" when trying to use the app? Typically, you grant camera and microphone permissions to specific people on a need-to-provide basis. However, if you deny permission, the camera and microphone will not work and will display this error message instead. Solving this problem is very basic and you can do it in a minute or two. Fix 1 – Provide Camera, Microphone Permissions You can provide the necessary camera and microphone permissions directly in settings. Step 1 – Go to the Settings tab. Step 2 – Open the Privacy & Security panel. Step 3 – Turn on the “Camera” permission there. Step 4 – Inside, you will find a list of apps that have requested permission for your phone’s camera. Step 5 – Open the “Camera” of the specified app

Detailed explanation of how to use take and limit in Laravel Detailed explanation of how to use take and limit in Laravel Mar 10, 2024 pm 05:51 PM

"Detailed explanation of how to use take and limit in Laravel" In Laravel, take and limit are two commonly used methods, used to limit the number of records returned in database queries. Although their functions are similar, there are some subtle differences in specific usage scenarios. This article will analyze the usage of these two methods in detail and provide specific code examples. 1. Take method In Laravel, the take method is used to limit the number of records returned, usually combined with the orderBy method.

How to set up my business card in Contacts on iPhone [2023] How to set up my business card in Contacts on iPhone [2023] Sep 22, 2023 pm 09:17 PM

With My Business Cards in iOS, you can create a personalized contact card that Siri and other services recognize and associate with you and your phone number. With the introduction of contact posters in iOS17, My Cards becomes very important as it is now used to create your contact posters. If you're eager to get your contact poster up and running, you have to start by setting up My Business Card. We'll walk through how to create a My Business Card and how to make it work smoothly with Siri and your contact poster. How to Set Up My Business Cards in Contacts on iPhone [2023] If you are setting up My Business Cards on your iPhone for the first time, you must do it through the Contacts app only

See all articles