How To Import CSV Into Database - CSV Import And Export Into Database Using PHP - part 1/2

[@rabiamohsin874]

Bohat zabardast nice

[@UltimateWebDevelopment]

thanks

[@panhavuthkret9842]

I love your step by step tutorial as well as testing out as you go. I'd love to request this same lesson but on a more complicate csv structure, seperate Name to First name, Last name, and how to save in multiple table. I have search around there isn't any good one yet. I love how you use just php (I saw some people using AJAX and so on which is fast but it is confusing for basic learner) to do it, basic and understandable.

[@UltimateWebDevelopment]

Noted

[@kinnarishah2930]

Can we do this import in procedure of MySQL? If CSV file contains more number of rows and if we need to manipulate / update multiple tables doing this in PHP script will not slow down performance? Please advise.

[@UltimateWebDevelopment]

yes

[@SKDurgesh]

where have you made that mysqli class which you extending, that's not clear

[@UltimateWebDevelopment]

my friend that mysqli class comes with default php code, we don't have to create it, it is part of php

[@sourapmusic415]

nice can you provide the source code of this???

[@UltimateWebDevelopment]

you can watch the video and write it yourself OR purchase one of my course to get full source code

[@caseyjake2681]

The code is absolutely perfect except there's one dilemma I'm having. i need to be able to insert apostrophes and mysql will not allow me to do this. Is there a way to include $mysqli->real_escape_string to this code, or another way to allow the other characters into the code. Also, it could null the field instead of not pasting the row all together, that would also be great. Thank you.

[@UltimateWebDevelopment]

your very welcome, and let me know if you still need any help

[@ZerotoheroTuT]

I'm just a beginner. Got some error, it says "Column count doesn't match value count at row 1Column count doesn't match value count at row 1". It seems that i missed something... could you help me ?

[@UltimateWebDevelopment]

show me screenshot of your whole code, you must be doing something wrong

[@reinaldoferreira4318]

Hi, very useful your video, could make something like that when you have to import a csv file with two or more sheets? I’m having issues to make a program with that kind of file

[@UltimateWebDevelopment]

well, i will try my best to make it

[@jeyarizvi4314]

Nice 👍

[@UltimateWebDevelopment]

thanks

[@millner100]

Well done!

[@UltimateWebDevelopment]

thanks

[@krunala.kishnadwala6198]

How Can i delete duplicate entries from database when importing same excel file?? Please reply me.

[@UltimateWebDevelopment]

well you have to check against id or username or any column in db and if exist then remove it

[@ashutoshsrivastava8252]

You should consider giving the source code. Nice way of telling by the way.

[@UltimateWebDevelopment]

for source code you will have to enroll in one of my course

[@hetvishah1295]

I'm getting the below error while executing the query. I have typed the same code. Warning: mysqli::query(): invalid object or resource csv

[@UltimateWebDevelopment]

you are not providing correct reference, plz follow correctly

[@MarcelRinker]

I just have one column. Can you help me?

[@UltimateWebDevelopment]

i need more information about this so i can help

[@subirsingh9539]

NIce, can u share how to save API data into MySQL.

[@UltimateWebDevelopment]

sure i will do my best to make video

[@NelsonFilipeCosta23]

Can you share the code?

[@UltimateWebDevelopment]

follow the video and write it

[@amardjebabla916]

plz can you can give me the code i need it for my final exams

[@UltimateWebDevelopment]

i provide source code only who purchase any of my course.

[@hemalbhatt9664]

aap kaha se padhte ho asa sab

[@UltimateWebDevelopment]

brother i try my best to make videos that are unique and most in demand

[@medsah6096]

Great video!

[@UltimateWebDevelopment]

Glad you enjoyed it

[@mojar2680]

Its good tutorial, sad that I wasn't looking for the OOP method :(

[@UltimateWebDevelopment]

it's not a big difference, you can follow this and use it without OOP

[@kwanpoyiu1380]

source code please??

[@UltimateWebDevelopment]

for source code you can enroll in any of my paid course and i will provide you source code

[@hemalbhatt9664]

great

[@UltimateWebDevelopment]

thanks

[@vaibhavshah3740]

source code please

[@UltimateWebDevelopment]

for source code you will have to enroll in one of my course

[@skeeterstudies8109]

Please share code

[@UltimateWebDevelopment]

i already replied you my friend

[@danalexandruapostol8247]

T

[@UltimateWebDevelopment]

your welcome