while ($x = mysql_fetch_assoc($result)) { echo '<tr>'; echo '<td><button type=submit name=delete value=\'' . $x['subloc_id'] . '^' . $x['catagory'] . '\'>X</button></td>'; foreach ($x as $k => $v) { if ($k != 'subloc_id') { echo '<td>' . $v . '</td>'; } } echo '</tr>'; } echo '</table></form>'; } function delete_seat($link) { $ex = explode('^', $_POST['delete']); $subloc_id = $ex[0]; $catagory = $ex[1]; $sql = 'delete from seat where subloc_id=\'' . $subloc_id . '\' and catagory=\'' . $catagory . '\''; $result = mysql_query($sql, $link); } $link = mysql_connect('127.0.0.1', 'root', 'pppp'); mysql_select_db('npg', $link); read_seat($link); if (isset($_POST['save_seat'])) { save_seat($link); } if (isset($_POST['delete'])) { delete_seat($link); } print_seat($link); //print_array($_POST);
/*-----------執行動作判斷區----------*/ include_once $GLOBALS['xoops']->path('/modules/system/include/functions.php'); $op = system_CleanVars($_REQUEST, 'op', '', 'string'); $MemID = system_CleanVars($_REQUEST, 'MemID', 0, 'int'); common_template($WebID); switch ($op) { case "import_excel": import_excel($WebID, $_FILES['importfile']['tmp_name']); break; case "import2DB": import2DB($WebID); break; //儲存座位 //儲存座位 case "save_seat": save_seat($MemID); header("location: {$_SERVER['PHP_SELF']}?WebID={$WebID}"); exit; break; //輸入表格 //輸入表格 case "tad_web_mems_form": $main = tad_web_mems_form($WebID, $MemID); die($main); break; //刪除資料 //刪除資料 case "delete_tad_web_mems": delete_tad_web_mems($MemID); header("location: {$_SERVER['PHP_SELF']}?WebID={$WebID}"); exit;