function action() { global $db; //判断是否登陆 !isset($_SESSION['user']) && exit('Please login!'); //判断tid的合法性 if (isset($_GET['tid']) && $_GET['tid'] > 0 && $_GET['tid'] <= 3) { $tid = ceil($_GET['tid']); } if (isset($_POST['tid']) && $_POST['tid'] > 0 && $_POST['tid'] <= 3) { $tid = ceil($_POST['tid']); } !isset($tid) && exit('tid不合法!'); //获取表的信息 (!isset($_GET['tb']) || $_GET['tb'] == '' || $_GET['tb'] == 0) && exit('tb error!'); $tables = Cache::R('tables', 5000); if (!$tables) { $tables = $db->row_select('tables'); @Cache::W('tables', $tables); } //获取表名 $tb = intval($_GET['tb']); !($tbname = get_table_name($tb, $tables)) && exit('tb error!'); //转到添加记录页面 if (isset($_GET['do']) && $_GET['do'] == 'add') { $arr = array('id' => '', 'tid' => $tid, 'sub' => '添加', 'do' => 'add', 'tb' => $tb); tpl($tbname . '_edit', 'arr', $arr); } //转到修改记录页面 if (isset($_GET['do']) && $_GET['do'] == 'edit') { (!isset($_GET['id']) || $_GET['id'] == '') && show('', '操作错误!缺少id', '-1'); $id = ceil($_GET['id']); $arr = $db->row_select_one($tbname, "id={$id}"); $arr['sub'] = '修改'; $arr['do'] = 'edit'; $arr['tb'] = $tb; tpl($tbname . '_edit', 'arr', $arr); } //添加一条记录 if (isset($_POST['add'])) { $Model = new Model($tbname); if (isset($_POST['content'])) { $Model->_validate = array(array('content', '')); } $rs = $Model->insert(); $Model->msg($rs, '数据添加成功!', '数据添加失败!', URL); } //更新一条记录 if (isset($_POST['edit'])) { $Model = new Model($tbname); if (isset($_POST['list_id'])) { $id = ceil($_POST['id']); $list_id = ceil($_POST['list_id']); $post = htmlescape($_POST); $arr = array('id' => $list_id, 'name' => $post['name'], 'introduction' => $post['introduction'], 'say' => $post['say'], 'img' => $post['img']); $rs = $db->row_update('teacher', $arr, "id={$id}"); $Model->msg($rs, '数据修改成功!', '数据修改失败!', URL); } if (isset($_POST['content'])) { $Model->_validate = array(array('content', '')); } $rs = $Model->update(); if ($tbname == 'studio') { $Model->msg($rs, '数据修改成功!', '数据修改失败', '?module=admin&act=action&tb=10&tid=1&do=edit&id=1'); } $Model->msg($rs, '数据修改成功!', '数据修改失败!', URL); } //修改开班信息标题 if (isset($_POST['update'])) { $title = htmlescape($_POST['title']); $rs = $db->row_update('classes', array('title' => $title), "id=-1"); if ($rs) { show('', '修改开班信息标题成功!', URL); } else { show('', '修改失败,请稍后再试!', '-1'); } } //删除一条记录 if (isset($_GET['do']) && $_GET['do'] == 'del') { (!isset($_GET['id']) || $_GET['id'] == '') && show('', '操作错误!缺少id', '-1'); $id = ceil($_GET['id']); $rs = $db->row_delete($tbname, "id={$id}"); if ($rs) { show('提示', '删除成功!', "index.php?module=admin&act=action&tid={$tid}&tb={$tb}"); } else { show('提示', '删除失败!', '-1'); } } //批量删除 if (isset($_POST['del'])) { !isset($_POST['id']) && show('', '没有选中项', '-1'); $rs = $db->delete_row($tbname, number($_POST['id'])); if ($rs) { show('提示', '批量删除成功!', URL); } else { show('提示', '批量删除失败!', '-1'); } } $Page = new Page($tbname, "tid={$tid}"); $pageInfo = $Page->get_basic_info(); $data = $Page->get_data(); $buttonBasic = $Page->button_basic(0, 0); $buttonSelect = $Page->button_select(); $arr = array('pageInfo' => $pageInfo, 'data' => $data, 'buttonBasic' => $buttonBasic, 'buttonSelect' => $buttonSelect, 'tid' => $tid, 'tb' => $tb); tpl($tbname, 'arr', $arr); }