[es] - fetch_row - selectovanje pojedinacnih polja

djamsi
Dejan Kircanov
Data Centar
HostNet Limited Corp.
Chicago

Član broj: 11896
Poruke: 172
..tspeed.crlkil.sbcglobal.net.

Sajt: www.hostnetcorp.com

+1 Profil

fetch_row - selectovanje pojedinacnih polja

^{12.10.2015. u 07:08 - pre 103 meseci}

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
  // 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 **/


    if ($num_results <=0) {
?>

...

...


<?php
} elseif ($num_results ==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?!

Odgovor na temu

djamsi
Dejan Kircanov
Data Centar
HostNet Limited Corp.
Chicago

Član broj: 11896
Poruke: 172
..tspeed.crlkil.sbcglobal.net.

Sajt: www.hostnetcorp.com

+1 Profil

Re: fetch_row - selectovanje pojedinacnih polja

^{12.10.2015. u 09:00 - pre 103 meseci}

OK resio sam problem. Hvala svima koji su dosli i procitali kod...

...

<?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;


if ($num_results <=0) {
?>

...

...


<?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());
{

?>

...

<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();
?>

Odgovor na temu