function get_stock($stock_id){
$sql = "SELECT * FROM tbl_product_stock WHERE `stock_id`= '$stock_id'";
$query = $this->conn->query($sql);
$result = $query->fetch_object();
return $result;
}
}
$_ajax = new AJAX_CLASS();
$stock_id = filter_var($_POST['ajax_stock_id'], FILTER_SANITIZE_STRING);
$count_stock = $_ajax->count_stock($stock_id);
$data_stock = $_ajax->get_stock($stock_id);
if($count_stock->rows > 0){
$stock_qty = $data_stock->stock_quantity;
if($stock_qty > 0){
if($stock_qty > 9){
$stock_qty = 9;
}else{
$stock_qty = $stock_qty;
}
{
$sql = "SELECT COUNT(stock_id) AS rows FROM `tbl_product_stock` WHERE type_id = '{$type_id}' AND `stock_name` = '{$stock_name}'";
$result = $this->fetchData('single', $sql);
return $result;
}
function get_stock($type_id, $stock_name)
{
$sql = "SELECT stock_quantity FROM `tbl_product_stock` WHERE `type_id`= '{$type_id}' AND `stock_name` = '{$stock_name}'";
$result = $this->fetchData('single', $sql);
return $result;
}
}
$_ajax = new AJAX_CLASS();
$type_id = filter_var($_POST['type_id'], FILTER_SANITIZE_NUMBER_INT);
$stock_name = filter_var($_POST['stock_name'], FILTER_SANITIZE_STRING);
$count_stock = $_ajax->count_stock($type_id, $stock_name);
if ($count_stock->rows > 0) {
$data_stock = $_ajax->get_stock($type_id, $stock_name);
$stock_qty = $data_stock->stock_quantity;
if ($stock_qty > 0) {
if ($stock_qty > 9) {
$stock_qty = 9;
} else {
$stock_qty = $stock_qty;
}
for ($i = 1; $i <= $stock_qty; $i++) {
echo '<option value="' . $i . '">' . $i . '</option>';
}
} else {
echo '<option value="0">1</option>';
}
