Hello everyone š. Long time no writting to this blog. And sorry if I don’t reply so many comments. Because busy with other thing and jobs. (actually not busy. just pretending to be busy lol) just let’s start. I’ve created a library to make it easier to implement the server-side DataTable in codeIgniter4. I’ve share the code to GitHub . Here I want to make a small tutorial how to use. Maybe I will not too detail like previous article. But I’ll try as easy to understand as possible. Requirement : CodeIgniter 4.x jQuery jQuery DataTables 1.10.x CodeIgniter4-DataTables Library Database and
(Codeigniter) Server-side DataTables Bootstrap with Custom Filter
Screenshot : Ā Required and Included on this source : PHP+ MySQL or you may use XAMPP –> Download Codeigniter 3.1.0 –> Download jQuery 2.2.3 –> Download Bootstrap 3.3.7 –> Download DataTables 1.10.12 –> Download Database and Query : or you can download sample data here : example.sql Configuring Codeigniter : assets folder structure : Routing path : config/route.php Base URL Cofig (required if using Codeigniter 3.0.3 or later) path : config/config.php see for dynamic base_url : Dynamic base_url() and site_url() Codeigniter 3.0.3 + Source Code model : Customers_model.php path : application/models/Customers_model.php Controller Customers.php path : applications/controllers/Customers.php
(Codeigniter) Simple Server-side DataTables Bootstrap with ColVis (Column Visibility Extension)
Screenshot : Required and Included on this source : PHP+ MySQL or you may use XAMPP –> Download Codeigniter 3.1.0 –> Download jQuery 2.2.3 –> Download Bootstrap 3.3.7 –> Download DataTables 1.10.12 –> Download dataTables.colVis.css –> Download dataTables.colVis.js –> Download dataTables colVis site –> https://datatables.net/extensions/colvis Database and Query : or you can download sample data here : example.sql Configuring Codeigniter : assets folder structure : Routing path : config/route.php Base URL Cofig (required if using Codeigniter 3.0.3 or later) path : config/config.php see for dynamic base_url : Dynamic base_url() and site_url() Codeigniter 3.0.3 + Source Code model :
(Codeigniter) Simple Server-side Datatables bootstrap style example
Screenshot : Required and Included on this source : PHP+ MySQL or you may use XAMPP –> Download Codeigniter 3.1.0 –> Download jQuery 2.2.3 –> Download DataTables 1.10.12 –> Download Database and Query : or you can download sample data here : example.sql Configuring Codeigniter : assets folder structure : Routing path : config/route.php Base URL Cofig (required if using Codeigniter 3.0.3 or later) path : config/config.php see for dynamic base_url : Dynamic base_url() and site_url() Codeigniter 3.0.3 + Source Code model : Customers_model.php path : application/models/Customers_model.php Controller Customers.php path : applications/controllers/Customers.php view : customers_view.php
(Codeigniter) Ajax CRUD using Bootstrap modals and DataTables with Bulk Delete
Screenshot : Required and Included on this source : PHP+ MySQL or you may use XAMPP –> Download Codeigniter 3.1.0 –> Download jQuery 2.1.4 –> Download Twitter Bootstrap 3.3.7 –> Download Bootstrap-datepicker 1.6.1 –> Download DataTables 1.10.12 –> Download Database and Query : Configuring Codeigniter : assets folder structure : Routing path : config/route.php Base URL Cofig (required if using Codeigniter 3.0.3 or later) path : config/config.php see for dynamic base_url : Dynamic base_url() and site_url() Codeigniter 3.0.3 + Source Code model : Person_model.php path : application/models/Person_model.php Controller Person.php path : applications/controllers/Person.php view : person_view.php
(Codeigniter) Ajax CRUD using Bootstrap modals and DataTables with image upload
Screenshot : Required and Included on this source : PHP+ MySQL or you may use XAMPP –> Download Codeigniter 3.1.0 –> Download jQuery 2.1.4 –> Download Twitter Bootstrap 3.3.7 –> Download Bootstrap-datepicker 1.6.1 –> Download DataTables 1.10.12 –> Download Database and Query : Configuring Codeigniter : assets folder structure : Routing path : config/route.php Base URL Cofig (required if using Codeigniter 3.0.3 or later) path : config/config.php see for dynamic base_url : Dynamic base_url() and site_url() Codeigniter 3.0.3 + Source Code model : Person_model.php path : application/models/Person_model.php Controller Person.php path : applications/controllers/Person.php view
(Codeigniter) Simple server-side DataTables example
Screenshot : Required and Included on this source : PHP+ MySQL or you may use XAMPP –> Download Codeigniter 3.0.6 –> Download jQuery 2.2.3 –> Download DataTables 1.10.11 –> Download Database and Query : or you can download sample data here : example.sql Configuring Codeigniter : assets folder structure : Routing path : config/route.php Base URL Cofig (required if using Codeigniter 3.0.3 or later) path : config/config.php see for dynamic base_url : Dynamic base_url() and site_url() Codeigniter 3.0.3 + Source Code model : Customers_model.php path : application/models/Customers_model.php Controller Customers.php path : applications/controllers/Customers.php view :
(Codeigniter) Dynamic base_url() and site_url() Codeigniter 3.0.3 +
For security reason codeigniter 3.0.3 or later $config[‘base_url’] must be configure manually. check this article -> https://www.codeigniter.com/userguide3/installation/upgrade_303.html When $config[‘base_url’] is not set, CodeIgniter tries to automatically detect what your websiteās base URL is. This is done purely for convenience when you are starting development of a new application. Auto-detection is never reliable and also has security implications, which is why you should always have it manually configured! One of the changes in CodeIgniter 3.0.3 is how this auto-detection works, and more specifically it now falls back to the serverās IP address instead of the hostname requested by the client. Therefore,
(Codeigniter) Ajax CRUD using Bootstrap modals and DataTables with server-side validation
Screenshot : Required and Included on this source : PHP+ MySQL or you may use XAMPP –> Download Codeigniter 3.0.2 –> Download jQuery 2.1.4 –> Download Twitter Bootstrap 3.3.5 –> Download Bootstrap-datepicker 1.4.0 –> Download DataTables 1.10.7 –> Download Database and Query : Configuring Codeigniter : assets folder structure : Routing path : config/route.php Base URL Cofig (required if using Codeigniter 3.0.3 or later) path : config/config.php see for dynamic base_url : Dynamic base_url() and site_url() Codeigniter 3.0.3 + in this source leave empty because using codeigniter 3.0 Source Code model : Person_model.php path : application/models/Person_model.php Controller
(Codeigniter) Ajax CRUD using Bootstrap modals and DataTables
Screenshot : Required and Included on this source : PHP+ MySQL or you may use XAMPP –> Download Codeigniter 3.0 –> Download jQuery 2.1.4 –> Download Twitter Bootstrap 3.3.5 –> Download Bootstrap-datepicker 1.4.0 –> Download DataTables 1.10.7 –> Download Database and Query : Configuring Codeigniter : assets folder structure : Routing path : config/route.php Base URL Cofig (required if using Codeigniter 3.0.3 or later) path : config/config.php see for dynamic base_url : Dynamic base_url() and site_url() Codeigniter 3.0.3 + in this source leave empty because using codeigniter 3.0 Source Code model : Person_model.php path : application/models/Person_model.php