1#@!#!123s

: / home2 / technoi4 / www / admin /
Filename : productajax.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 (product_name like'%".$searchValue."%' or 
                    brand_name like '%".$searchValue."%' or 
                    categary_title like '%".$searchValue."%') ";
}

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

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

$sql = "SELECT product.*, brand.id as bid, brand.brand_name, categary.id as cid, categary.categary_title FROM `product` LEFT JOIN categary ON product.cid=categary.id LEFT JOIN brand ON product.bid=brand.id".$searchQuery." order by ".$columnName." ".$columnSortOrder." limit ".$row.",".$rowperpage;
$result = mysqli_query($conn, $sql);

while ($row = mysqli_fetch_assoc($result)) {
    $data[] = array(
		"pid"=>$row['pid'],
		"categary_title"=>$row['categary_title'],
		"brand_name"=>$row['brand_name'],
		"product_name"=>$row['product_name'],
		"product_desc"=>$row['product_desc'],
		"image"=>'<a href="img/product/'.$row['image'].'" target="_blank"> ' . $row['image'] . '<a/> ',
		"edit"=>'<a href="product_edit.php?pid=' . $row["pid"] . '"><i class="fas fa-edit"></i></a>',
		"delete"=>'<a href="delete_product.php?pid=' . $row["pid"] . '" 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);