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

[@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]

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: kzbin.info/www/bejne/gomYfJyBbNV1o6c

[@mdjabedbhuiyan]

Thanks for create my required tutorial.

[@smarter_by_bit9346]

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

[@wplearners8480]

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

[@margaretkanganga4882]

☺ Hi, very good 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?

[@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

[@johnroninocarpio6239]

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

[@trinhthanhhiep9195]

What version of xampp are you using?

[@akila9168]

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

[@mdjabedbhuiyan]

You are real hero. Thanks

[@FundaofWebITHindi]

Thank you. Keep supporting.

[@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

[@1149binu]

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

[@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???

[@VishwasKale51]

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

[@bibhanshuyadav]

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

[@the_power_ride]

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

[@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.

[@swapnilpatil4994]

How give mobile validation in import

[@ashinsiby2814]

How to install composer??

[@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 ?

[@bejoapp]

Can you share the source remover?

[@rajeshtewari6059]

How to import date from excel

[@snehadutta2664]

how to download composer

[@ashishnath9121]

How to create table instead of insert or update here?

[@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!

[@ammar-techprofessionalserv4423]

Please I need the source code for study

[@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.

[@franklingonzalezsierra217]

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

[@debashishbasu1505]

how to remove excel header??

[@Telugufacts228]

if you that code with you please share it guys

[@denchaisingmahan]

How to Import Data from PDF and Word

[@markevantorremocha2664]

file of the code pleaseee i really want this

[@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]

Undefined index: file

[@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

[@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

[@debashishbasu1505]

i want to ignore first row of excel sheet..