Hi, I have a non-profit website that I've developed with PHP. I'm trying to make the logged in users can output letters in Word with selected data from a query in MySQL. I've tried to use PHPWord, the letters outputted with no data in the letters. Also I tried used PHP COM, but Hostforlife won't let me restart the server because it is shared.
Lastly I wrote a SELECT query with INTO OUTFILE '$file' to create a CSV which the users could download and use to merge into Word, but because the database user does not have FILE access, it produces this error:

Error: Access denied for user 'blabla'@'localhost' (using password: YES)

I think Hostforlife will not allow FILE privileges on a shared server. So, how can I get around this. Somehow I want to be able to at least write the query and download the data. Javascript? jQuery? or Something else? Any of you can help me?

Thanks in advance

PHPWord is probably a good start. If there were not any data in the letters, then there were mistakes in your php script. Try again or hire a programmer to do the job.
Javascript is not needed for this.

set below in the PHP scripts you write

<?php
error_reporting(E_ALL);
ini_set('display_errors', '1');

That will help to find the errors...

Cheers
j

I bolded the error above, in what you posted...did you understand that error?? The user you're specifying in the PHP file to connect to the database doesn't have permissions to that database, or you specified it incorrectly in your PHP file. Since you don't actually post the relevant parts of your PHP code that make this connection, we can't tell you which...read the "Question Guidelines" link in my posting signature.

Either create a user name that has read-only access to that database (more secure), or verify your connection credentials are correct.