Page 1 of 1

problem with php_self in search.php for next page

Posted: Wed May 06, 2009 7:02 am
by lukilukg4
hi guys...

I am searching inserts from mysql database, and i am using 2 files, one is .html and the other is .php
I want to display 10 results per page.
the first 10 results are ok but when i try to see the next 10 results i saw again the same first 10

can u help me with this

the html code is: main.html

Code: Select all

<form name="form" action="search.php" method="get">
  <input type="text" name="q" />
  <input type="submit" name="Submit" value="Search" />
</form>
i think that the problem is in line 104

Code: Select all

echo "&nbsp;<a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 >></a>";
in php code

this means that during refreshing the php do not get the variables from html

All php code is in search.php which is:

Code: Select all

<?php
 
  // Get the search variable from URL
 
  $var = @$_GET['q'] ;
  $trimmed = trim($var); //trim whitespace from the stored variable
 
// rows to return
$limit=10;
 
// check for an empty string and display a message.
if ($trimmed == "")
  {
  echo "<p>Please enter a search...</p>";
  exit;
  }
 
// check for a search parameter
if (!isset($var))
  {
  echo "<p>We dont seem to have a search parameter!</p>";
  exit;
  }
 
//connect to your database ** EDIT REQUIRED HERE **
mysql_connect("localhost","username","password"); //(host, username, password)
 
//specify database ** EDIT REQUIRED HERE **
mysql_select_db("database") or die("Unable to select database"); //select which database we're using
 
// Build SQL Query 
$query = "select * from the_table where 1st_field like \"%$trimmed%\" 
  order by 1st_field"; // EDIT HERE and specify your table and field names for the SQL query
 
 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);
 
// If we have no results, offer a google search as an alternative
 
if ($numrows == 0)
  {
  echo "<h4>Results</h4>";
  echo "<p>Sorry, your search: "" . $trimmed . "" returned zero results</p>";
 
// google
 echo "<p><a href=\"http://www.google.com/search?q="
  . $trimmed . "\" target=\"_blank\" title=\"Look up
  " . $trimmed . " on Google\">Click here</a> to try the
  search on google</p>";
  }
 
// next determine if s has been passed to script, if not use 0
  if (empty($s)) {
  $s=0;
  }
 
// get results
  $query .= " limit $s,$limit";
  $result = mysql_query($query) or die("Couldn't execute query");
 
// display what the person searched for
echo "<p>You searched for: "" . $var . ""</p>";
 
// begin to show results set
echo "Results";
$count = 1 + $s ;
 
// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {
  $title = $row["1st_field"];
 
  echo "$count.)&nbsp;$title" ;
  $count++ ;
  }
 
$currPage = (($s/$limit) + 1);
 
//break before paging
  echo "<br />";
 
  // next we need to do the links to other results
  if ($s>=1) { // bypass PREV link if s is 0
  $prevs=($s-$limit);
  print "&nbsp;<a href=\"$PHP_SELF?s=$prevs&q=$var\"><<
  Prev 10</a>&nbsp&nbsp;";
  }
 
// calculate number of pages needing links
  $pages=intval($numrows/$limit);
 
// $pages now contains int of pages needed unless there is a remainder from division
 
  if ($numrows%$limit) {
  // has remainder so add one page
  $pages++;
  }
 
// check to see if last page
  if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {
 
  // not last page so give NEXT link
  $news=$s+$limit;
 
  [b]echo "&nbsp;<a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 >></a>"; [/b]}
 
$a = $s + ($limit) ;
  if ($a > $numrows) { $a = $numrows ; }
  $b = $s + 1 ;
  echo "<p>Showing results $b to $a of $numrows</p>";
 
Cau u help me with this... thnx alot

Re: problem with php_self in search.php for next page

Posted: Wed May 06, 2009 7:59 am
by Bill H
Try

Code: Select all

echo "&nbsp;<a href=\"$_SERVER['PHP_SELF']?s=$news&q=$var\">Next 10 >></a>";
see if that helps

Re: problem with php_self in search.php for next page

Posted: Wed May 06, 2009 8:47 am
by lukilukg4
Bill H wrote:Try

Code: Select all

echo "&nbsp;<a href=\"$_SERVER['PHP_SELF']?s=$news&q=$var\">Next 10 >></a>";
see if that helps

This didnt work and aslo didnt work this

Code: Select all

echo "&nbsp;<a href=\"".$_SERVER['PHP_SELF']."?s=$news&q=$var\">Next 10 >></a>";
but tnx for your reply :wink:

Re: problem with php_self in search.php for next page

Posted: Wed May 06, 2009 8:51 am
by Defiline

Code: Select all

<?php
 
    echo getenv('SCRIPT_NAME');
 
?>
SCRIPT_NAME - is a system constant, not your filename :)

Re: problem with php_self in search.php for next page

Posted: Wed May 06, 2009 9:45 am
by lukilukg4
Defiline wrote:

Code: Select all

<?php
 
    echo getenv('SCRIPT_NAME');
 
?>
SCRIPT_NAME - is a system constant, not your filename :)

:?: :roll: :?:

i dont understand ....
can u explain me again plz

Re: problem with php_self in search.php for next page

Posted: Wed May 06, 2009 9:48 am
by Defiline
Just run this code :)
getenv('SCRIPT_NAME') = $_SERVER['PHP_SELF'] :)

At a pinch you may use $_SERVER['REQUEST_URI'].
The worst variant.

Re: problem with php_self in search.php for next page

Posted: Wed May 06, 2009 10:15 am
by lukilukg4
with $_SERVER['REQUEST_URI'] it works but I still have problems with the results...

it keeps this time the variables from .html but after first 10 results when i click next>> i see again the first 10.

So there is another mistake in php code, i think...

i think that

Code: Select all

$s
cant change the second time... $s value the second time is still 10 and it has to be 20.

can u help me to solve it....

tnx

Re: problem with php_self in search.php for next page

Posted: Wed May 06, 2009 4:14 pm
by lukilukg4
McInfo many thnxs

it works... tnx alot man... :wink: :wink: :wink: :drunk: