Question

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.

Closed 10 years ago.

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  
  ");

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 "$header
$data";

上文提到的在座标注中,即在我sql_quey边铺设

我们正在经历错误

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

in query string charter is not identifying as string thats why above error getting

Answer 1

页: 1

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

无名列名的<代码>将提前终止该示意图。

例:

This is incorrect: "A " is a double quote"
This is correct: "A " is a double quote"

友情链接