<?php
include "../../root.class.php";
$db = new db_safeguard();

if (isset($_GET['item_name']) && !empty($_GET['item_name'])) { 

    $stock_data_res = $db->query("stock_control", "SELECT * FROM stock_control WHERE record_id = {$_GET['item_name']}");

    // echo "SELECT * FROM stock_control WHERE record_id = {$_GET['item_name']}";

    if ($stock_data_res->num_rows > 0) {
        while ($stock_data = $stock_data_res->fetch_assoc()) {
            $stock_no = $stock_data['stock_no'];
            $stock_des = $stock_data['description'];
            $stock_quantity = $stock_data['quantity'];

            echo $stock_no . "~" . $stock_des . "~" . $stock_quantity;
        }
    } else {
        echo "No results found";
    }

} else {
    echo "No item_name provided";
}