You are here: Re: CSV to MySQL table (MyPHPAdmin) « PHP Language « IT news, forums, messages
Re: CSV to MySQL table (MyPHPAdmin)

Posted by Joe G. on 04/10/07 22:31

Thanks to all that replied, but I found the most helpful information in a
post from "Software Engineer". She directed me to a web site that offers
"detailed" solutions to PHP programming issues.

http://tutorial.fyicenter.com/824/MySQL/PHP/Tutorials/Importing_CSV_data_into_MySQL_with_a_PHP.html

With a few modifications, I was able to use the code to load my data on to
the web MySQL server. The code works and there are detailed instructions
that I was able to paste into the code as comments (as all good programmers
should).

It seems that too many responses in newsgroups are just too terse. It really
doesn't help to reply with suggestions without leading them to more details
on the subject. Telling me to break apart the CSV file I suppose could be
considered a simple solution, but not the best. Without instructions or a
link on the best way to accomplish this, there really no sense in posting a
response. More than likely another person browsing the postings will think
that the question has been answered when seeing threads to the discussion.
I'm sure all people mean well, but people are coming to these newsgroups
looking for detailed solutions or at least to be pointed in the direction of
a solution.

"Joe Gazda" <email@1on1cc.com> wrote in message
news:oZKdnUNtYMARxIfbnZ2dnUVZ_s2vnZ2d@wideopenwest.com...
>I have a large data file (9 Meg) that I want to upload to a MySQL table. It
> contains the key, model year, maker, model, and engine type for about the
> past 50 years. The limitation of my MyPHPAdmin transfer is 2 Meg. So, I;m
> looking for a simple PHP script to take 7 fiedls of data and transfer it
> to
> an already existing (blank) MySQL table. I've done an Internet search and
> the "free" code that I have found either lacks enough comments to work
> with
> and just doesn't work at all.
>
> I've seen programs that can be ourchased like from Sobolsoft, but don't
> have
> any experience with the company. If it will work for this application,
> then
> I'm willing to purchase it. If someone can lead me to a "functional",
> commented script, al the better. But, if any one has successfully used any
> commerical software and can lead me in the right direction, your input
> would
> be greatly appreciated.
>
> Joe G.
> Dearborn, MI
>
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация