Output mysql data to csv/txt file using php script

Question

I am trying to output mysql columns to txt-file using php script, the query works fine on mysql but fails on php. When clicked on the button the function returns Internal Server error.

function RsyncFTPAction() {
$sql = "SELECT CONCAT("sshpass -p ""Password""  rsync   -avvtzh -e  ""ssh -o StrictHostKeyChecking=no""  --log-file=""/home/toor/rsync2.log""",   login,"@", ftp_addr, " :", camera_name,"/",    "/",'home',"/",login, "/", camera_name)
FROM inteliviz.cameras order by id INTO OUTFILE '/tmp/wptitles2.csv' LINES TERMINATED BY '\r\n'";
        $result = $conn->Execute($sql);
        if(!$result) {
            print $conn -> ErrorMsg(); ;
            exit;
        }
}

Farkie · Accepted Answer · 2015-12-07 11:23:52Z

1

You need to escape your quotes - or easier.. switch to single quotes, and escape them (there's less of them!)

$sql = 'SELECT CONCAT("sshpass -p ""Password""  rsync   -avvtzh -e  ""ssh -o StrictHostKeyChecking=no""  --log-file=""/home/toor/rsync2.log""",   login,"@", ftp_addr, " :", camera_name,"/",    "/",`'home`',"/",login, "/", camera_name)
FROM inteliviz.cameras order by id INTO OUTFILE \'/tmp/wptitles2.csv\' LINES TERMINATED BY \'\r\n\'';

edited Dec 7, 2015 at 11:23

answered Dec 7, 2015 at 10:05

Farkie

3,3372 gold badges25 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

swidmann Over a year ago

I can't see, that you escaped the quotes

Farkie Over a year ago

..The single quotes are escaped, rather than the double ones.

swidmann Over a year ago

This will still end up in a parse error. For example here: ,'home

Farkie Over a year ago

Ah yes, Missed one, I gave him the correct answer though, not all SO is meant to be copy and paste :)

Collectives™ on Stack Overflow

Output mysql data to csv/txt file using php script

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related