How to Import Excel file into mysql Database from PHP

Question

Lets say  i want to import upload excel file to mysql from PHP  My HTML is like below   lt form enctype  multipart form-data  method  post  role  form  gt       lt div class  form-group  gt           lt label for  exampleInputFile  gt File Upload lt  label gt           lt input type  file  name  file  id  file  size  150  gt           lt p class  help-block  gt Only Excel CSV File Import  lt  p gt       lt  div gt       lt button type  submit  class  btn btn-default  name  Import  value  Import  gt Upload lt  button gt   lt  form gt    PHP code is like below   lt  php  if isset   POST  Import             First we need to make a connection with the database      host  localhost      Host Name       db user   root     User Name      db password           db   product record      Database Name       conn mysql connect  host  db user  db password  or die  mysql error         mysql select db  db  or die  mysql error         echo  filename   FILES  file    tmp name        if   FILES  file    size    gt  0                 file   fopen  filename   r               sql data    SELECT   FROM prod list 1            while    emapData   fgetcsv  file  10000            FALSE                          print r  emapData                 exit                 sql    INSERT into prod list 1 p bench p name p price p reason  values    emapData 0     emapData 1     emapData 2     emapData 3                  mysql query  sql                     fclose  file           echo  CSV File has been successfully Imported           header  Location  index php              else         echo  Invalid File Please Upload CSV File       gt    Excel file is like below    I want to import only the 2nd row values into my table  Please help me how can i solve it or give me any resource  I was able to upload the  excel file but it is  not correctly formatted  i want to upload 4 column in mysql s 4 column but it is uploading all 4 column in mysql s 1 column  am i missing something

User · Answer

You are probably having a problem with the sort of CSV file that you have.

Open the CSV file with a text editor, check that all the separations are done with the comma, and not semicolon and try the script again. It should work fine.

User · Answer

For    2nd row values insert into table-     file   fopen  filename   r       sql data    SELECT   FROM prod list 1      count   0                                             add this line while    emapData   fgetcsv  file  10000            FALSE          print r  emapData         exit         count                                            add this line      if  count gt 1                                       add this line        sql    INSERT into prod list 1 p bench p name p price p reason  values    emapData 0     emapData 1     emapData 2     emapData 3            mysql query  sql                                                         add this line

[php] How to Import Excel file into mysql Database from PHP

Examples related to php

Examples related to mysql

Examples related to excel