Database mein data ko dhoondhna (Search) aur use ek sahi tarteeb/kram mein lagana (Sorting) kisi bhi website ka sabse important feature hota hai. Jaise jab aap Amazon par koi product search karte hain ya "Price: Low to High" filter karte hain, toh peeche yahi commands kaam karti hain.

Chaliye inko HTML Form, PHP backend code, aur SQL syntax ke sath asan Hindi mein samajhte hain.

1. LIKE (Website Search Bar Me Matching Words Dhoondne Ke Liye)

LIKE ka use tab hota hai jab hamein exact word nahi pata hota, balki hum kisi aadh-adhure shabd ya matching word se data search karna chahte hain. Isme % (Wildcard) ka use hota hai.

• '%shirt%' ka matlab hai: Aisa naam jisme beech mein, aage, ya peeche kahin bhi "shirt" aata ho (jaise: T-Shirt, Shirt-Men, Casualshirt).

HTML Form & PHP Code:

HTML

<form action="search.php" method="GET">
    <input type="text" name="search_query" placeholder="Kuch bhi search karein...">
    <button type="submit">Search</button>
</form>

PHP

// search.php
$search = $_GET['search_query'];

// Syntax: SELECT * FROM table WHERE column LIKE '%pattern%';
$query = "SELECT * FROM Products WHERE name LIKE '%$search%'";

• Meaning: Agar user ne search bar mein "phone" likha, toh yeh query un sabhi products ko nikal degi jinke naam mein "phone" shabd aata hai (e.g., iPhone, Smartphone, Headphone).

2. ORDER BY, ASC, aur DESC (Sorting Ke Liye)

ORDER BY ka kaam hai data ko kisi specific column ke hisab se line se lagana. Iske sath do options use hote hain:

• ASC (Ascending): Chhote se bada (A to Z, 1 to 100, ya Purani date se Nayi date). Agar aap ASC nahi bhi likhenge, toh SQL automatic ASC hi karta hai.

• DESC (Descending): Bade se chhota (Z to A, 100 to 1, ya Nayi date se Purani date).

HTML Form & PHP Code:

HTML

<form action="sort.php" method="GET">
    <select name="sort_option">
        <option value="low_to_high">Price: Low to High</option>
        <option value="high_to_low">Price: High to Low</option>
        <option value="newest">Newest Arrivals</option>
    </select>
    <button type="submit">Sort Karein</button>
</form>

PHP

// sort.php
$sort = $_GET['sort_option'];

// Default query
$query = "SELECT * FROM Products";

if($sort == "low_to_high") {
    // ORDER BY price ASC (Saste se Mehenga)
    $query = "SELECT * FROM Products ORDER BY price ASC";
} 
elseif($sort == "high_to_low") {
    // ORDER BY price DESC (Mehenge se Sasta)
    $query = "SELECT * FROM Products ORDER BY price DESC";
}
elseif($sort == "newest") {
    // ORDER BY id DESC (Jo product baad me add hua uski ID badi hogi, yani naya product pehle)
    $query = "SELECT * FROM Products ORDER BY id DESC";
}

Dono ko Ek Sath Use Karna (Search + Sort)

Aksar websites par aap kuch search karte hain aur fir use sort bhi karte hain. SQL mein pehle LIKE (Filter) lagta hai aur sabse aakhiri mein ORDER BY lagta hai.

SQL

-- Phone search karo aur saste se mehenge ke kram mein lagao
SELECT * FROM Products WHERE name LIKE '%phone%' ORDER BY price ASC;

Quick Revision Table

Command / Keyword	Asli Zindagi ka Kaam (E-commerce Example)	SQL Example
LIKE	Search bar mein "shoe" likhne par Shoes dikhana	WHERE name LIKE '%shoe%'
ORDER BY	Data ko kisi tarteeb (order) mein set karne ki shuruaat	ORDER BY column_name
ASC	Price: Low to High / Alphabetical (A to Z)	ORDER BY price ASC
DESC	Price: High to Low / Latest Items (Naya pehle)	ORDER BY date DESC

=====================================================================

Go TO one Page php1   >    

What is CRUD? Basic Database Operations Explained for Beginners php 1

Go TO one Page php2  >

SQL Filters & Conditions Tutorial: WHERE, AND, OR, IN, BETWEEN Explained php 2

Go TO one Page php3  >

SQL Search & Sorting Guide: Learn LIKE, ORDER BY, ASC, & DESC Easily php 3

Go TO one Page php4  >

SQL Pagination Tutorial: Master LIMIT and OFFSET (SKIP) in Databases php4

Go TO one Page php5  >

SQL Calculations & Groups Guide: Learn COUNT, SUM, AVG, GROUP BY & HAVING php 5

Go TO one Page php6  >

SQL Tables Linking Tutorial: JOIN vs UNION Differences Explained Easily php 6