Login   Register  
PHP Classes
elePHPant
Icontem

Seriously...

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

      PHP Classes blog  >  Quickly importing dat...  >  All threads  >  Seriously...  >  (Un) Subscribe thread alerts  
Subject:Seriously...
Summary:Does this really deserve an article?
Messages:10
Author:Nicholas Calugar
Date:2009-02-25 22:45:20
Update:2010-06-02 03:09:04
 

  1. Seriously...   Reply  
Picture of Nicholas Calugar
Nicholas Calugar
2009-02-26 00:25:46
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/

  2. Re: Seriously...   Reply  
Picture of Nathan Stiles
Nathan Stiles
2009-02-26 01:14:03 - In reply to message 1 from Nicholas Calugar
hehehe

  3. Re: Seriously...   Reply  
Picture of Patrick Tan
Patrick Tan
2009-02-26 01:58:04 - In reply to message 1 from Nicholas Calugar
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.

  4. Re: Seriously...   Reply  
Picture of jorge
jorge
2009-02-26 05:52:56 - In reply to message 1 from Nicholas Calugar
Thx for the article, its really helpfull for beginers like me =), sometimes is hard to find something like this.. direct to the point

  5. Re: Seriously...   Reply  
Picture of Manuel Lemos
Manuel Lemos
2009-02-26 05:53:08 - In reply to message 1 from Nicholas Calugar
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.

http://www.phpclasses.org/blog/post/87-10-steps-to-migrate-W ...

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:

http://www.phpclasses.org/blog_post.html

  6. Re: Seriously...   Reply  
Picture of Rinie Kervel
Rinie Kervel
2009-02-26 07:32:35 - In reply to message 4 from jorge
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...

  7. Re: Seriously...   Reply  
Picture of John Cherry
John Cherry
2009-07-08 00:05:29 - In reply to message 1 from Nicholas Calugar
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?

http://en.wikipedia.org/wiki/SYmbolic_LinK_(SYLK)

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?

  8. Re: Seriously...   Reply  
Picture of claudio
claudio
2009-09-03 01:59:10 - In reply to message 5 from Manuel Lemos
Thank's for the article, this article help me.

  9. Re: Seriously...   Reply  
Picture of greg
greg
2009-10-07 18:21:05 - In reply to message 8 from claudio
Thanks for the article it's very useful for beginners, keep up the good work!

  10. Re: Seriously...   Reply  
Picture of Stephen Jennings
Stephen Jennings
2010-06-02 03:09:04 - In reply to message 8 from claudio
ditto...i need this kind of kindness