Sql Katman Mysqli Veritabanı Sınıfı

PHP
80 lines
<?php
class SQLKatman {
var $sunucu;
var $kullaniciadi;
var $sifre;
var $veritabaniadi;
var $link;
function SQLKatman ($sunucu = "", $kullaniciadi = "", $pass = "", $veritabaniadi = "") {
$this->sunucu = $sunucu;
$this->kullaniciadi = $kullaniciadi;
$this->sifre = $pass;
$this->veritabaniadi = $veritabaniadi;
$this->baglan();
}
function baglan(){
$this->link=mysqli_connect($this->sunucu,$this->kullaniciadi,$this->sifre,$this->veritabaniadi);
mysqli_set_charset($this->link, "utf8");
}
function close(){
return mysqli_close($this->link);
}
function sorgu($sorgu){
$this->rs=mysqli_query($this->link,$sorgu);
if (!$this->rs){
echo("Hata: Hatalı sorgu \"".$sorgu."\"...<br>");
echo("Hata: ".mysqli_errno($this->link)."<br>");
die("Hata: ".mysqli_error($this->link)."<br>");
}else{
return $this->rs;
}
}
function veri_ara ($row = 0) {
return mysqli_data_seek($this->rs,$row);
}
function dizi_getir($rs=""){
if($rs==""){$rs=$this->rs;}
$this->row=mysqli_fetch_array($rs);
return $this->row;
}
function birles_getir($rs=""){
if($rs==""){$rs=$this->rs;}
$this->row=mysqli_fetch_assoc($rs);
return $this->row;
}
function nesne_getir($rs=""){
if($rs==""){$rs=$this->rs;}
$this->row=mysqli_fetch_object($rs);
return $this->row;
}
function satir_say($rs=""){
if($rs == ""){$rs=$this->rs;}
$rs = $this->rs;
return mysqli_num_rows($rs);
}
function etkilenen_satir() {
return mysqli_affected_rows($this->link);
}
function serbest_sonuc($rs = "") {
if($rs == ""){$rs=$this->rs;}
$rs = $this->rs;
return mysqli_free_result($rs);
}
}
$s=new SQLKatman("localhost","root","","php");
$s->sorgu("select * from php where id=1");
print_r($s->dizi_getir());echo "<br>";
$s->sorgu("select * from php where id=1");
print_r($s->birles_getir());echo "<br>";
$s->sorgu("select * from php where id=1");
print_r($s->nesne_getir());echo "<br>";
$s->sorgu("select * from php where id=1");
print_r($s->satir_say());echo "<br>";
$s->sorgu("select * from php where id=1");
print_r($s->etkilenen_satir());echo "<br>";
$s->sorgu("select * from php where id=1");
print_r($s->serbest_sonuc());
$s->sorgu("select * from php where id=1");
var_dump($s->veri_ara(2));
?>
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Çıktısı

PHP
6 lines
Array ( [0] => 1 [id] => 1 )
Array ( [id] => 1 )
stdClass Object ( [id] => 1 )
1
1
bool(false)
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

 

Sizin Değerli Görüşlerinize İhtiyacımız Var.