query("SELECT * FROM set_menu where page_id = '".$_GET['page_id']."' AND menu_id = '".$_GET['menu_id']."'"); if(!($chk->num_rows)) { $con->query("INSERT INTO `set_menu` (`id`, `timestamp`, `menu_id`, `page_id`) VALUES (NULL, CURRENT_TIMESTAMP, '".$_GET['menu_id']."', '".$_GET['page_id']."')"); echo ''; } } if($_GET['action'] == 'Unset') { $con->query("DELETE FROM `set_menu` WHERE `set_menu`.`page_id` = '".$_GET['page_id']."'"); echo ''; } ?>
query("SELECT * FROM his_page"); while($p = $pages->fetch_assoc()) { $ch = $con->query("SELECT * FROM set_menu where page_id = '".$p['id']."' "); if($ch->num_rows) { echo ''; } else { echo ''; } } ?>
Page Name Action
'.ucwords($p['page_name']).' Unset
'.ucwords($p['page_name']).' Set