Upload CSV and Insert Data into Mysql Using PHP

You can find how import data from csv file and insert into mysql table in php. Here I show you user first upload csv file and with help of php code we can get csv file data and make mysql insert query and insert that data to mysql table. Source Code - www.webslesson.info/2016/04/up...

[@Sami-sg5os]

Thank you !
For those who have the error "Notice: Undefined offset: 1", you can replace the line of code "while($data = fgetcsv($handle))" with this one "while($data = fgetcsv($handle,1000,";"))". You must specify the separator.

[@kobimontague2101]

apart from the computer talk..this really helped me upload a lot of data to the mysql data base.
Thanks for the code...
Kobi

[@agehjeremiah]

Awesome Tutorial. Thanks Webslesson!!!

[@orpee4486]

Thank you so much. You're so resourceful.

[@danielchung0228]

it doesn't work for me. Nothing happens.
very frustrating because I did everything what you did and it doesn't work for me.

[@VFRodriguez]

Good example. Easy to learn. Thanks.

[@user-fw2ur9jy3z]

Apart from saying "friends" 1Milloin times
That wae very helpful ...
Friend 😁♥

[@dbs253]

Exactly what I was going to say too!

[@mutalemulenga8708]

Wow. this is awesome. I never wanted to use third parties library and here is pure php system.

[@miteshnile7350]

Thank you very clear explanation!

[@jsfahmi]

thank you friends

[@CarlosMoreno-vw4ir]

Thanks a lot, you are a hero !

[@pallavigupta321]

great video it worked for me thanks

[@geethavadupu1760]

thnks sir its working..helpful to me

[@ekanshbihal2850]

Hello sir, thanks for code. Sir, i have two queries. When i upload CSV file using this code, CSV heading at the top of csv are also upload in database. Tell me which condition is used for this and also tell me how i validate csv in uploded time using php that data should not repeated again.

[@user-dt9uv4ww7v]

Thank you very much sir

[@AlinafeNthondowaCode-Zero]

Thanks it worked

[@umabm502]

It is getting inserted but not with actual value... help me out with this

[@moussaabbouzid579]

Thanks u so much bro ❤️❤️❤️

[@hyasinti]

Thanks is very useful, but is there any way that I can convert excel file to csv in php without using plagins

[@codingbladeit8255]

Thank you so much

[@--INDIAN--TRADER]

very nice clear and precise thanks a ton

[@webslesson]

Thanks Mahboob...

[@emmanuelepiscope4853]

thank you

[@pallavi7116]

Thanks 😊❤️

[@parthpd3781]

csv file add images how can get that image save folded and database add in php

[@dhruvchauhan5581]

The line :
($_FILES['file']['name'])
Is giving an error as : Undefined index: file
How to solve this issue?

[@ehsaanali2789]

same issue

[@balikahinge2226]

can u store image using csv

[@parichartkittikhun4666]

Thank you so much :)

[@samikhaneth]

if entry exit then wont be uplaod again ? how to put code in this section and which code?

[@AhmedAli-ky6jt]

Is this will be work on live server ??

[@yashrojha]

Thanks

[@niceboyyou]

This is fantastic and helpful
How we can add the data by escaping the first row

[@ninthcrusade4871]

Use a variable counter. If the counter is greater that '0' then insert the data.
$Flag = 0;
while($data = fgetcsv(($handle))
{
if($Flag != 0)
{
// Execute the insert inside of this if statement
}
if($Flag == 0) $Flag = 1;
}

[@nigochen6665]

Thanks :)

[@ariefunited07]

i get this notice but i can"t solve the problem
Notice: Undefined offset: 1 in C:\xampp\htdocs\PhpProject1\index.php on line 14
help me to figure it out
thanks

[@moussaabbouzid579]

i have the same problem bro can u halp me plz :/

[@pranotipatil7070]

I'm facing the same issue ....now its fixed use the correct csv file format.

[@Sami-sg5os]

@@pranotipatil7070 you can replace the line of code "while($data = fgetcsv($handle))" with this one "while($data = fgetcsv($handle,1000,";"))". You must specify the separator.

[@shovonrahmanshuvo]

Great one.made my life easier... :D (Y)

[@webslesson]

Thanks Shovon...

[@robertbobila4682]

Good day sir.
Is this compatible for php 5?
Or 7 only?
Thanks.

[@webslesson]

Yes, it is compatible with both PHP 5 and 7.

[@gokuldasvs2205]

useful

[@obeddordor]

thx friends!

[@webslesson]

Thanks Kevin...

[@gz3442]

can i do that with file type is xlsx ?

[@abdulbasitrana2743]

No, You Can't

[@tordbjornalbertsen2901]

Okay i hope they rede and fixit

[@elysiumstudios]

Thank you

[@webslesson]

You are most welcome..

[@snatandharma6]

Import nhi ho rha hai item1 and...item2 uninitialized bta rha Ha i

[@amnaiqbal3080]

after choosing the file when we upload it, it returns no file chosen

[@amnaiqbal3080]

where as file ext is .csv

[@tordbjornalbertsen2901]

Notice: Undefined offset: 1 in /Applications/MAMP/htdocs/finans_dk.dk/upload_csv/index.php on line 14

[@tordbjornalbertsen2901]

again it is a problem in item2 that my mysqli will not accept, there is a solution :-((

[@patrickbevernage2919]

Yes, it doesn't work with me either.
When I make a txt file it works.

[@jihaddarmawan7985]

Not work

[@sagarkaushal5228]

Sir to me again and again no file choosen is shown please solve my problem

[@bulbulrani9307]

have you find any solution?

[@orpee4486]

Save your excel file as CSV (Comma Delimited). Choose "CSV (Comma Delimited)" in "Save as type"

[@zahidqureshi9523]

how can use 77mb file

[@webslesson]

Have you tried Zahid Queshi to upload this type of heavy file, for export this type of file you have to set server property.

[@zahidqureshi9523]

my csv file is 77mb and not import this file

[@zahidqureshi9523]

how import this file

[@attotadinesh356]

undefined index file : error -- i'm getting
Is there any solution for that error to get clear

[@edward3062]

i got the same problem.

[@glen3801]

have you got the answer guys?

[@trishulsherigar1961]

Same here.....

[@moussaabbouzid579]

Thanks u so much bro ❤️❤️❤️