ORM

ORM.php

<?php

$username='s4l1h';
$email='s4l1h@maildengel.com';
$ad='Adı';
$soyad=' Soyadı';


// User sınıfı
class User extends ORM{
    
    protected $_table='user';
    protected $pk='id';
    protected $ai='id';
    
    public $ad;
    public $soyad;
    public $username;
    public $email;
    public $onay;
}


$user=new User();

if($user->exists_email($email)){
    echo 'Bu e-posta adresi kullanılıyor';
}elseif($user->exists_username($username)){
    echo 'Kullanıcı Adı Müsait değil';
}else{
    $user->ad=$ad
    $user->soyad=$soyad
    $user->username=$username;
    $user->onay='e';

    if($user->save()){
        echo 'Kayıt Başarılı';
    }
}
// SELECT ad,soyad FROM user WHERE onay='e' LIMIT 10
$user->onay('e')->limit(10)->select('ad,soyad');
$user->gR(); // Get Result 

$user->toArray(); // Sonucu Array olarak verir.
$user->toObject(); // Sonucu Obje olarak gverir.
$user->toJson(); // Sonucu Json olarak verir.

// SELECT * FROM user WHERE username='$username'
$user->getusername($username);
$user->gRo(); // Get result one

// SELECT * FROM user WHERE onay='e' AND username='$username'
$user->where_onay_and_username('e',$username);

// SELECT * FROM user onay!='e'
$user->where_not_onay('e');

// SELECT * FROM user WHERE onay='e' AND username<>'$username'
$user->where_onay_and_not_username('e',$username);

//SELECT * FROM user WHERE onay='e' AND onay='h';
$user->where_onay(array('e','h'));

//SELECT * FROM user ORDER BY id DESC
$user->all()->order("id","DESC");

// SELECT ad,email FROM user WHERE email='$email';
$user->where_email($email)->select('ad,email')->gRo();
$user->sync(); // Sync edelim

$user->ad='s4l1h2';

// UPDATE user SET ad='s4l1h2' WHERE email='$email'
$user->update('email');