Re: [Newbie Q] csv file upload via php to mysql tutoria
| From: | Maxim Maletsky | Date: | Thu, 07 Nov 2002 19:45:29 +0000 |
| Subject: | Re: [Newbie Q] csv file upload via php to mysql tutoria | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23111@lists.php.net to get a copy of this message | ||
Basically, you would have to receive a CSV data to then pass it to the
mysql via command prompt, just as if you would do it via shell. You
should be using mysqlimport in shell. So, in PHP you'd get to use system
command to accomplish this all automatically. Be aware of some security
issues.
--
Maxim Maletsky
maxim@php.net
Ruprecht Helms <rhelms@mayn.de> wrote... :
> Hi kristina,
>
> >[...] I can see that phpMyAdmin does this,
> > which is great but I
> > need it for joe public to be able to
> > use. so I don't
> > want them using phpMyAdmin.
>
> If you can't use phpMyAdmin try to make it with SQL-Import or
> a similar function.
>
> For mysql you have documentation under http://www.mysql.com in
> English
> and http://www.mysql.de for German.
>
> Regards,
> Ruprecht
>
> ----------------------------------
> Ruprecht Helms IT-Service und Softwareentwicklung
>
> Tel/Fax.: +49[0]7621 16 99 16
> Homepage: http://www.rheyn.de
> email: info@rheyn.de
> ----------------------------------
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>