acctman Posted November 25, 2010 Share Posted November 25, 2010 Hi can someone assist me with adding a second upload that grabs all files from within a directory. 1. user select .csv file (coding down for that) 2. user select folder with .docx files in side (this folder will only have docx files) 3. on submit .csv and all .docx files are upload to /temp_docx/ folder 4. the .csv has a matching docx_id that relates to the .docx file name (ex file 1.docx == docx_id = 1 in the csv file) so every time an insert is done a move_file happens and 1.docx would be moved to /docx_files/ 5. and if there is ever an error or no match at the end output all errors. I think the part where i'm stuck and confused the most is handling the second upload where all docx files in the folder are upload and looped through moving and inserting <?php if(isset($_POST['submit'])) { $filename = file_get_contents($_FILES['uploadedfile']['tmp_name']); $handle = fopen("$filename", "r"); while (($data = fgetcsv($handle, 100000, ",")) !== FALSE) { $import="INSERT into kmmb_member1(docx_id,no_ahli,no_pin,nama,no_ic_baru,no_ic_lama) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]')"; mysql_query($import) or die(mysql_error()); } fclose($handle); print "Import done"; } else { print "<form action='import.php' method='post'>"; print "Type file name to import:<br />"; print "Select csv file: <input name='uploadedfile' type='file' /><br />"; print "<input type='submit' name='submit' value='submit' /></form>"; } ?> Quote Link to comment Share on other sites More sharing options...
acctman Posted November 26, 2010 Author Share Posted November 26, 2010 i'm assuming a directory upload can't be done with a php file upload and flash would be needed. so can anyone show me how this would be done with a single php file upload and I can look into the flash part after i have everything working correctly Quote Link to comment Share on other sites More sharing options...
BlueSkyIS Posted November 26, 2010 Share Posted November 26, 2010 the flash part sends each file separately. so a single php file is all that is needed. Quote Link to comment Share on other sites More sharing options...
acctman Posted November 26, 2010 Author Share Posted November 26, 2010 yes only one upload is needed. lets say that the files are already on the server. once the .csv file is in $data[0] is used to go to /temp_docx/ folder and look for the file $data[0] that matches (ex. $data[0] = 1 then look for 1.docx and move it to /docx_files/ and do the insert into the database. i just need help with the part where $data[0] is used to check the directory on the server for the corresponding file and then the move Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.