Insert Excel file into MySQL database using PHP

Insert Excel file into MySQL database using PHP

Codes and Tricks

4 года назад

28,579 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@anarishakari8627
@anarishakari8627 - 20.12.2022 00:21

Loved it. Great work.👍

Ответить
@abrudeandenisa9442
@abrudeandenisa9442 - 07.06.2022 20:23

I have this error
Uncaught Error: Class 'SimpleXLSX' not found

Ответить
@Kalot_tv
@Kalot_tv - 08.02.2022 04:19

Good Nice Its helpful keep up the good deeds my friend

Ответить
@afoidahmedali9932
@afoidahmedali9932 - 24.12.2021 04:02

Thank you so much

Ответить
@IsHardynafthardynaft
@IsHardynafthardynaft - 28.11.2021 14:41

Shis is my sh*t 4

Ответить
@alemayehutesfaye1653
@alemayehutesfaye1653 - 29.10.2021 16:49

Thank you very much I have solved my problem

Ответить
@easwaranv9856
@easwaranv9856 - 15.10.2021 15:37

how to import xls and csv file

Ответить
@dr.jagdishthacker6085
@dr.jagdishthacker6085 - 12.10.2021 16:57

very nice really I appreciate

Ответить
@treetext3182
@treetext3182 - 09.07.2021 18:24

God Bless You Bro...

Ответить
@matheshrx8625
@matheshrx8625 - 20.06.2021 17:42

Great tutorial. just struggled to modify the code to enter only data in existing table instead of creating a new table and inserting in it,Thanks sir

Ответить
@MdHasan-pg8sx
@MdHasan-pg8sx - 30.03.2021 05:56

Thanks you so much! upload more Tricks.

from Bangladesh!

Ответить
@buzzolol
@buzzolol - 04.03.2021 04:21

For some reason if i add another column on excel dont work anymore

Ответить
@erictan7379
@erictan7379 - 23.02.2021 16:05

Anyone can help me, i not sure why my last row in my excel sheet will be save duplicated on phpMyAdmin side

Ответить
@MrFullstackDeveloper
@MrFullstackDeveloper - 15.01.2021 18:32

very nice! I love this sir thanks!

Ответить
@hhaneya
@hhaneya - 02.12.2020 14:12

My columns are not all of type varchar(50). I have 2 int(255) and 2 varchar(120) and the primary key is auto-increment. How can I implement that in my code? Thank you

Ответить
@shivasingh188
@shivasingh188 - 20.11.2020 09:20

SimpleXLSX class not find error

Ответить
@tanzeelurrehman8419
@tanzeelurrehman8419 - 12.08.2020 09:54

Function rtrim is not working to remove comma ","

Ответить
@sevenadams2979
@sevenadams2979 - 03.06.2020 03:16

Great video. Is it possible for one to write a php code that will upload a csv file and import it to mysql database as it is, without having to first read and manipulate the contents of the file because the file can have upto 15 rows and 48 columns?

Ответить