Upload excel file in mysql from php

[sukhdev.singh]

Hi this is Sukhdev,
I am new in php and wish to know how to import the data from excel sheet to mysql Table;

1. I have a table with the name of city in mysql with following fields;
   city_id,city_name,tier_id,tier_name,state_id,state_name

2. what would be the function for uploading above fields, if I filled the data in format and click on upload, all fields can be updated in above table.
   Thanks,
   awaiting for your reply

[Tpojka]

You would need understanding of OOP and classes.
Here is the class doing that.

[broj1]

Here's another Excel library with good documentation and examples: https://phpexcel.codeplex.com/

[chrishea]

If you don't need to do it very often, just do it manually using PHPMyAdmin.