Jinsi ya Kutengeneza PHP Search with Partial Matches

Kutengeneza mfumo wa utafutaji kwenye PHP unaoruhusu partial matches (yaani kutafuta maneno yenye sehemu ya match) ni muhimu kwa mifumo mingi kama blog, inventory, au database management. Hapa tutatumia MySQL LIKE query kuonyesha jinsi ya kufanya partial search kwa ufanisi.

Code Sample:

<?php
// Muunganiko na database
$conn = new mysqli("localhost", "username", "password", "database");
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

// Angalia kama user amesubmit search
$searchTerm = isset($_POST['search']) ? $_POST['search'] : '';

// Tayarisha query kwa partial match
$sql = "SELECT * FROM products WHERE name LIKE ?";
$stmt = $conn->prepare($sql);
$likeTerm = "%$searchTerm%";
$stmt->bind_param("s", $likeTerm);
$stmt->execute();
$result = $stmt->get_result();

// Onyesha matokeo
if($result->num_rows > 0){
while($row = $result->fetch_assoc()){
echo "<p>".$row['name']." - ".$row['price']."</p>";
}
} else {
echo "Hakuna matokeo";
}
?>

HTML Form:

<form method="post" action="">
<input type="text" name="search" placeholder="Tafuta bidhaa...">
<button type="submit">Tafuta</button>
</form>

Ufafanuzi:

%$searchTerm% inaruhusu partial matching, inamaanisha matokeo yoyote yenye searchTerm ndani yake yataonyeshwa.

Tumia prepare na bind_param ili kuepuka SQL Injection.

Unaweza kurekebisha kwa column nyingine au kuongeza filtering zaidi kwa database yako.

🔗 Links Za Kujifunza Zaidi:

🌐 Faulink Official Website:
https://www.faulink.com/

📘 Jifunze Web Design & Programming (Tutorials / Mifumo):
https://www.faulink.com/excel_mifumo.php

📲 Piga / WhatsApp kwa msaada wa haraka:
https://wa.me/255693118509