PHP Classes

Seriously...

Recommend this page to a friend!

      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   Report abuse  
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   Report abuse  
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   Report abuse  
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   Report abuse  
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   Report abuse  
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.

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

  6. Re: Seriously...   Reply   Report abuse  
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   Report abuse  
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?

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?

  8. Re: Seriously...   Reply   Report abuse  
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   Report abuse  
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   Report abuse  
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