Link to home
Start Free TrialLog in
Avatar of Nikhil Dange
Nikhil DangeFlag for India

asked on

How to check exiting data from excel sheet to phpmyadmin database?

I want php code to check every row in excel sheet, and if any row already exist in phpmyadmin database then ignore that row and insert remaining new rows into database phpmyadmin by "Upload Document" input field.
Avatar of Zakaria Acharki
Zakaria Acharki
Flag of Morocco image

Hi Nikhil,

Could you please clarify what you mean by "Upload Document" input field..

And it will be better if you could share with us an excel sheet example and how your DB table looks like.
you can use php excel reader to read each row of uploaded excel file, check the value in db and if not found then insert the data.
you can refer below url for reference

https://www.phpgang.com/how-to-read-excel-file-insert-data-into-mysql-database-using-php_609.html
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.