Php ile Arama motoru yapmak

1. < html>
2. < head>
3. < title>PHP ile veritabaninda Arama Ornegi – turk-php.com
4. < /head>
5. < body>
7. < ?php
9. $string=$_POST['string'];
11. echo $string;
13. $baglanti=mysql_connect(“localhost“,“root“,“”);
15. mysql_select_db(“veritabani_adi“);
17. $SQL=“SELECT id FROM edergi WHERE makale_keywords like ‘%$string%’ or makale_ad like
19. ‘%$string%’ or makale_yazar like ‘%$string%’“;
21. $sorgu=mysql_query($SQL) ;
23. if (!$sorgu)
25. {
27. echo “Hata Olustu:

    “ . mysql_error() . ““); exit();

29. }
31. $arguman=0;
33. $adet=0;
35. while($sira=mysql_fetch_array($sorgu))
37. {
39. $sonuc[$arguman]=$sira["id"];
41. $arguman++;
44. }
46. if($string{0}!=‘“‘)
48. {
50. $pieces=explode(“ “,$string);
52. for($i=0;$i<(count($pieces)-1);$i++)
54. {
56. $SQL=“SELECT id FROM edergi WHERE makale_keywords like ‘%$pieces[$i]%’or
58. makale_yazar like ‘%$pieces[$i]%’ or makale_ad like ‘%$pieces[$i]%’ “;
60. $sorgu=mysql_query($SQL) ;
62. if (!$sorgu)
64. { echo(“Hata Olustu:

    “ . mysql_error() . ““); exit();}

66. $i=0;
68. echo count($sonuc);
71. while($sira=mysql_fetch_array($sorgu))
73. {
75. while($i<(count($sonuc)-1))
77. {
79. if($sira["id"]!=$sonuc[$i])
81. $sonuc[$arguman]=$sira["id"];
83. $arguman++;
85. $i++;
87. }
89. }
91. }
93. }
95. for($i=0;$i<count($sonuc);$i++)
97. {
99. $SQL=“SELECT * FROM edergi WHERE id=’$sonuc[$i]‘“;
101. $sorgu=mysql_query($SQL) ;
103. if (!$sorgu)
105. { echo(“Hata Olustu:

     “ . mysql_error() . ““); exit();}

107. while($sira=mysql_fetch_array($sorgu))
109. {
111. echo $sira["makale_ad"];
113. ? >
115. < BR>
117. < ?php
119. }
121. }
123. ? >
125. < /body>
127. < /html>