Kaynak : Http://dostuz.biz/forum/aramada-if-t237974.html
LIMIT - karışık - - echo - - DESC - - - - - echo - - $nerden,$kacar"[/COLOR][COLOR=#007700]);
- - [/COLOR][COLOR=#DD0000]""[/COLOR][COLOR=#007700];
- bulunamadı - diyor - filtre - - [/COLOR][COLOR=#DD0000]""[/COLOR][COLOR=#007700];
- - - die - bu - - - [/COLOR][COLOR=#007700]== - [/COLOR][COLOR=#DD0000]""[/COLOR][COLOR=#007700];
- arama - ([/COLOR][COLOR=#0000BB]$sorgu[/COLOR][COLOR=#007700][[/COLOR][COLOR=#0000BB]0[/COLOR][COLOR=#007700]] - where - - denedim - - - [/COLOR][COLOR=#007700]!=[/COLOR][COLOR=#0000BB]0[/COLOR][COLOR=#007700]) - - - - - * - - sadece - - [/COLOR][COLOR=#DD0000]""[/COLOR][COLOR=#007700];
- - koymazsam - echo - BY - [/COLOR][COLOR=#0000BB]0[/COLOR][COLOR=#007700];
- sorum - - - - - [/COLOR][COLOR=#0000BB]0[/COLOR][COLOR=#007700]) - - - - var - aşağıdaki - - - - - İf - daki - - - ama - - - [/COLOR][COLOR=#DD0000]""[/COLOR][COLOR=#007700];
- - - - - - - - [/COLOR][COLOR=#DD0000]""[/COLOR][COLOR=#007700];
- onsuzda - - like - - cümle - - echo - $sorgu[0] -
[/COLOR][/COLOR] [/LEFT]
Sorunlu - - }
- - - - if - - - - - - - varsa - - echo - if - kaldır - - ([/COLOR][COLOR=#0000BB]$sutun - - ORDER - - [/COLOR][COLOR=#DD0000]""[/COLOR][COLOR=#007700];
- kod - - '%$kod%' - [/COLOR][COLOR=#DD0000]"[B]"[/COLOR][COLOR=#007700].[/COLOR][COLOR=#0000BB]$data[/COLOR][COLOR=#007700][[/COLOR][COLOR=#0000BB]kod[/COLOR][COLOR=#007700]].[/COLOR][COLOR=#DD0000]"[/B]"[/COLOR][COLOR=#007700];
- ([/COLOR][COLOR=#0000BB]$sayfa[/COLOR][COLOR=#007700]==[/COLOR][COLOR=#DD0000]""[/COLOR][COLOR=#007700]) - - - - - - - - echo - (![/COLOR][COLOR=#0000BB]is_numeric[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$sayfa[/COLOR][COLOR=#007700])) - ise - - - Arkadaşlar - [/COLOR][COLOR=#DD0000]""[/COLOR][COLOR=#007700];
- - - FROM - - ı - buyrun - - - [/COLOR][COLOR=#007700]= - sayfalamada - - - Kodu:
[LEFT] [COLOR=#000000][COLOR=#0000BB]$db - while - - aşağıda - {
[/COLOR][COLOR=#0000BB]$sayfasayisi[/COLOR][COLOR=#007700]++;
}
[/COLOR][COLOR=#0000BB]$nerden[/COLOR][COLOR=#007700]=([/COLOR][COLOR=#0000BB]$sayfa[/COLOR][COLOR=#007700]*[/COLOR][COLOR=#0000BB]$kacar[/COLOR][COLOR=#007700])-[/COLOR][COLOR=#0000BB]$kacar[/COLOR][COLOR=#007700];
[/COLOR][COLOR=#0000BB]$sorgu2[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000BB]mysql_query[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"SELECT - - - - - var - diye - - - - şu - where - var - if - Bulunamadı.Aranan - - - buluyor - - {
[/COLOR][COLOR=#0000BB]$sayfa[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000BB]1[/COLOR][COLOR=#007700];
}
if - - - - - - echo - Ürün - türlü - == - onu - echo - - - - [/COLOR][COLOR=#0000BB]trim[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$kod[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]$sorgu - - filtre - biraz - - - - - echo - koyunca - {
- - - ($sorgu[0]==0) - Ba?lanylamady'[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]mysql_select_db[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]'filter'[/COLOR][COLOR=#007700],[/COLOR][COLOR=#0000BB]$db[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#FF8000]///Arama
[/COLOR][COLOR=#0000BB]$kod[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000BB]$_GET[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'ara'[/COLOR][COLOR=#007700]];
[/COLOR][COLOR=#0000BB]$kod[/COLOR][COLOR=#007700]= - Ürün:[I]$kod[/I][/B]"[/COLOR][COLOR=#007700];
- - - - demeyin - başlayan - - - - - - - - like - [/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000BB]mysql_fetch_array[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]mysql_query[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"select - {
[/COLOR][COLOR=#0000BB]$sayfa[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000BB]1[/COLOR][COLOR=#007700];
}
[/COLOR][COLOR=#0000BB]$sayfasayisi[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000BB]$sorgu[/COLOR][COLOR=#007700][[/COLOR][COLOR=#0000BB]0[/COLOR][COLOR=#007700]]/[/COLOR][COLOR=#0000BB]$kacar[/COLOR][COLOR=#007700];
if - [/COLOR][COLOR=#0000BB]mysql_connect[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]'localhost'[/COLOR][COLOR=#007700],[/COLOR][COLOR=#DD0000]'tolgay'[/COLOR][COLOR=#007700],[/COLOR][COLOR=#DD0000]'ttoklar'[/COLOR][COLOR=#007700]) - - [/COLOR][COLOR=#0000BB]$sutun[/COLOR][COLOR=#007700]++;
- - {
- - [/COLOR][COLOR=#DD0000]"5"[/COLOR][COLOR=#007700]) - - - - {
- or - ([/COLOR][COLOR=#0000BB]$data[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000BB]mysql_fetch_array[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$sorgu2[/COLOR][COLOR=#007700])) - - [/COLOR][COLOR=#DD0000]""[/COLOR][COLOR=#007700];
- her - - }
- - - - - - - [/COLOR][COLOR=#0000BB]$sutun[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000BB]0[/COLOR][COLOR=#007700];
- - kod - - kodları - - if - - php - - - - - - - '%.$kod.%'"[/COLOR][COLOR=#007700]));
[/COLOR][COLOR=#FF8000]///Sayfalama
[/COLOR][COLOR=#0000BB]$kacar[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000BB]15[/COLOR][COLOR=#007700];
[/COLOR][COLOR=#0000BB]$sayfa[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000BB]$_GET[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'page'[/COLOR][COLOR=#007700]];
if - - 0 - exit;
- - - COUNT(*) - - - yüzden - kullanılıyor - olmadı - - [/COLOR][COLOR=#0000BB]$sutun - sayfası - - echo - - - li - [/COLOR][COLOR=#DD0000]"[B]Aranan - Sistemde - - echo - - kodlar
PHP - [/COLOR][COLOR=#007700]= - - Aramada - - id - - - - - ([/COLOR][COLOR=#0000BB]$sorgu[/COLOR][COLOR=#007700]%[/COLOR][COLOR=#0000BB]$kacar - } - ([/COLOR][COLOR=#DD0000]'Veritabanyna - - - -
- from -