I'm trying to create a script to ease the connection to MySQL for my users (without having to download an ODBC driver). And I've created a php-script that creates XML files out of the MySQL queries.
It works fine at the moment, but I'm concerned about the security and wonder if I could save the files to a directory outside the web root and access it from there instead. I've been googling the matter, but not found a solution.
I assume in PHP I would just save the XMLs to "/home/safedir/" instead of "/home/www/" but how would I connect to it again from an offline application (Excel VBA)? Is it even possible?