How to import excel data into mysql using php?

[apssiva]

Hi,

i tiring to insert excel data into mysql using php.

1. i saved the Excel data as a CSV file.
2. i use below code to retrieve data.

$fcontents = file('./ite_APS.csv');
for($i=0;$i<sizeof($fcontents);$i++)
{
    $line = trim($fcontents[$i]);
    $arr = explode(",",$line);
    $sql = implode("','",$arr);
    echo "$sql <br>";
}
 

i got is output, but i don't know how to insert the data in mysql. can you help me?

EMPLID','COMPLETE_NAME','STRM','SESSION_CODE','SUBJECT','CATALOG_NBR','COURSE_TITLE_LONG','CRSE_GRADE_OFF','UNT_EARNED','CUM_GPA 
F1809289K','JEGANNES A/L C KRISHNAN','5081','E05','EM','20000','Communication Skills','U','2','0.75 
F1809289K','JEGANNES A/L C KRISHNAN','5081','E05','EM','20070','Information Technology','U','1','0.75 
F1809289K','JEGANNES A/L C KRISHNAN','5081','E05','ME','28020','Piping & Valve System','F','6','0.75 
F1809289K','JEGANNES A/L C KRISHNAN','5081','E05','ME','28050','Mechanical Fabrication','F','6','0.75 
F1809289K','JEGANNES A/L C KRISHNAN','5087','E11','EM','20030','Personal Effectiveness','U','3','0.75 
F1809289K','JEGANNES A/L C KRISHNAN','5087','E11','EM','20060','Sports & Wellness I','U','1','0.75 
G0428701R','WEI HUAJIE ','5091','E05','EE','28110','Fundamentals of Electricity','C','6','2.25 
G0428701R','WEI HUAJIE ','5091','E05','EE','28120','Residential Wiring Systems','C','6','2.25 
G0428701R','WEI HUAJIE ','5091','E05','EE','29060','Basic Electronics','B','2','2.25 
G0428701R','WEI HUAJIE ','5091','E05','EM','20000','Communication Skills','S','2','2.25 
G0428701R','WEI HUAJIE ','5091','E05','EM','20070','Information Technology','S','1','2.25 
G0428701R','WEI HUAJIE ','5097','E11','EE','28130','Industrial Wiring Systems','B','6','2.25 
G0428701R','WEI HUAJIE ','5097','E11','EE','28140','Electrical Maintenance and Control','C','6','2.25 
 

[Mayur2007]

Hello,

You have to write some php code like below

mysql_connect('your host','your username','your password');
 
mysql_select_db('your database name');
 
$insquery = "INSERT INTO `tbl_name` (`field1`, `field2`, `field3`) VALUES ('val1', 'val2', 'val3'), ('val1', 'val2', 'val3');";
mysql_query($insquery);
 

Regards,
Mayur Bhayani

[apssiva]

thanks,

but i have one doubt, one user have multiple "COURSE_TITLE" how i can insert? pls check my above output...

[Mayur2007]

Hello,

For that you have to set user_id in your mysql table.

Regards,
Mayur Bhayani

[apssiva]

All data are in excel sheet. the table is empty now. i will insert this excel data in to the table. pls any one help.........