"ABSURD_NEWS", 1=> "ABSURD_ANNCOUNCE");
//SET FEILDS TO BE USED
$feilds = array(0 => "ID", 1=> "KEYWORDS", 2=> "BODY");
if(isset($_GET['search_query']) && $_GET['search_query'] != NUll)
{
$search_query = prepare_query($search_query);
$search_results_k = search_keywords($tables,$search_query,$feilds);
$search_results_b = search_body($tables,$search_query,$feilds);
if($search_results_k != NULL)
{
$formatted_results_k = format_results_k($search_results_k,$search_query,$feilds);
}//MATCH IN KEYWORDS
else
{
echo('unable to find matchs in keywords
');
}
if($search_results_b != NULL)
{
$formatted_results_b = format_results_b($search_results_b,$search_query,$feilds);
}//MATCH IN BODY
else
{
echo('unable to find matchs in text body
');
}
prepare_display($formatted_results_k,$formatted_results_b);
}
else
{
echo('you must search for something
');
die();
}
}
//USER DEFINED FUNCTINOS
function prepare_query($search_query)
{
$search_query = trim($search_query);
$search_query = explode(' ',$search_query);
//var_dump($search_query);
return $search_query;
}
function search_keywords($tables,$search_query,$feilds)
{
$j=0;
foreach($tables as $table_key => $table_element)
{
foreach($search_query as $search_key => $search_element)
{
$query = "SELECT * FROM $table_element WHERE $feilds[1] LIKE \"%$search_element%\";";
if(@mysql_num_rows(@mysql_query($query)))
{
$result_k[$j] = $query;
}
$j++;
}
}
//var_dump($result_k);
return $result_k;
}
function search_body($tables,$search_query,$feilds)
{
$j=0;
foreach($tables as $table_key => $table_element)
{
foreach($search_query as $search_key => $search_element)
{
$query = "SELECT * FROM $table_element WHERE $feilds[2] LIKE \"%$search_element%\";";
if(@mysql_num_rows(@mysql_query($query)))
{
$result_b[$j] = $query;
}
$j++;
}
}
//var_dump($result_b);
return $result_b;
}
function format_results_k($search_results_k,$search_query,$feilds)
{
$j = 0;
foreach($search_results_k as $keywords_key => $keywords_element)
{
$query = $keywords_element;
$result = mysql_query($query);
$num = mysql_num_rows($result);
for($i=0;$i<$num;$i++)
{
//GET TABLE NAME -- VERY IMPORTANT
$table_name = explode(" ",$query);
$table_name = $table_name[3];
//GET TERM NAME -- VERY IMPORTANT
$search_term = explode("%",$query);
$search_term = $search_term[1];
$ID = mysql_result($result,$i,$feilds[0]);//$feilds[0] = ID
$KEYWORDS = mysql_result($result,$i,$feilds[1]);//$feilds[1] = KEYWORDS
$KEYWORDS = explode(' ',$KEYWORDS);
//var_dump($KEYWORDS);
$count = 0;
foreach($search_query as $search_key => $search_element)
{
foreach($KEYWORDS as $KEYWORDS_key => $KEYWORDS_element)
{
if(strtolower($KEYWORDS_element) == strtolower($search_element))
{
$count++;
}
}
$formatted_results_k[$j] = $table_name . '-' . $ID . '-' . $search_term . '-' . $count;
}
$j++;
}
}
//var_dump($formatted_results_k);
return $formatted_results_k;
}
function format_results_b($search_results_b,$search_query,$feilds)
{
$j = 0;
foreach($search_results_b as $body_key => $body_elements)
{
$query = $body_elements;
$result = mysql_query($query);
$num = mysql_num_rows($result);
for($i=0;$i<$num;$i++)
{
$table_name = explode(" ",$query);
$table_name = $table_name[3];
$search_term = explode("%",$query);
$search_term = $search_term[1];
$ID = mysql_result($result,$i,$feilds[0]);
$BODY = mysql_result($result,$i,$feilds[2]);
$BODY = explode(' ',$KEYWORDS);
//var_dump($BODY);
$count = 0;
foreach($search_query as $search_key => $search_element)
{
foreach($BODY as $BODY_key => $BODY_elements)
{
if(strtolower($BODY_element) == strtolower($search_element))
{
$count++;
}
}
$formatted_results_b[$j] = $table_name . '-' . $ID . '-' . $search_term . '-' . $count;
}
} $j++;
}
//var_dump($formattd_results_b);
return $formatted_results_b;
}
function prepare_display($formatted_results_k, $formatted_results_b)
{
foreach($formatted_results_k as $f_r_k_key => $f_r_k_elements)
{
$rank_findings = explode('-',$f_r_k_elements);
for($i=0;$i