CJones
Final Approach
OK guys.. I feel like I'm chasing my own tail here.
I am using PHP to pull a large chunk of data from Oracle and mySQL. I combine the results from these queries into one large array. I use the array and PHP to write HTML to display the data on a webpage. I would like to be able to export the data from the array to Excel as well, but WITHOUT having to run the queries again (for speed reasons).
I know I can redirect to a new page and have PHP run the queries again and use header(...) to export to Excel, but that requires running the queries again. I also don't want to use the header(...) on the current page because I don't want to lose the data that is displayed on the current page and have to wait for it to refresh.
I tried using PHP to write JavaScript that creates an AciveXObject, but that only works in IE and only if security levels are set to allow ActiveX objects. Since I am in a corporate environment, the IE security is set too high and I don't want to deal with it getting reset by a logon script if someone manually adjusts it low enough for my page to work.
Any ideas on how I can make this work without having to run the queries again? I think I've thought about it for so long that I'm starting to confuse myself...
I am using PHP to pull a large chunk of data from Oracle and mySQL. I combine the results from these queries into one large array. I use the array and PHP to write HTML to display the data on a webpage. I would like to be able to export the data from the array to Excel as well, but WITHOUT having to run the queries again (for speed reasons).
I know I can redirect to a new page and have PHP run the queries again and use header(...) to export to Excel, but that requires running the queries again. I also don't want to use the header(...) on the current page because I don't want to lose the data that is displayed on the current page and have to wait for it to refresh.
I tried using PHP to write JavaScript that creates an AciveXObject, but that only works in IE and only if security levels are set to allow ActiveX objects. Since I am in a corporate environment, the IE security is set too high and I don't want to deal with it getting reset by a logon script if someone manually adjusts it low enough for my page to work.
Any ideas on how I can make this work without having to run the queries again? I think I've thought about it for so long that I'm starting to confuse myself...