How to Import Data from Excel/CSV File into MySql DB in PHP using PhpSpreadsheet | Insert & Update

In this video, i have taught about How to Import Data from Excel or CSV File to Mysqli in PHP using PhpSpreadsheet where we are inserting data and if record already exists means will be updated into database.
Import Excel Sheet data to Database in PHP using Phpspreadsheet
• How to Import Data fro...
Export Data from Database to Excel Sheet in PHP using Phpspreadsheet
• How to Export data fro...
Php Spreadsheet's Link
phpspreadsheet.readthedocs.io...
Follow us on Instagram:
/ funda_of_web_it
Website: fundaofwebit.com/

[@mdjabedbhuiyan]

I complete your all play list tutorial of funda of web it english.

[@ngongo934]

i am from VietNam and i thank you so much

[@mdjabedbhuiyan]

Thanks for create my required tutorial.

[@Shopnomoi]

Hi, very good tutorial
I would like to insert multiple tables from the csv fie
Like some data insert table one, other data insert table 2
how to do that, Could help me?

[@margaretkanganga4882]

☺
Hi, very good tutorial

[@mdjabedbhuiyan]

Your tutorial is so easy to understand. Thanks

[@webeloperuz1669]

i don't know indian language this is video very hard for me

[@FundaofWebITHindi]

You can try with english language:
czcams.com/video/LX5KiK7pBmE/video.html

[@mdjabedbhuiyan]

You are real hero. Thanks

[@FundaofWebITHindi]

Thank you. Keep supporting.

[@trinhthanhhiep9195]

What version of xampp are you using?

[@1149binu]

Sir,If the excel have 2000rows will it work?

[@pratikbhuva4346]

Thanks. very easy to understand. how to start reading from second row? as excel files may have headers

[@kushgada2133]

Did you get to know how to do that ? If yes please guide me

[@oumasstabdallah3424]

Thank you brother. you did will actually

[@msa_1439]

hello Bro I am From #Somaliland, English Version of This Lecture is Very Important Please Could you do it for us, please???

[@johnroninocarpio6239]

is the data will not showing up in the main homepage of the website?

[@akila9168]

I have product excel data along with images. How to import images from an excel file?

[@wplearners8480]

that's very nice but how can we handle date cell in php?

[@franklingonzalezsierra217]

Hola, no me funciona. Me puede compartir el código?

[@StatusWorld-pz8ld]

Sir after installing pho spreadsheet its redirecting to index.php if i remove spreadsheet files its works properly, can i know how to fix it

[@bejoapp]

Can you share the source remover?

[@smarter_by_bit9346]

aap to mano bhagvaan kaa rup hi ho.......shukriyaa bhai

[@VishwasKale51]

xls file format not getting upload, it displaying special char in DB

[@surajopagrahari877]

How to increase limit data import. actually we have face a problem it's only 2000 data import but we want more thousands data import how could possible this ?

[@the_power_ride]

Isme index.php file ka. Code kahan se le. Skte hn.... Please reply?

[@snehadutta2664]

how to download composer

[@neeraj0511]

hello sir
composer install krne ke bad v link se vendor folder create nhi ho rha h
sir, kia krna hoga plz help
sir plz share mail Id for ask Question.

[@ashinsiby2814]

How to install composer??

[@bibhanshuyadav]

I am getting some error like this:
Undefined type of phpspreadsheet\IOFactory....
Need help

[@ashishnath9121]

How to create table instead of insert or update here?

[@swapnilpatil4994]

How give mobile validation in import

[@trinhthanhhiep9195]

Your requirements could not be resolved to an installable set of packages.
Problem 1
- Root composer.json requires phpoffice/phpspreadsheet ^1.18 -> satisfiable by phpoffice/phpspreadsheet[1.18.0].
- phpoffice/phpspreadsheet 1.18.0 requires ext-gd * -> it is missing from your system. Install or enable PHP's gd extension.
To enable extensions, verify that they are enabled in your .ini files:
- C:\xampp\php\php.ini
You can also run `php --ini` inside terminal to see which files are used by PHP in CLI mode.
Installation failed, deleting ./composer.json.
can you help me? please!

[@denchaisingmahan]

How to Import Data from PDF and Word

[@ammar-techprofessionalserv4423]

Please I need the source code for study

[@rajeshtewari6059]

How to import date from excel

[@debashishbasu1505]

how to remove excel header??

[@Edhimanafactguru]

if you that code with you please share it guys

[@mdjabedbhuiyan]

I want to import some student data from csv file but some row column field select form select option. If see an video tutorial. Thanks

[@FundaofWebITHindi]

If you have any suggestion, please do let me know.

[@mdjabedbhuiyan]

Branch option, shift option, version option, session option, group option, class oprion, section option, student type option, those option value take from html form and other some info take csv file. How can i import multiple row in mysqli database. Thanks

[@FundaofWebITHindi]

Can you be little more clear. What is required with small explanation as example.

[@enotechworld112]

Fatal error: Uncaught Error: Class "PhpOffice\PhpSpreadsheet\IOFactory" not found in D:\xampp\htdocs\excel_project\upload_sheet.php:19 Stack trace: #0 {main} thrown in D:\xampp\htdocs\excel_project\upload_sheet.php on line 19
how to fix this error?

[@bibhanshuyadav]

Did you solved this?? I need some help

[@markevantorremocha2664]

file of the code pleaseee i really want this

[@debashishbasu1505]

Undefined index: file

[@nishantnagdeve5431]

i want to ignore first row of excel sheet..

[@shreeharshpandey1055]

Sir, when I am clicking on submit button it's redirecting to code.php page but over there no data is visible and data is not being imported too in the database.(No error is showing on the page of code.php)

[@almosawi32]

Fatal error: Uncaught Error: Class 'PhpOffice\PhpSpreadsheet\IOFactory ... return nothing because not correct composer, php zip extension installed in your server

[@msa_1439]

How to Skip Header from Excel Spreadsheet While Uploading to MySQL

[@santoshkp9254]

You can just use a variable i to iterate over all the rows and then use a condition if i==0 then continue; this will skip your header row hopefully.

[@debashishbasu1505]

@@santoshkp9254 please share code

[@santoshkp9254]

@@debashishbasu1505 I would have provided you the code but it very simple you just have to use if($i==0) { continue; } this would surely do the work.

[@debashishbasu1505]

@@santoshkp9254 where it's put this code
After foreach??

[@santoshkp9254]

@@debashishbasu1505 just after your loop. Like
foreach(your expression){
if($i==0){ continue; }
// then wrtite all your logic
}

[@debashishbasu1505]

i want to ignore first row of excel sheet..