www.hkvforums.com

Hi
Can anyone help me to create a button in a Custom file to export a query into Excel?
so i have ..
$sql = "Query";
echo $db->ExecuteHtml($sql, array( "fieldcaption" => TRUE, "tablename" => array("status")));
Displays the result
then i would like a button to click on to export it into excel.

many thanks in advanced

You need to refer to the function "ExportData" in the generated files and write your own script to handle the export.

If you need export feature, you better create a view for the table instead of using Custom File.

Thanks, can you help i have no idea how to do this?
Just need a button to click on the download the export.

cheers

1. Create a button with the link that has a parameter to tell the custom page you need to export.
   e.g. <Custom Page>.php?export=excel

2. In the custom page, you need to check the parameter and handle the export.
   e.g.

if (@$_GET["export"] == "excel") {
//code to perform the export.
}

You can refer to the function "ExportData" in the generated files and write your own script to handle the export.

As said:
If you need export feature, you better create a view for the table instead of using Custom File.

Hi
Can anyone help with a example on who to use the ExportData function from within a custom page?
many thanks

arbei wrote:
You can refer to the function "ExportData" in the generated files and write your
own script to handle the export.

See and learn the code from "ExportData" function in the generated *list and/or *view.php files.