ASP ile mySQL baglanti
blogta ilk gun olmasindan kaynakli yuksek paylasim arzusu varken herseyi siralayalim.

MySQL Baglanti
DSN="DRIVER={MySQL ODBC 3.51 Driver}; SERVER=sunucu_adresi; PORT=1111; DATABASE=db_adi; USER=db_kullanici_adi; PASSWORD=sifre; OPTION=0;"
set ObjCon = server.CreateObject("ADODB.connection")
ObjCon.open DSN


Veri Guncelleme
("update tbl_adi set sutun = "& Request.Form("sutun_veri")&""`)


Veri Ekleme
("insert into tbl_adi(sutun)values('" & Request.Form("sutun_veri") & "')")


Veri Silme
("Delete from tbl_adi where id = x")


Veri Cekme (Secilen Veri)
("select * from tbl_adi where id = x")


Veri Cekme (10 Tane)
("select * from tbl_adi order by id limit 10")


Veri Cekme (10. kayit ve 20. kayit arasi)
("select * from tbl_adi order by id limit 10,20")
May 6, 2008
Ayberk Atasay
ASP
2 yorum