add_styles_page();
$table_name = "items";
$db_safeguard = new db_safeguard();
?>
SEARCH ITEMS
input_html("name", "", "name", "name");
$restorants_res = $db_safeguard->query("restorants", "SELECT * FROM restorants WHERE record_id = {$_SESSION['restorant_id']}");
$restorant_data = $restorants_res->fetch_assoc();
$like_query = "restorant_id = {$restorant_data['record_id']}";
$item_categories_res = $db_safeguard->query("item_categories", "SELECT * FROM item_categories WHERE " . $like_query);
$like_query = [];
while ($item_categories_data = $item_categories_res->fetch_assoc()) {
$like_query[] = "item_categories_id = {$item_categories_data['record_id']}";
}
echo $html->select_html_from_db('item_sub_categories', 'record_id', 'name', implode(" OR ", $like_query), "item_sub_categories_id", "item_sub_categories_id");
echo $html->submit_btn('submit', 'SEARCH', "search_$table_name()"); ?>
html_form_ajax("search_$table_name", "SELECT", $table_name, '', false, ['name', 'item_sub_categories_id'], "edit_$table_name.php"); ?>