prepare("SELECT `unit`, `description` FROM `item_master` WHERE `item_name` = ? LIMIT 1"); $stmt->bind_param('s', $item); $stmt->execute(); $stmt->bind_result($unit, $extraDesc); if ($stmt->fetch()) { echo json_encode([ 'unit' => $unit, 'extra_description' => $extraDesc ]); } else { echo json_encode([ 'unit' => '', 'extra_description' => '' ]); } $stmt->close(); }