Etiket: Sql Query

Sql Sorgu Kontrol Sınıfı

PHP
61 lines
<?php
class sqlKontrol{
    var $id_alan;
    var $id_deger;
    function sec($tablo,$alan,$deger){
        $sorgu="SELECT * FROM $tablo WHERE ";
        for($c=count($alan);$c>0;$c--) {
            $id=$c-1;
            $sorgu.=" ".$alan[$id]."='".$deger[$id]."' ";
            if($c-1!=0){
                $sorgu.=" AND ";
            }
        }
        return $sorgu;
    }
    function guncelle($tablo,$alan,$deger){
        $sorgu="UPDATE $tablo SET ";
        for($c=count($alan);$c>0;$c--) {
            $id=$c-1;
            $sorgu.=" ".$alan[$id]."='".$deger[$id]."' ";
            if($c-1!=0){
                $sorgu.=" , ";
            }
        }
        $sorgu.=" WHERE $this->id_alan = '$this->id_deger'";
        return $sorgu;
    }
    function ekle($tablo,$alan,$deger){
        $sorgu="INSERT INTO $tablo SET ";
        for($c=count($alan);$c>0;$c--) {
            $id=$c-1;
            $sorgu.=" ".$alan[$id]."='".$deger[$id]."' ";
            if($c-1!=0){
                $sorgu.=" , ";
            }
        }
        return $sorgu;
    }
    function sil($tablo,$alan,$deger){
        $sorgu="DELETE FROM $tablo WHERE ";
        for($c=count($alan);$c>0;$c--) {
            $id=$c-1;
            $sorgu.=" ".$alan[$id]."='".$deger[$id]."' ";
            if($c-1!=0){
                $sorgu.=" AND ";
            }
        }
        return $sorgu;
    }
} 
$data = new sqlKontrol;
echo $data->sec('table',['name1','name2'],['value1','value2']);
echo "<br>";
$data->id_alan="id";
$data->id_deger="1";
echo $data->guncelle('table',['name1','name2'],['value1','value2']);
echo "<br>";
echo $data->ekle('table',['name1','name2'],['value1','value2']);
echo "<br>";
echo $data->sil('table',['name1','name2'],['value1','value2']);
?>
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Çıktısı

Markdown
5 lines
SELECT * FROM table WHERE name1='value1' 
SELECT * FROM table WHERE name2='value2' AND name1='value1' 
UPDATE table SET name2='value2' , name1='value1' WHERE id = '1'
INSERT INTO table SET name2='value2' , name1='value1' 
DELETE FROM table WHERE name2='value2' AND name1='value1'
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX