$link = $_POST['link']; $pic_url = $_POST['pic_url']; $content = $_POST["content"]; $mark = $_POST['mark']; $week = isset($_POST["week"]) ? $_POST["week"] : ''; $ad_start_time = isset($_POST["ad_start_time"]) ? strtotime(trim($_POST["ad_start_time"])) : time(); $ad_end_time = isset($_POST["ad_end_time"]) ? strtotime(trim($_POST["ad_end_time"])) : time(); $out_title = isset($_POST["out_title"]) ? $_POST["out_title"] : ''; $out_link = isset($_POST["out_link"]) ? $_POST["out_link"] : ''; $out_pic_url = isset($_POST["out_pic_url"]) ? $_POST["out_pic_url"] : ''; $status = isset($_POST["status"]) ? $_POST["status"] : ''; if ($title == "" || $alias == "" || $name == "") { $updateMessage = "请把信息填写完整!!"; } else { $sql = 'SELECT * FROM `ad` WHERE (`name`="' . $name . '" OR `alias`="' . $alias . '") AND `id`<>"' . $id . '"'; $rs = $pdo->query($sql); $row = $rs->fetchAll(); $count = count($row); if ($count == 0) { $row = array('title' => $title, 'alias' => $alias, 'name' => $name, 'content' => $content, 'link' => $link, 'pic_url' => $pic_url, 'mark' => $mark, 'week' => $week, 'ad_start_time' => $ad_start_time, 'ad_end_time' => $ad_end_time, 'out_title' => $out_title, 'out_link' => $out_link, 'out_pic_url' => $out_pic_url, 'status' => $status); $result = AdModel::model()->update(array('id' => $id), $row); if ($result > 0) { $updateMessage = "修改成功"; } else { $updateMessage = "修改失败"; } } else { $updateMessage = '标题或者别名重复!'; } } }
$mark = isset($_POST["mark"]) ? $_POST["mark"] : ''; $link = isset($_POST["link"]) ? $_POST["link"] : ''; $pic_url = isset($_POST["pic_url"]) ? $_POST["pic_url"] : ''; $content = isset($_POST["content"]) ? $_POST["content"] : ''; $week = isset($_POST["week"]) ? $_POST["week"] : ''; $ad_start_time = isset($_POST["ad_start_time"]) ? strtotime(trim($_POST["ad_start_time"])) : time(); $ad_end_time = isset($_POST["ad_end_time"]) ? strtotime(trim($_POST["ad_end_time"])) : time(); $out_title = isset($_POST["out_title"]) ? $_POST["out_title"] : ''; $out_link = isset($_POST["out_link"]) ? $_POST["out_link"] : ''; $out_pic_url = isset($_POST["out_pic_url"]) ? $_POST["out_pic_url"] : ''; $status = isset($_POST["status"]) ? $_POST["status"] : ''; if ($title == "" || $alias == "") { $createMessage = "请把信息填写完整!!"; } else { $sql = 'SELECT * FROM `ad` WHERE `alias`="' . $alias . '" AND `id`<>"' . $id . '"'; $rs = $pdo->query($sql); $row = $rs->fetchAll(); //取得所有记录 $count = count($row); if ($count == 0) { $lastetId = AdModel::model()->create($_POST); if ($lastetId != FALSE) { $createMessage = "添加成功"; } else { $createMessage = "添加失败"; } } else { $createMessage = '【名称】或者【标题】或者【系统别名】重复!'; } } }
$count = count($pdo->query($sql)->fetchAll()); $totalPage = ceil($count / $pageSize); $init = 1; $page_len = 9; //页码个数 $max_p = $totalPage; $pages = $totalPage; //判断当前页码 if (empty($_GET['page']) || $_GET['page'] < 0) { $page = 1; } else { $page = $_GET['page']; } $offset = $pageSize * ($page - 1); $sql = $sql . " LIMIT {$offset},{$pageSize}"; $itemArr = AdModel::model()->findAllBySql($sql); $page_len = $page_len % 2 ? $page_len : $pagelen + 1; //页码个数 $pageoffset = ($page_len - 1) / 2; //页码个数左右偏移量 $key = '<div class="page">'; $key .= "<span>{$page}/{$pages}</span> "; //第几页,共几页 if ($page != 1) { $key .= "<a href=\"ad_manage.php?page=1\">首页</a> "; //第一页 $key .= "<a href=\"ad_manage.php?page=" . ($page - 1) . "\">上一页</a>"; //上一页 } else { $key .= "首页 "; //第一页