dbquery_tree_full()

Hierarchy full data output.

Versions: 9

dbquery_tree_full( string $db, string $id_col, string $cat_col [, bool $filter, string $query_replace ] ) : array

Parameters

$db (string) (Required) Table name.

$id_col (string) (Required) ID column.

$cat_col (string) (Required) Category column.

$filter (string) (Optional) Replace conditional structure. Default value: null

$query_replace (string) (Optional) Replace the entire query structure. Default value: null

Return Values

(array) Returns cat-id relationships with full data.

Examples

$data = dbquery_tree_full(DB_NEWS_CATS, 'news_cat_id', 'news_cat_parent');
/*
Array
(
[0] => Array
(
[1] => Array
(
[news_cat_id] => 1
[news_cat_parent] => 0
[news_cat_name] => Bugs
[news_cat_image] => bugs.svg
[news_cat_visibility] => 0
[news_cat_draft] => 0
[news_cat_sticky] => 0
[news_cat_language] => English
)
....
)
)
*/