bnmbertsurheoppopopooooooooooooooopoopopdf'tdfg

hjkhghoppoopppooppoppoppoopoirh bnmbertsurheoppopopooooooooooooooopoopopdf'tdfg

<?php
include('lib/config.php');
$banner_id = $_REQUEST['banner_id'];
$sql = "SELECT * FROM banners_click INNER JOIN vendor_login ON vendor_login.id=banners_click.vendor_id INNER JOIN vendor_profile ON vendor_profile.vendor_id=banners_click.vendor_id WHERE banner_id='$banner_id'";

// Fetch data
$result = $conn->query($sql);
$totalData = $result->num_rows;

// Server-side processing

if (!empty($_REQUEST['search']['value'])) {
    $sql .= " AND (full_name LIKE '%" . $_REQUEST['search']['value'] . "%' ";
    $sql .= " OR vendor_id LIKE '%" . $_REQUEST['search']['value'] . "%' ";
    $sql .= " OR contact LIKE '%" . $_REQUEST['search']['value'] . "%' ";
    $sql .= " OR email LIKE '%" . $_REQUEST['search']['value'] . "%')";
}

$query = mysqli_query($conn, $sql);
$totalFiltered = mysqli_num_rows($query);

// Server-side processing
$sql .= " ORDER BY banners_click.id DESC";
$sql .= " LIMIT " . $_REQUEST['start'] . ", " . $_REQUEST['length'];

$result = $conn->query($sql);
$totalFiltered = $totalData;

$data = array();
$serial = $_REQUEST['start'] + 1; // Serial number counter
while ($row = $result->fetch_assoc()) {

$nestedData = array();
    $nestedData[] = $serial; // Serial number

$nestedData[] = $row['banner_id'];
    $nestedData[] = '<a href="edit_vendor?token='.$row['id'].'" target="_blank">'.$row['vendor_id'].'</a>';

$nestedData[] = $row['full_name'];
    $nestedData[] = $row['contact'];
    $nestedData[] = $row['email'];
    $nestedData[] = date('d-m-Y',strtotime($row['created_date']));

$data[] = $nestedData;
    $serial++;
}

// Prepare JSON data
$json_data = array(
    "draw" => intval($_REQUEST['draw']),
    "recordsTotal" => intval($totalData),
    "recordsFiltered" => intval($totalFiltered),
    "data" => $data
);

echo json_encode($json_data);
?>