PHPBuilder - Dynamic Document Search Engine - Part 2 Page 4



RSS Twitter
Articles Tricks And Hacks

Dynamic Document Search Engine - Part 2 - Page 4

by: M.Murali Dharan
|
February 25, 2004

For every record in the results of the link table, the content id and number of occurrences is stored in an associative array $contArray. During 'while loop operation', if the content id already exists in $contArray, the occurrence is incremented with this new occurrence value.
Now $contArray is set and it shows that some results are found in the database table. Otherwise, the program skips to the next part that displays the result “NO RESULTS FOUND”

<?php
if(isset($contArray)){
    
//declare an array to store the results
    
$FoundRef=array();
    
//Sort array in desending order of the key value
    
arsort($contArray,SORT_DESC);
    
//Store the results in the $FoundRef Array 
    //code for this is given in the next line.
}
?>
In the next step we have to fetch title, the first 200 words in content table, into an array $FoundRef.

<?php
foreach($contArray as $cont){
   
$rank=$cont["wrank"];

   if (
$rank == $noofSearchWords ) {
          
$contentId $cont["id"];
          
$occurances $cont["oc"];
          
$aQuery "select contid,title,left(abstract,200) as summary from content where contid = " $contentId;
          
$aResult mysql_query($aQuery);

         if(
mysql_num_rows($aResult) > 0){
                   
$aRow mysql_fetch_array($aResult);
                   
$FoundRef[] = array (
                              
"contid" => $aRow["contid"],
                              
"title" => $aRow["title"],
                              
"summary" => $aRow["summary"],
                              
"occurance"=>$occurances );
         }
//end of  if
//end of for each
?>

« Previous Page
1
|
2
|
3
|
4
|
5
|
6
Next Page »

Comment and Contribute

Your comment has been submitted and is pending approval.

Author:
M.Murali Dharan

Comment:



Comment:

(Maximum characters: 1200). You have characters left.