示例#1
0
 private function meta_row_query($controller, $params)
 {
     if (isset($params['id'])) {
         $tables = $controller . '_meta, ' . $controller . '_lookup';
         //set variable value to retrieve all columns
         $columns = $controller . '_meta.*';
         $where = $controller . '_lookup.meta_id=' . $controller . '_meta.meta_id AND ' . $controller . '_lookup.' . $controller . '_id';
         $field = array($params['id']);
         //build single query from BuildQuery class
         $db_results = BuildQuery::single_field_query($tables, $columns, $where, $field);
         self::$db_meta_row = $db_results;
     }
 }
示例#2
0
 private function meta_row_query($controller, $format, $params)
 {
     if (isset($params['id'])) {
         $tables = $controller . '_meta, ' . $controller . '_lookup';
         //set variable value to retrieve all columns
         $columns = $controller . '_meta.*';
         if (!empty($format)) {
             $type_id = ContentController::get_content_type($controller, $format);
         }
         $where = $controller . '_lookup.meta_id=' . $controller . '_meta.meta_id AND ' . $controller . '_lookup.' . $controller . '_type_id=? AND ' . $controller . '_lookup.' . $controller . '_id=?';
         $field = array($type_id, $params['id']);
         //build single query from BuildQuery class
         $db_results = BuildQuery::single_lookup_query($tables, $columns, $where, $field);
         self::$db_meta_row = $db_results;
     }
 }