how to upload excel(csv) file to database with php & mysql

Показать описание

This video is about how you can upload an excel file to your database with PHP and MySQL database in easy and simple steps.

My blog link & download the source code:

Рекомендации по теме

Комментарии

Very useful vedio, I liked and subscribed your channel

educator

really good tutorial and all that but i have a question, how do you import more excel extensions ? such as xlsx, xlx and you answer my question please ? thanks

murtazanoori

Hi user,
the code told in this video is older now and it works PHP version < =5.2.
here is the source code link that will work on all versions.
the folder contains
1. A database, first import it.
2. Change the config files
3. upload the sample sheet in the folder.
It will work 100%

Source code link

Thanks!

CodingBirdsOnline

Does this work with .xls or .xlsx files or should it only be saved as csv ? If doesn't work, how can we make it accept xls and xlsx files too?

hhaneya

Thanks It Works For XAMPP 3.2.2(PHP Version:5.6.32)

yusufnasrul

What if the excel file will have a top column with label like NAME, EMAIL. how do you handle such situation. Thanks

akinlabiabdulkabeerhabeebu

How can I upload multile files? I followed the tutorial and I can only upload one file

JIGAup

Extravagant sir, Thank you for the knowledge you shared...make more and more.

simonkariuki

dear sir i want to add drop down list in csv file but its not work .i want to know how to upload only excel file .

mytech

error:---Warning: mysqli_query() expects at least 2 parameters, 1 given in on line 32
plzz sahre the source code link

Kajal_Verma

Sir can you please share source code of this please...

anitan

How to upload more files in this and save them in the the same Database?

bushrashourin

i want to send mail available email id in excel file, so how its possible??

jadejajaypalsinh

how can i upload image along with this

jincygeorge

I m getting fatal error at line 2 in comfig file

shrutiparulekar

show config.php file you dont showen ???

hardikchauhan

Thanks a lot!, greetings from Bogotá-Colombia!

macropsialberto

the below is the error am getting sir... Notice: Undefined offset: 1 in on line 135

Fatal error: Uncaught Error: Call to undefined function mysql_query() in Stack trace: #0 {main} thrown in on line 140

simonkariuki

why does the last data in the csv is the only one that adds in the database? help thanks

iztelc

how to upload excel(csv) file to database with php & mysql

How to Import CSV File Into Excel

How To Import CSV File Into Microsoft Excel [Tutorial]

Opening .CSV Files with Excel - Quick Tip on Delimited Text Files

How to Save Excel File as a CSV File

How to Convert a CSV File to Excel

How to Convert Excel to CSV (Quick and Correct)

How to Convert CSV to Excel (Simple and Quick)

Step-by-Step Guide: Importing Products into Your Shopify Store with CSV / Excel Files

Pandas: Nlargest & Nsmallest Functions | Python Tutorial

Import Series - Import CSV TXT File into Excel

How To Import A CSV File Into Office 365 Excel Mac - Excel Tutorial

How to Convert Excel File to CSV File Format

Use This Trick to Merge CSV Files Together Instantly

How to import a CSV to the online Excel

Import Excel/CSV file data into Postgresql database table pgAdmin 4

Importing csv files into Excel on a Mac

How to IMPORT Excel file (CSV) to MySQL Workbench.

Stata Lecture 2: How to import Excel/CSV data?

How to import data from Excel files to R | R Programming

How to Import CSV File Into Excel (In Hindi)

CSV Import and Export in Jira

How to Add Products using a CSV file || Shopify Help Center

Microsoft Excel 2019 | How to Import & Export .CSV, TXT Files | How to Convert CSV to Excel Tabl...

06 - Import Data from CSV Files into Excel using Power Query