PHP - Search Engine Friendly Urls

I'm currently runing an classifieds ads site, Php + Mysql (no frameworks) Basically i have the ads listing page (ads.php) and the ads details page (ad_detail.php) This is my current .htaccess:

# disable directory browsing
Options All -Indexes

ErrorDocument 400 /error.php
ErrorDocument 401 /error.php
ErrorDocument 403 /error.php
ErrorDocument 404 /error.php
ErrorDocument 500 /error.php
ErrorDocument 502 /error.php
ErrorDocument 504 /error.php

RewriteEngine on

RewriteRule ^(.*)-da([0-9]+)$ ad_detail.php?ad=$2
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^([^\.]+)$ $1.php [NC,L]

RewriteRule ^([^\.]+)$ $1.php [NC,L]

The final result is something like this: www.mysite.com/this-is-the-ad-detail-da50555 (the number is the ad id)   What i need is to get this: www.mysite.com/ads/another-ad-detail-da50777 + What can i do in others urls to show like www.mysite.com/about/ instead of www.mysite.com/about (without the /)     I already tried this but doesn't work:

RewriteEngine on
RewriteBase /

RewriteRule -da([0-9]+)/?$ ad_detail.php?ad=$1 [L,QSA]

RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{DOCUMENT_ROOT}/$1\.php -f [NC]
RewriteRule ^(.+?)/?$ $1.php [L]

Edited by asanti, 22 November 2014 - 05:16 PM.

I want to know how to display results from mysql database by filling in a form. but i have found a tutorial which shows typing in a text box which displays results. if i follow this tutorial will it help me to understand and create php coding to display results for my form?

I require a page to be added to my website. This page will facilitate a refined search via Google, Bing and Yahoo search engine simultaneously , show the top 5 of each engine.

Is this possible using php ?

Thank's

Hello,

Does anyone know a tutorial I can follow to create my own search engine over the items I have in my SQL database?
I find a lot of tutorials but they are all 'one word searches' which means if you type two words you will get all results that contain either word (too many hits).

If the search engine tutorial displays result with AJAX even better.

Thanks for help.
df

Friends,

I want to extract the Search Keyword from the URL, a visitor came from. I am using a PHP CMS and want to show the Keyword on my Blog.

So if they search "abcd" from google, i want to extract "abcd" and echo on my blog.

Here is the coding i could got hold of, but its not working, not echoing anything

<?php

function pk_stt2_function_get_delimiter($ref) {
    $search_engines = array('google.com' => 'q',
'go.google.com' => 'q',
'images.google.com' => 'q',
'video.google.com' => 'q',
'news.google.com' => 'q',
'blogsearch.google.com' => 'q',
'maps.google.com' => 'q',
'local.google.com' => 'q',
'search.yahoo.com' => 'p',
'search.msn.com' => 'q',
'bing.com' => 'q',
'msxml.excite.com' => 'qkw',
'search.lycos.com' => 'query',
'alltheweb.com' => 'q',
'search.aol.com' => 'query',
'search.iwon.com' => 'searchfor',
'ask.com' => 'q',
'ask.co.uk' => 'ask',
'search.cometsystems.com' => 'qry',
'hotbot.com' => 'query',
'overture.com' => 'Keywords',
'metacrawler.com' => 'qkw',
'search.netscape.com' => 'query',
'looksmart.com' => 'key',
'dpxml.webcrawler.com' => 'qkw',
'search.earthlink.net' => 'q',
'search.viewpoint.com' => 'k',
'mamma.com' => 'query');
    $delim = false;
    if (isset($search_engines[$ref])) {
        $delim = $search_engines[$ref];
    } else {
        if (strpos('ref:'.$ref,'google'))
            $delim = "q";
elseif (strpos('ref:'.$ref,'search.atomz.'))
            $delim = "sp-q";
elseif (strpos('ref:'.$ref,'search.msn.'))
            $delim = "q";
elseif (strpos('ref:'.$ref,'search.yahoo.'))
            $delim = "p";
        elseif (preg_match('/home\.bellsouth\.net\/s\/s\.dll/i', $ref))
            $delim = "bellsouth";
    }
    return $delim;
}

/**
 * retrieve the search terms from search engine query
 * */ 
function pk_stt2_function_get_terms($d) {
    $terms       = null;
    $query_array = array();
    $query_terms = null;
    $query = explode($d.'=', $_SERVER['HTTP_REFERER']);
    $query = explode('&', $query[1]);
    $query = urldecode($query[0]);
    $query = str_replace("'", '', $query);
    $query = str_replace('"', '', $query);
    $query_array = preg_split('/[\s,\+\.]+/',$query);
    $query_terms = implode(' ', $query_array);
    $terms = htmlspecialchars(urldecode(trim($query_terms)));
    return $terms;
}

/**
 * get the referer
 * */ 
function pk_stt2_function_get_referer() {
    if (!isset($_SERVER['HTTP_REFERER']) || ($_SERVER['HTTP_REFERER'] == '')) return false;
    $referer_info = parse_url($_SERVER['HTTP_REFERER']);
    $referer = $referer_info['host'];
    if(substr($referer, 0, 4) == 'www.')
        $referer = substr($referer, 4);
    return $referer;
}



$referer = pk_stt2_function_get_referer();
if (!$referer) return false;
$delimiter = pk_stt2_function_get_delimiter($referer);
if( $delimiter ){
$term = pk_stt2_function_get_terms($delimiter);
}
echo $term;
?>


May someone help?

Natasha T

Hi, I have a script which searches the MySQL database. It outputs the result which is a business name, but I need the business name to be in a link so the user can click on it and go to another page to find out more information. However the business name is not included in the link, but the $value is.   Here is my script

<?php
include 'init.php';

// normal search
$result_tb = "";
if (!empty($_POST['SEARCH']) && !empty($_POST['search_value'])) {

   $e = $_POST['search_value'];

   $query = 'SELECT aquaticCenterName FROM reviews WHERE ' .
           "aquaticCenterName LIKE '%$e%' OR " .
           "town LIKE '%$e%' OR " .
           "county LIKE '%$e%' OR " .
           "country LIKE '%$e%' OR " .
           "rating LIKE '%$e%' ";

   $query_result = $con->query($query);

 $result_tb = '<div>';
   while ($rows = $query_result->fetch_assoc()) {
      foreach ($rows as $k => $v) {
         $result_tb .= '<a href="reviewResults.php?aquaticCenterName= . $v . ">' . $v . '</a><br>';
      }
   }
   $result_tb .='</div><hr>';

   $con->close();
}
?>
<?php
include 'includes/overall/header.php';
include 'includes/logo.php';
?>
      <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
         <table>
            <tr>
               <td>
                  <input type="text" name="search_value" size="30" maxlength="30"/>
               </td>
               <td>
                  <input type="submit" name="SEARCH" value="Search"/>
               </td>
            </tr>
         </table>
      </form>
      <?php echo $result_tb; ?>
<?php
include 'includes/overall/footer.php';

But when I click on the link, I get this in the address bar   reviewResults.php?aquaticCenterName=%20.%20$v%20.   How do I get this to read   eg, reviewResults.php?aquaticCenterName=PaulsAquaticCenter   Many Thanks   aquaman  

I thinking about building a search engine just as a fun project and a way to develop my skills.  However I'm not sure where to start... 

I want it to be a comparison search engine for computer parts so say the user type in "RAM" it would display results from PC World, Ebuyer, etc.  I was thinking of using cURL but how do I know where the search results are on each page.  For example say  I get a html page of results from PC World and store them in a variable how do I then know what to strip out to get the results I want?  Would I just have to look at the source code?  Also would I then have to work this out for each site I wanted to search from and have a different method of getting the results from search site?

If anyone has done anything like this in the past and could give me some advice that would be great. 

Thanks

Php search engine for my site

I have a Romanian based language site: http://www.firmelavedere.com with informations about business companies.

I implemented a simple php search engine for my website on pages like this on the top right corner:
http://www.firmelave...aj-Zalau-15.php

I want to add a new radio box field to select language for displayed text.

Is there a possibility to integrate Google Site Search with more languages?
How can i do that?

I need some code suggestions, to make this script run fast.

Thanks all.

Hi, Im trying to do a search engine. However, im facing this errors.. Anyone can help..

Error :

Notice: Undefined variable: searching in C:\wamp\www\i-document\s.php on line 17

Thankz in advance.

Code: [Select]


<h2>Search Form</h2>

<form name="search" method="post" action="s.php">
  Seach for: <input type="text" name="find" /> in
  <Select NAME="field">
    <Option VALUE="file_name">File Name</option>
    <Option VALUE="year">Year</option>
    <Option VALUE="downer">Owner</option>
        <
  </Select>

  <input type="hidden" name="searching" value="yes" />
  <input type="submit" name="search" value="Search" />
</form>

<?php
  if ($searching =="yes"){
    echo "<h3>Search Results</h3><p>";
    if ($find == ""){
      echo "<p>Please Enter a search term";
      exit;
    }
   
    include "config.php";
    $find = strtoupper($find);
    $find = strip_tags($find);
    $find = trim ($find);

    $query = mysql_query("SELECT * FROM document WHERE upper($field) LIKE'%$find%'");
    while($result = mysql_fetch_array($query)){
      echo $result['file_ref'];
      echo " ";
      echo $result['file_name'];
      echo "<br>";
      echo $result['owner'];
      echo "<br>";
      echo "<br>";
    }

    $matches=mysql_num_rows($query);
    if ($matches == 0){
      echo "Sorry, we can not find an entry to match your query<br><br>";
    }

    echo "<b>Searched For:</b> " .$find;
  }
?>

 

hi frnds need a small favour......


                             i want to create a page with a simple text box and a submit button and as soon as i click the submit button it should get the data from the database matching to the text what i enterd in the text box and sholud display those data below the text box according to the number of keywords that are matching ..text that matches max keywords should display first...simply to say i need exactly the way google search engine homepage works...

Mega thanks in advance
pythagoras

I'm in the process of build a network and need to create a search that lets people search by both first and last names. I have tailored the code below to search for first names, but I don't know how to tailor it to search for both first and last names.

Code: [Select]


<?php

//get data
$button = $_GET['search'];
$search = $_GET['search'];

if (!$button)
        echo "You didn't submit a keyword.";
else
{
        if (strlen($search)<1)
                echo "Search term too short.";
        else
        {
                echo "You searched for $search<hr>";
               
                require('connect.php');
                       
                        //explode our search term
                        $search_exploded = explode(" ",$search);
                       
                        foreach($search_exploded as $search_each)
                        {
                                //contruct query
                                $x++;
                                if ($x==1)
                                        $construct .= "firstname LIKE '%$search_each%'";
                                else
                                        $construct .= " OR firstname LIKE '%$search_each%'";
                        }
               
                //echo out construct
               
                $construct = "SELECT * FROM users WHERE $construct";
                $run = mysql_query($construct);
               
                $foundnum = mysql_num_rows($run);
               
                if($foundnum==0)
                        echo "No results found!<p>";
                else
                {
                        echo "$foundnum results found!<p>";
                       
                        while ($runrows = mysql_fetch_assoc($run))
                        {
                       
                        //get data
                        $firstname = $runrows['firstname'];
                        $lastname = $runrows['lastname'];
                       
                        echo "
                       
                        $firstname $lastname
                        ";
                       
                        }
                }
        }
}
?>

I have a search bar that searches my databases for information.  It works perfectly on my site,.  I want to know how to make it modular so that other people can place my search box on their site and get results from my databse without having to give out all my site infomration.

I need some help with a php code I made for a search engine which I will use on my site, but an error code comes up please help me im ok at php but i need some pointers on my code!

CODE:

Code: [Select]
<?php

$button = $GET_['submit'];

$search = $GET_['search'];



if (!$button)

   echo "Please enter a keyword!";

else

{

    if (strlen($search)<2)

             echo "search term to short"

      else

      {   

            echo "you searched for $search <hr size='1'>"

       }

        mysql_connect("ftp.gpcoin.monkeyserve.com","seanhall_seanhall","81834567");

        mysql_select_db("seanhall_search");

      



         

              $search_exploded = explode(" ",$search)



              foreach($search_exploded as $search_each)

              {



                   $x++;

                   if ($x==1)

                      $construct .= "keywords LIKE '%$search_each%'";

                   else

                      $construct .= " OR keywords LIKE '%$search_each%'";

              }





        $construct = "SELECT * FROM searchengine WHERE $construct";

        

        echo $construct;

        $run = mysql_query($construct);

        

        $found = mysql_num_rows($run)



        if ($found==0)

           echo "No results Found.";

        else

        {

            echo  "$foundnum results found!<p>";



          while ($runrows = mysql_fetch_assoc($run))

          {

           $title = $runrows['title'];

           $desc = $runrows['description'];

           $url = $runrows['url']

           

           echo "

            <b>$title</b><br>

            $desc<br>

            <a herf='$url'>$url</a><br>

           ";



          }

    }

}

?>
error:

Parse error: syntax error, unexpected T_ELSE, expecting ',' or ';' in /home/seanhall/public_html/search.php on line 11

Help

Good evening,

I am a newbie when it comes to programming, and I am yet learning. With several help from this forum, and other websites, I am able to finish my very first PHP project. It worked fine, as well as the search engine. However, it is foreseen that the application will be utilizing huge amount of data which would require pagination when viewing. And so I found a tutorial from php freaks as well. However, after I integrated the codes from my web application, the search engine suddenly stopped working. It is still, when I leave the field blank, which would display all data. However, if I type down a search query on the field, it still displays all data. Can anyone help me on this? Here's my complete code:

<link href="add_client.css" rel="stylesheet" type="text/css">

<?PHP
include("dbconnection.php");

$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"  ;

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

} 

?>

<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><table width="760" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td width="199" align="center" valign="top"><a href="login.html"><img src="invent-asia.gif" alt="" width="152" height="58" border="0" /></a>        <script type="text/javascript" src="menu.js"></script></td>
        <td width="176" align="right" valign="bottom"><a href="main.php"><img src="Home.jpg" width="104" height="20" border="0"/></a></td>
        <td width="130" align="right" valign="bottom"><img src="View.jpg" width="104" height="20" border="0"/></td>
        <td width="146" align="right" valign="bottom"><a href="add_client.php"><img src="Add.jpg" width="104" height="20" border="0"/></a></td>
        <td width="109" align="right" valign="bottom">&nbsp;</td>
        </tr>

    </table></td>
  </tr>
  <tr>
    <td><table width="760" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <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>
    </table></td>

  </tr>
  <tr>
    <td height="553" align="center" valign="top" bgcolor="#F3FAFE"><br />

      <form name="form" action="view_client.php" method="post">
        <br />
      <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 />
        <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

$conn = mysql_connect('localhost','root','') or trigger_error("SQL", E_USER_ERROR);
$db = mysql_select_db('invent-asia',$conn) or trigger_error("SQL", E_USER_ERROR);


$sql = "SELECT COUNT(*) FROM records";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
$r = mysql_fetch_row($result);
$numrows = $r[0];


$rowsperpage = 10;

$totalpages = ceil($numrows / $rowsperpage);


if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {

   $currentpage = (int) $_GET['currentpage'];
} else {

   $currentpage = 1;
}


if ($currentpage > $totalpages) {

   $currentpage = $totalpages;
}

if ($currentpage < 1) {

   $currentpage = 1;
} 


$offset = ($currentpage - 1) * $rowsperpage;


$sql = "SELECT * FROM records LIMIT $offset, $rowsperpage";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);


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 "<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>";
  }
  }


$range = 3;


if ($currentpage > 1) {

   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1'><<</a> ";

   $prevpage = $currentpage - 1;

   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> ";
} 


for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {

   if (($x > 0) && ($x <= $totalpages)) {

      if ($x == $currentpage) {

         echo " [<b>$x</b>] ";

      } else {

         echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";
      } 
   }
} 
                 
       
if ($currentpage != $totalpages) {

   $nextpage = $currentpage + 1;

   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>></a> ";

   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> ";


}

?>


  
        </table>
        <p>
<br />
        </p>
      </form>
    <p>&nbsp;</p></td>

  </tr>
  <tr>
    <td height="38"><table width="760" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td width="200" height="35" align="center"  bgcolor="#1B1C78" class=white><img src="images/topspacerblue.gif" alt="" width="1" height="3" />&nbsp;<a href="disclaimer.html"><font color="#FFFFFF">Legal Disclaimer</font></a> </td>

        <td width="560" align="center"  bgcolor="#0076CC"  class=white><img src="images/topspacerlblue.gif" alt="" width="1" height="3" />&nbsp;Copyright &copy; 2006 - 2010 InventAsia Limited. All rights reserved.
</td>
      </tr>

    </table></td>
  </tr>
</table>

Immediate response is very well appreciated. Thank you very much ^^