tepisenordek
08-11-2007, 21:01 PM
Konu: PHP Yazar: Süleyman Eker Tarih: 12/31/03
Asagidaki kod parcasi mysql veritabaninda nasil arama islemi yapabileceginizi anlatmaktadir.Lutfen
yorumlarinizi makalenin en altindaki bolume ekleyiniz...
PHP:
1.
2. <html>
3. <head>
4. <title>PHP ile veritabaninda Arama Ornegi - turk-php.com</title>
5. </head>
6. <body>
7.
8. <?php
9.
10. $string=$_POST['string'];
11.
12. echo $string;
13.
14. $baglanti=mysql_connect("localhost","root","");
15.
16. mysql_select_db("veritabani_adi");
17.
18. $SQL="SELECT id FROM edergi WHERE makale_keywords like '%$string%' or makale_ad like
19.
20. '%$string%' or makale_yazar like '%$string%'";
21.
22. $sorgu=mysql_query($SQL) ;
23.
24. if (!$sorgu)
25.
26. {
27.
28. echo "<P>Hata Olustu: " . mysql_error() . "</P>"); exit();
29.
30. }
31.
32. $arguman=0;
33.
34. $adet=0;
35.
36. while($sira=mysql_fetch_array($sorgu))
37.
38. {
39.
40. $sonuc[$arguman]=$sira["id"];
41.
42. $arguman++;
43.
44.
45. }
46.
47. if($string{0}!='"')
48.
49. {
50.
51. $pieces=explode(" ",$string);
52.
53. for($i=0;$i<(count($pieces)-1);$i++)
54.
55. {
56.
57. $SQL="SELECT id FROM edergi WHERE makale_keywords like '%$pieces[$i]%'or
58.
59. makale_yazar like '%$pieces[$i]%' or makale_ad like '%$pieces[$i]%' ";
60.
61. $sorgu=mysql_query($SQL) ;
62.
63. if (!$sorgu)
64.
65. { echo("<P>Hata Olustu: " . mysql_error() . "</P>"); exit();}
66.
67. $i=0;
68.
69. echo count($sonuc);
70.
71.
72. while($sira=mysql_fetch_array($sorgu))
73.
74. {
75.
76. while($i<(count($sonuc)-1))
77.
78. {
79.
80. if($sira["id"]!=$sonuc[$i])
81.
82. $sonuc[$arguman]=$sira["id"];
83.
84. $arguman++;
85.
86. $i++;
87.
88. }
89.
90. }
91.
92. }
93.
94. }
95.
96. for($i=0;$i<count($sonuc);$i++)
97.
98. {
99.
100. $SQL="SELECT * FROM edergi WHERE id='$sonuc[$i]'";
101.
102. $sorgu=mysql_query($SQL) ;
103.
104. if (!$sorgu)
105.
106. { echo("<P>Hata Olustu: " . mysql_error() . "</P>"); exit();}
107.
108. while($sira=mysql_fetch_array($sorgu))
109.
110. {
111.
112. echo $sira["makale_ad"];
113.
114. ?>
115.
116. <BR>
117.
118. <?php
119.
120. }
121.
122. }
123.
124. ?>
125.
126. </body>
127.
128. </html>
Asagidaki kod parcasi mysql veritabaninda nasil arama islemi yapabileceginizi anlatmaktadir.Lutfen
yorumlarinizi makalenin en altindaki bolume ekleyiniz...
PHP:
1.
2. <html>
3. <head>
4. <title>PHP ile veritabaninda Arama Ornegi - turk-php.com</title>
5. </head>
6. <body>
7.
8. <?php
9.
10. $string=$_POST['string'];
11.
12. echo $string;
13.
14. $baglanti=mysql_connect("localhost","root","");
15.
16. mysql_select_db("veritabani_adi");
17.
18. $SQL="SELECT id FROM edergi WHERE makale_keywords like '%$string%' or makale_ad like
19.
20. '%$string%' or makale_yazar like '%$string%'";
21.
22. $sorgu=mysql_query($SQL) ;
23.
24. if (!$sorgu)
25.
26. {
27.
28. echo "<P>Hata Olustu: " . mysql_error() . "</P>"); exit();
29.
30. }
31.
32. $arguman=0;
33.
34. $adet=0;
35.
36. while($sira=mysql_fetch_array($sorgu))
37.
38. {
39.
40. $sonuc[$arguman]=$sira["id"];
41.
42. $arguman++;
43.
44.
45. }
46.
47. if($string{0}!='"')
48.
49. {
50.
51. $pieces=explode(" ",$string);
52.
53. for($i=0;$i<(count($pieces)-1);$i++)
54.
55. {
56.
57. $SQL="SELECT id FROM edergi WHERE makale_keywords like '%$pieces[$i]%'or
58.
59. makale_yazar like '%$pieces[$i]%' or makale_ad like '%$pieces[$i]%' ";
60.
61. $sorgu=mysql_query($SQL) ;
62.
63. if (!$sorgu)
64.
65. { echo("<P>Hata Olustu: " . mysql_error() . "</P>"); exit();}
66.
67. $i=0;
68.
69. echo count($sonuc);
70.
71.
72. while($sira=mysql_fetch_array($sorgu))
73.
74. {
75.
76. while($i<(count($sonuc)-1))
77.
78. {
79.
80. if($sira["id"]!=$sonuc[$i])
81.
82. $sonuc[$arguman]=$sira["id"];
83.
84. $arguman++;
85.
86. $i++;
87.
88. }
89.
90. }
91.
92. }
93.
94. }
95.
96. for($i=0;$i<count($sonuc);$i++)
97.
98. {
99.
100. $SQL="SELECT * FROM edergi WHERE id='$sonuc[$i]'";
101.
102. $sorgu=mysql_query($SQL) ;
103.
104. if (!$sorgu)
105.
106. { echo("<P>Hata Olustu: " . mysql_error() . "</P>"); exit();}
107.
108. while($sira=mysql_fetch_array($sorgu))
109.
110. {
111.
112. echo $sira["makale_ad"];
113.
114. ?>
115.
116. <BR>
117.
118. <?php
119.
120. }
121.
122. }
123.
124. ?>
125.
126. </body>
127.
128. </html>