Create Account

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5

i want to allow user to download query data from mySQL server
10-12-2016, 03:16 PM,
i want to allow user to download query data from mySQL server
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.EU 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.EU 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

Possibly Related Threads...
Thread Author Replies Views Last Post
  How to download Norton security software kristen11 2 615 07-08-2019, 07:18 PM
Last Post: anayasinha185
  How Big Data Tools help? Djlakhany 0 331 11-18-2018, 12:07 PM
Last Post: Djlakhany

Forum Jump:

Users browsing this thread: 1 Guest(s)

Community Software by MyBB.