ESH/get_item_salts_data.php
2024-10-23 18:28:06 +05:30

36 lines
1.1 KiB
PHP

<?php
include('includes/config/config.php');
include('includes/functions.php');
$itemId = $_REQUEST['item_id'];
$query = "select salt_id from item_salt where item_id='".$itemId."' ";
error_log($query);
$salt_name=array();
$count=0;
if (!$result = @mysqli_query($conn,$query)) {
exit(mysqli_error($conn));
}
$data = array();
$item_name=getTableFieldValue('tbl_items','item_name','item_id',$_REQUEST['item_id']);
// array_push($data,$item_name);
// }
if(mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_assoc($result)) {
if(!empty(['salt_id'])){
$salt_name[$row['salt_id']]=getTableFieldValue('salt_master','salt_name','salt_id',$row['salt_id']).' of '.getTableFieldValue('tbl_items','item_name','item_id',$_REQUEST['item_id']);
array_push($data,$row['salt_id']);
$count++;
}
}
}
$data['count']=$count;
$data['item_name']=$item_name;
$data['salt_name']=$salt_name;
error_log("str allergy_items ".print_r($data,true));
echo json_encode($data);
?>