excel import query error

Posted by pmms on Stack Overflow See other posts from Stack Overflow or by pmms
Published on 2010-04-27T07:09:24Z Indexed on 2010/04/27 7:13 UTC
Read the original article Hit count: 421

Filed under:
|
|
|

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

in the above code in query string i.e string in side mysql_quey

we are getting following error

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in C:\wamp\www\samples\mysql_excel\exel_outfile.php on line 8

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

© Stack Overflow or respective owner

Related posts about xls

Related posts about php