$id = @$_POST["id"]; $catname = @$_POST["catname"]; $status = @$_POST["status"]; $template_list = @$_POST["template_list"]; $template_show = @$_POST["template_show"]; $pagesize = @$_POST["pagesize"]; #if if (!empty($catname) && !empty($pagesize)) { if (empty($template_list)) { $template_list = "house_list.html"; } if (empty($template_show)) { $template_show = "house_show.html"; } #sql $sql = "insert into " . tablePrefix() . "house_category (catname,status,template_list,template_show,pagesize) values (?,?,?,?,?)"; $sql_data = array($catname, $status, $template_list, $template_show, $pagesize); if (!empty($id)) { $sql = "update " . tablePrefix() . "house_category set catname=?,status=?,template_list=?,template_show=?,pagesize=? where id = ?"; $sql_data[] = $id; } #execute _execute($sql, $sql_data); #tishi $error = "操作成功"; } else { $error = "操作失败,缺少必要参数"; } include_once getTPL("tishi"); exit; }
//status if (!empty($type) && $type == "status") { #param $status = @$_GET["status"]; $id = @$_GET["id"]; #update if (!empty($id)) { if ($status != null && $status == "0") { $status = 1; } else { $status = 0; } $sql = "update " . tablePrefix() . "house_village set status =? where id = ?"; _execute($sql, array($status, $id)); $error = "操作成功"; } else { $error = "操作失败,缺少必要参数"; } #tpl include_once getTPL("tishi"); exit; } //edit if (!empty($type) && $type == 'edit') { #地区 $sql_dq = "select id,name,parent_id from " . tablePrefix() . "house_area where status= 0 order by id asc"; $arr_dq = _select($sql_dq); #tpl include_once getTPL("house_village-edit"); exit; }
#logout $error = ""; if (!empty($type) && $type == "logout") { $error = "用户已退出,请重新登录"; } #timeout if (!empty($type) && $type == 'timeout') { $error = "用户认证超时,请重新登录"; } #login $status = 0; if (!empty($type) && $type == "login") { $username = @$_POST['username']; $password = @$_POST['password']; if (!empty($username) && !empty($password)) { $sql = "select * from " . tablePrefix() . "user where username=? and status=1 limit 1"; $res = _select($sql, array($username)); if (!empty($res) && count($res) > 0) { $user = $res[0]; $user_pwd = $user['password']; if (md5($password) == $user_pwd) { $_SESSION['user'] = $user; //session $error = "登录成功,正在跳转"; $status = 1; } else { $error = "密码错误,请检查密码填写"; $status = 0; } } else { $error = "登录失败,未找到该用户";
} # insert thumbs to $id if (!empty($id) && !empty($thumbs)) { $sql2 = "insert into " . tablePrefix() . "thumbs (refer_id,refer_table,url,createtime) values"; $arr = explode(",", $thumbs); for ($i = 0; $i < count($arr); $i++) { if ($i == count($arr) - 1) { $sql2 .= " (" . $id . ",'house','" . $arr[$i] . "'," . time() . ")"; } else { $sql2 .= " (" . $id . ",'house','" . $arr[$i] . "'," . time() . "),"; } } _execute($sql2); $error = "操作成功"; } } else { $error = "操作失败,缺少必要参数"; } include_once getTPL("tishi"); exit; } //delete if (!empty($type) && $type == "delete") { $id = @$_GET["id"]; #sql $sql = "update " . tablePrefix() . "house set status=1 where id=?"; #execute _execute($sql, array($id)); include_once getTPL("tishi"); exit; }