function plugin_details($plugin_id) { if (isset($plugin_id)) { $table = DB_PLUGINS; //set variable value to retrieve all columns $column = '*'; $where = 'plugin_id'; $field = array($plugin_id); //build single query from BuildQuery class $db_results = BuildQuery::single_field_query($table, $column, $where, $field); self::$db_plugin_details = $db_results; } }
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; } }
private function content_field_query($controller, $format, $params) { if (isset($params['id'])) { $table = $controller; $column = $controller . $format; $where = "contentid"; $field = array($params['id']); //build single query from BuildQuery class $db_results = BuildQuery::single_field_query($table, $column, $where, $field); $db_result = $db_results[$column]; self::$db_content_field = $db_result; } }
private function content_type_query($controller, $format) { $table = $controller . '_type'; $column = $controller . '_type_id'; $where = $controller . "_type_name"; $field = array($format); //build single query from BuildQuery class $db_results = BuildQuery::single_field_query($table, $column, $where, $field); $db_result = $db_results[$column]; self::$db_content_type = $db_result; }