<?php 

require('config.php');
require_once('include/functions.php');


$_page_title =  "Site Içi Arama ".stripslashes($words)."";
$_page_desc = "Site Içi Arama  ".stripslashes($words)."";

include('header.php');
?>
	<div id="content-wrap">
<div id="searchbar">
<div class="breadcrumbs"><a href="<?=_URL?>">Anasayfa</a> > Arama Sonuçları</div>
	<div class="searchform">
	<form method="POST" action="<?=_URL?>/search.php">
	 <input type="hidden" name="cmd" value="search" />
	   <input class="inputtext" type="text" name="words" value="<?=$words?>" size="30" maxlength="50"/> 
		<input type="hidden" name="mode" value="normal">
		<input class="inputbutton" type="submit" value="Search" /> 
	</form>
	</div>
</div>

 <div id="content">
    <div class="right">
		<div class="show_ads">
		<? echo show_ads();?>
		</div>
	</div>

	<div class="left">
	<div id="breadcrumbs"></div>
	<h2 class="browseh2">Site Içi Arama</h2>
<br />
		<div id="browsing">
				<?
				include_once('include/search.inc.php');
				?>
		</div>
	</div>
 </div>
 </div>
<?
include_once('footer.php'); 
?>

<?php 
$cmd = (isset($_POST['cmd']) ? $_POST['cmd'] : '');

switch($cmd)
{
  default:
#    echo '<h1>Search Database!</h1>';
  break;

  case "search":
     $searchstring = mysql_escape_string($_POST['words']);
     $searchstring = htmlentities($searchstring);
	 $sql_string_check = mysql_query("SELECT string FROM ura_searches WHERE string=\"$searchstring\"");
	 $string_check = mysql_num_rows($sql_string_check);
 	 if($string_check > 0){
     $sql = mysql_query("UPDATE ura_searches SET hits=hits+1 WHERE string=\"$searchstring\"") or die (mysql_error());
     }
	 else {
     $sql = mysql_query("INSERT INTO ura_searches SET string=\"$searchstring\"") or die (mysql_error());
	 }
	 
    switch($_POST['mode'])
    {
      case "normal":
        $sql = "SELECT ProductID, CategoryID, ProductName, LongDesc, 
               MATCH(ProductName, LongDesc) 
               AGAINST ('$searchstring') AS score FROM ura_items 
               WHERE MATCH(ProductName, LongDesc) 
               AGAINST ('$searchstring') ORDER BY score DESC LIMIT 50";
      break;
      
      case "boolean":
        $sql = "SELECT ProductID, CategoryID, ProductName, 
               MATCH(ProductName, LongDesc) 
               AGAINST ('$searchstring' IN BOOLEAN MODE) AS score FROM ura_items 
               WHERE MATCH(ProductName, LongDesc) 
               AGAINST ('$searchstring' IN BOOLEAN MODE) ORDER BY score DESC";
      break;
    } 
    $result = mysql_query($sql) or die (mysql_error());
    $j = 0; 
    while($row = mysql_fetch_assoc($result))
    {
			($j % 2) ? $div = "list2" : $div = "list";
			echo "<div class=\"".$div."\">";
			echo "<a href=\"".seo_links('detail', $row['ProductID'], $row['ProductName'], 1, _SEO)."\">".unhtmlentities($row['ProductName'])."</a>  <br>";
			echo '</div>';
			$j++;
    }

	$count = mysql_num_rows($result);
	if($count == 0){
	echo "<center><br><b>Üzgünüz aradiginiz kelime bulunamadi
Lütfen degisik karakter kullanip tekrar deneyiniz.</b></center>";
	}
  break;
}
?>