Jump to content

Archived

This topic is now archived and is closed to further replies.

ger_mac74

Nothing appearing on page after php script

Recommended Posts

Hi all
I am running a php search script within a html webpage. The top part of the web page appears ok when viewed, as does the script part ..but the part of html code after the script is not appearing on page until the script is called. The script is calling itself..i think this may be where the problem is coming from?? I would like to keep the script in the same file.
Any ides whats happenin?

Share this post


Link to post
Share on other sites
Hi
Here is the form part of html and the php script that follows after it. The html file is called search1.php which is also what the action is calling. Also having prob displaying results. First 10 results are being displayed fine but the next 10>> link is not working..same page being return. Thanks for coming back to me. Cheers

[code]<p>


<br></br>
<form name="form" action="search1.php" method="get">
  <input type="text" name="q" />
  <input type="submit" name="Submit" value="Search" />
</form>




<?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 database
mysql_connect("","","");



//specify database   ****
mysql_select_db("") or die("Unable to select database");




// Build SQL Query
$query = "SELECT * FROM articles1 WHERE (description LIKE '%$trimmed%' ) OR (articlename LIKE '%$trimmed%' ) ORDER BY description";


$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 "Results";
  echo "<p>Sorry, your search: &quot;" . $trimmed . "&quot; 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>";
  }



else{
// 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: &quot;" . $var . "&quot;</p>";




// begin to show results set
echo "Results: <br>";

$count = 1 + $s;




// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {
           $title = $row["articlename"];
           $arturl  = $row["articleurl"];
           echo "$count.) <a href='$arturl'>$title</a><br>";
           $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\">&lt;&lt;
  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;

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

$a = $s + ($limit);
  if ($a > $numrows) { $a = $numrows; }
  $b = $s + 1;
  echo "<p>Showing results $b to $a of $numrows</p>";

}


?>[/code][s]

Share this post


Link to post
Share on other sites
I'm going to assume that you deleted the connection info, otherwise that's going to be your biggest problem.

Are you getting any errors? What exactly is happening? Have you tried to echo various parts of the script to see if things are coming out how you expect?

Share this post


Link to post
Share on other sites
yes desleted connect details for security reasons. Have tried echoing parts and everything seems fine. i am newish to php. The script is running fine except that when the page loads up first the html stuff below the php file is not appearing on the website. but when the search is done the search finds the articles and the html stuff after php script appears fine then. As for the second part for problem it is saying that 25 reults are found but the link to next 10>> is only displaying the same page with first 10 results. i found the script online.
cheers

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.