PHP lmbPgsqlRecord Examples

Example #1

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

 function getOneRecord()
 {
     $record = new lmbPgsqlRecord();
     $queryId = $this->connection->executeStatement($this);
     $values = pg_fetch_assoc($queryId);
     $record->import($values);
     pg_free_result($queryId);
     if (is_array($values)) {
         return $record;
     }
 }

Example #2

File: lmbPgsqlRecordSet.class.php Project: snowjobgit/limb

 function at($pos)
 {
     $stmt = clone $this->stmt;
     $stmt->free();
     if ($this->sort_params) {
         $stmt->addOrder($this->sort_params);
     }
     $stmt->addLimit($pos, 1);
     $queryId = $stmt->execute();
     $res = pg_fetch_assoc($queryId);
     pg_free_result($queryId);
     if ($res) {
         $record = new lmbPgsqlRecord();
         $record->import($res);
         return $record;
     }
 }