This class can be used to access MySQL database servers and display query results in HTML tables.
It can establish database connections to a given MySQL host, retrieve server database information, execute SQL queries, retrieve the inserted identifier by the last INSERT query, get the number of effected rows by a query, get the number of returned rows by a query, get the number of columns in a query result set, retrieve query result rows into arrays or objects.
The class can also generate HTML tables to display query result data or metadata about the query result columns. |