Seriously...

I don't mean to be cynical but this is elementary...and no mention of one of the most common tools used by PHP/MySQL Devs and installed on practically every LAMP Hosting environment: http://www.phpmyadmin.net/

hehehe

Thanks for the article. I find it useful.

I didn't know there is a specially built-in command in php to deal with csv with quotes and commas - fgetcsv.

In the past I had to use my own way to let users import their csv file into a web application.

Thx for the article, its really helpfull for beginers like me =), sometimes is hard to find something like this.. direct to the point

Nicholas, as mentioned in a past post the PHPClasses site is accepting guest articles. This is an experimental initiative to see if people are willing to contribute with helpful articles.

phpclasses.org/blog/post/87-10-step ...

So far two authors accepted to submit their articles. Maybe the articles are not as great as you would like, but since it is contributed content the site cannot demand much unless there is a greater offer of articles.

Anyway, if you would like to contribute better quality articles about PHPMyAdmin or something else you think it is interesting, feel free to do so. I will talk more about this in an upcoming article, but you can submit your article proposals already in this page:

phpclasses.org/blog_post.html

CSV is not that simple... ; or , headers or not...

Nice function in the source is:
//gets count of each possible CSV separator
//returns most appropriative separator (by max count in the string)
public static function try_separators($line, $default=','

I would have liked that you can save the mapping,
so that you can select the mapping (or create a new one) and process the file...

Yes, the article was a little light on detail, but my recent reading of forums (not this one, I'm a newcomer here) suggests that there is no lower limit to the level of detail you should supply.

The other day, I was preparing CSV files for insertion into a MySQL database. They contain numerical information and I opened one in Excel just to have a look at the data (while making a mental note not to save it because Excel would change date formats and numerical precision.

Excel said 'whoa, this is a SYLK file, are you sure you want to open it?'

I'd never heard of SYLK files. What does it mean?

en.wikipedia.org/wiki/SYmbolic_LinK ...

Of course it was just another example of MS attempting to claim ownership of every aspect of computer software, and I could ignore it, but why did no-one ever tell me about them?

Thank's for the article, this article help me.

Thanks for the article it's very useful for beginners, keep up the good work!

ditto...i need this kind of kindness