SqlToHtml(sSqlData, sHeading, sOptions) : string
This function provides a quick and easy way to view sql data.
sSqlData - The resulting string of a GSAK SQL query.
sHeading - The heading for the HTML generated table
sOptions - Comma delimited options. Currently only one being Y= display result in browser
The return result is the generated html code. You would normally include the Y option to display the HTML so the result can usually be ignored, but is provided so you can save to a file or further manipulate.
Note: You can run more than one sql command at a time and a function parameter may include a function, therefore the following report can actually be generated in just 2 lines of code (generate the data, run sqltohtml). However for clarity I have broken it down line by line.
# First create the required sql file $result = dbtosql("logs","lparent,ltype,llogid",$_Install + "\macros\logs.txt","") # get the sql data to display $result = sql("Select ltype as LogType, count(logtype) as total from logs GROUP by logtype ORDER by logtype","H") # display the data $html = sqltohtml($result,"Summary by log type","y") |
This should open up a report in your browser that looks something like:
This generated report allows you to sort any column by clicking on the column heading
Also see the SQL() function
Summary