PHP MySQL CSV importing

[BliarOut]

Anyone come across any decent PHP scripts to allow uploading of CSV files into MySQL from a remote file system? (Windows platform, not a url)

I want something to butcher, but haven't found much yet.

PHPMyAdmin can do it, but there is too much info in there to rip out the bits I need.

I don't want full MySQL control, as this is just for end users to import userlists into my app.

Ta,
Rob

[JamieBeeston]

aah, thought you just wanted to do it... instead you want to implement some code to do it..

not so easy..

A simple way woud be to code a PHP uploader, which takes the CSV, dumps to a file, and them pipes the data off to a local MySQL session.

Full of risk and secuity holes tho..but once coded arond, a simple method..

Allowing clients access to databases is always 'fun' tho

[BliarOut]

To true... I found one set of code... modified it.. and it fell at the first hurdle, it only worked from the server.

While PHPMyAdmin does it, it's way to complicated for an end user and a bit of a beast to break apart

I intend to walk them through a full backup first!!! and then give them a template to modify and save, then import.

In theory it's good, but my code still has a big hole in it where this bit fits. At least my app lives on a closed network, so security is less of an issue than a public server.

I just think I need to improve my Googling