if (!empty($suluetu2)) { $glcpxx = glcpxx($suluetu2); unset($_POST['suluetu2']); unset($_POST['gift_id']); $suluetu2 = $glcpxx['table']; $gift_id = $glcpxx['urlid']; $tyxxsql = "select id from " . $glcpxx['table'] . " where id=" . $glcpxx['urlid']; $result = $pdo->query($tyxxsql); } if (!empty($_POST['suluetu2']) && !$result) { $createMessage = "关联产品地址不正确,如果没有关联产品请留空!!"; } elseif ($title == "" || $content == "") { $updateMessage = "请把信息填写完整!!"; } else { $sql = 'SELECT * FROM `wenzhang` WHERE `title`="' . $title . '" AND `id`<>"' . $id . '"'; $rs = $pdo->query($sql); $row = $rs->fetchAll(); if (count($row) == 0) { $row = array('title' => $title, 'category_id' => $category_id, 'keyword' => $keyword, 'description' => $description, 'content' => $content, 'tag' => $tag, 'promote_id' => $promote_id, 'num_iids' => $num_iids, 'pindao_id' => $pindao_id, 'ZhuyaoPic' => $ZhuyaoPic, 'suluetu1' => $suluetu1, 'suluetu2' => $suluetu2, 'tougao_id' => $tougao_id, 'author' => $author, 'source' => $source, 'tiaoyong_id' => $tiaoyong_id, 'create_user_id' => $create_user_id, 'recommend' => $recommend, 'status' => $status, 'gift_id' => $gift_id); $result = WenZhangModel::model()->update(array('id' => $id), $row); if ($result > 0) { $updateMessage = "修改成功"; } else { echo $sql; $updateMessage = "修改失败"; } } else { $updateMessage = '标题 重复'; } } }
$sql = 'SELECT * FROM `wenzhang` WHERE `category_id`=' . $searchCategoryId . $sql_key_str . ' ORDER BY `id` DESC'; } else { $sql = 'SELECT * FROM `wenzhang` WHERE 1 ' . $sql_key_str . ' ORDER BY `id` DESC'; } $pageSize = 30; //页面大小 $count = count($pdo->query($sql)->fetchAll()); $totalPage = ceil($count / $pageSize); $init = 1; $page_len = 9; //页码个数 $max_p = $totalPage; $pages = $totalPage; $offset = $pageSize * ($page - 1); $sql = $sql . " LIMIT {$offset},{$pageSize}"; $wenzhangArr = WenZhangModel::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=\"wenzhang_manage.php?page=1" . "&searchCategoryId=" . $searchCategoryId . "&searchWord=" . urlencode($searchWord) . "\">首页</a> "; //第一页 $key .= "<a href=\"wenzhang_manage.php?page=" . ($page - 1) . "&searchCategoryId=" . $searchCategoryId . "&searchWord=" . urlencode($searchWord) . "\">上一页</a>"; //上一页 } else { $key .= "首页 "; //第一页
if (!empty($suluetu2)) { $glcpxx = glcpxx($suluetu2); unset($_POST['suluetu2']); unset($_POST['gift_id']); $_POST['suluetu2'] = $glcpxx['table']; $_POST['gift_id'] = $glcpxx['urlid']; $tyxxsql = "select id from " . $glcpxx['table'] . " where id=" . $glcpxx['urlid']; $result = $pdo->query($tyxxsql)->fetch(); if (!$result) { $createMessage = "关联产品地址不正确,如果没有关联产品请留空!!"; } } if ($title == "" || $content == "") { $createMessage = "请把文章信息填写完整!!"; } else { $sql = 'SELECT * FROM `wenzhang` WHERE `title`="' . $title . '" AND `id`<>"' . $id . '"'; $rs = $pdo->query($sql); $row = $rs->fetchAll(); //取得所有记录 if (count($row) == 0) { $lastetId = WenZhangModel::model()->create($_POST); if ($lastetId != FALSE) { $createMessage = "添加成功"; } else { $createMessage = "添加失败"; } } else { $createMessage = '标题重复!'; } } }