friend i got this importing csv to database working fine but how could i make it that i choose the csv file from a html form and then upload please help me out <?php //database connection details require_once('config.php'); // path where your CSV file is located define('CSV_PATH','C:\Users\Downloads/'); // Name of your CSV file $csv_file = CSV_PATH . "student.csv"; if (($getfile = fopen($csv_file, "r")) !== FALSE) { $data = fgetcsv($getfile, 100000000, ","); while (($data = fgetcsv($getfile, 100000000, ",")) !== FALSE) { $num = count($data); for ($c=0; $c < $num; $c++) { $result = $data; $str = implode(",", $result); $slice = explode(",", $str); $col0 = $slice[0]; $col1 = $slice[1]; $col2 = $slice[2]; $col3 = $slice[3]; $col4 = $slice[4]; $col5 = $slice[5]; $col6 = $slice[6]; $col7 = $slice[7]; // SQL Query to insert data into DataBase $query = "INSERT INTO details(id, student_phone, student_fname, student_lname, street_address, city, state, zip) VALUES('".$col0."','".$col1."','".$col2."','".$col3."','".$col4."','".$col5."','".$col6."','".$col7."')"; $s=mysql_query($query); } } } echo "File data successfully imported to database!!"; ?> regards and thanks

little help please. need to make file get uploaded by form/

By lovephp
April 3, 2014 in PHP Coding Help

Followers 0

Go to solution Solved by lovephp, April 4, 2014

Recommended Posts

Solution

lovephp

Posted April 4, 2014

Author
Solution

- Share

Posted April 4, 2014

I thought it was a permissions problem. Change the permissions and it will go away. OR use the advice given to you and skip the whole move and creating a permanent file and just let the system delete the temporary file.

OH - and work on your English. Or stop typing on your cell phone. A little respect for yourself and those you wish to read and understand your writings can come in handy.

hehe yes i was on the cell phone on the previous reply. anyways i sorted it by redirecting it to another php file through which i delete files inside that dir