PHPFixing
  • Privacy Policy
  • TOS
  • Ask Question
  • Contact Us
  • Home
  • PHP
  • Programming
  • SQL Injection
  • Web3.0

Tuesday, March 15, 2022

[FIXED] how to specific response in ajax datatable using codeigniter?

 March 15, 2022     ajax, codeigniter, php     No comments   

Issue

This my code for datatable in view file (Codeigniter 3)

function trade_Datatable()
{
    $.ajax({
        url:'<?php echo base_url('user/get_trade_manage'); ?>',
        type:'POST',

        success:function(data)
        {
            var dataTable=$('#trade_management').DataTable({
            'searching' : false,
            'ordering'  : false,
            'processing': true,
            'serverSide': true,
            'ajax':'<?php echo base_url('user/get_trade_manage'); ?>',
            
            "rowCallback": function( row,response) {

                $('td', row).css('background-color', '#00b0f0');
                
                },

            });
        }

    });
}
trade_Datatable();

Controller code

......
$output['draw']=$draw;
$output['recordsTotal']=$counts;
$output['recordsFiltered']=$counts;
$output['data']=$data;
$output['colors']=$bgcolor;
echo json_encode($output);

i need to echo $bgcolor variable inplace #00b0f0 of to apply style dynamically.Anyone suggest best answer ?


Solution

User createdRow for apply styles in ajax datatables

$.ajax({
        url:'<?php echo base_url('user/get_trade_manage'); ?>',
        type:'POST',
        success:function(data)
        {
            var dataTable=$('#trade_management').DataTable({
            'searching' : false,
            'ordering'  : false,
            'processing': true,
            'serverSide': true,
            'ajax':'<?php echo base_url('user/get_trade_manage'); ?>',
    
            columns:[
                {data: 'sno'},
                {data: 'created'},
                {data: 'updatedon'},
                {data: 'tip_type'},
                {data: 'tip_for'},
                {data: 'script_name'},
                {data: 'tip_date'},
                {data: 'tip_position'},
                {data: 'tip_price'},
                {data: 'action'},
                {data: 'tip_exitat'},
                {data: 'photo'},
                {data: 'profit_loss'},  
                ],
    
                createdRow: function(row, rowColors, dataIndex)
                {
                    var colorRow = rowColors.colors;
                    $(row).css('background-color',colorRow);
                }
    
                });
            }
        });


Answered By - manikandan
  • Share This:  
  •  Facebook
  •  Twitter
  •  Stumble
  •  Digg
Newer Post Older Post Home

0 Comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Total Pageviews

Featured Post

Why Learn PHP Programming

Why Learn PHP Programming A widely-used open source scripting language PHP is one of the most popular programming languages in the world. It...

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments

Copyright © PHPFixing