<?php
Function index (){
include("ust.php");
$ara = $_GET["ara"];
   if($ara!=""){
   $limit	= 30;
	$sira	= $_GET["sira"];	
	if(empty($sira) or !is_numeric($sira)){
	$sira	= 1;	
	}
		$satirsayisi	= mysql_num_rows(mysql_query("SELECT * FROM urunler "));
		$toplamsayfa	= ceil($satirsayisi / $limit);
		$baslangic		= ($sira-1)*$limit;
     $sor =mysql_query("SELECT * FROM urunler  WHERE  ( marka  LIKE '%$ara%' or urunkod  LIKE '%$ara%' or urunadi  LIKE '%$ara%' or urunozellik  LIKE '%$ara%')  ORDER BY id ASC LIMIT $baslangic,$limit");
        $toplamsonuc = mysql_num_rows($sor);
        if($toplamsonuc > 0){
        echo "<p align=\"left\">&nbsp;&nbsp;&nbsp;&nbsp;Aranan Kriterlere Uygun <font color=\"#FF0000\">$toplamsonuc</font> 
Sonuç Bulundu</p>";
        echo "<br><div align=\"center\">
  <table width=\"95%\" border=\"0\" cellspacing=\"1\" cellpadding=\"0\">  
    <tr>
      <td width=\"20%\" height=\"22\" bgcolor=\"#DCE4ED\"><div align=\"center\" class=\"style1\">Marka</div></td>
      <td width=\"60%\" height=\"22\" bgcolor=\"#DCE4ED\"><div align=\"center\" class=\"style1\">Ürün Adı</div></td>
      <td width=\"20%\" height=\"22\" bgcolor=\"#DCE4ED\"><div align=\"center\" class=\"style1\">Ürün Kodu</div></td>
    </tr>";
           While($yaz=mysql_fetch_array($sor)){
           $marka       = $yaz['marka'];
           $urunkod     = $yaz['urunkod'];
           $urunadi     = $yaz['urunadi'];
           $id          = $yaz['id'];
           $katid       = $yaz['katid'];
           echo "<tr>
      <td height=\"20\" onMouseOut=\"this.bgColor='#EBF0F5'\" onMouseOver=\"this.bgColor='#F2F5F9'\" bgcolor=\"#EBF0F5\"><div align=\"center\"><a href=\"Sayfa.php?Git=Urunler&Sayfa=UrunOku&id=$id\" target=\"_blank\">$marka</a>
      </div>
      <div align=\"center\"></div></td>
      <td height=\"20\" onMouseOut=\"this.bgColor='#EBF0F5'\" onMouseOver=\"this.bgColor='#F2F5F9'\" bgcolor=\"#EBF0F5\"><div align=\"center\"><a href=\"Sayfa.php?Git=Urunler&Sayfa=UrunOku&id=$id\" target=\"_blank\">$urunadi</a>
      </div>
      <div align=\"center\"></div></td>
      <td height=\"20\" onMouseOut=\"this.bgColor='#EBF0F5'\" onMouseOver=\"this.bgColor='#F2F5F9'\" bgcolor=\"#EBF0F5\"><div align=\"center\"><a href=\"Sayfa.php?Git=Urunler&Sayfa=UrunOku&id=$id\" target=\"_blank\">$urunkod</a>
      </div>
      <div align=\"center\"></div></td>
    </tr>";
           }
         echo "</table>           
</div>";
        echo "<br><center> </center>";
        for($x=1; $x<=$toplamsayfa; $x++){
        echo "[ <a href=\"Sayfa.php?Git=Arama&sira=$x\">$x</a> ] ";
        }
        }else{
        echo "<br><br><div align=\"center\">
  <table width=\"450\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
    <tr>
      <td height=\"81\" valign=\"top\" bgcolor=\"#FDAD00\"><div align=\"center\">
        <table width=\"450\" border=\"0\" cellspacing=\"1\" cellpadding=\"0\">
          <tr>
            <td height=\"80\" bgcolor=\"#EBF0F5\"><div align=\"center\">
              <table width=\"400\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
                <tr>
                  <td width=\"450\" valign=\"middle\">
					<p align=\"center\">Aranan Kriterlere Uygun Sonuç Bulunamadı</td>
                </tr>
              </table>
            </div></td>
          </tr>
        </table>
      </div></td>
    </tr>
  </table>
</div>";
        }
   }else{   
   echo "Lütfen Bir Kelime Girin"; 
   }
include("alt.php");
}
$Sayfa = $_GET["Sayfa"];
Switch($Sayfa){    
default:
    index();
    break;
}
?>