PHP - Search Page Coding Help

I need to disable a query on the products page. The URL is www.myjabberbox.com
If you goto the products page, you'll see when you hover over one of the three products, you can
click it to take you to another page of that product. I want to disable that. I thought the code that
I'd need to modify would be under the products-page.php file but I can't seem to find the code.
Notice also when you hover over the products, a mouseover color of black happens around the image/text
frame, I'd like to keep that, just disable the linking...

Thanks

Hey there is no error with this code it works just fine but I would love to know if there is unnecessary coding in it  for example do i have to do the global variables? is there a better way to do mysql editing page?

thanks

<?php
include "../configdb.php";

$id = $_GET['id'];
if(isset($_POST['submit']))
{
    //global variables
$name = $_POST['name'];
$footer = $_POST['footer'];


//run the query which adds the data gathered from the form into the database    
$result = mysql_query("UPDATE pages SET name='$name', footer='$footer' WHERE id='$id' ",$connect);
echo "<b>Your Page have been edited successfully";
}
elseif($id)
{
$result = mysql_query("SELECT * FROM pages WHERE id='$id' ",$connect);
        while($row = mysql_fetch_assoc($result))
{
$name = $row['name'];
$footer = $row['footer']; ?>

<h3>::Edit Page</h3>
<form method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>?id=<?php echo $row['id']?>">
<input type="hidden" name="id" value="<?php echo $row['id']?>">
<input name="name" size="40" maxlength="255" value="<?php echo $name; ?>">
<input name="footer" size="40" maxlength="255" value="<?php echo $footer; ?>">
<input type="submit" name="submit" value="Submit">       

     
      <?php
}
}

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=343748.0

I have code for a perv. and next links at the bottom of my search page. Which shows the next ten results however when the next link is clicked the page says please fill in all fields (as if the search box was left empty and the search button was clicked... please help me figure this out...


Code: [Select]
<?php


  // Get the search variable from URL

  $var = $_GET['search'];
  $searchtype = $_GET['searchtype'];
  $isbn = "ISBN";
  $school = "School";
  $title = "Title";
  $subject = "Subject";
 
  $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
$connect = mysql_connect("db","user","pass") or die("Not connected");

//specify database 
mysql_select_db("user") or die("could not log in");

if ($searchtype == ($title))

{

// Build SQL Query  
$query = "select * from boox where name like \"%$trimmed%\"  
   order by name"; // EDIT HERE and specify your table and field names for the SQL query
}
elseif ($searchtype == ($school))
{
// Build SQL Query  
$query = "select * from boox where school like \"%$trimmed%\"  
   order by school"; // EDIT HERE and specify your table and field names for the SQL query

}
elseif ($searchtype == ($isbn))

{
// Build SQL Query  
$query = "select * from boox where isbn like \"%$trimmed%\"  
   order by isbn"; // EDIT HERE and specify your table and field names for the SQL query


}
elseif ($searchtype == ($subject))

{
// Build SQL Query  
$query = "select * from boox where subject like \"%$trimmed%\"  
   order by subject"; // 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: &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>";
  }

// 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; in &quot;" . $searchtype ."&quot; </p>";

// begin to show results set
echo "Results&nbsp;&nbsp;";
$count = 1 + $s ;

if ($searchtype = $title)

{
// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {
  $title = $row["name"];
  
  
   echo "$count.&nbsp;$title&nbsp;&nbsp
 </br><table width='297' border='1' align='center'>
  <tr>
    <td width='152'>Book Title:</td>
    <td width='129'>$row[name]</td>
  </tr>
  <tr>
    <td>Author:</td>
    <td>$row[author]</td>
  </tr>
    <tr>
    <td>ISBN#</td>
    <td>$row[isbn]</td>
  </tr>
  <tr>
    <td>Date Posted:</td>
    <td>$row[date]</td>
  </tr>
  <tr>
    <td>Posted By:</td>
    <td><a href='backpack.php?usr=$row[username]'>$row[username]</a></td>
  </tr>
  <tr>
    <td>School:</td>
    <td>$row[school]</td>
  </tr>
</table></br>";
   $count++ ;
   }
}
elseif ($searchtype = $school)
{
// now you can display the results returned
while ($row= mysql_fetch_array($result)) {
  $title = $row["school"];
   echo "$count.&nbsp;$title" ;
   $count++ ;
   }
 
}
elseif ($searchtype = $subject)
{
// now you can display the results returned
while ($row= mysql_fetch_array($result)) {
  $title = $row["subject"];
 echo "$count.&nbsp;$title" ;
   $count++ ;
   }

}
elseif ($searchtype = $isbn)
{
// now you can display the results returned
while ($row= mysql_fetch_array($result)) {
  $title = $row["isbn"];
   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\">&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&search?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>";
  
?>

hello, was wondering if there is a way to have a search box that searches all data on the current page.  similar to what a ctrl+F would do in internet exoplorer

Hi all.

I am in need of some help with a simple page search function.

In short what i need is a way the user can search for a specific page name from the home index page.

My site (local for now) will be constructed as follows:

localhost/mysite/index.html

0001.html

0002.html

...

0132.html

etc...

The subpages will be added/modified externaly and may run into the hundreds of pages.

For this reason mySQL will be hard to implement and somewhat overkill especialy for this simple search function.

So, is there a way i can type the page to look for "0132" into the field and be forwarded onto the searched page "0132.html"

I realise i could just type mysite/0132.html but the page may or may not exist and searching would be tiny bit more elegant.

Simple for you guys i expect but im at a loss as all search functions use mySQL in addition.

Many thanks for your help in advance!

Regards, Matt.

 

How can I write a 404 file to redirected any 'not found' page with structure of example.com/something/more/final.html to example.com/search?q=something+more+final 

Thanks 

Hi,

I have a website which displays products on product display pages and static pages such as 'contact us'.  I am now looking to add a search function which directs to the display page so the products are neatly presented.  However, all the tutorials I can find are based on displaying the echo on same page as the search and directing the search to another page.

Does anyone know how to do this?

i have a html page which is derived from an excel spreedsheet.

is it possable to use php to search the page and pull a row of data from it and store them as $vars ? sort of treat it as a database.

if so can you point me in the right direction. i tryed google with no luck.

cheers

Hello. I am having a hard time building my own search results page for my mysql database. Basically I am trying to search for game categories from the fldCategory field in the table, and display 15 results at a time in an HTML table with the Image of the games (fldIconMedium), and the titles of the games (fldTitle) placed in to the table. Also, at the bottom of the table would have a number bar that you can click on numbers to go to the next set of search results in the same page. The number bar would have Previous and Next button.

For the code I am using, I had help from another expert. I thank him, but here is the code I have so far.

===========================
===========================
<?php
$cat=1;
$nor=15;
$a=1;
if(isset($_GET['cat']))
{
}
else
{
$_GET['cat']=1;
}
echo $_GET['cat'];
$con=mysql_connect("host","nusername","password")
or die ("error");
$db=mysql_select_db("database",$con)
or die("Database not found!");
$result=mysql_query("SELECT * FROM games")
or die ("query error");
echo "<table border='1'><tr><th>ImageIcon</th><th>Title</th></tr>";
$r=mysql_num_rows($result);
echo $r."<br/>";
$p=ceil($r/$nor);
//echo $p;
while($rows=mysql_fetch_array($result))
{
if($a>($_GET['cat']-1)*$nor)
{
echo "<tr><td>".$rows['fldIconMedium']."</td><td>".$rows['fldTitle']."</td></tr>";
}
$a=$a+1;
}
echo "</table>";
for($i=1;$i<=$p;$i++)
{
if($i==$_GET['cat'])
{
echo $i;
}
else
{
echo "<a href='gameslist.php?cat=".$i."'>".$i."</a>";
}
}

?>

===========================
===========================

To see this code in action, heres the link http://netroxy.com/gameslist.php?cat=skills. > Not working well.

I am expecting the games search results page to look like this: http://netroxy.com/51274581336/search.htm

So basically its:

- viewing how many games found for game category, ex: Skills. Or Action, Mind, etc..

- the URL containing 'gameslist.php?cat=' with the given ID category at the end should search for that given category and display at least 15 games per results, along the number bar bellow, which counts how many are found from that category, which automatically increases or decreases the number bar bellow depending how many games from that specific category was found. I also forgot to mention that I did not add the Previous and Next button, which i dont know how   

- As for the 15 results per page, its basically 15 images (fldIconMedium) of different games of the same category, with their Titles (fldTitle) underneath them and both image and title should have the LINK to that specific game by retrieving the links from the 'fldLink' column where all the links of the games are found.

Thanks all!

The php web video script that I'm using displays user/member account pages in google searches.

For example, the url displaying the page is the https://webvideosite.com/@chrisj

I'm looking for guidance/suggestions on how to have the user/member account pages not appear in searches, either by blocking that somehow,

or only having access to it if you are logged into the site.

I look forward to any replies

http://2eastvalleyhomes.expandyourwebpresence.com/
In this site on the right widget the search option opens a new page and directs you off the page. I have created a page not visible on the home page called MLS and I would like the search on the right side to have its information populate in a page I created in my wordpress site, does any one have any suggestions or any ideas for this thank you for any help.

Sorry if this should be in the HTML forum but as it is relating to something I am trying to do with php I thought this was the right place!

I am creating a search page and one of the columns has only two potential values, 'H' for Home Games and 'A' for Away Games. Using radio buttons I can get the search page to filter correctly but there will also be times, once there are a few more search options on there, when a search would want to show All Games.
The current form I have is
Code: [Select]
<form id="form1" name="form1" method="post" action="fixrestestsearch.php">
    <p>
      <label for="OPP">OPP</label>
      <input type="text" name="OPP" id="OPP" />
      <br />
           <label>
        <input type="radio" name="HA" value="H" id="HA_0" />
        Home</label>
      <br />
      <label>
        <input type="radio" name="HA" value="A" id="HA_1" />
        Away</label>
      <br />
      <label>
        <input type="radio" name="HA" value="" id="HA_2" />
        All</label>
      <br />
      <br />
      SUB
<input type="submit" name="SUB" id="SUB" value="Submit" />
    </p>
</form>
and the query in the results page contains
Code: [Select]
WHERE team_name='$OPP' AND h_a='$HA'
If either the 'Home' or 'Away' buttons are checked everything works fine. If I check the 'All' button nothing is returned as it is looking for blank cells. I have also tried using 'value="*"' but that did not work.

Is there anything that I can put as the value of a radio button that would select all records or would it have to be something amended in the query on the results page?

Thanks in advance
Steve

Hello

I have this code that searches multiple tables. running this query in the phpmyadmin page works fine and gives correct results.
I echo-ed the $kw and noticed that it is lost (empty) when I click on Next (when moving to the second page or so..)
How do I save the $kw for all search results?

Thank you so much


$kw = trim($_POST['keyword']);
$kw = mysql_real_escape_string($kw);

//Nomber of rows to display per page
$page_rows=20;

//This checks to see if there is a page number. If not, it will set it to page 1 
 if (!(isset($pagenum)))
 {
 $pagenum = 1;
 }

echo "$kw of $pagenum";

//Count we count the number of results
$data = mysql_query("
SELECT `id`,`title`, `body`, 'condoms_en' as REF FROM `condoms_en` where `title` like '%$kw%' OR `body` like '%$kw%'
UNION
SELECT `id`,`title`, `body`, 'discr_en' as REF FROM `discr_en` where `title` like '%$kw%' OR `body` like '%$kw%'
UNION
SELECT `id`,`title`, `body`, 'diseases_en' as REF FROM `diseases_en` where `title` like '%$kw%' OR `body` like '%$kw%'
UNION
SELECT `id`,`title`, `body`, 'express_en' as REF FROM `express_en` where `title` like '%$kw%' OR `body` like '%$kw%' ") or die(mysql_error());
$rows = mysql_num_rows($data);

if ($rows ==1 || $rows > 1)
{
//echo "Number of rows $rows <br/>";

//This tells us the page number of our last page 
$last = ceil($rows/$page_rows);

//this makes sure the page number isn't below one, or more than our maximum pages
if ($pagenum < 1) 
 { 
 $pagenum = 1; 
 } 
 elseif ($pagenum > $last) 
 { 
 $pagenum = $last; 
 } 

//echo "<h4>".$pagenum."-20 of ".$total."results</h4> <br />";
// This shows the user what page they are on, and the total number of pages
 echo " ===> Page $pagenum of $last <br/><br/>";

//This sets the range to display in our query 
$max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows;

//This is your query again, the same one... the only difference is we add $max into it
$data_p = mysql_query("
SELECT `id`,`title`, `body`, 'condoms_en' as REF FROM `condoms_en` where `title` like '%$kw%' OR `body` like '%$kw%'
UNION
SELECT `id`,`title`, `body`, 'discr_en' as REF FROM `discr_en` where `title` like '%$kw%' OR `body` like '%$kw%'
UNION
SELECT `id`,`title`, `body`, 'diseases_en' as REF FROM `diseases_en` where `title` like '%$kw%' OR `body` like '%$kw%'
UNION
SELECT `id`,`title`, `body`, 'express_en' as REF FROM `express_en` where `title` like '%$kw%' OR `body` like '%$kw%' $max") or die(mysql_error());

//This is where you display your query results
 while($info = mysql_fetch_array( $data_p ))
 {
 
 print $info['title']; //print $info['REF'];
 echo "<br>";
 }
 echo "<p><br/>";

 // First we check if we are on page one. If we are then we don't need a link to the previous page 
 //or the first page so we do nothing. If we aren't then we generate links to the first page, and to the previous page.

 if ($pagenum == 1) 
 {
 } 
 else 
 {
 echo " <a style=\"color: #FF0000\" href='{$_SERVER['PHP_SELF']}?pagenum=1'> <<-First</a> ";
 echo " ";
 $previous = $pagenum-1;
 echo " <a style=\"color: #FF0000\" href='{$_SERVER['PHP_SELF']}?pagenum=$previous'> <-Previous</a> ";
 }
 //just a spacer
 echo " ---- ";

 //This does the same as above, only checking if we are on the last page, and then generating the Next and Last links
 if ($pagenum == $last) 
 {
 } 
 else {
 $next = $pagenum+1;
 echo " <a style=\"color: #FF0000\" href='{$_SERVER['PHP_SELF']}?pagenum=$next'>Next -></a> ";
 echo " ";
 echo " <a style=\"color: #FF0000\" href='{$_SERVER['PHP_SELF']}?pagenum=$last'>Last ->></a> ";
 } 


} //results was found
else
{
echo "No results FOUND";
}

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=346243.0