Import to mysql using php

treeleaf20

Hello All, I have a question for you. I was wondering if it would be possible for a user to download an excel spreadsheet to their local machine and make changes that they need to and be able to upload a .csv file similar to how it is done in phpmyadmin. Is this at all possible? The next obstacle would be that only certain users can view certain things. So for example the results that they get back isn't the whole database so I don't believe I can do a replace unless you can add in a where claus to a statement saying replace where unitnum (which is the primary key) is the same??? Anyone have any suggestions or written anything similar to this?? Thanks for all the help in advance. I've been struggling with this for awhile!

Roger_Ramjet

PHP has many functions to upload files. Check the manual for file system functions

MySQL also has the very function used by phpmyadmin, its is called load data infile and would be your best option.

treeleaf20

DO you know if you can just use a post to be able to input the data. So it would look something like this:

$_POST['file'] = $file;

LOAD DATA LOCAL INFILE '$file' REPLACE INTO TABLE `upload` 
FIELDS TERMINATED BY ';'
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\r\n'

Does anyone know if this would work or do you have to do something different to be able to upload the document??

Roger_Ramjet

Should just about do it, except I'm sure you mean lines terminated by '\r\n'