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")