SQLSTATE[42000]: Syntax error or access violation with csv export related php script

Question

I'm customizing a csv export php script which I admit I took from the internet but

I'm having this error

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\',\' optionally enclosed by \'\'' at line 1

The line of code described is

$fnam2 = 'data-' . substr(md5(microtime()), 0, 8); 
$setsu->query("SELECT * FROM ".$tblname." into outfile '".$fnam2 ."' fields terminated by \',\' optionally enclosed by \'\'");

Which was originally

$setsu->query("SELECT * FROM ".$tblname.". ' into outfile "c:/xampp/htdocs/' . $fnam2 . '" fields terminated by \',\' optionally enclosed by \'"\'');

I would like the remove the part where it points to xampp folder so that the user can place wherever she/he wants to download the file.

Any help appreciated.

Jono20201 · Accepted Answer · 2014-05-24 09:04:59Z

1

$fnam2 = 'data-' . substr(md5(microtime()), 0, 8); 
$setsu->query("SELECT * FROM ".$tblname." into outfile '".$fnam2 ."' fields terminated by \",\" optionally enclosed by '\"'");

Maybe?

answered May 24, 2014 at 9:04

Jono20201

3,2053 gold badges22 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

SQLSTATE[42000]: Syntax error or access violation with csv export related php script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related