I got data But it will append at second row instead of first row, so it will show no data available

I got data But it will append at second row instead of first row, so it will show no data available

ashishaware2830ashishaware2830 Posts: 1Questions: 1Answers: 0

<!DOCTYPE HTML>
<html lang="en-US">
<head>
<meta charset="UTF-8">
<title>Customer List</title>
<meta name="viewport" content="initial-scale=1.0,maximum-scale=1.0,user-scalable=no">
<link rel="icon" type="image/ico" href="<?php echo base_url();?>favicon.ico">
<link rel="stylesheet" href="<?php echo base_url();?>bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="<?php echo base_url();?>css/elusive/css/elusive-webfont.css">
<link rel="stylesheet" href="<?php echo base_url();?>js/lib/datatables/css/bootstrap.dataTables.css">
<link rel="stylesheet" href="<?php echo base_url();?>js/lib/datatables/extras/TableTools/media/css/TableTools.css">
<link rel="stylesheet" href="<?php echo base_url();?>css/style.css">
<link rel="stylesheet" href="<?php echo base_url();?>css/blue.css" id="theme">
<link rel="stylesheet" href="<?php echo base_url();?>css/fonts.googleapis.css">
</head>
<body>
<!-- main wrapper (without footer) -->
<div id="main-wrapper">
<?php include("header.php");?>
<section id="main_section">
<div class="container-fluid">
<div id="contentwrapper">
<div id="content">
<!-- main content -->
<div class="row-fluid">
<div class="span12">
<div class="box_a">
<div class="box_a_heading"></div>
<div class="box_a_heading"><!--important div to show table sorting text on it--></div>
<div class="box_a_content">
<table id="dt_scroll" class="table table-striped">
<thead>
<tr>
<th>Sr. No.</th>
<th>ecap app id</th>
<th>Customer Name</th>
<th>Customer Contact</th>
<th>Application-ID</th>
<th>File Status</th>
<th>City</th>
<th>Vendor Login Date</th>
<th>Total Amount Applied</th>
<th>Sanctione Date</th>
<th>Loan Amount Sanctioned</th>
<th>Name Of Vendor</th>
<th>Sourcing Channel</th>
</tr>
</thead>
<tbody id="abc">
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include("sidemenu.php");?>
<div id="footer_space"></div>
</div>
</section>
</div>
<?php include("footer.php");?>
<script src="<?php echo base_url();?>js/jquery.min.js"></script>
<script src="<?php echo base_url();?>js/jquery-migrate-1.2.1.min.js"></script>
<script src="<?php echo base_url();?>bootstrap/js/bootstrap.min.js"></script>
<script src="<?php echo base_url();?>js/jquery.actual.min.js"></script>
<script src="<?php echo base_url();?>js/jquery_cookie.js"></script>
<script src="<?php echo base_url();?>js/jquery.jpanelmenu.js"></script>
<script src="<?php echo base_url();?>js/tinynav.js"></script>
<script src="<?php echo base_url();?>js/hagal_common.js"></script>
<script src="<?php echo base_url();?>js/lib/datatables/jquery.dataTables.min.js"></script>
<script src="<?php echo base_url();?>js/lib/datatables/bootstrap.dataTables.js"></script>
<script src="<?php echo base_url();?>js/pages/hagal_datatables.js"></script>
<script src="<?php echo base_url();?>js/spanbadge.js"></script>
<script>
$(document).ready(function(){
$('#dt_scroll').dataTable();
});

    $(document).ready(function()
    { 
        $.ajax({
            url:"<?php echo base_url()?>super_admins/customer_controller/get_customer_list",
            type: "POST",
            dataType: 'json',
            success: function(data)
            {
                    var obj = data;
                     var i;
                            for (i = 0; i < obj.length; i++) {

                                if(i%2 != 0){                                       
                                    var category = '<tr class="odd">'                                           
                                        + '<td class="sorting_1" >' +  obj[i].sr + '</td>'
                                        + '<td>' +  obj[i].mis_no + '</td>'
                                        + '<td>' +  obj[i].customer_name + '</td>'
                                        + '<td>' +  obj[i].mobile1 + '</td>'
                                        + '<td>' +  obj[i].vendor_appli_id + '</td>'
                                        + '<td>' +  obj[i].work_status + '</td>'
                                        + '<td>' +  obj[i].work_city + '</td>'
                                        + '<td>' +  obj[i].vendor_login_date + '</td>'
                                        + '<td>' +  obj[i].total_amount_applied + '</td>'
                                        + '<td>' +  obj[i].sanctioned_declined_date + '</td>'
                                        + '<td>' +  obj[i].loan_amount_sanctioned + '</td>'
                                        + '<td>' +  obj[i].vendor_name + '</td>'
                                        + '<td>' +  obj[i].source_channel + '</td>'
                                        + '</tr>';                           
                        $("#abc").append(category);
                                }
                                else{
                                    var category = '<tr class="even">'                                          
                                        + '<td class="sorting_1" >' +  obj[i].sr + '</td>'
                                        + '<td>' +  obj[i].mis_no + '</td>'
                                        + '<td>' +  obj[i].customer_name + '</td>'
                                        + '<td>' +  obj[i].mobile1 + '</td>'
                                        + '<td>' +  obj[i].vendor_appli_id + '</td>'
                                        + '<td>' +  obj[i].work_status + '</td>'
                                        + '<td>' +  obj[i].work_city + '</td>'
                                        + '<td>' +  obj[i].vendor_login_date + '</td>'
                                        + '<td>' +  obj[i].total_amount_applied + '</td>'
                                        + '<td>' +  obj[i].sanctioned_declined_date + '</td>'
                                        + '<td>' +  obj[i].loan_amount_sanctioned + '</td>'
                                        + '<td>' +  obj[i].vendor_name + '</td>'
                                        + '<td>' +  obj[i].source_channel + '</td>'
                                        + '</tr>';
                        $("#abc").append(category);
                                }

                                }//for loop

                $('#dt_scroll').dataTable(); 
            }//success function

        });
    });

    </script>
</body>

</html>

This discussion has been closed.