Hi Manu. After view this great video, maybe to see LoaderDataPlus tool. This tool import flat files and export to MYSQL, MARIADB sintax and other DMBS, also parsing and detect data type.
First of all excellent video...but i am facing some issue...i used the same code, but it is not running ...my query is printing, but table is not getting created..please help
Hi. I have a csv file having 4 lac+ records in it. I want to add these records in mysql database with minimum time like in 4-5 minutes using laravel. Kindly tell me what exact i have to do with. I have done many methods and all takes too much time to insert data into DB.
Thanks for the tutorial. It really works. By the way, if you don't mind me asking for help. If I want to always update the data in database do I need to upload the csv everyday? Because I am selling products to clients so I need to store my data. Right now my forms are in PDF then convert to excel or csv then to database. Do you have any shortcuts like PDF data entry directly goes to Mysql? And if I want to retrieve data i can also do it directly to pdf form?
I am sure I type the exactly same as you did but I got this error what is happening? Notice: Undefined index: csvfile in C:\xampp\htdocs\insert.php on line 6
Thanks so much. i love this tutorials. I would to get one on a way where the table columns is gotten dynamically from the csv file without you specifying them in code
it is just the cell of the CSV. please check with your CSV column. if you having 2 columns on your CSV file, then use only $cont[0],$cont[1]. if you looking for $cont[2]. it will show you an error.
The below is the error message am getting, please help sir.........Fatal error: Uncaught Error: Call to undefined function myqsli_connect() in C:\xampp\htdocs\login\tuts\insert.php:2 Stack trace: #0 {main} thrown in C:\xampp\htdocs\login\tuts\insert.php on line 2
Video for excel sheet Importing - ruclips.net/video/9ijUxsttphk/видео.html
i know I am pretty randomly asking but do anybody know of a good website to watch new tv shows online?
@Otis Luciano Flixportal :)
@Walter Lucca thank you, signed up and it seems like they got a lot of movies there :) Appreciate it!
@Otis Luciano happy to help :)
It's really very very useful... thankyou 😁
Hi Manu. After view this great video, maybe to see LoaderDataPlus tool. This tool import flat files and export to MYSQL, MARIADB sintax and other DMBS, also parsing and detect data type.
GRACIAS
First of all excellent video...but i am facing some issue...i used the same code, but it is not running ...my query is printing, but table is not getting created..please help
Hey I need the 2 file php codes. Can you pls share with me
thank you somuch
Thanks you so much !!..
Hello, This is working perfectly local server. But not working Live server(CPanel). What is the reason behind that?
Hi. I have a csv file having 4 lac+ records in it. I want to add these records in mysql database with minimum time like in 4-5 minutes using laravel. Kindly tell me what exact i have to do with. I have done many methods and all takes too much time to insert data into DB.
Sir can you upload the link for the source code ?
Thanks for the tutorial. It really works.
By the way, if you don't mind me asking for help. If I want to always update the data in database do I need to upload the csv everyday?
Because I am selling products to clients so I need to store my data.
Right now my forms are in PDF then convert to excel or csv then to database. Do you have any shortcuts like PDF data entry directly goes to Mysql? And if I want to retrieve data i can also do it directly to pdf form?
Good job! More videos please on PHP! Thanks!
Thank you very much for your real video. I search many videos about this topic in youtube but maximum are not workable. Thanks a lot again
Thanks for you tutorial! Really helpful!
great,
Hey this is great, thanks a lot, actually, you're good at teaching, you go slow and makes it easy to understand you. Cheers!
I am sure I type the exactly same as you did but I got this error what is happening?
Notice: Undefined index: csvfile in C:\xampp\htdocs\insert.php on line 6
how do you prevent the column names from inserting into the database? Thx
how if we not using localhost but using real server? is it works?
100% working..Thank you So much.
This video makes surprise me. Thanks so much
Please make a video on importing excel file in mysql php database.
ruclips.net/video/9ijUxsttphk/видео.html
@@CodesandTricks thank you
how to import do not use the input form, so automatically import the csv dump to mysql file ??
Thanks so much. i love this tutorials. I would to get one on a way where the table columns is gotten dynamically from the csv file without you specifying them in code
Thanks for comment, Ebenezer
This helpful, but where did the browse button come from?
Thanks buddy it worked !
This was fantastic. Thank you for posting it.
hey nice video can you tell me what is cont[ ] here as it is showing that undefined offset
it is just the cell of the CSV. please check with your CSV column. if you having 2 columns on your CSV file, then use only $cont[0],$cont[1]. if you looking for $cont[2]. it will show you an error.
Thank you so much..!!! It worked ..!!
الْحَمْدُ للَّهِ رَبِّ الْعَالَمِيْن thanks Cody my Indian mate
The below is the error message am getting, please help sir.........Fatal error: Uncaught Error: Call to undefined function myqsli_connect() in C:\xampp\htdocs\login\tuts\insert.php:2 Stack trace: #0 {main} thrown in C:\xampp\htdocs\login\tuts\insert.php on line 2
myqsli_connect() should be mysqli_connect() :)
Anyone has same problem?