1#@!#!123s

: / home2 / technoi4 / public_html / admin /
Filename : productfile.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."%') ";
}


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

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

$sql = "SELECT product_image.*, product.pid, product.product_name FROM `product_image` LEFT JOIN product ON product_image.pid=product.pid".$searchQuery." order by ".$columnName." ".$columnSortOrder." limit ".$row.",".$rowperpage;
$result = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_assoc($result)) {
    $data[] = array(
		"id"=>$row['id'],
		"product_name"=>$row['product_name'],
		"image"=>'<a href="img/product_image/'.$row['image'].'" target="_blank"> ' . $row['image'] . '<a/> ',
		"edit"=>'<a href="edit_product.php?id=' . $row["id"] . '"><i class="fas fa-edit"></i></a>',
		"delete"=>'<a href="product_delete.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);