Jump to content

Archived

This topic is now archived and is closed to further replies.

daverose

Query works from shell but not PHP page

Recommended Posts

Hi,

 

I have a query that I\'m attempting to load from a PHP page that is not working. However, the exact same query works just fine when I run it from the MySQL command line.

 

This is the query:

LOAD DATA LOCAL INFILE \'/home/ratdog/public_html/test.txt\' INTO TABLE `shows`

 

I\'ve run similar queries through PHP with no problem, and I\'m absolutely stumped on why this won\'t work when it works fine from the command line.

 

Thanks for any help,

 

Dave

Share this post


Link to post
Share on other sites

a. does the webserver have access to that directory/file?

b. are you connecting to the db with a use that has the permission to run the query?

Share this post


Link to post
Share on other sites

Yes. I can run that same query that imports the data from that same file if I type it at the command line. Nothing happens from PHP though. (The same PHP script has other queries of the database, and those work properly.)

 

Thanks.

Share this post


Link to post
Share on other sites

By the way, I get the error:

 

ERROR: The used command is not allowed with this MySQL version

 

if I make it `shows` instead of \'shows\'

 

 

 

I get the error:

 

ERROR: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near \'\'shows\'\' at line 1

 

if I leave it as \'shows\'

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.