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 = '标题重复！';
}
}
}
