- This Library makes it very easy to Integrate Ajax based DataTables in CodeIgniter
- It uses CodeIgniter's Database Query Builder API so you have all the powers in one place
- It does not require any interface Class or extra Model to construct the query
- It enables you to bind custom search, Where Clauses, Having Clauses, Group by and Order by clauses.
- It can also mutate (Edit) Query field before sendng it to the DataTables.
- It makes it easy to Add Action (Edit/Delete/View etc) Columns to the Query and you can easily bind it to the Table.
- It can format Columns as Currency, Percent, Date and Number and You can use its Edit COlumn ability to have any other formating and calculation.
To understand how to use this library and get full benefits of it, Follow the step by step process below
- Download the library by clicking here or cloning it via git or whatever method you like.
- You will get a zip file (If you downloaded from the link above).
- Extract the Zip library so you can get the package files
- Locate
application/libraries/DataTables.phpfile.
- Copy/Move the
DataTables.phpfile from the packageapplication/librariesdirectory - And paste it into your CodeIgniter's
application/libariesdirectory. - Open
application/config/autoload.phpfrom your Codeigniter's Directory. - Locate
$autoload['libraries'] = array(...)and addDataTablesto the array. - Save changes to the
autoload.phpfile.
- We are going to use Employees Sample Database
- Download this database from here
- Database Schema can be located here
- Follow the instruction in the Database Github page and Intsall this database so we can use it smoothly in our examples.
- Go ahead and create a Controller class with the name
Company.phpinapplication/controllers/directory - Paste the following code into the
Company.php
class Company extends CI_Controller{
public function employees_ajax(){
echo '{}';
}
public function employees(){
$this->load->view('employees');
}
public function departments_ajax(){
echo '{}';
}
public function departments(){
$this->load->view('departments');
}
}
- You must download or generate a DataTables Js/Css Library from the DataTables.net website
- You can use thi sview to get started, We have generated a full package compatible with our example.
- Goto
application/views/and create a file with nameemployees.php - Paste the following code into the
employees.phpfile
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Employees</title>
<link href="css/bootstrap.min.css" rel="stylesheet">
<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:https:// -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
<![endif]-->
</head>
<body>
<h1>Hello, world!</h1>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
</body>
</html>