PHP - Help With Finding Results From A Search

I am trying to write a script that will allow me visitors to my site to search my database for items. I followed a tutorial that I had found and tweaked it to fit my needs. I am not getting any results it keeps telling that there was no search results found. Even though I have the items that I have been testing on in my database.

I have two files the main search.php file and the search_func.php file

Here is the search.php file
Code: [Select]
<form method='post' action='search.php'>
<fieldset>
<input type='text' name='search' id='search' value='type name here'/>
<input type='submit' name='search_submit' id='search_submit' value='search'/>
</fieldset>
</form>

<?php

include('includes/search_func.php');

if(isset($_POST['search'])) {
$keywords = mysql_real_escape_string(htmlentities(trim($_POST['search'])));

$errors = array ();

if (empty($keywords )){
$errors[] = 'Please enter a search term';
} else if (strlen($keywords ) < 3 ) {
$errors[] = 'Search term must be more then three characters long';
} else if (search_results($keywords  == false)) {
$errors[] = 'Your search for ' .$keywords . ' showed no results';
}

if (empty($errors)) {
$results = search_results($keywords );
$results_num = count($results);
$suffix = ($results_num != 1) ? 's' : '';
echo 'Your search for <strong>'. $keywords  .'</strong> returned <strong>' .$results_num.'</strong> result'.$suffix.'';

foreach($results as $result) {
echo $result['first'];
}

} else {
foreach($errors as $error){
echo $error;
}
}

}

?>
Here is the search_func.php file
Code: [Select]
<?php
include('includes/config.php');
connect();

function search_results($keywords ) {
$returned = array();
$where = "";

$keywords  = preg_split('/[\s+]/', $keywords );
$total = count($keywords );

foreach($keywords  as $key=>$keyword) {
$where .= "`l_name` LIKE '%$keyword%'";

if($key != ($total - 1)){
$where .= "OR";
}
}

$results  = "SELECT `l_name`,`f_name`,`image`,`item_return` FROM `ttmautos` WHERE $where";
$results_num = ($results = mysql_query($results)) ? mysql_num_rows($results): 0 ;

if ($results_num === 0) {
return false;
} else {
while($results_row = mysql_fetch_assoc($results)) {
$returned_results[] = array(
'last' => $results_row['l_name'],
'first' => $results_row['f_name'],
'image' => $results_row['image'],
'item' => $results_row['item_return']
);
}

return $returned_results;
}
}
?>

If anyone could give me an idea of what I am doing wrong I would appreciate it.

I have a page that I am using to search a database. Basically what I want to do is allow the end user to sort by column headings after the search results are returned. The sort code that I am using works fine on a "lesser complicated" page that does not involve $_GET variables. I am not sure however if I adapted it properly. Also, I am having problems adding the new $_GET variables to the URL string when the user chooses to sort the returned search results. Thank you in advance for any suggestions. My code is below:

Code: [Select]
<?php 
//////////////////// INITIATE SESSION ////////////////////
if (!isset($_SESSION)) {
session_start();
}
//////////////////// ALLOW ACCESS ONLY TO ADMINISTRATORS ////////////////////
if ($_SESSION['person_priveleges'] == 0) {
header("location:index.php");
}
//////////////////// CONNECT AND SELECT DATABASE ////////////////////
require_once('connect.php');
mysql_select_db($database, $connect);
//////////////////// GET STATES ////////////////////
$state = mysql_query("SELECT state_abbreviation FROM state ORDER BY state_abbreviation ASC", $connect);
$data_state = mysql_fetch_assoc($state);
$rows_state = mysql_num_rows($state);




//////////////////// GET USER SEARCH RESULTS ////////////////////
if (array_key_exists('search', $_GET)) {
$error = array();
if ((empty($_GET['last_name_search'])) && (empty($_GET['organization_search'])) && (empty($_GET['state_search'])) && (empty($_GET['payment_status']))) {
$error['search'] = "Please enter at least one search parameter.";
} else {
$search = "SELECT * FROM person";
$where = false;
if (isset($_GET['last_name_search']) && !empty($_GET['last_name_search'])) {
$last_name_search = $_GET['last_name_search'];
$search .= " WHERE person_last_name LIKE '%$last_name_search%'";
$where = true;
} 
if (isset($_GET['organization_search']) && !empty($_GET['organization_search'])) {
$organization_search = $_GET['organization_search'];
if ($where) {
$search .= ' AND ';
   } else {
$search .= ' WHERE ';
$where = true;
   }
$search .= " person_organization LIKE '%$organization_search%'";
}
if (isset($_GET['state_search']) && !empty($_GET['state_search'])) {
$state_search = $_GET['state_search'];
if ($where) {
$search .= ' AND ';
   } else {
$search .= ' WHERE ';
$where = true;
   }
$search .= " person_state LIKE '%$state_search%'";
}
if (isset($_GET['payment_status']) && !empty($_GET['payment_status'])) {
$payment_search = $_GET['payment_status'];
if ($where) {
$search .= ' AND ';
   } else {
$search .= ' WHERE ';
$where = true;
   }
$search .= " person_paid LIKE '%$payment_search%'";
}

if (isset($_GET['sort'])) {
$sort = mysql_real_escape_string($_GET['sort']);
if (strcasecmp($sort, "DESC") == 0) {
$new_sort = "ASC";
} else {
$new_sort = "DESC";
}
} else {
$sort = "ASC";
$new_sort = "DESC";
}
if (isset($_GET['order'])) {
$order = mysql_real_escape_string($_GET['order']);
$search .= " AND person_priveleges = 0 ORDER BY $order";

if (strcasecmp($sort, "DESC") == 0) {
$search .= " DESC";
} else {
$search .= " ASC";
}
} else {
$search .= " AND person_priveleges = 0 ORDER BY person_last_name";
$query_search = mysql_query($search, $connect) or die(mysql_error());
$result_search = mysql_fetch_assoc($query_search);
$number_search = mysql_num_rows($query_search);
$count = 0;
}
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>2011 IDUES Project Directors Meeting</title>
<link href="layout.css" rel="stylesheet" type="text/css" />
</head>

<body class="twoColFixLtHdr">
<br />

<!--container starts here-->
<div id="container">

<?php include('header.php'); ?>

<?php include('menu_admin.php'); ?>

<?php include('sidebar_admin.php'); ?>

<!--main content starts here-->
<div id="mainContent">
<h2 class="page_title">REGISTRANT SEARCH</h2>

<div align="center"><?php if (isset($error)) {
echo '<div align="center"><span class="contact_us_error">';
foreach ($error as $alert) {
echo "$alert<br />\n";
}
echo '</div></span>';
} ?></div>

<form id="search" name="search" method="get" action="">
<table width="60%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td class="black_font"><label>Search by Last Name:</label></td>
<td class="black_font"><input type="text" name="last_name_search" id="last_name_search" /></td>
</tr>
<tr>
<td class="black_font"><label>Search by Organization:</label></td>
<td class="black_font"><input type="text" name="organization_search" id="organization_search" /></td>
</tr>
<tr>
<td class="black_font"><label>Search by State:</label></td>
<td class="black_font"><select name="state_search" id="state_search">
    <option value="">Select State</option>
<?php do { ?>
<option value="<?php echo $data_state['state_abbreviation']?>"
<?php if (isset($_POST['state']) && $_POST['state'] == $data_state['state_abbreviation']) {
echo 'selected="selected"';
}
echo $data_state['state_abbreviation']; ?>><?php echo $data_state['state_abbreviation']?></option>
<?php } while ($data_state = mysql_fetch_assoc($state));
$rows = mysql_num_rows($state);
if ($rows > 0) {
mysql_data_seek($state, 0);
$data_state = mysql_fetch_assoc($state);
} ?>
</select></td>
</tr>
<tr>
  <td valign="top" class="black_font">Search by Payment Status:</td>
  <td class="black_font"><p>
    <label>
      <input type="radio" name="payment_status" value="Yes" id="payment_status_0" />
      Paid</label>
    <br />
    <label>
      <input type="radio" name="payment_status" value="Pending" id="payment_status_1" />
      Pending</label>
    <br />
    <label>
      <input type="radio" name="payment_status" value="No" id="payment_status_2" />
      Not Paid</label>
    <br />
  </p></td>
</tr>
</table>
<input type="submit" name="search" id="search" value="Search" />
</form>

<br />

<?php if (array_key_exists('search', $_GET) && !$error) { ?>

<?php if ($number_search == 0) 
{ ?>
<div align="center" class="contact_us_error">No results match your search</div>
<span class="black_font">
<?php } else { ?>

<strong>Total Search Results: <?php echo $number_search; ?></strong>

<br />

</span>

<table width="100%" border="0" align="center" cellpadding="5" cellspacing="0">
  <tr>
    <td bgcolor="#CCCCCC" class="black_font">&nbsp;</td>
    <td bgcolor="#CCCCCC" class="black_font"><strong><a href="<?php echo $_SERVER['PHP_SELF']."?".$_SERVER['QUERY_STRING']."?order=person_last_name&sort=$new_sort"; ?>">Name</a></strong></td>
    <td bgcolor="#CCCCCC" class="black_font"><strong><a href="<?php echo $_SERVER['PHP_SELF']."?order=person_organization&sort=$new_sort"; ?>">Organization</a></strong></td>
    <td bgcolor="#CCCCCC" class="black_font"><strong><a href="<?php echo $_SERVER['PHP_SELF']."?order=person_state&sort=$new_sort"; ?>">State</a></strong></td>
    <td align="left" bgcolor="#CCCCCC" class="black_font"><strong><?php if ((isset($_GET['payment_status'])) && ($_GET['payment_status'] == 'Yes')) { ?> <a href="<?php echo $_SERVER['PHP_SELF']."?order=person_payment_method&sort=$new_sort"; ?>">Payment</a></strong></td> <?php } else { echo "Paid</strong></td>"; } ?>
  </tr>
<tr>
<?php do { ?>
<?php $count++; ?>
<?php $person_id = $result_search['person_id']; ?>
<?php $first_name = $result_search['person_first_name']; ?>
<?php $last_name = $result_search['person_last_name']; ?>
<?php $organization = stripslashes($result_search['person_organization']); ?>
<?php $state = $result_search['person_state']; ?>
<?php $paid = $result_search['person_paid']; ?>
<?php $payment_method = $result_search['person_payment_method']; ?>
<td class="black_font"><?php echo $count; ?></td>
    <td class="black_font"><?php echo "<a href='registrant_info.php?id=$person_id'>$last_name, $first_name</a>"; ?></td>
    <td class="black_font"><?php echo stripslashes($organization); ?></td>
    <td class="black_font"><?php echo $state; ?></td>
    <td class="black_font"><?php if ($paid =='Yes') { echo $payment_method; } else { echo $paid; } ?></td>
</tr>
<?php } while ($result_search = mysql_fetch_assoc($query_search)); ?>
</table>

<span class="black_font">
<?php } ?>
<?php } ?>
</span><br />
<br />
<br />
<br />
<br />
<br />
</div>
<!--main content ends here-->

<!--clearing element should immediately follow #mainContent div to force the #container div to contain all child floats-->
<br class="clearfloat" />

<?php include('footer.php'); ?>

</div>
<!--container ends here-->

</body>
</html>

Hi guys,

A beginner at php/mysql here...

For a project I'm doing, I would like to display search results with an image, small description, then a 'read more' link.
After googling this issue, I can't find much information on it, which surprised me.  Someone did mention blobs for images... (whatever they are!)
I'm wondering if anyone knows of any tutorials, or has any code to do this?

Your help is much appreciated.

Thanks.

Hi, I have search form which works apart from 1 part, I have set the results limit to 10 per page with a next link if there are more than 10 results, however when the next link is clicked, i get the error 'you do not have a search parameter' which comes from this code:

Code: [Select]
if (!isset($var))
          {
          echo "<p>We dont seem to have a search parameter!</p>";
          exit;
          }
The next link is defined by the code below:

Code: [Select]
// 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>";
          }
Can anyone see where I have gone wrong with this code without me sending the whole search form? Any help would be very much appreciated. Thanks

hi,

I have a search page with a checkbox $departuk that returns the value "true" if checked.

I want to return search results if this returns true and the flag 'Y' is available

if ($departuk == "true"){

if ($data[$i]['departuk'] == 'Y'){

$result = $obj->result;

}

else{

echo "do some thing else";

}

else{

echo"there was a problem";

}


any pointers / advice is appreciated
thanks

Good Evening,
I've been in a trial and error state for the past week trying to figure out how I can put on the pre-made pagination scripts I found on the web, but of no luck. I have just started programming like two weeks ago, and is still trying to understand logics and stuffs so I can get my desired output. So far, everything is doing well except for one - I am really having a hard time to incorporate pagination scripts with my code. To rank myself as a php programmer, I can say I am lower than one, and seemingly, what I want to achieve is an advanced code. Can anyone help me on what pagination code I should try to play with and incorporate with my code?

Here's my code so far:

<?PHP
include("dbconnection.php"); //Include database connection to file

$query = "SELECT * FROM records";

if(isset($_POST["btnSearch"]))

{
$query .= " WHERE last_name LIKE '%".$_POST["search"]."%' OR first_name LIKE '%".$_POST["search"]."%'OR territory LIKE '%".$_POST["search"]."%'OR job_title LIKE '%".$_POST["search"]."%'OR title LIKE '%".$_POST["search"]."%'OR employer LIKE '%".$_POST["search"]."%' ORDER BY territory ASC LIMIT 0,15"  ;

$result = mysql_query($query, $connection) or die(mysql_error());
} 

?>

<!-- Start of table -->
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<td>
      <table width="760" border="0" cellpadding="0" cellspacing="0">
        
<!-- Table data containing the Asia Logo -->
            <td width="199" align="center" valign="top">
                <a href="login.html">
                 <img src="asia.gif" alt="" width="152" height="58" border="0" />
                </a>
            </td>
            <!-- Table data containing Home button -->
            <td width="176" align="right" valign="bottom">
                <a href="main.php">
                 <img src="Home.jpg" width="104" height="20" border="0"/>
                </a>
            </td>
            <!-- Table data containing View Client button -->
            <td width="130" align="right" valign="bottom">
                <img src="View.jpg" width="104" height="20" border="0"/>
            </td>
            <!-- Table data containing the Add Client button -->
            <td width="146" align="right" valign="bottom">
                <a href="add_client.php">
                 <img src="Add.jpg" width="104" height="20" border="0"/>
                </a>
            </td>
            <!-- Blank table data -->
            <td width="109" align="right" valign="bottom">&nbsp;
            
            </td>
        </table>

        <!-- Table design division and body-->
        <table width="760" border="0" cellpadding="0" cellspacing="0">
     <td width="200" height="3"  bgcolor="#1B1C78">
     <img src="images/topspacerblue.gif" alt="" width="1" height="3" /></td>
    <td width="560"  bgcolor="#0076CC">
     <img src="images/topspacerlblue.gif" alt="" width="1" height="3" /></td>
    <tr>
    <td height="500" colspan="2" align="center" valign="top"  bgcolor="#F3FAFE">
            <!-- Page contents -->
            <!-- Search Query -->
            <br>
            <form name="form" action="view_client.php" method="post">
            <table width="351" border="0">
<tr>
                    <td width="137" align="left" valign="middle">
                        SEARCH RECORD:
                    </td>
                    <td width="144" align="center" valign="middle">
                        <input type="text" name="search" />
                    </td>
                    <td width="56" align="left" valign="middle">
                        <input type="submit" name="btnSearch" value="Search" />
                    </td>
</tr>
</table>
            <br>
            <!-- End of search query-->
            <!-- Start of Search Results-->
            <table border="0" cellpadding="3" cellspacing="1" bordercolor="38619E" >
                <tr>
                    <th width="80" align="center" bgcolor="#E0E8F3">Territory</th>
                    <th width="330" align="center" bgcolor="#E0E8F3">Employer</th>
                    <th width="160" align="center" bgcolor="#E0E8F3">Name</th>
                    <th width="80" align="center" valign="middle" bgcolor="#E0E8F3">&nbsp;</th>
                </tr>
<?php
if($result)
{
for($i=0; $i<mysql_num_rows($result); $i++)
   {
$id = trim(mysql_result($result, $i, "id"));
$territory = trim(mysql_result($result, $i, "territory"));
$employer = trim(mysql_result($result, $i, "employer"));
$first_name = trim(mysql_result($result, $i, "first_name"));
$last_name = trim(mysql_result($result, $i, "last_name"));
  
echo "<tr>";
   echo "<td>".$territory."</td>";
   echo "<td>".$employer."</td>";
   echo "<td>".$last_name.", ".$first_name."</td>";
   echo "<td><a href='edit_client.php?id=".$id."'>edit</a> | <a href='delete_client.php?id=".$id."'>delete</a></td>";
   echo "</tr>";
}   
}  
?>

</table>
            </form>
            <!-- End of page -->
            </td>
          </tr>
        </table>
</td>
<tr>
     <td height="38">
         <table width="760" border="0" cellpadding="0" cellspacing="0">      
         <td width="200" height="35" align="center"  bgcolor="#1B1C78" class=white>
         <a href="disclaimer.html">
             <font color="#FFFFFF">Legal Disclaimer</font>
             </a>
         </td>
         <td width="560" align="center"  bgcolor="#0076CC">
         Copyright &copy; 2006 - 2010 Asia. All rights reserved.
         </td>
</table></td>
</tr>
</table>

Thank you very much, and I am looking forward for your responses. Thanks!

I'm new to php and been trying to follow along with different tutorials to try and build my own site, i followed a tutorial on making a search feature
for the site and have it working perfectly, but i want to change the way how to search displays the results. I want to make it display them how there displayed on the index page.

here is the index page how there displayed


<div id="table">
            <table>
                <tr class="top">
                <th>Account</th>
                <th>Country</th>
                <th>Info</th>
                <th>Login</th>
                <th>Pass</th>
                <th>Price</th>
                <th>Buy</th>
            </tr>
            
              
           <?php $class = 'grey'; ?>
                <?php $items = getItems(); ?>
           <?php if(empty ($items)): ?>
                <h3>No Items Found</h3>
            <?php else: ?>
                <?php foreach($items as $item): ?>
                  <?php $class = ($class == 'grey') ? 'grey2' : 'grey'; ?>
                   <tr class="<?php echo $class; ?>">              
                    <td><?php echo $item['item_account']; ?></td>
                    <td><?php echo $item['item_country']; ?></td>
                    <td><?php echo $item['item_info']; ?></td>
                    <td><?php echo maskUser($item['item_login']); ?></td>
                    <td><?php echo maskPass($item['item_pass']); ?></td>
                    <td><?php echo $item['item_price']; ?> </td>
                    <td><form method="post" action="https://sci.libertyreserve.com/"><input type="submit" name="buy" value="Buy" class="button" /></form></td>
                    
                </tr>
               
                <?php endforeach; ?>
          <?php endif; ?>


how the search is display


if (strlen($search) <= 2)
        {
            echo 'Search keyword is too short.';
        }
        else
        {
            echo "You searched for <b>$search</b><hr size='1'>";
           
              
                $search_exploded = explode(" ", $search);
                
                foreach($search_exploded as $search_each)
                {
                   
                    $x++;
                    if ($x == 1)
                        $construct .= "item_account LIKE '%$search_each%'";
                    else
                        $construct .= " OR item_account LIKE '%$search_each%'";
                        
                    
                }
                
                $construct = "SELECT * FROM items WHERE $construct";
                
               $run = mysql_query($construct);
               
               $foundnum = mysql_num_rows($run);
               
               if ($foundnum == 0)
               {
                   echo 'No results found.';
               }
               else
               {
                   echo "$foundnum results found!</p>";
                   
                   while ($numrows = mysql_fetch_assoc($run))
                   {
                       $item_id = $numrows['item_id'];
                       $itemAccount = $numrows['item_account'];
                       $itemI = $numrows['item_info'];
                       $itemLogin = $numrows['item_login'];
                       $itemPass = $numrows['item_pass'];
                       $itemPrice = $numrows['item_price'];
                       
                       echo "
                           <b>$itemAccount</b><br />
                           $itemI <br />
                            " . maskUser($itemLogin) . '<br />' . maskPass($itemPass, 0) . '<br />'; 
                   }
                   
               }
           
            
        }

my question is im not sure how to edit the search code to display the results in the same format as the index page

thanks

Hi All,   I need to get a small function working for a site I need to build for a group of friends.   I was able to get a login page, and a way to add data to the data base.   Now I am stuck on the search and show results fuctionalities.   I have found tens of scripts on the internet, but most of them are outdated, or I cant get them to work, either it sends me back a blank page, does nothing or sends me to an error page   The GOAL User Inputs text in a text box, clicks submit, the data in the text box is looked for in the second collumn of the DB, The information of the collumns 2 to 7 of the DB for the name search are displayed either on the same page or on a new page.   Is there any chance you could hel me with that, taken into account that I dont need the html part of the code, I only need help with the php part...   Thanks in advance to all the people reading this and the ones helping me...

Hello friends,
Posting this thread after many months.
Well I am making a small script in which on first page there will be a text box with button.
What I want to have is,
When we enter any keyword, like "yahoo" in textbox and click on submit button, on next page, there should be top 10 domain names from google search.
One of the most important is it should have option to select pages from specific countries like from google.co.uk or google.com or google.jp, this should be on first page.


I dont know how to fetch first 10 results domain names / URL and insert it in PHP variable and populate in table.


Need help

Hi All,

I have a pagination script that works correctly when a user clicks on a category heading, however when I am using it to try an display search results it does not take into account the set of records to display per page, it just shows all results.


<?php


echo '<h3>Search Results</h3><br />';



$query = "SELECT count(*) from merchants WHERE name LIKE '%$_GET[q]%' OR short like '%$_GET[q]%' OR full like '%$_GET[q]%' OR keywords like '%$_GET[q]%'"; 
$row=mysql_fetch_assoc(mysql_query($query));
$total_records = $row['count(*)'];
$records_per_page = 5;
$total_pages = ceil($total_records / $records_per_page);
$page = intval($p);
if ($page < 1 || $page > $total_pages) $page = 1;
$offset = ($page - 1) * $records_per_page; 
 
$limit = " LIMIT $offset, $records_per_page";



$query = mysql_query("SELECT * FROM merchants WHERE name LIKE '%$_GET[q]%' OR short like '%$_GET[q]%' OR full like '%$_GET[q]%' OR keywords like '%$_GET[q]%' ORDER BY m_id  DESC") ; 
echo mysql_error() ;



while($row = mysql_fetch_assoc($query)){

$name = $row['name'];
$short = $row['short'];
$per = $row['percent'];
$m_id = $row['m_id'];

?>
    
    <div id="cbbox">
    <a href="viewm.php?m_id=<?php echo $m_id;?>">
     <div class="cbname">
         <?php echo $name;?> &nbsp; - Up to <?php echo $per ;?>% Cashback Available
        </div>
        <div class="cbimage">
         <img src="pimage/<?php echo $name;?>.gif" height="50px" width="100px" />
        </div>
      <div class="cbshort">
         <?php echo $short;?>
        </div>
        </a>
        <div class="cbtweet">
        <a href="http://twitter.com/home/?status=Get up to <?php echo $per;?> percent Cashback on purchase from <?php echo $name;?> http://goo.gl/PLkp"><img src="images/cbtweet.png" width="90" height="50" alt="Tweet This" /></a>
 
        </div></div>
<br /><br />
<?php
}
if($total_records > 5)
{
for ($i = 1; $i <= $total_pages; $i++) {
echo "<a title='page $i p=$i'>Page $i -  </a>";
}
}

?>
</div>


if I echo out $total_records it displays the correct amount (7 in the case I am looking at)

Any ideas?

I need some serious help filtering search results using dropdown boxes. Right now my search is working perfectly fine. It searches by the keywords that people enter in and returns the results. My only problem is that after getting those results, I want people to be able to filter those results using dropdown boxes. So if someone searches by the keyword artwork, it will pull up all of my portfolio images that have artwork as a keyword. Now if they want to filter those results by: Color: Green, Type: Painting and Size: Large then they can use the dropdown boxes that will be populated with that information based off of their search term.

I have no idea on how to even get started on something like this, so I would really appreciate all of the help I can get.

Thanks in advance!

Greetings!

This n00b has a "search engine" dedicated to extracting relevant information from log files. It works by parsing preset fields in the log filename.

I'd like to have some notification when the search returns no rows as I am planning to add more search options. Here's my code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head>
        <title>LogFile Search</title>
        <style type="text/css">      <<irrelevant stuff removed>>        </style>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <script type="text/javascript" language="javascript" src="js/UI.js"></script>
    </head>
    <body>
        <h3 id="myh3">Log File Search</h3><h5>Version 1.0.1</h5>
        <h4 id="myh4"><ul><li>         <<irrelevant stuff removed>>   </li></ul></h4>
        <form method="post" name="LogFile_Search" action="<?php echo $_SERVER['PHP_SELF']; ?>">
            <table id="mytable">
                <tbody>
                    <tr>
                        <td id="mytd">Result(P|F|N):  <input type="text" id="Result_PFN" name="Result_PFN" size="31"/></td>
                        <td id="mytd">Script Version:  <input type="text" id="ScriptVersion" name="ScriptVersion" size="31"/></td>
                    </tr>
                </tbody>
            </table>
            <br>
            <input type="submit" value="Search" onclick="doForm();">
            <input type="button" value="Reset" onclick="resetForm();">
        </form>
<div id="searchResult">
            <?php
            /* Where the logs files are dropped by external process. */
            $mydir = $_SERVER['DOCUMENT_ROOT'] . "/LogFile_Search/LogFiles";
            /* Handle to directory. */
            $dir = opendir($mydir);
            /* Form variables. */
            $Result_PFN = $_POST['Result_PFN'];
            $ScriptVersion = $_POST['ScriptVersion'];
            /*  Test each field -- triggers JS alert if all are empty.         */
            if (!empty($Result_PFN)) {
                doResult_PFN();
            } elseif (!empty($ScriptVersion)) {
                doScriptVersion();
            }
            /* Function for Search on Script version in logfile contents.             */
            function doScriptVersion() {
                global $dir;
                global $mydir;
                global $ScriptVersion;

                echo '<table id=\'mytable\'><tbody><tr><td id=\'mytd\'>Log File Name.</td></tr>';
                //grabs all log files matching the script version number that's input in the form.
                $cmd = "find " . $mydir . " -type f -print0 | xargs -0 grep  -e 'Test_Version=" . $ScriptVersion . "'";
                exec($cmd, $output);

                //Sort the array using a case insensitive "natural order" algorithm.
                natcasesort($output);

                if (count($output) > 0) {
                    foreach ($output as $v) {
                        //Display file name without full path as URL.
                        echo '<tr><td><a href="' . basename($mydir) . '/'
                        . array_pop(explode("/", array_shift(explode(":", $v)))) . '"  target="_blank">'
                        . array_pop(explode("/", array_shift(explode(":", $v)))) . '</a></td></tr>';
                    }
                } else {
                    echo "<html><body style=\"background-color:#0080c0\">
<script type=\"text/javascript\" language=\"javascript\">alert(
'Nothing found'
+ '.');</script> </body></html>";
                }
                closedir($dir);
                echo "</table></body>";
            }

            /* Function for Search on Result marker in file name.            */
            function doResult_PFN() {
                global $dir;
                global $mydir;
                global $Result_PFN;

                echo '<table id=\'mytable\'><tbody><tr><td id=\'mytd\'>Log File Name.</td></tr>';

                if ($dir) {
      //List files in directory
                    while (($file = readdir($dir)) !== false)
      //Ignores OS stuff.
                        if ($file != "." && $file != "..") {
      //Pattern match for result.
                            if (preg_match("/~(P|F|N)*" . $Result_PFN . "~/i", $file)) {
                      //Sort the array using a case insensitive "natural order" algorithm.
                      natcasesort($file);
                                echo '<tr><td><a href="' . basename($mydir) . '/' . $file . '"  target="_blank">' . $file . '</a></td></tr>';
                            }
                        } else {
                    echo "<html><body style=\"background-color:#0080c0\">
<script type=\"text/javascript\" language=\"javascript\">alert(
'Nothing found'
+ '.');</script> </body></html>";
                }
                    closedir($dir);
                }
                echo "</table></body>";
            }
            ?>
        </div>
    </body>
</html>

When doResult_PFN() returns no result, the ELSE portion is never evaluated and no notification is sent to the user. However, I have no problem with doScriptVersion(): it returns an alert.

What am I missing?

Thanks,

Al.

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!

Hi,

I have a searchbar which looks for a value in my tables, it works great but i want to know how i can make the results of the search clickable; go to a page relevent to that search, let me explain in more depth.

User searches for a postcode, script finds and displays the postcode on the next page, user clicks the result postcode to goto the next page.

What im stuck with is how to take that result and automatically display it on the clicked "final" page?

Search script:

Code: [Select]
<?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("xxxxx","xxxx","xxxx"); //(host, username, password)

//specify database ** EDIT REQUIRED HERE **
mysql_select_db("removalspacelogin") or die("Unable to select database"); //select which database we're using

// Build SQL Query  
$query = "(SELECT postcode FROM freelistings
             WHERE postcode like '%$trimmed%')         
UNION           
  (SELECT postcode FROM basicpackage              
    WHERE postcode like '%$trimmed%')          
UNION           
  (SELECT postcode FROM premiumuser              
    WHERE postcode like '%$trimmed%')         
  ORDER BY postcode"; // EDIT HERE and specify your table and field names for the SQL query
 
 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);
 $result = mysql_query($query) or die("<b>Query:</b> $query<br><b>Error</b>: " . mysql_error());



// 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;</p>";

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

// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {
  $title = $row['postcode'];

  echo "&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&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>";
  
  
?>

<form method="post" action="localarea.php">
<a href="localarea.php"><?php echo "&quot;" .$var. "&quot;</p>";?></a>
</form>
[\code]


The form at the bottom im guessing is where i should take the $var from but how exactly? or if not where should it be pulled from to display on the next page?

I want this "next" page because ideally there would be lots of results in postcode, so the user can choose which one is more relevant to them and go to that specific page with all the companies within that postcode. Hope this helps for a better understanding of what im trying to achieve, its just implementing it in?