Server : Apache/2 System : Linux server-15-235-50-60 5.15.0-164-generic #174-Ubuntu SMP Fri Nov 14 20:25:16 UTC 2025 x86_64 User : gositeme ( 1004) PHP Version : 8.2.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory :  /home/gositeme/domains/gositeme.com/public_html/quickqr/admin/datatable-json/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
/*
Copyright (c) 2015 Devendra Katariya (bylancer.com)
*/
require_once('includes.php');

// initilize all variable
$params = $columns = $totalRecords = $data = array();
$params = $_REQUEST;
if($params['draw'] == 1)
    $params['order'][0]['dir'] = "desc";
//define index of column
$columns = array(
    0 =>'r.id',
    1 =>'r.name',
    2 =>'u.username',
    3 =>'r.address',
    4 =>'r.created_at'
);

$where = $sqlTot = $sqlRec = "";

// check search value exist
if( !empty($params['search']['value']) ) {
    $where .=" WHERE ";
    $where .=" ( r.name LIKE '".$params['search']['value']."%' ";
    $where .=" OR u.username LIKE '%".$params['search']['value']."%' ";
    $where .=" OR r.address LIKE '".$params['search']['value']."%' )";
}

// getting total number records without any search
$sql = "SELECT r.*, u.username as username, u.name as fullname, u.currency
FROM `".$config['db']['pre']."restaurant` as r
INNER JOIN `".$config['db']['pre']."user` as u ON u.id = r.user_id ";

$sqlTot .= $sql;
$sqlRec .= $sql;
//concatenate search sql if value exist
if(isset($where) && $where != '') {
    $sqlTot .= $where;
    $sqlRec .= $where;
}


$sqlRec .=  " ORDER BY ". $columns[$params['order'][0]['column']]."   ".$params['order'][0]['dir']."  LIMIT ".$params['start']." ,".$params['length']." ";

$queryTot = $pdo->query($sqlTot);
$totalRecords = $queryTot->rowCount();
$queryRecords = $pdo->query($sqlRec);

//iterate on results row and create new index array of data
foreach ($queryRecords as $row) {
    //$data[] = $row;
    $id = $row['id'];
    $name = htmlentities( (string) $row['name'], ENT_QUOTES, 'UTF-8' );
    $username = htmlentities( (string) $row['username'], ENT_QUOTES, 'UTF-8' );
    $fullname = htmlentities( (string) $row['fullname'], ENT_QUOTES, 'UTF-8' );
    $address = htmlentities( (string) $row['address'], ENT_QUOTES, 'UTF-8' );
    $image = $row['main_image'];
    $created_at = timeAgo($row['created_at']);
    $membership = get_user_membership_detail($row['user_id']);
    $membership_name = $membership['name'];


    $row0 = '<td>
                <label class="css-input css-checkbox css-checkbox-default">
                    <input type="checkbox" class="service-checker" value="'.$id.'" id="row_'.$id.'" name="row_'.$id.'"><span></span>
                </label>
            </td>';
    $row1 = '<td class="text-center">
                <div class="pull-left m-r"><img class="img-avatar img-avatar-48" src="../storage/restaurant/logo/'.$image.'"></div>
                <p class="font-500 m-b-0">'.$name.'</p>
                <p class="text-muted m-b-0">#'.$username.'</p>
            </td>';
    $row2 = '<td class="hidden-xs">'.$fullname.'</td>';
    $row3 = '<td class="hidden-xs">'.$membership_name.'</td>';
    $row4 = '<td class="hidden-xs">'.$address.'</td>';
    $row5 = '<td class="hidden-xs">'.$created_at.'</td>';
    $row6 = '<td class="text-center">
                <div class="btn-group">
                    <a href="#" class="btn btn-xs btn-default login-as-user" data-user-id="'.$row['user_id'].'"><i class="fa fa-sign-in"></i> Login</a>
                    <a href="javascript:void(0)" class="btn btn-xs btn-default item-js-delete" data-ajax-action="deleteRestaurant"><i class="ion-close"></i> Delete</a>
                </div>
            </td>';
    $value = array(
        "DT_RowId" => $id,
        0 => $row0,
        1 => $row1,
        2 => $row2,
        3 => $row3,
        4 => $row4,
        5 => $row5,
        6 => $row6,
    );
    $data[] = $value;
}

$json_data = array(
    "draw"            => intval( $params['draw'] ),
    "recordsTotal"    => intval( $totalRecords ),
    "recordsFiltered" => intval($totalRecords),
    "data"            => $data   // total data array
);

echo json_encode($json_data);  // send data as json format
?>