语法错误，意外的T

mysql_connect("localhost","root","");
mysql_select_db("hitnrunf_db");

$result=mysql_query("select * from jos_users INTO OUTFILE 'users.csv' FIELDS ESCAPED BY '""' TERMINATED BY ',' ENCLOSED BY '"'
 LINES TERMINATED BY 'n' ");

header("Content-type:  text/plain");
header("Content-Disposition: attachment; filename=your_desired_name.xls");
header("Content-Transfer-Encoding: binary");
header("Pragma: no-cache");
header("Expires: 0");
print "$headern$data";

在上面的代码中查询字符串即mysql_quey中的字符串

我们正在收到以下错误

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in C:wampwwwsamplesmysql_excelexel_outfile.php on line 8

在查询字符串' n'章程不识别为字符串多数民众赞成为什么上述错误得到

---

您需要将双引号转义为： "而不是""

$result=mysql_query("select * from jos_users INTO OUTFILE 'users.csv' FIELDS ESCAPED BY '"' TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY 'n' ");

未转义的"会过早地终止字符串。

例：

这是不正确的： "A " is a double quote"
这是正确的： "A " is a double quote"

链接地址: http://www.djcxy.com/p/11975.html

上一篇: Syntax error, unexpected T

下一篇: Interpolation (double quoted string) of Associative Arrays in PHP