PHP Excel Import : How to insert / import excel data into mysql database in php | PHP Tutorial 28

In this video, I have taught how to import excel data into mysql database in php. php excel import. insert excel data into database in php using phpspreadsheet package.
Source Code - How to insert / import excel data into mysql database in php:
www.fundaofweb...
PHP Excel Import : How to import excel data into mysql database in php
• PHP Excel Import : How...
PHP Export Excel : How to export data from mysql database to excel sheet in php
• PHP Export Excel : How...
Buy me a Coffee: www.buymeacoff...
Follow us on Instagram: / funda_of_web_it
Subscribe to my Hindi/Urdu Channel: / fundaofwebithindi

[@naveen20054]

thanx alot GuruJi... 😄

[@rezaahmadyieh3214]

Thank you for the nice and informative clip. That was brilliant. Th'll be so great if you kindly add three more parts to the contents: Avoiding insertion of duplicate records, giving the number of successfully imported records, and giving the record numbers that are not imported due to some problems such as inconsistencies. Much appreciated.

[@DeepakVerma-lx5wo]

very useful tutorial thanks

[@islahdalebacolod2454]

thank youuuuuu so muchhh sir! youre a life saver! your videos helps me a lot with my current project.

[@spacelover2868]

Thanks bro love from Tamil Nadu

[@bibhanshuyadav]

Did it worked for you??? I need some help.

[@nhpiash42]

Awesome Video

[@youngprogrammers0112]

nice bro thanks
most useful tutorials

[@jun_melody]

Very nice.. thnx

[@sushantpatil7950]

Life Saver Thanks :)

[@codingrecharge]

Thank yu very much sir

[@An-Nur_Info-Tech]

Perfect and so educative.

[@waltergermanes4528]

Can you please add function not to insert data if already added or if data is same, only one will insert to database? Thanks in advance

[@mdjabedbhuiyan]

Thanks this tutorial. If see this tutorial with oop in php.

[@azstech3530]

Thanks alot bro

[@vinhledinh2793]

17:11 good

[@ashtin5095]

Good Day Sir. Thank You very much for this tutorial. ^_^

[@jevalaggaantamilalagan6111]

First

[@wplearners8480]

sir your videos are very informative but in this video when i applied on my project, i've stuck at one point when inserting date column of excel file into database plz help about this date coversion

[@jeffrydelgado5334]

New subscriber here! Your tutorials are great and it really helps me a lot in my current project. Regarding this tutorial, I just want to ask if there's a function that will restrict the data from inserting into the database if there's already a data that has the same value in the new excel file you want to import. Thank you!

[@hafizsatryandi9372]

thank you perfect...!!! (y)

[@KkSabari111]

How to duplicate data skip and to import data

[@TS-zh3mr]

bro, I can't install composer in terminal

[@scriptmaster3357]

So does PhpSpreadsheet require payment to work? My code is entered, but I'm presented a blank page for the return. When I re-run 'composer require phpoffice/phpspreadsheet' I get a "Nothing to install, update or remove. Generating autoload files. 3 packages you are using are looking for funding. Use the `composer fund` command to find out more!" message.

[@wilmoreosing5261]

thank u for the info. but can you pls display the data from sql to website/dashboard?

[@fundaofwebit]

Here, we are displaying data from sql database
th-cam.com/video/GAfikNNQLWE/w-d-xo.html

[@hermain-vm]

Hello, how to remove empty spaces in exel,
When I save I get an empty in the database?

[@jobkochu6533]

Can u please guide to create an IT ticketing system in PHP?

[@FaiZunGaming]

I did everything same but only inserting first row like Full Name, Email, Phone to database, and other main data not inserting.

[@SASATubees]

how to remove duplicates like email or NIC likewise when importing data

[@santosrobelynv.5707]

How can i fix an error in my composer installation..

[@KillyHoffman-ci6wu]

Mine only upload the first row of the exce file to the database anybody with the similar problem...and to anyone who knows how to fix it plzz...reply this

[@mahamedmuqtaar2695]

Sir make hotel system backend and frontend plz

[@mdjabedbhuiyan]

How to import and export from sql database in php. If see how its work. Thanks

[@troyvincentmaestrado9688]

Sir please give a tutorial on how to send otp verification code using gmail

[@frerikscas]

Why do you put strings on a int value. String is just only for text

[@Anandsaduwale4547]

how to import excel data inlude image in phpmyadimn

[@sithanyak4151]

could you please provide codeigniter code?

[@yakult0930]

Brother I want help from you in Bangladesh please give me a method

[@vitalistaaivandaniel9261]

How to do this on laravel?

[@abdulajeez9777]

I have a one error when I installed composer through error PHP warning

[@bibhanshuyadav]

Did this code helped you? I am facing phpspreadsheet issue

[@SantosRobelyn]

Fatal error: Uncaught Error: Class "PhpOffice\PhpSpreadsheet\IOFactory" not found in C:\xampp\htdocs\db_parish\code.php:18 Stack trace: #0 {main} thrown in C:\xampp\htdocs\db_parish\code.php on line 18
can someone po can help me to this problem.. thank you.

[@ProdJAN-hh9lv]

I need help, why is this not working??
$spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load($inputFileNamePath);

[@bibhanshuyadav]

Is this worked or not for you??? I am facing the same problem.

[@bibhanshuyadav]

I fixed that.

[@aayushikukreja4925]

how???@@bibhanshuyadav

[@kukun2748]

why the \PhpOffice\PhpSpreadSheet\IOFactory::load($inputFileNamePath); is not working on me?

[@bibhanshuyadav]

Is this worked or not for you??? I am facing the same problem.

[@kukun2748]

@@bibhanshuyadav its working now I just fix the file path

[@bibhanshuyadav]

@@kukun2748 yes i fixed it later by
Uncommenting the fileinfo and gd in php.ini file

[@lazyturtle61]

whats the path?@@kukun2748

[@thechoosen4240]

Good job bro, JESUS IS COMING BACK VERY SOON;WATCH AND PREPARE

[@ilhamherex]

create code import excel by bulk insert into phpmyadmin bootsrap, please 🙏

[@msc6071]

please DataTables export excel