PHP save_seat Examples

Example #1

File: seat.php Project: nishishailesh/npg

    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);

Example #2

File: aboutus.php Project: prolin99/tad_web

/*-----------執行動作判斷區----------*/
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;