PHP Tutorials,Examples and Demos

This Datatable jquery tutorial help to parse JSON data which was received from server side.I got huge response from reader on datatable tutorials,i am sharing next level datatable tutorial with php and mysql,I am extending Datatable Pagination, Sorting and Search – Server Side (PHP/MySQl) Using Ajax. Sometimes we need to add some text,process json data or filter JSON object data before to send datatable jQuery table.I am using Datatable in-build call back dataSrc() function which will parse JSON data as your requirement and send to datatable. This tutorial will help to achieve following milestone, Added Hyperlink(Anchor HTML tag) on column in jquery datatable. Added img HTML tag in table td column. Added edit/delete and view action button. Also Checkout other tutorial of jQuery Datatable, Part 1: Introduction of Datatable Part 2- DataTables Example – Server-side Processing with PHP Part 3 - How to add RowId and RowClass on each record using Datatable Part 4 - Datatable Pagination, Sorting and Search – Server Side (PHP/MySQl) Using Ajax Part5 - Export the jQuery Datatable data to PDF,Excel,CSV and Copy Part 6 - Datatable Responsive - Using PHP and Mysql with Ajax Part 7 - How to parse JSON data in datatable I am are using below Files in this tutorial Index.php - This file will responsible to create html and instance datatable using jquery code. response.php - This file responsible to create database connection string and convert records into json string and returns data to Ajax method as response. connection.php - This file responsible to create mysql database connection. I already mentioned in this post i am extending Datatable Pagination, Sorting and Search – Server Side (PHP/MySQl) Using Ajax, so i assumed you have read and understand that tutorial. How to parse JSON data in jQuery Datatable Step 1: we will create new profile_image column in employee table. This column will store profile image path. ALTER TABLE `employee` ADD `profile_image` VARCHAR(255) NOT NULL DEFAULT 'images/default_profile.png' AFTER `employee_age`; Step 2: Added profile_image column in $column array in response.php file. //define index of column $columns array( 0 >'id', 1 >'employee_name', 2 > 'employee_salary', 3 > 'employee_age', 4 >'profile_image' ); Step 3: Added profile_image and Action column in HTML table header and footer heading in index.php file. Empid Name Salary Age Image Action Empid Name Salary Age Image Action Step 4: We will user dataSrc callback jquery datatable function to parse JSON object.This function will take JSON data as a parameter which will returned from Ajax request. $( document ).ready(function() { $('#employee_grid').DataTable({ ..... "ajax":{ ..... "dataSrc": function (jsonData) { for ( var i0, lenjsonData.data.length ; i

Php

How to Generate Barcode using PHP 7

Categories

Php

How to Generate Barcode using PHP 7

Categories

Headline