[ djamsi @ 12.10.2015. 07:08 ] @
| ovako sam naslov sve kaze ne radi mi funcija jer imam search engine u index.php pa zatim ide na results.php evo coda:
Code:
...
<!-- PHP Search from POST -->
<?php
// create short variable names
$searchtype=$_POST['searchtype'];
$searchterm=trim($_POST['searchterm']);
if (!$searchtype || !$searchterm) {
echo "<center>You have not entered search details. Please go <a href=\"javascript:history.go(-1)\"> back</a> and try again.</center>";
exit;
}
if (!get_magic_quotes_gpc()){
$searchtype = addslashes($searchtype);
$searchterm = addslashes($searchterm);
}
@ $db = new mysqli('host', 'user', 'pass', 'mydb');
if (mysqli_connect_errno()) {
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
$query = "select * from brokers where ".$searchtype." regexp '[[:<:]]".$searchterm."[[:>:]]' ";
$result = $db->query($query);
$num_results = $result->num_rows;
/** zelim da dodam ovo ali ne radi **/
while($row = $result->fetch_row());
{
/** /.zelim da dodam ovo ali ne radi **/
<!-- query if it is <=0 -->
if ($num_results <=0) {
?>
...
<!-- HTML elemente su ovde kad nije rezultat jednak na 1 -->
...
<!-- query if it is ==1 -->
<?php
} elseif ($num_results ==1) {
?>
...
<!-- HTML elemente su ovde kad je rezultat jednak na 1 -->
<h3 align="center">Search Results for <span class="green-label"><b><?php echo "".$searchtype.'# '.$searchterm."" ; ?></b></span> number found: <span class="green-label"><?php echo "".$num_results."" ; ?></span></h3>
<h5 align="center">
<b>
<?php echo "".$row['Ime'].""; ?> // ovo se ne ispisuje ( zelim preuzeti informacije koji su u istoj liniji sa .$searchterm.
...
<?php
/** ovde zatvaram PHP
/** end search **/
}
?>
<?php
/** end row **/
}
?>
sta nije uredu gde sam pogresio?! |
[ djamsi @ 12.10.2015. 09:00 ] @
OK resio sam problem. Hvala svima koji su dosli i procitali kod...
...
<!-- PHP Search from POST -->
<?php
// create short variable names
$searchtype=$_POST['searchtype'];
$searchterm=trim($_POST['searchterm']);
if (!$searchtype || !$searchterm) {
echo "<center>You have not entered search details. Please go <a href=\"javascript:history.go(-1)\"> back</a> and try again.</center>";
exit;
}
if (!get_magic_quotes_gpc()){
$searchtype = addslashes($searchtype);
$searchterm = addslashes($searchterm);
}
@ $db = new mysqli('host', 'user', 'pass', 'mydb');
if (mysqli_connect_errno()) {
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
$query = "select * from brokers where ".$searchtype." regexp '[[:<:]]".$searchterm."[[:>:]]' ";
$result = $db->query($query);
$num_results = $result->num_rows;
<!-- query if it is <=0 -->
if ($num_results <=0) {
?>
...
<!-- HTML elemente su ovde kad nije rezultat jednak na 1 -->
...
<!-- query if it is ==1 -->
<?php
} elseif ($num_results ==1) {
$query = "select * from brokers where ".$searchtype." regexp '[[:<:]]".$searchterm."[[:>:]]' ";
$result = $db->query($query);
$num_results = $result->num_rows;
while($row = $result->fetch_row());
{
?>
...
<!-- HTML elemente su ovde kad je rezultat jednak na 1 -->
<h3 align="center">Search Results for <span class="green-label"><b><?php echo "".$searchtype.'# '.$searchterm."" ; ?></b></span> number found: <span class="green-label"><?php echo "".$num_results."" ; ?></span></h3>
<h5 align="center">
<b>
<?php echo "".$row['Ime'].""; ?> // ovo se ne ispisuje ( zelim preuzeti informacije koji su u istoj liniji sa .$searchterm.
...
<?php
/** end search **/
}
?>
<?php
/** end row **/
}
$result->free();
$db->close();
?>
Copyright (C) 2001-2025 by www.elitesecurity.org. All rights reserved.