/** * Create table * * @param string $name * @param array $data */ function createTable($name, $data) { $PDODb = PDODb::getInstance(); $PDODb->rawQuery("DROP TABLE IF EXISTS {$name}"); $query = "CREATE TABLE {$name} (id INT(9) UNSIGNED PRIMARY KEY AUTO_INCREMENT"; foreach ($data as $key => $value) { $query .= ", {$key} {$value}"; } $query .= ")"; $PDODb->rawQuery($query); }
public function testPagination() { $PDODb = PDODb::getInstance(); $PDODb->orderBy('id', 'ASC')->setPageLimit(2); $result = $PDODb->paginate('products', 1); $this->assertEquals(3, $PDODb->totalPages); $this->assertEquals(2, count($result)); }