1#@!#!123s

: / home2 / technoi4 / public_html / admin /
Filename : ajaxfile.php
back
<?php
require_once('config.php');

$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($conn,$_POST['search']['value']); // Search value

## Search 
$searchQuery = " ";
if($searchValue != ''){
   $searchQuery = " and (categary_title like '%".$searchValue."%') ";
}

## Total number of records without filtering
$sel = mysqli_query($conn,"select count(*) as allcount from categary");
$records = mysqli_fetch_assoc($sel);
$totalRecords = $records['allcount'];

## Total number of record with filtering
$sel = mysqli_query($conn,"select count(*) as allcount from categary");
$records = mysqli_fetch_assoc($sel);
$totalRecordwithFilter = $records['allcount'];

//$sql = "SELECT * FROM `categary` WHERE `is_deleted` = 0"." order by ".$columnName." ".$columnSortOrder." limit ".$row.",".$rowperpage;
$sql = "SELECT * FROM `categary` WHERE `is_deleted` = 0".$searchQuery." order by ".$columnName." ".$columnSortOrder." limit ".$row.",".$rowperpage;
$result = mysqli_query($conn, $sql);

while ($row = mysqli_fetch_assoc($result)) {
    $data[] = array(
		"id"=>$row['id'],
		"categary_title"=>$row['categary_title'],
		"desc"=>$row['desc'],
		"image"=>'<a href="img/categary/'.$row['image'].'" target="_blank"> ' . $row['image'] . '<a/> ',
		"edit"=>'<a href="edit_categary.php?id=' . $row["id"] . '"><i class="fas fa-edit"></i></a>',
		"delete"=>'<a href="process.php?id=' . $row["id"] . '" onclick="return confirm(\'Are you sure you want to Delete?\');"><i class="fa fa-trash"></i></a>'
	);
}

$response = array(
    "draw" => intval($draw),
	"iTotalRecords" => $totalRecords,
	"iTotalDisplayRecords" => $totalRecordwithFilter,
    "aaData" => $data
);

echo json_encode($response);