<form method="get" action="search.php">
<input type="text" value="" name="find">
<select name="searchtype">
<option value="1">Kod Başlığında Ara</option>
<option value="2">Kod Metninde Ara</option>
<option value="3">Hepsinde Ara</option>
</select>
<br/>
<button type="submit">ara</button>
</form>
<?php
// First connect to database
$host = "localhost";
$dbuser = "user";
$dbpass = "sifre";
$db = "db";
$con = mysql_connect($host, $dbuser, $dbpass);
if(!$con){
die(mysql_error());
}
$select = mysql_select_db($db, $con);
if(!$select){
die(mysql_error());
}
$kayitcan = 8;
if(!$kayitcan OR $kayitcan<=0){$kayitcan=8;}
if(!$HTTP_GET_VARS[Cem]){$Cem=1;}
if($HTTP_GET_VARS[Cem]<0){$Cem=1;}
// Now collect all info into $item variable
$item = $_REQUEST['find'];
$stype = $_REQUEST['searchtype'];
// This will take all info from database where row tutorial is $item and collects it into $data variable
$nerden =($Cem-1)*$kayitcan;
if(!$item)
{
die();
}
switch($stype)
{
case 1:
$sql = "SELECT * FROM kodlar WHERE kodbaslik LIKE '%$item%' LIMIT $nerden,$kayitcan";
break;
case 2:
$sql = "SELECT * FROM kodlar WHERE kod LIKE '%$item%' LIMIT $nerden,$kayitcan";
break;
case 3:
$sql = "SELECT * FROM kodlar WHERE kod LIKE '%$item%' OR baslik LIKE '%$item%' LIMIT $nerden,$kayitcan";
break;
 
}
if(!$sql)
{
die();
}
$data = mysql_query($sql);
 
// This creates a loop which will repeat itself until there are no more rows to select from the database. We getting the field names and storing them in the $row variable. This makes it easier to echo each field.
while($row = mysql_fetch_assoc($data)): ?>
<table border="0">
<tr>
<td><b><? echo "<a href='
Bu forumdaki linkleri ve resimleri görebilmek için en az 25 mesajınız olması gerekir.
color='darkblue' size='2'><b><i> ".$row['baslik']." </b></a>"; ?></i></b></font></td>
</tr>
<tr>
<td><? $satirlar = explode(" ",$row[kod]);
$i = 0;
while ($i < 15){
echo $satirlar[$i]," ";
$i++;
} ?>
</td>
</tr>
<tr>
<td><right><? echo "<br><a href='
Bu forumdaki linkleri ve resimleri görebilmek için en az 25 mesajınız olması gerekir.
color='darkgreen'><b>
Bu forumdaki linkleri ve resimleri görebilmek için en az 25 mesajınız olması gerekir.
size="2"></tr>
<tr>
<td>&nbsp;</td>
</tr>
</table>
<?
endwhile;
 
$toplam = mysql_fetch_row(mysql_query("SELECT COUNT(*) FROM kodlar WHERE kod LIKE '%$item%'"));
$kacCem = ceil($toplam[0] / $kayitcan);
$i = 1;
echo "| ";
while ($i< $kacCem+1)
{
if($i <> $Cem){
echo " <a href='search.php?Cem=$i + & + '$data''><font color='#f7922e'>$i</font></a> | ";}
else {
echo "<font size='2'>$i</font> |";}
$i++;
}
?>
<br>
&nbsp;</p></td>
<td height="614" width="68">&nbsp;</td>
</tr>
<tr>
<td height="34" width="147">&nbsp;</td>
<td height="34" width="706">&nbsp;</td>
<td height="34" width="68">&nbsp;</td>
</tr>
</table>
<br>
</body>
</html>