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 **/
}
?>
...
<!-- 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?!