使用php脚本将mysql数据输出到csv/txt文件 - Output mysql data to csv/txt file using php script

Output mysql data to csv/txt file using php script

我正在尝试使用php脚本将mysql列输出到txt-文件，查询在mysql上运行良好，但在php上失败。单击按钮后，函数将返回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;
        }
}

您需要转义引号-或者更容易。。切换到单引号，并对其进行转义（它们更少！）

$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''';