Ufdjrw

< script >
 $(document).ready(function() 
 $('#example').DataTable(
 colReorder: true,
 "scrollX": true,
 "processing": true,
 "serverSide": true,
 "ajax": "rep_down_data.php"
 );
 ); <
/script>

<?php
$table = 't_user';
$primaryKey = 'id';
$columns = array(
 array( 'db' => 'is_phone_verified', 'dt' => 0 ),
 array( 'db' => 'email', 'dt' => 1 ),
 array( 'db' => 'mobile_number', 'dt' => 2 ),
 array( 'db' => 'first_name', 'dt' => 3 ),
	array( 'db' => 'last_name', 'dt' => 4 ),
 array( 'db' => 'rep_code', 'dt' => 5 ),
);
require('config.php');
$sql_details = array(
	'user' => $db_username,
	'pass' => $db_password,
	'db' => $db_name,
	'host' => $db_host
);
require('ssp.customized.class.php' );
$joinQuery = "FROM `t_user` AS `u` JOIN `t_user_course` AS `ud` ON (`ud`.`user_id` = `u`.`id`)";
echo json_encode(
	SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns, $joinQuery )
);

<?php
$table = 't_user';
$primaryKey = 'id';
$columns = array(
 array( 'db' => 'created_at', 'dt' => 0 ),
 array( 'db' => 'email', 'dt' => 1 ),
 array( 'db' => 'mobile_number', 'dt' => 2 ),
 array( 'db' => 'first_name', 'dt' => 3 ),
	array( 'db' => 'last_name', 'dt' => 4 ),
);
require('config.php');
$sql_details = array(
	'user' => $db_username,
	'pass' => $db_password,
	'db' => $db_name,
	'host' => $db_host
);
require( 'ssp.class.php' );
echo json_encode(
 SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
);

<section id="column-filtering">
 <div class="row">
 <div class="col-12">
 <div class="card">
 <div class="card-header">
 <h4 class="card-title">Rep Downloads</h4>
 <a class="heading-elements-toggle"><i class="la la-ellipsis-v font-medium-3"></i></a>
 <div class="heading-elements">
 <ul class="list-inline mb-0">
 <li><a data-action="collapse"><i class="ft-minus"></i></a></li>
 <li><a data-action="reload"><i class="ft-rotate-cw"></i></a></li>
 <li><a data-action="expand"><i class="ft-maximize"></i></a></li>
 <li><a data-action="close"><i class="ft-x"></i></a></li>
 </ul>
 </div>
 </div>
 <div class="card-content collapse show">
 <div class="card-body card-dashboard">
 <table id="example" class="display nowrap table table-striped table-bordered" style="width:100%;">
 <thead>
 <tr>
 <th>Enr. Date</th>
 <th>Email</th>
 <th>Mobile Number</th>
 <th>First Name</th>
 <th>Last Name</th>
 </tr>
 </thead>
 <tfoot>
 <tr>
 <th>Enr. Date</th>
 <th>Email</th>
 <th>Mobile Number</th>
 <th>First Name</th>
 <th>Last Name</th>
 </tr>
 </tfoot>
 </table>
 </div>
 </div>
 </div>
 </div>
 </div>
</section>