Hello all,
I ran into something rather troubling today and wanted to run it by folks here to see what it is that I screwed up.
We have a PHP app that attaches to a MySQL database. It does some real basic queries which filters based on security and displays a bunch of job data. Everything seemed to be working quite well.
Today we got a call from one of our users who has Office XP. They have a "Export to Microsoft Excel" option when they right-click. Not a huge deal. Well, not quite. When they right click and do the export they get ALL the data, not just what was on the screen.
When I tried it, sure enough, all the data out of my database (not just the data on the screen) was pulled into Excel.
For the moment I have disabled the right-click functions, but long term I would like to solve this.
Is there something in the setup of PHP/MySQL that I missed and should have set to prevent this? How the heck are they getting directly into the database to pull the info?
Any help would be greatly appreciated.
-Dave
