PHP excel import data into database

In this video, I will show you how to use PHPExcel library to data import into database.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


I am a Digital Marketer by passion and a Developer by profession. With experience and expertise spanning around 10 years, in the Digital space.

Good amount of experience in development of web applications using PHP, .Net, JavaScript Library’s, Frameworks, CMS, API’s, Reporting tools and Payment Gateways. Skilled in digital viral marketing, technology innovation's, brand building and all phases of the Web development lifecycle with an expert in translating business requirements into technical solutions and fanatical about quality, usability, security, and scalability. Dealing with and resolving problems and issues which arise.

[rks]

No matter which topic I think of, there always exists a video by Vishal Sir. Thanks a lot!!

[tarunjaiswal]

Your video always become best and best . 👍

[danishrajvala]

Wow Sir, You are amazing your teaching style is the best that it made this code very easier to understand, thanks a lot for sharing knowledge, May God always bless you :)

[sonamvishwakarma]

Sir your codes always work thanks for your support

[sanDpp]

Very Nice...

Next Video: Web Scraping....plzz

[msmediascreenentertainment]

vishal bahee acha topic tha so nice of you

[jangamdevender]

I'm very must impress with your lecture, can you please make video to retrieve import Google sheets data to MySQL once we submit through form automatically

[aniket]

Sir app man ki bat samaj jate hoo

Mai comment karne hi wala tha excel export ka video ke wareme

& Tabhi apne bola ki next video ushi ke uppar ayega

[erhimanshuraj]

sir really thnks
all code is working

[trikaal]

Thanks alot. I am searching this...
Plz sir, if possible make a mlm project, or a online vdo class room

[akshaychougule]

Ye like hum 1 bar hi kyu de sakate hai youtube par .... Main to 1000 likes dena chahata hu vishal sir ko.... Thank you so much sir...

[sagarhonbhakare]

Hat's off sir thank you for this video

[yasironvideo]

Thank you so much for such a wonderful video very informative perspicuous and crisp, two quick points a. Why did you delete first row (probably to fetch data values only and not headings), I suppose we should not touch the structure of the excel to make it more practical through programming we should fetch second row onward. b. Why would we empty the msql table every time we upload data, that will not serve the purpose. You see, what I am trying to say is in real world it will be very useful if we design a web page which allows users to upload excel file (which has a fixed structure) as input data instead of filling a web form. Now the system should be smart enough to check if the uploaded data already there (duplicate upload) based on certain field(s). and (if not duplicate then) it should append the data in the excel file as the last row of mysql data. Ideally in this setup all the data that excel file will be considered as ONE ROW. Sorry this is too long but it will it a general utility. Thanks

[binu]

I was waiting for this, thanks Mr.Vishal..i have a doubt. Is there any restriction for number of rows?

[rggodman]

Sir nice. But you can use "accept" attribute in input type file html element. Everything nice. Carry on sir.

[rezaulhaque]

Thank you sir. Sir laravel ka series complete hone ke baad react js ke upar bhi series layega. Q ki aapki series samajh me aati hain...

[shubhamkumarsuryavanshi]

sir i need help, in java for
data import into database by java servlet or jsp/jsf.

[aarohi_world]

thanks for the code sir .. i have one doubt am facing a error ["Trying to access array offset on value of type int in on line 90"] ... am using integer number in excel thats why am getting this error could you please help me in this

[anshuvishwakarma]

Sir mere Excel me 2 excel sheet hai aur mujhe one by one krke dono hi import krni hai every sheet me 80000 rows hai to kaise kren

[junihbhatt]

Great....
(Reminder : Hospital Management system 😁...)