PHP BasicDB Examples

Example #1

File: PearDB.php Project: jsan4christ/idrc-uganda-site

 function query($query)
 {
     if (parent::query($query)) {
         return true;
     }
     if ($this->db != null) {
         $res = $this->db->query($query);
         if (is_a($res, "DB_Error")) {
             $this->_addError($res->message, 'query()');
         } else {
             $this->result = $res;
             return true;
         }
     }
     return false;
 }

Example #2

File: DbxDB.php Project: jsan4christ/idrc-uganda-site

 function query($query)
 {
     parent::query($query);
     if ($this->db != null) {
         $res =& $this->db->dbx_query($query);
         if (!$res) {
             $this->error = $this->db->dbx_error();
             $this->result = null;
             return false;
         } else {
             $this->result = $res;
             return true;
         }
     } else {
         return false;
     }
 }

Example #3

File: PhplibDB.php Project: jsan4christ/idrc-uganda-site

 function query($query)
 {
     parent::query($query);
     if ($this->db != null) {
         // submit query
         @$this->db->query($query);
         // everything fine?
         if ($this->db->Errno == 0) {
             return true;
             // save error msg
         } else {
             $this->error = $this->db->Error;
             return false;
         }
     } else {
         return false;
     }
 }

Example #4

File: PostgresDB.php Project: jsan4christ/idrc-uganda-site

 function query($query)
 {
     parent::query($query);
     $this->_count = 0;
     if ($this->db != null) {
         // submit query
         $this->result = @pg_query($this->db, $query);
         if ($this->result != false) {
             return true;
             // save error msg
         } else {
             $this->error = @pg_last_error($this->db);
             return false;
         }
     } else {
         return false;
     }
 }

Example #5

File: PearDB.php Project: jsan4christ/idrc-uganda-site

 function query($query)
 {
     parent::query($query);
     if ($this->db != null) {
         $res = $this->db->query($query);
         if (is_a($res, "DB_Error")) {
             $this->error = $res->message;
             //        $this->error .= " / CODE(" .$res->code . ") / MODE(" . $res->mode . ")";
             $this->result = null;
             return false;
         } else {
             $this->result = $res;
             return true;
         }
     } else {
         return false;
     }
 }

Example #6

File: SQLiteDB.php Project: jsan4christ/idrc-uganda-site

 function query($query)
 {
     parent::query($query);
     if ($this->db != null) {
         // submit query
         $this->result = @sqlite_unbuffered_query($this->db, $query);
         if ($this->result != false) {
             return true;
             // save error msg
         } else {
             $this->error = @sqlite_error_string(sqlite_last_error($this->db));
             $this->result = null;
             return false;
         }
     } else {
         return false;
     }
 }

Example #7

File: MysqlDB.php Project: jsan4christ/idrc-uganda-site

 function query($query)
 {
     parent::query($query);
     if ($this->db != null) {
         // submit query
         $this->result = @mysql_query($query, $this->db);
         if ($this->result != false) {
             //            $this->_updateCache($query, $cacheTime);
             return true;
             // save error msg
         } else {
             $this->error = @mysql_error($this->db);
         }
     }
     //    $this->_cachedRes = null;
     //    $this->fromCache = false;
     return false;
 }

Example #8

File: update_example.php Project: BatuAksoy/BasicDB

<?php

// class file
require 'BasicDB.php';
// connection
$db = new BasicDB('localhost', 'testdb', 'testuser', 'password');
// update
$query = $db->update('users')->where('user_id', 2)->set(array(username => 'another user'));
if ($query) {
    echo 'update success';
}

Example #9

File: ADOdbDB.php Project: jsan4christ/idrc-uganda-site

 function query($query)
 {
     parent::query($query);
     $this->_count = 0;
     if ($this->db != null) {
         $res = $this->db->Execute($query);
         if (!$res) {
             $this->error = $this->db->ErrorMsg();
             $this->result = null;
             return false;
         } else {
             $this->result = $res;
             return true;
         }
     } else {
         return false;
     }
 }

Example #10

File: MetabaseDB.php Project: jsan4christ/idrc-uganda-site

 function query($query)
 {
     parent::query($query);
     $this->_count = 0;
     $result = MetabaseQuery($this->db, $query);
     if ($result == 0) {
         $this->error = MetabaseError($this->db);
         return false;
     } else {
         $this->result = $result;
         return true;
     }
 }

Example #11

File: MysqlDB.php Project: jsan4christ/idrc-uganda-site

 function query($query)
 {
     parent::query($query);
     if ($this->db != null) {
         // submit query
         $this->result = @mysql_query($query, $this->db);
         if ($this->result != false) {
             return true;
             // save error msg
         } else {
             $this->_addError(@mysql_error($this->db), "query({$query})");
         }
     }
     return false;
 }

Example #12

File: select_example.php Project: BatuAksoy/BasicDB

<?php

// class file
require 'BasicDB.php';
// connection
$db = new BasicDB('localhost', 'testdb', 'testuser', 'password');
// select
$query = $db->select('post')->join('users', '%s.user_id = %s.post_userid', 'left')->where('post_approval', 1)->or_where('post_approval', 2)->orderby('post_id', 'desc')->groupby('post_user')->limit(0, 10)->run();
if ($query) {
    foreach ($query as $row) {
        print_r($row);
    }
}

Example #13

File: pagination_example.php Project: BatuAksoy/BasicDB

<?php

// class file
require 'BasicDB.php';
// connection
$db = new BasicDB('localhost', 'testdb', 'testuser', 'password');
// pagination example
$totalRecord = $db->select('users')->from('count(user_id) as total')->total();
$pageLimit = 4;
$pageParam = 'page';
$pagination = $db->pagination($totalRecord, $pageLimit, $pageParam);
$query = $db->select('users')->orderby('user_id', 'DESC')->limit($pagination['start'], $pagination['limit'])->run();
print_r($query);
echo $db->showPagination('http://localhost/test/?' . $pageParam . '=[page]');

Example #14

File: ADOdbDB.php Project: jsan4christ/idrc-uganda-site

 function query($query)
 {
     if (parent::query($query)) {
         return true;
     }
     $this->_count = 0;
     if ($this->db != null) {
         $res =& $this->db->Execute($query);
         if (!$res) {
             $this->_addError($this->db->ErrorMsg(), "query({$query})");
             $this->result = null;
             return false;
         } else {
             $this->result = $res;
             return true;
         }
     } else {
         return false;
     }
 }

Example #15

File: OdbcDB.php Project: jsan4christ/idrc-uganda-site

 function query($query)
 {
     if (parent::query($query)) {
         return true;
     }
     if ($this->db) {
         $this->result = @odbc_exec($this->db, $query);
         if (!$this->result) {
             $this->_addError(odbc_errormsg($this->db), "query({$query})");
         } else {
             return true;
         }
     }
     return false;
 }

Example #16

File: insert_example.php Project: BatuAksoy/BasicDB

<?php

// class file
require 'BasicDB.php';
// connection
$db = new BasicDB('localhost', 'testdb', 'testuser', 'password');
// insert
$query = $db->insert('users')->set(array(username => 'test user', password => 123456, email => '*****@*****.**'));
if ($query) {
    echo 'Last Insert Id: ' . $db->lastId();
}

Example #17

File: delete_example.php Project: BatuAksoy/BasicDB

<?php

// class file
require 'BasicDB.php';
// connection
$db = new BasicDB('localhost', 'testdb', 'testuser', 'password');
// delete
$query = $db->delete('users')->where('user_id', 2)->done();
if ($query) {
    echo 'user deleted';
}