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

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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.