用php+mysql一個(gè)名片庫程序_PHP
Jun 01, 2016 pm 12:42 PM
用php+mysql一個(gè)名片庫程序,有分類查找,分頁功能。
第一步:按下列代表先做個(gè)靜態(tài)頁面。
第二步:如下建庫。
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 "
??????
???? |
";
??
????????
}
$vor = $show + $limit;
$back = $show - $limit;
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)注明作者及出處】????

Hot AI Tools

Undress AI Tool
Undress images for free

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Clothoff.io
AI clothes remover

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

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

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

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

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

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

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&

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" 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]](https://img.php.cn/upload/article/000/465/014/169538863364905.jpg?x-oss-process=image/resize,m_fill,h_207,w_330)
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
