zagorisback
Advanced Member | Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору
Mavrikii
index.php (только JavaScript)
Код:
<script>
$(document).ready(function(){
$('#empTable').DataTable({
'processing': true,
'serverSide': true,
'serverMethod': 'post',
'ajax': {
'url':'ajaxfile.php'
},
"order": [[ 0, "desc" ]],
"pageLength": 5,
"dom": '<lfi<t>ip>',
"lengthChange": false, // Will Disabled Record number per page
'columns': [
{data: 'id'},
{data: 'title'},
{data: 'image'},
{data: 'cast' },
{ data: 'data_web', name: 'data_web',
render: function(data) {
return moment(data).format('YYYY-MM-DD')}},
{data: 'tags' },
{data: 'trailer' },
{data: 'otherData'},
],
|
ajaxfile.php (Полный код)
Код:
<?php
include 'config.php';
## Read value
$draw = $_POST['draw'];
$row = $_POST['start'];
$rowperpage = $_POST['length']; // Rows display per page
$columnIndex = $_POST['order'][0]['column']; // Column index
$columnName = $_POST['columns'][$columnIndex]['data']; // Column name
$columnSortOrder = $_POST['order'][0]['dir']; // asc or desc
$searchValue = mysqli_real_escape_string($con,$_POST['search']['value']); // Search value
## Search
$searchQuery = " ";
if($searchValue != ''){
$searchQuery = " and (title like '%".$searchValue."%' or
tags like '%".$searchValue."%' or
data_web like'%".$searchValue."%' ) ";
}
## Total number of records without filtering
$sel = mysqli_query($con,"select count(*) as allcount from store");
$records = mysqli_fetch_assoc($sel);
$totalRecords = $records['allcount'];
## Total number of records with filtering
$sel = mysqli_query($con,"select count(*) as allcount from store WHERE 1 ".$searchQuery);
$records = mysqli_fetch_assoc($sel);
$totalRecordwithFilter = $records['allcount'];
## Fetch records
$empQuery = "select * from store WHERE 1 ".$searchQuery." order by ".$columnName." ".$columnSortOrder." limit ".$row.",".$rowperpage;
$empRecords = mysqli_query($con, $empQuery);
$data = array();
while ($row = mysqli_fetch_assoc($empRecords)) {
$data[] = array(
"id"=>$row['id'],
"title"=>$row['title'],
"title"=>'<a href="../member/film.php?id=' . $row['id'] . '" target="_blank"' . '>' . $row['title'] . '</a>',
"image"=>'<a href="../images/' .$row['image']. '"><img src="../images/' .$row['image']. '" width="50px" class="zoom"/><a>',
"cast"=>$row['cast'],
"data_web"=>$row['data_web'],
"tags"=>$row['tags'],
"trailer"=>'<a href="../trailer/' . $row['trailer'] . '" target="_blank"' . '>' . $row['trailer'] . '</a>'
);
}
if ( (strtotime($row['data_web'])+7*86400)>time() ){
$otherData = '<b style="color:green;">' .$row['data_web']. '</b>
' . '<img src="ico/new_icon.gif" />';
}else{
$otherData = $row['data_web'];
}
## Response
$response = array(
"draw" => intval($draw),
"iTotalRecords" => $totalRecords,
"iTotalDisplayRecords" => $totalRecordwithFilter,
"aaData" => $data,
"otherData" => $otherData
);
echo json_encode($response);
?>
|
|
