Import CSV to MySQL using PHP | Display Imported Data
Vložit
- čas přidán 9. 04. 2020
- Hey Guys What up!
In this video, you can find how to import the data from the csv into the mysql databasse using php language. So, we will upload the csv and then read all the data from the csv and store that data into database using PHP. Then we will go to the step 2 of this video i.e. we will read the imported or we can say uploaded data from the database and then display it on the webpage. We will again use PHP for this.
Hope it Helps!
@CodeFlix12
For more about these videos, subscribe to my channel CodeFlix.
Link: bit.ly/CodeFlix
BE MY 'THE PATREON' and enjoy some exciting benefits and custom help in you projects or development practices : / codeflix
Watch My Other Playlists:
PHP: bit.ly/2PslVTs
NODEJS : Nodejs From Basics to Advance: bit.ly/2ZrJMXX
Html & Css | Awesome Stuff: bit.ly/2MM5BLe
One Minute Code: bit.ly/2ZFo8ei
GIT Basics for Beginners: bit.ly/2Ruf0s4
Also If you want updated projects and codes follow :
Github(Codeflix12) : bit.ly/2po5Gup
Telegram Channel: CodeFlix
// import csv to mysql
// import csv to mysql php
// import csv php mysql
Muitissimo obrigado. Era exatamente isto que eu estava procurando. Valeu irmão.
It was a great video. I learned a lot.
AWESOME! IT WORKED! THANK YOU SO MUCH!
❤️❤️❤️
awesome tuts :). Keep it up bro
Thanks bro❤️❤️
@@CodeFlix12 Hi, bro i troubling with a small issue, After upload csv file special character not supporting what i should to do bro!. the text come in like this
S�ren Bager AS
but i import Øst-Finnmark tingrett this type of text please give me solution
how about the csv file size is 60 mb and has 60k rows? Which code should be changed?
is there anyway that column automatically adjust to the csv file in the database while uploading
which code editor are you using? I've been using notepad++ which seems to lack some features.
Visual studio code
Muy fácil, espero me salga igual.
Yes it is
does your CSV file contains the table column names?
Yes
i got an error as Undefined index: file
where's the code for the button choose file?
can u drop the csv file structure?
I have shown it
I try to copy all codes but didn't work on my scratch, always echoing "Problem in importing csv"
Is csv valid?
Problem : Only 0th row i'm getting in array but other rows are missing...
Then you might not be reading it from file
2.51 what did you do there on line 13? with that comma
because i have a error: Parse error: syntax error, unexpected ';'
otherwise you can comment the code on line 13 below thnx!
Hey Sir, the ';' is necessary, you might be missing a double quote in that line somewhere, and that's why you are getting error!
Hi CodeFlix - I've got this error "Warning: Undefined array key "temp_name". May I know where is this "temp_name"
Just control + f on code and you will find it
@@CodeFlix12 Yes, I see there is only [tem_name]. Did you declare this array? because I can't find it.
@@CodeFlix12 Sorry it's my bad, it should be tmp_name not temp_name. Thanks a lot it work now.
Happens with me too🙌
@@danvallesfin8516 :) same error LOL...
problem: Undefined array key "file"
Warning: Trying to access array offset on value of type null line 6
Try files
I got same problem and also tried with files
Sir....I have got error
This while loop is not getting terminated
See length of file, Because loop runs until end of file
@@CodeFlix12 can i get the code please
In the description
i hope you react soon bro
I did
can I get this code?
Sure
In the description
@@CodeFlix12 can't find sir
Follow the code then
Can i get the code please
In the description
@@CodeFlix12 nop