PHP ile MySQL veritabanında Arama Örneği
Asagidaki kod parcasi mysql veritabaninda nasil arama islemi yapabileceginizi anlatmaktadir.
PHP:
<html>
<head>
<title>PHP ile veritabaninda Arama Ornegi - turk-php.com</title>
</head>
<body>
<?php
$string=$_POST['string'];
echo $string;
$baglanti=mysql_connect("localhost","root","");
mysql_select_db("veritabani_adi");
$SQL="SELECT id FROM edergi WHERE makale_keywords like '%$string%' or makale_ad like
'%$string%' or makale_yazar like '%$string%'";
$sorgu=mysql_query($SQL) ;
if (!$sorgu)
{
echo "<P>Hata Olustu: " . mysql_error() . "</P>"); exit();
}
$arguman=0;
$adet=0;
while($sira=mysql_fetch_array($sorgu))
{
$sonuc[$arguman]=$sira["id"];
$arguman++;
}
if($string{0}!='"')
{
$pieces=explode(" ",$string);
for($i=0;$i<(count($pieces)-1);$i++)
{
$SQL="SELECT id FROM edergi WHERE makale_keywords like '%$pieces[$i]%'or
makale_yazar like '%$pieces[$i]%' or makale_ad like '%$pieces[$i]%' ";
$sorgu=mysql_query($SQL) ;
if (!$sorgu)
{ echo("<P>Hata Olustu: " . mysql_error() . "</P>"); exit();}
$i=0;
echo count($sonuc);
while($sira=mysql_fetch_array($sorgu))
{
while($i<(count($sonuc)-1))
{
if($sira["id"]!=$sonuc[$i])
$sonuc[$arguman]=$sira["id"];
$arguman++;
$i++;
}
}
}
}
for($i=0;$i<count($sonuc);$i++)
{
$SQL="SELECT * FROM edergi WHERE id='$sonuc[$i]'";
$sorgu=mysql_query($SQL) ;
if (!$sorgu)
{ echo("<P>Hata Olustu: " . mysql_error() . "</P>"); exit();}
while($sira=mysql_fetch_array($sorgu))
{
echo $sira["makale_ad"];
?>
<BR>
<?php
}
}
?>
</body>
</html>
Yukaridaki kodun renklendirilmis haline asagidaki linkten erisebilirsiniz:
Program:
|