How to Import Excel File in Codeigniter

Подписаться 96 тыс.

Просмотров 62 тыс.

50% 1

Learn How to Import Excel data mysql in Codeigniter using PHPExcel. Codeigniter Tutorial on Import or Upload Excel file into Mysql using Codeigniter. How to import data from excel to mysql database using PHPExcel with Codeigniter. Import Excel sheet into mysql database in Codeigniter.
For Source Code - www.webslesson....

Опубликовано:

21 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

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

@samario0912 3 года назад

Friend, thank you, it worked, greetings from Santa Marta Colombia. I did it directly from the form. in the view put

@franzibanez1558 4 года назад

Gracias por la ayuda Saludos desde BOLIVIA

@vrajchavda5425 9 месяцев назад

Thank you 😍

@hugengseto Год назад

thanks a lot bro, really helpful

@Andreanrahmansyahputra 5 лет назад

An uncaught Exception was encountered Type: Error Message: Call to undefined method Main_model::fetch_data() Filename: C:\xampp\htdocs\andreanrahmansyahputra\how-to-import-excel-file-in-codeigniter\application\controllers\main.php Line Number: 9 Backtrace: File: C:\xampp\htdocs\andreanrahmansyahputra\how-to-import-excel-file-in-codeigniter\index.php Line: 315 Function: require_once

@harshapriyalal3958 6 лет назад

It is working completely. thank you keep it up.

@fahadkp587 5 лет назад

Yeah That's worked for me. Thank you so much dear. Hope you post more useful videos in future

@gitaaulia1166 2 года назад

Thanks 👍

@shahinulislamsuzon9319 4 года назад

Your tutorial is good .I need react tutorial .This type tutorial will be help full to everybody........

@danapersad1179 5 лет назад

This did not work for me. Im getting an error on the main.php file on line 9 and i didnt change anything

@piusvictor8780 4 года назад

There are minor changes you need to do,first you need to create a database called testing then navigate on database.php file to make sure the configuration matches your database connection,second you have to go route.php and add $route['excel_import/fetch']='excel_import/fetch'; then go to your browser type the link your base_url followed with excel_import/fetch e.g base_url/excel_import/fetch and it will work as a magic,note:base_url represent the url path to your project root directory...

@vincentkenny98 5 лет назад

Thankyou so so much. You're my hero!

@patrickmaine7778 3 года назад

how to update only the existing row with same id in import?

@digitalcodelibrary3221 6 лет назад

GOOD FRIEND I WANT TO INSERT AN EXCEL FILE, BUT BEFORE I WOULD LIKE TO VALIDATE THAT IT DOES NOT HAVE EMPTY FIELDS AND AFTER THAT VALIDATE THAT IT IS NOT IN THE DATABASE NOTIFYING WITHOUT INSERT NOTHING

@rahmatfirman5765 6 лет назад

It's worked for me. But, it's seems like receive any file as long it's excel file and insert into db. I have been trying to import file that didn't match with the column requirement at column table but it's still success insert that data. How to add validation so just file that have save column with the table at db inserted. So, i can return an error message. Thanks.

@fahadkp587 5 лет назад

you can get the count of rows in selected file and database. just check weather they are equal or not

@The.eminence 2 года назад

thanks

@haadsine 4 года назад

life saver👍🏽

@zahidtuhin1407 6 лет назад

Really helpful.

@dediatib6573 6 лет назад

awesome tutorial,

@amirulafiq4371 6 лет назад

Hello Webslesson can you make a tutorial about editing and deleting imported data via mysql and then display it in excel after exporting?

@expresstutorial3255 6 лет назад

I want to show data in a table but then i want to show at the bottom i a new row, the result of a SUM From a column, how can i do that with datatables, jquery AJAX PHP and mysqli?? Could you do a tutorial.?

@befekaduasmare6410 6 лет назад

Thank You , Best Video. If you can please prepare tcpdf with code igniter video

@webslesson 6 лет назад

Ya sure we will publish video tutorial on Generate PDF by using TCPDF with Codeigniter.

@riaudeveloper6631 4 года назад

this did not work for me Im getting an error on the main.php file on line 9 and i didnt change anything. can you help me mr ? This Error : An uncaught Exception was encountered Type: Error Message: Call to undefined method Main_model::fetch_data() Filename: C:\xampp2\htdocs\testing\application\controllers\main.php Line Number: 9 Backtrace: File: C:\xampp2\htdocs\testing\index.php Line: 315 Function: require_once

@pedroacosta6124 3 года назад

Thanks

@robyortega6147 2 года назад

can make how skipp if row value empty please

@artichaudhari3539 2 года назад

I am getting this error Message: Class 'PHPExcel_Shared_String' not found

@arohiwahi8220 Год назад

excuess me their as issue of duplicate key error can you tell me the solution for it

@saurabhtechmave Год назад

it work on local is fine but it is not working in live server how can i fix this

@ayandas9477 4 года назад

value fetch successfully done but not in insert or importing data into database. hope anyone will help @Webslesson

@bernardgeron3694 4 года назад

I got an ziparchieve error. Is says something wrong with excel2007.php

@freedy9740 6 лет назад

i had watch this tutorial, very helpfully, i succeeded to display the data from the db , but the insert part is not working, is someone can provide assistance ?

@rahmatfirman5765 6 лет назад

can you show the error message ?see console at your web browser to see if any error happen with your code. make sure you didn't miss any line of code. see the full code at the web under description and compare with your code. contact me : transilica@gmail.com

@venkyammu9145 2 года назад

i have a function fetch issue not importin data can you help me

@MeghaNatekar59 15 дней назад

It is not working out for me

@ahsannisar8211 3 года назад

sir please tell me about read and write docx file in codeigniter

@michaelkaszuba3921 5 лет назад

Does this still work with the new PHPspreasheet extion?

@Cacanh180 5 лет назад

How to know that which row is inserted successful or not?

@rahmatfirman5765 5 лет назад

i think u should do that in the controller. first you need to check each data success or not inserted. push it into php object and then return it to view. you can display that data as you like. for example : in this tutorial. controller send one parameter as ajax function success return.

@Cacanh180 5 лет назад

Rahmat Firman i already did it. Query insert_batch return number of successful inserted records, ex: resultNumber. I get this number to function get_last_record(resultNumber) which is order by id (auto incre) desc. Then i just compare returned data to excel file.

@Jarjitsingh20 5 лет назад

Why this is not working?? And the css not applied. Can you help me?

@leoanglo6176 4 года назад

An uncaught Exception was encountered Type: Error Message: Call to undefined method Main_model::fetch_data() Filename: C:\xampp\htdocs\prologin\how-to-import-excel-file-in-codeigniter\application\controllers\main.php Line Number: 9 Backtrace: File: C:\xampp\htdocs\prologin\how-to-import-excel-file-in-codeigniter\index.php Line: 315 Function: require_once

@WaniaAliFoodSecret 4 года назад

Execllent

@christianigay6553 5 лет назад

db fetch successfully done but not in insert or importing data into database. hope anyone will help

@ijasdeen3809 6 лет назад

Please make a tutorial about creating social app like facebook or whatsApp

@codextricks 3 года назад

Class 'ZipArchive' not found file => application/libraries/PHPExcel/Reader/Excel2007.php on line 85

@syafa_channel2938 4 года назад

The action you have requested is not allowed.

@namrataskale130 2 года назад

Display no direct script access allowed

@syafa_channel2938 4 года назад

what if the date format?

@AlexanderKwalsh 6 лет назад

Good tutorial. Please can you send a download link to this tutorial so we can download it? Thank you

@rahmatfirman5765 6 лет назад

check in the description. He provide web link to see the full code.

@Cacanh180 5 лет назад

@@rahmatfirman5765 500 internal server error. i download code above but not work

@parthprajapati8977 5 лет назад

.sql file is not available in source code

@hassanfarooq2502 2 года назад

Hi Sir its humble request please accet . Can We code in This video also in Codeligniter 4

@sistemassarco8234 5 лет назад

how import dates? please

@Kajal_Verma17 5 лет назад

plz give me Excel folder all files code like phpexcel.php, excel.php, IOFactory

@wz_alex9798 6 лет назад

index name undefined :'v helpmeeeeeeeee

@pharyyady 6 лет назад

Hi Friends

@ulinnuha1961 4 года назад

save permission

@christianigay6553 5 лет назад

500 internal server error

@rezachrisna2453 5 лет назад

i think it was because you send $data in controller but not setting $data in model, so $data is not initialization for model, that's what make it error

@Cacanh180 5 лет назад

@@rezachrisna2453 did you fix this one? can you show me full code. i download code above but not work. same 500 internal server error

@Cacanh180 5 лет назад

i found it. you should set variable in autoload.php as video clip above. in 2:00