DB Connect

This is a simple class that can connect to a MySQL database, execute an SQL query and retrieve the result set rows and the respective metadata.

The class get function executes an SQL query and returns status of success of the executed query, the number of rows, the number of columns, the total number or result cells, and the list of names of the result columns as part of the result set array. The metadata result fields are prefixed with & to avoid confusion with the result column names.

Depending on the number of rows and columns contained in the result set, it may contain a two dimension array with all the data of the result columns and rows, or just an array with the data of one column or one row, or just one result value.