PHP lmbSqliteRecord Examples

Example #1

File: lmbSqliteQueryStatement.class.php Project: knevcher/limb

 function getOneRecord()
 {
     $record = new lmbSqliteRecord();
     $queryId = $this->connection->execute($this->getSQL());
     $values = sqlite_fetch_array($queryId, SQLITE_ASSOC);
     if (is_array($values)) {
         $record->import($values);
         return $record;
     }
 }

Example #2

File: lmbSqliteRecordSet.class.php Project: knevcher/limb

 function at($pos)
 {
     $query = $this->query;
     if (is_array($this->sort_params)) {
         $query .= ' ORDER BY ';
         foreach ($this->sort_params as $field => $order) {
             $query .= $this->connection->quoteIdentifier($field) . " {$order},";
         }
         $query = rtrim($query, ',');
     }
     $queryId = $this->connection->execute($query . " LIMIT 1 OFFSET {$pos}");
     $res = sqlite_fetch_array($queryId, SQLITE_ASSOC);
     if (is_array($res)) {
         $record = new lmbSqliteRecord();
         $record->importRaw($res);
         return $record;
     }
 }