Re: CSV importer tool
| From: | tamouse mailing lists | Date: | Tue, 27 Nov 2012 22:09:18 +0000 |
| Subject: | Re: CSV importer tool | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-319759@lists.php.net to get a copy of this message | ||
On Tue, Nov 27, 2012 at 2:56 PM, Leandro Dardini <ldardini@gmail.com> wrote:
> Hello,
> I am going to write a PHP page to allow the client to upload a CSV file and
> assign each column to one or more fields of a mysql table. Quite simple,
> but I feel like I am reinventing the wheel... is it possible there is no
> library to do it, maybe using AJAX or similar cute techniques?
>
> Leandro
This has been asked a few times, I wrote up a how-to and posted it on my wiki:
http://wiki.tamaratemple.com/Technology/UsingUploadedTempFilesToPopulateATableInPHP
It's such a few actual lines of code, I wonder if no one thinks it's
such a big deal to just write it over and over again. Basically it's
handled pretty much entirely in SQL rather than PHP.