Database functions

Here are the articles in this section:
array_depth()
Get maximum depth of a hierarchy tree.
column_exists()
Determine whether column exists in a table.
db_exists()
Check if a table exists.
dbarray()
Fetch one row as an associative array.
dbarraynum()
Fetch one row as a numeric array.
dbconnect()
Connect to the database.
dbconnection()
Get the AbstractDatabase instance.
dbcount()
Count the number of rows in a table.
dblastid()
Get the last inserted auto_increment id.
dbnextid()
Get the next auto_increment id of a table.
dbquery()
Send a database query.
dbquery_insert()
MYSQL Row modifiers. Insert/Update/Delete.
dbquery_order()
Table rows ordering.
dbquery_tree()
Hierarchy ID to category output.
dbquery_tree_full()
Hierarchy full data output.
dbresult()
Fetch the first column of a specific row.
dbrows()
Count the number of rows in a given database query.
dbtree()
Get hierarchy array with injected child key.
dbtree_index()
Lighter version of dbtree() with only id and child key.
display_parent_nodes()
Display parent nodes.
fieldgenerator()
MYSQL show columns shorthand.
get_all_parent()
Get parent IDs from dbquery_tree() result.
get_depth()
Get current depth from dbquery_tree() result.
get_hkey()
Get tree root ID of a child via SQL. Alternative function to get_root().
get_child()
Get child IDs from dbquery_tree() result.
get_parent()
Get immediate parent ID from dbquery_tree() result.
get_parent_array()
Get immediate parent array from dbquery_tree_full() result.
get_root()
Get tree root ID of a child from dbquery_tree() result.
in_group()
SQL statement helper to find values in between dots.
multilang_column()
Multilang column.
multilang_table()
Check multilang tables.
reduce_tree()
Reduce the results of a hierarchy tree array to a non multidimensional single output value while preserving keys.
search_field()
Single column search.
sort_tree()
To sort key on dbtree_index results.
sorter()
Sort tree an associative array.
tree_count()
Count result from dbquery_tree().
tree_depth()
Get the total max depths of dbtree().
tree_index()
Get index information from dbquery_tree_full().