PHP Search true karakterima
04.07.2015. u 20:23 · pre 137 meseci
#1
ovako php search radi ali ne znam kako da ga podesim da cita full string. Objasnicu malo detalnije. Ukoliko u search box-u unesem 11 na results.php izbacuje mi sve gde nadze 11, a treba mi za 8 karaktere. Sad ne zmam kako da obradim da kad ukucam 11 da mi da povratnu informaciju da takav artikl ne postoi. A kad ukucam 11111111 onda da mi izbaci podatak sa databazu.
I jos nesto zelim da znam kako da stavim ADD link kada je $i=0;.
Cod koi imam ide ovako:
I jos nesto zelim da znam kako da stavim ADD link kada je $i=0;.
Cod koi imam ide ovako:
Code:
<?php
$searchtype=$_POST['searchtype'];
$searchterm=trim($_POST['searchterm']);
if (!$searchtype || !$searchterm) {
echo 'You have not entered search details. Please go back and try again.';
exit;
}
if (!get_magic_quotes_gpc()){
$searchtype = addslashes($searchtype);
$searchterm = addslashes($searchterm);
}
@ $db = new mysqli('host', 'user', 'pass', 'db');
if (mysqli_connect_errno()) {
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
$query = "select * from polje where ".$searchtype." like '%".$searchterm."%'";
$result = $db->query($query);
$num_results = $result->num_rows;
echo "<p>Number of polje found: ".$num_results."</p>";
for ($i=0; $i <$num_results; $i++) {
$row = $result->fetch_assoc();
echo "<p><strong>".($i+1).". Ime1: ";
echo htmlspecialchars(stripslashes($row['ime1']));
echo "</strong><br />Broj1: ";
echo stripslashes($row['broj1']);
echo "<br />Broj2: ";
echo stripslashes($row['broj2']);
echo "<br />Broj3: ";
echo stripslashes($row['broj3']);
echo "</p>";
}
$result->free();
$db->close();
?>
<?php
$searchtype=$_POST['searchtype'];
$searchterm=trim($_POST['searchterm']);
if (!$searchtype || !$searchterm) {
echo 'You have not entered search details. Please go back and try again.';
exit;
}
if (!get_magic_quotes_gpc()){
$searchtype = addslashes($searchtype);
$searchterm = addslashes($searchterm);
}
@ $db = new mysqli('host', 'user', 'pass', 'db');
if (mysqli_connect_errno()) {
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
$query = "select * from polje where ".$searchtype." like '%".$searchterm."%'";
$result = $db->query($query);
$num_results = $result->num_rows;
echo "<p>Number of polje found: ".$num_results."</p>";
for ($i=0; $i <$num_results; $i++) {
$row = $result->fetch_assoc();
echo "<p><strong>".($i+1).". Ime1: ";
echo htmlspecialchars(stripslashes($row['ime1']));
echo "</strong><br />Broj1: ";
echo stripslashes($row['broj1']);
echo "<br />Broj2: ";
echo stripslashes($row['broj2']);
echo "<br />Broj3: ";
echo stripslashes($row['broj3']);
echo "</p>";
}
$result->free();
$db->close();
?>