コード例 #1
0
 /**
  * @param array $fields
  * @param array|string|bool $order
  * @return ICmdSelect
  */
 protected function createQuery(array $fields, $order = false)
 {
     $query = $this->connector->select()->from($this->tableName);
     $this->createFilter($query, $fields);
     if (is_string($order)) {
         $query->orderBy($order);
     } else {
         if (is_array($order)) {
             foreach ($order as $field => $type) {
                 $query->orderBy($field, $type);
             }
         }
     }
     return $query;
 }
コード例 #2
0
 /**
  * @param string $key
  * @return string|null
  */
 public function get($key)
 {
     return $this->connector->select()->columns('Data')->from($this->tableName)->byField('ID', $key)->queryScalar(null, false);
 }