<% Function QueryFilter(Str) Str = Replace(Str, "*", "[INJ]",1,-1,1) Str = Replace(Str, "=", "[INJ]",1,-1,1) Str = Replace(Str, "<", "[INJ]",1,-1,1) Str = Replace(Str, ">", "[INJ]",1,-1,1) Str = Replace(Str, ";", "[INJ]",1,-1,1) Str = Replace(Str, "(", "[INJ]",1,-1,1) Str = Replace(Str, ")", "[INJ]",1,-1,1) Str = Replace(Str, "+", "[INJ]",1,-1,1) Str = Replace(Str, "#", "[INJ]",1,-1,1) Str = Replace(Str, "'", "[INJ]", 1, -1, 1) Str = Replace(Str, "&", "[INJ]", 1, -1, 1) Str = Replace(Str, "%", "[INJ]", 1, -1, 1) Str = Replace(Str, "?", "[INJ]", 1, -1, 1) Str = Replace(Str, "´", "[INJ]", 1, -1, 1) Str = Replace(Str, ",", "[INJ]",1,-1,1) Str = Replace(Str, "UNION", "[INJ]",1,-1,1) Str = Replace(Str, "SELECT", "[INJ]",1,-1,1) Str = Replace(Str, "WHERE", "[INJ]",1,-1,1) Str = Replace(Str, "LIKE", "[INJ]",1,-1,1) Str = Replace(Str, "FROM", "[INJ]",1,-1,1) Str = Replace(Str, "UPDATE", "[INJ]",1,-1,1) Str = Replace(Str, "INSERT", "[INJ]",1,-1,1) Str = Replace(Str, "ORDER", "[INJ]",1,-1,1) Str = Replace(Str, "GROUP", "[INJ]",1,-1,1) Str = Replace(Str, "ALTER", "[INJ]",1,-1,1) Str = Replace(Str, "ADD", "[INJ]",1,-1,1) Str = Replace(Str, "MODIFY", "[INJ]",1,-1,1) Str = Replace(Str, "RENAME", "[INJ]",1,-1,1) Str = Replace(Str, Chr(39), "[INJ]", 1, -1, 1) If InStr(1,Str,"[INJ]",1) then Response.Redirect "Default.asp" end if QueryFilter = Str End Function %> <% Harfler = "ABCDEFGHIJKLMNOPQRSTUVWXYZ" Aranan = Temizle(QueryFilter(Request.QueryString("aranan"))) Bolgesi = Temizle(QueryFilter(Request.QueryString("bolge"))) Harf = Temizle(QueryFilter(Request.QueryString("harf"))) Set Bag2 = Server.CreateObject("ADODB.Connection") Bag2.Open "Driver={Microsoft Text Driver (*.txt; *.csv)}; Dbq=" & Server.MapPath(".") & "; Extensions=asc,csv,tab,txt; Persist Security Info=False" %>
HAVAYOLU ŞİRKETLERİNİN UÇUŞ KODLARI
Arama Yapın: " style="width:120px">
Harfe Göre Sırala: <% For i=1 To Len(Harfler) Response.Write "" & Mid(Harfler,i,1) & "  " Next %>
<% KayitSayisi = 21 If QueryFilter(Request.QueryString("s")) <> "" Then Sayfa = CInt(QueryFilter(Request.QueryString("s"))) Else Sayfa = 1 End If If Aranan <> "" Then Set Rs = Server.CreateObject("ADODB.Recordset") SQL = "SELECT * FROM havayolu.txt WHERE FirmaAdi LIKE '%" & Aranan & "%'" Rs.Open SQL, Bag2, 1, 3 ElseIf Harf <> "" Then Set Rs = Server.CreateObject("ADODB.Recordset") SQL = "SELECT * FROM havayolu.txt WHERE FirmaAdi LIKE '" & Harf & "%'" Rs.Open SQL, Bag2, 1, 3 Else Set Rs = Server.CreateObject("ADODB.Recordset") SQL = "SELECT * FROM havayolu.txt WHERE FirmaAdi LIKE 'A%'" Rs.Open SQL, Bag2, 1, 3 End If Set Havayolu = Server.CreateObject("ADODB.Recordset") 'Bag2.Execute(SQL) Havayolu.Open SQL, Bag2, 1, 3 %> <% If Not Havayolu.EOF Then Havayolu.PageSize = KayitSayisi Havayolu.CacheSize = Rs.PageSize Havayolu.AbsolutePage = Sayfa TopKayit = Rs.RecordCount i=0 Do While Not Havayolu.EOF And i <% i=i+1: Havayolu.MoveNext: Loop %> <% Else %> <% End If %>
Havayolu Şirketi Uçuş Kodu
<%=Havayolu("FirmaAdi")%> <%=Havayolu("Kod")%>
<% If CInt(TopKayit) > CInt(KayitSayisi) Then SayfaSayisi = CInt(TopKayit) / CInt(KayitSayisi) If InStr(1,SayfaSayisi,",",1) > 0 Then SayfaSayisi = CInt(Left(SayfaSayisi,InStr(1,SayfaSayisi,",",1))) + 1 If SayfaSayisi > 1 Then Response.Write "Devam: " TopKayit = SayfaSayisi TopSayfa = 10 Onceki = Sayfa - (TopSayfa/2) If Onceki <= 0 Then Onceki = 1 Sonraki = Sayfa + (TopSayfa/2) If Sonraki < TopSayfa Then Sonraki = TopSayfa If Sonraki > TopKayit Then Sonraki = TopKayit If Onceki <> 1 Then Response.Write "<< İlk | " For i=Onceki To Sayfa-1 Response.Write "" & i & " - " Next Response.write "[" & Sayfa & "] " If Sayfa <> TopKayit Then Response.Write "- " For i=Sayfa+1 To Sonraki Response.Write "" & i & " " If i <> Sonraki Then Response.Write "- " Next If Sonraki <> TopKayit Then Response.Write "| Son >> " End If End If %>

Veritabanında Kayıt Bulunamadı!

<%=DikeyBol%>
<%=Hr%>