? LOAD csv DATA to MySql via form

prosys

Ok, I have searched the board here; looked at the tutorials at HotScripts, WebMonkey, DevShed, & others; and examined how phpMyAdmin uploads a text file to MySql.

But I still cannot determine how having MAGIC_QUOTES enabled will affect how I will need to process the CSV file before LOADing it into MySql.

phpMyAdmin strips slashes, and adds slashes, and strips slashes -- all quite confusing.

What I need is to allow a browser to upload a CSV file via a form that will then be LOADed INTO MySql.

Won't the 'escapes' that MAGIC_QUOTES inserts cause a problem with my SQL query?

Do I strip them all? And then add some back in??

Any help would be greatly appreciated.

prosys

After doing more research and testing, I have answered my own question.

I found "Slash 'em: The War Against Magic Quotes" at http://www.pinkgoblin.com/quotesarticle.php and decided to put those ideas to the test.

In short, that author's "War Against Magic Quotes" is a bunch of BS. I did not need to do anything to my uploaded CSV file before LOADing it into MySql. No stripslashes(), addslashes(), stripslashes(), ad nauseum... It even handled single-quotes within columns properly.

The only problem I had was in building the query in PHP that would LOAD the file into the table. In particular, the line $query .= " ENCLOSED BY '"'"; (that's "single-quote double-quote single-quote double-quote semi-colon" at the end) caused a problem. The solution? Escape only one double-quote; as in "single-quote escape double-quote single-quote double-quote semi-colon".

Magic_quotes must have been improved since the publishing of "Slash 'em ...".

I hope this helps anyone having the same issues.