public function getUserByFbId($uid) { $sql = SqlUtils::selectWhere(self::TABLE_USERS, "fb_uid = '{$uid}'"); $r = $this->handle->query($sql); $results = array(); while ($row = $r->fetchArray(SQLITE3_ASSOC)) { $results[] = $row; } return $results; }
public function searchBooks($name, $offset, $limit) { $sql = SqlUtils::selectWhere(self::TABLE_BOOKS, "name LIKE '%{$name}%'", $offset, $limit); $r = $this->handle->query($sql); $results = array(); while ($row = $r->fetchArray(SQLITE3_ASSOC)) { $results[] = $row; } return $results; }