public function getpaginateddata($position) { $connection = db_factory::factory(DB_TYPE); $sql = "SELECT id,name,message FROM PaginateDao ORDER BY id DESC LIMIT {$position} ," . ITEM_PER_PAGE; $results = $connection->getArray($sql); $this->populate($results, 'paginate'); }
public function getwithdata() { $connection = db_factory::factory(DB_TYPE); $sql = "select * from userdao order by username"; $results = $connection->getArray($sql); $this->populate($results, 'user'); }
public function index() { $connection = db_factory::factory(DB_TYPE); $sql = "SELECT COUNT(*) as num FROM PaginateDao"; $result = $connection->getArray($sql); $pages = ceil((int) $result[0]['num'] / ITEM_PER_PAGE); return $pages; }
public function deleteuser($user_id) { $connection = db_factory::factory(DB_TYPE); $sql = "DELETE FROM {$this->table} WHERE id = {$user_id}"; if ($connection->execute($sql)) { return "<h4>Delete Failed</h4>"; } else { return "<h4>Delete Successful</h4> "; } }
protected function update() { $connection = db_factory::factory(DB_TYPE); $sql = "update {$this->table} set "; $updates = array(); foreach ($this->values as $key => $value) { $updates[] = "`{$key}`='" . $connection->clean($value) . "'"; } $sql .= implode(',', $updates); $sql .= "where id={$this->id}"; $connection->execute($sql); }