多重條件組合查詢(xún)_PHP
Jun 01, 2016 pm 12:32 PM
平常我們?cè)陂_(kāi)發(fā)系統(tǒng)時(shí),一定不會(huì)缺少查詢(xún)功能,然而往往算個(gè)條件是無(wú)法滿(mǎn)足用戶(hù)的要求的,這時(shí)我們就應(yīng)該設(shè)置多重條件進(jìn)行組合,讓用戶(hù)查詢(xún)時(shí)以更加方便地選擇查詢(xún)條件,迅速找到他們所滿(mǎn)足的記錄.
現(xiàn)在我們假設(shè)開(kāi)發(fā)一個(gè)鐘表公司的客戶(hù)訂單系統(tǒng),有客戶(hù)訂單編號(hào),類(lèi)別,名稱(chēng),數(shù)量,價(jià)格等資料,這里就不將資料一一列擊,.訂單表如下:
訂單編號(hào)(ID) 類(lèi)別(TYPE) 名稱(chēng)(NAME) 數(shù)量(QTY) 價(jià)格(PRICE)
001 機(jī)芯 機(jī)芯1 100 100
001 表殼 表殼1 1000 30
001 表帶 表帶1 500 60
002 機(jī)芯 機(jī)芯2 200 150
002 表殼 表殼2 500 40
002 表帶 表帶2 300 70
現(xiàn)在我們?cè)O(shè)想要建一個(gè)查詢(xún)系統(tǒng),讓用戶(hù)即可根據(jù)訂單編號(hào),也可根據(jù)類(lèi)別,或者根據(jù)價(jià)格,或者其中的各自組合來(lái)實(shí)現(xiàn)快速查詢(xún),代號(hào)如下:
下面此部分是顯示查詢(xún)條件的窗體
$linkstr=mysql_connect("localhost","root","sa");
mysql_select_db("cx",$linkstr);
?>
摘自:PHP中文用戶(hù)
作者:Hafele

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

Download the latest version of 12306 ticket booking app. It is a travel ticket purchasing software that everyone is very satisfied with. It is very convenient to go wherever you want. There are many ticket sources provided in the software. You only need to pass real-name authentication to purchase tickets online. All users You can easily buy travel tickets and air tickets and enjoy different discounts. You can also start booking reservations in advance to grab tickets. You can book hotels or special car transfers. With it, you can go where you want to go and buy tickets with one click. Traveling is simpler and more convenient, making everyone's travel experience more comfortable. Now the editor details it online Provides 12306 users with a way to view historical ticket purchase records. 1. Open Railway 12306, click My in the lower right corner, and click My Order 2. Click Paid on the order page. 3. On the paid page

How to check my academic qualifications on Xuexin.com? You can check your academic qualifications on Xuexin.com, but many users don’t know how to check their academic qualifications on Xuexin.com. Next, the editor brings you a graphic tutorial on how to check your academic qualifications on Xuexin.com. Interested users come and take a look! Xuexin.com usage tutorial: How to check your academic qualifications on Xuexin.com 1. Xuexin.com entrance: https://www.chsi.com.cn/ 2. Website query: Step 1: Click on the Xuexin.com address above to enter the homepage Click [Education Query]; Step 2: On the latest webpage, click [Query] as shown by the arrow in the figure below; Step 3: Then click [Login Academic Credit File] on the new page; Step 4: On the login page Enter the information and click [Login];

MySQL and PL/SQL are two different database management systems, representing the characteristics of relational databases and procedural languages ??respectively. This article will compare the similarities and differences between MySQL and PL/SQL, with specific code examples to illustrate. MySQL is a popular relational database management system that uses Structured Query Language (SQL) to manage and operate databases. PL/SQL is a procedural language unique to Oracle database and is used to write database objects such as stored procedures, triggers and functions. same

Title: How to use Oracle to query whether a table is locked? In Oracle database, table lock means that when a transaction is performing a write operation on the table, other transactions will be blocked when they want to perform write operations on the table or make structural changes to the table (such as adding columns, deleting rows, etc.). In the actual development process, we often need to query whether the table is locked in order to better troubleshoot and deal with related problems. This article will introduce how to use Oracle statements to query whether a table is locked, and give specific code examples. To check whether the table is locked, we

If you want to check the activation date using an Apple mobile phone, the best way is to check it through the serial number in the mobile phone. You can also check it by visiting Apple's official website, connecting it to a computer, and downloading third-party software to check it. How to check the activation date of Apple mobile phone Answer: Serial number query, Apple official website query, computer query, third-party software query 1. The best way for users is to know the serial number of their mobile phone. You can see the serial number by opening Settings, General, About This Machine. . 2. Using the serial number, you can not only know the activation date of your mobile phone, but also check the mobile phone version, mobile phone origin, mobile phone factory date, etc. 3. Users visit Apple's official website to find technical support, find the service and repair column at the bottom of the page, and check the iPhone activation information there. 4. User

Forum is one of the most common website forms on the Internet. It provides users with a platform to share information, exchange and discuss. Discuz is a commonly used forum program, and I believe many webmasters are already very familiar with it. During the development and management of the Discuz forum, it is often necessary to query the data in the database for analysis or processing. In this article, we will share some tips for querying the location of the Discuz database and provide specific code examples. First, we need to understand the database structure of Discuz

Hello everyone, today I will share with my friends the specific steps of how to combine two graphics in PPT. If you follow these steps, you will learn the operation step by step, and you can draw inferences in the future. The details of the steps are below. Friends, come and take a serious look! 1. First, open a PPT document on your computer, and then create a new PPT slide (as shown in the picture below). 2. Next, find [Shape] in the upper menu bar item [Insert], and select the shape to be imported in the drop-down box of the shape (as shown in the red circle in the figure below). 3. Use the insert function of PPT to insert the triangle and circle shapes into the PPT in sequence, and adjust the size and position of the shapes (as shown by the red arrow in the picture below). 4

Check the latest price of BitTorrent Coin (BTT) BTT is a cryptocurrency on the TRON blockchain that is used to reward BitTorrent network users for sharing and downloading files. Here's how to find the latest price for BTT: Choose a reliable price check website or app. Some commonly used price query websites include: CoinMarketCap: https://coinmarketcap.com/Coindesk: https://www.coindesk.com/Binance: https://www.binance.com/ Search on the website or app BTT. Check out the latest prices for BTT. Note: Cryptocurrency Prices
