Example PDO

/**
 * Contoh menggunakan PDO
 * Sebelum mencoba PDO, pastikan terlebih dahulu konfigurasi di file config.php, menggunakan class PDO
 * Hanya untuk database MySql.
 */
class Data_User_PDO extends elDB
{
    private $id_user;
    private $username;
    private $email;
    private $password;

    public function setIdUser($value)
    {
        $this->id_user = trim($value);
    }
    public function setUsername($value)
    {
        $this->username = trim($value);
    }
    public function setEmail($value)
    {
        $this->email = trim($value);
    }
    public function setPassword($value)
    {
        $this->password = _md5(trim($value));
    }

    public function addData()
    {
        self::beginTransaction();
        self::query('insert into t_user(username,email,pass) VALUES(:username, :email, :pass)');

        self::bind(':username', $this->username);
        self::bind(':email',    $this->email);
        self::bind(':pass',     $this->password);

        $r = self::execute();
        self::endTransaction();
        return $r;
    }

    public function getDataUserSingle()
    {
        self::query("SELECT username FROM t_user WHERE username = :username limit 10");
        self::bind(':username', $this->username);
        $row = self::single();
        return $row;
    }

    public function getAllUser()
    {
        self::query('SELECT * FROM t_user limit 20');
        $row = self::resultset();
        return $row;
    }

    public function deleteData()
    {
        self::query('delete from t_user where id_user=:id_user');
        self::bind(':id_user', $this->id_user);
        $r= self::execute();
        return $r;
    }

    public function updateData()
    {
        self::query('update t_user set username=:username,email=:email,pass=:pass where id_user=:id_user');
        self::bind(':id_user',   $this->id_user );
        self::bind(':username',  $this->username );
        self::bind(':email',     $this->email );
        self::bind(':pass',      $this->password );
        $r = self::execute();
        return $r;
    }
}