public function actionSearch() { $this->pageTitle = "新闻搜索"; //获得表单提交的数据 $searchType = $_POST["searchType"]; $keyword = $_POST["keyword"]; //搜索记录 $newsInfo = NewsArticles::model()->findAll("{$searchType} like '%{$keyword}%'"); $data = array("newsInfo" => $newsInfo); $this->render("index", $data); }
public function actionIndex($typeId) { $this->pageTitle = "新闻分类"; //查询该分类下所有新闻 $newsInfo = NewsArticles::model()->findAll("typeId={$typeId}"); //查询该分类的详细信息 $newsType = NewsTypes::model()->findByPk($typeId); if ($newsInfo == NULL) { $this->redirect(__APP__ . "/success/index/act/nocontent"); } $data = array("newsInfo" => $newsInfo, "newsType" => $newsType); $this->render("index", $data); }
public function actionIndex() { $this->pageTitle = "天天新闻网"; //新闻总数 $newsCount = NewsArticles::model()->count(); //热点要闻 $sql = "select * from newsArticles a inner join newsTypes b on a.typeId=b.typeId order by hints desc limit 0,6"; $db = Yii::app()->db; $st = $db->createCommand($sql); $hotNews = $st->queryAll(); //一个分类带两条新闻 $newsList = array(); //存储所有记录 $newsModel = NewsArticles::model(); foreach ($this->newsTypes as $v) { $type = array("typeId" => $v["typeId"], "typeName" => $v["typeName"], "articleNums" => $v["articleNums"], "news" => $newsModel->findAll(array("condition" => "typeId={$v["typeId"]}", "order" => "dateandtime desc", "limit" => 2, "offset" => 0))); $newsList[] = $type; } $data = array("newsCount" => $newsCount, "hotNews" => $hotNews, "newsList" => $newsList); $this->render("index", $data); }
$delNums = NewsTypes::delNums($typeId); } //print_r(delNums); //获得表单提交的数据 $searchType = $_POST["searchType"]; $keyword = $_POST["keyword"]; $currentPage = $_POST["currentPage"]; //当前页的页码 $currentPage = $currentPage == NULL ? 1 : $currentPage; //搜索新闻 if ($keyword != NULL) { $result = NewsArticles::getNewsInfo($currentPage, $keyword, $searchType); $totalPage = $result[0]; $newsInfo = $result[1]; } else { $result = NewsArticles::getNewsInfo($currentPage); //所有新闻 $totalPage = $result[0]; $newsInfo = $result[1]; } ?> <!DOCTYPE html> <html> <head> <title>修改新闻</title> <meta http-equiv="content-type" content="text/html;charset=utf-8"> <link href="../css/admin.css" type="text/css" rel="stylesheet" /> <script type="text/javascript" src="../jquery/jquery-1.4.js"></script> <script type="text/javascript"> function checkSearch() {
function formatArticleResultSet($result) { $articledata = array(); if ($result != null) { $n = count($result); for ($i = 0; $i < $n; $i++) { $article = new NewsArticles(); $article->setnewsID($result[$i]->newsID); $article->setArticleNewstitle($result[$i]->newstitle); $article->setArticleBody($result[$i]->newsdesc); $article->setArticleDateCreated($result[$i]->datecreated); $article->setArticleStatus($result[$i]->status); $articledata[$i] = $article; } return $articledata; } else { return false; } }
if ($result > 0) { echo "<script type='text/javascript'>"; echo "\talert('发表评论成功!');"; echo "\twindow.location='news.php?articleId={$articleId}';"; echo "</script>"; } else { echo "<script type='text/javascript'>"; echo "\talert('发表评论失败!');"; echo "\twindow.location='news.php?articleId={$articleId}';"; echo "</script>"; } } $newsTypes = NewsTypes::getNewsTypes(); //所有分类 $newsInfo = NewsArticles::getNewsById($articleId); //当前新闻 $reviews = Reviews::getReviews($articleId); //当前新闻的所有评论 NewsArticles::addClick($articleId); //点击量加一 $smarty->assign("reviews", $reviews); $smarty->assign("newsInfo", $newsInfo); $smarty->assign("newsTypes", $newsTypes); $smarty->display("news.html"); ?>
header("content-type:text/html;charset=utf-8"); include_once 'nologin.php'; include_once '../dbio/NewsTypes.php'; include_once '../dbio/NewsArticles.php'; $articleId = $_GET["articleId"]; $newsInfo = NewsArticles::getNewsById($articleId); //获得表单提交的数据 $title = $_POST["title"]; $typeId = $_POST["typeId"]; $writer = $_POST["writer"]; $source = $_POST["source"]; $content = $_POST["content"]; //表单提交(修改新闻) if ($content != NULL) { $result = NewsArticles::updateNews($articleId, $title, $content, $writer, $source, $typeId); header("location:success.php?act=updateNews&rst={$result}&articleId={$articleId}"); } $newsTypes = NewsTypes::getNewsTypes(); //所有分类 ?> <html> <head> <title>修改新闻</title> <meta http-equiv="content-type" content="text/html;charset=utf-8"> <link href="../css/admin.css" type="text/css" rel="stylesheet" /> <script type="text/javascript" src="../jquery/jquery-1.4.js"></script> <script type="text/javascript" src="../kindeditor/kindeditor.js"></script> <script type="text/javascript"> var editor; KindEditor.ready(function(e){
include_once 'dbio/NewsTypes.php'; include_once 'dbio/NewsArticles.php'; include_once 'dbio/Reviews.php'; //获得表单提交的数据 $articleId = $_GET["articleId"]; $face = $_POST["face"]; $content = $_POST["content"]; $userName = $_POST["userName"]; //表单提交(发表谰论) if ($content != NULL) { $result = Reviews::addReviews($articleId, $userName, $content, $face); header("location:success.php?act=addreviews&rst={$result}&articleId={$articleId}"); } $reviews = Reviews::getReviews($articleId); //当前新闻所有评论 $newsInfo = NewsArticles::getNewsById($articleId); //当前新闻 $newsTypes = NewsTypes::getNewsTypes(); //所有分类 ?> <html> <head> <title>天天新闻网</title> <meta http-equiv="content-type" content="text/html;charset=utf-8"> <link href="css/news.css" type="text/css" rel="stylesheet" /> <script type="text/javascript" src="kindeditor/kindeditor.js"></script> <script type="text/javascript"> var editor;//编辑器对象 //加载编辑器 KindEditor.ready(function(e){ //创建编辑器,返回编辑器对象
<div class="loginDiv21"><input type="password" name="password" value="123" class="txt1">*</div> </div> <div class="loginDiv2 clear"> <div class="loginDiv20">验证码</div> <div class="loginDiv21"><input type="text" name="checkCode" size="8" maxlength="4"><img id="myImg" src="" align="absmiddle"></div> </div> <div class="loginDiv2 clear"> <div class="loginDiv20"> </div> <div class="loginDiv21"><input type="submit" value="登陆"></div> </div> </div> <!-- 一个分类带两条新闻 --> <?php foreach ($newsTypes as $v) { //通过typeId获得两条新闻 $news = NewsArticles::getNews2($v["typeId"]); ?> <div class="twoNews"> <div class="twoNews1"> <a href="newstype.php?typeId=<?php echo $v["typeId"]; ?> " class="a"><?php echo $v["typeName"]; ?> </a></div> <div class="twoNews2"><a href="newstype.php?typeId=<?php echo $v["typeId"]; ?> " class="a">更多</a> </div> </div> <?php
<?php include_once 'dbio/NewsTypes.php'; include_once 'dbio/NewsArticles.php'; //头部导航菜单 $newsTypes = NewsTypes::getNewsTypes(); //接收数据 $searchType = $_POST['searchType']; $keywords = $_POST['keywords']; $result3 = array(); if ($result3 != NULL) { $result3 = NewsArticles::search($searchType, $keywords); } ?> <html> <head> <title>天天新闻网</title> <meta http-equiv="content-type" content="text/html;charset=utf-8"> <link href="css/news.css" type="text/css" rel="stylesheet" /> <script type="text/javascript"> </script> </head> <body> <!-- 网站头 --> <?php include_once 'header.php'; ?>
<?php header('content-type:text/html;charset=utf-8'); include_once 'dbio/NewsTypes.php'; include_once 'dbio/NewsArticles.php'; //获取typeId值 $typeId = $_GET['typeId']; //通过typeId获得该分类的详细信息 $result1 = NewsTypes::getType($typeId); //通过TypeId获得该分类的所有新闻 $result2 = NewsArticles::getAllNews($typeId); //所有分类给header用 $newsTypes = NewsTypes::getNewsTypes(); ?> <html> <head> <title>天天新闻网</title> <meta http-equiv="content-type" content="text/html;charset=utf-8"> <link href="css/news.css" type="text/css" rel="stylesheet" /> </head> <body> <!-- 网站头 --> <?php include_once "header.php"; ?> <!-- 正文内容 --> <div class="mainDiv clear"> <div class="newsTypeDiv">
echo "</script>"; } } else { echo "<script type='text/javascript'>"; echo "\talert('验证码输入有误!');"; echo "\twindow.location='index.php';"; echo "</script>"; } } $newsTypes = NewsTypes::getNewsTypes(); //所有分类 $hotNews = NewsArticles::getHotNews(); //热点要闻 $newsCount = NewsArticles::getNewsCount(); //新闻总数 foreach ($newsTypes as $k => $v) { $newsInfo = NewsArticles::getNewsInfoTwo($v["typeId"]); $v["news"] = $newsInfo; $newsTypes[$k] = $v; } $smarty->assign("newsCount", $newsCount); $smarty->assign("hotNews", $hotNews); $smarty->assign("newsTypes", $newsTypes); $smarty->display("index.html"); ?>
include_once '../dbio/NewsArticles.php'; include_once 'nologin.php'; //获得URL参数 $articleId = $_GET['articleId']; $Id = $_GET['Id']; $news = NewsArticles::getNewsById($articleId); //获得表单提交的数据 $articleId2 = $_POST['articleId']; //echo $articleId; $title = $_POST["title"]; $typeId = $_POST["typeId"]; $writer = $_POST["writer"]; $source = $_POST["source"]; $newsImg = $_FILES["newsImg"]; $content = $_POST["content"]; $result = NewsArticles::modification($content, $title, $typeId, $userName, $writer, $source, $savePath, $articleId2); print_r($result); $newsTypes = NewsTypes::getNewsTypes(); //显示所有分类 ?> <!DOCTYPE html> <html> <head> <title>添加新闻</title> <meta http-equiv="content-type" content="text/html;charset=utf-8"> <link href="../css/admin.css" type="text/css" rel="stylesheet" /> <script type="text/javascript" src="../jquery/jquery-1.4.js"></script> <script type="text/javascript" src="../kindeditor/kindeditor.js"></script> <script type="text/javascript"> var editor; KindEditor.ready(function(e){
</div> <div class="loginDiv2 clear"> <div class="loginDiv20">验证码</div> <div class="loginDiv21"><input type="text" name="checkCode" size="8" maxlength="4"><img id="myImg" onclick="changeImg()" alt="看不清换一张" title="看不清换一张" src="image.php" align="absmiddle"></div> </div> <div class="loginDiv2 clear"> <div class="loginDiv20"> </div> <div class="loginDiv21"><input type="submit" value="登陆"></div> </div> </div> </form> <!-- 一个分类带两条新闻 --> <?php foreach ($newsTypes as $v) { //查询 查询当前分类下的两条新闻 $newsInfo = NewsArticles::getNewsTow($v["typeId"]); ?> <div class="twoNews"> <div class="twoNews1"> <a href="newstype.php?typeId=<?php echo $v["typeId"]; ?> " class="a"><?php echo $v["typeName"]; ?> </a></div> <div class="twoNews2"><a href="newstype.php?typeId=<?php echo $v["typeId"]; ?> " class="a">更多</a> </div> </div> <?php
<?php header("content-type:text/html;charset=utf-8"); include_once 'dbio/NewsTypes.php'; include_once 'dbio/NewsArticles.php'; //获得表单提交的数据 $searchType = $_POST["searchType"]; $keyword = $_POST["keyword"]; //开始查询数据库,搜索 $newsInfo = array(); if ($searchType != NULL) { $newsInfo = NewsArticles::searchNews($searchType, $keyword); } $newsTypes = NewsTypes::getNewsTypes(); //所有分类 ?> <html> <head> <title>天天新闻网</title> <meta http-equiv="content-type" content="text/html;charset=utf-8"> <link href="css/news.css" type="text/css" rel="stylesheet" /> <script type="text/javascript"> function checkSearch() { if(document.frm.keyword.value == "") { alert("搜索关键字不能为空!"); document.frm.keyword.focus(); return false; } }
<?php header("content-type:text/html;charset=utf-8"); include_once 'dbio/NewsTypes.php'; include_once 'dbio/NewsArticles.php'; //获得url中的typeId值 $typeId = $_GET["typeId"]; //通过typeId获得该分类的详细信息 $newsType = NewsTypes::getNewsType($typeId); //获得该分类下的所有新闻 $newsInfo = NewsArticles::getNewsByTypeId($typeId); //所有分类(给header用) $newsTypes = NewsTypes::getNewsTypes(); ?> <html> <head> <title>天天新闻网</title> <meta http-equiv="content-type" content="text/html;charset=utf-8"> <link href="css/news.css" type="text/css" rel="stylesheet" /> </head> <body> <!-- 网站头 --> <?php include_once 'header.php'; ?> <!-- 正文内容 --> <div class="mainDiv clear"> <div class="newsTypeDiv"> <div class="newsTypeDiv1"> <a href="index.php" class="a">新闻主页</a> » <?php echo $newsType["typeName"];
if ($ext == "jpg" || $ext == "gif" || $ext == "png" || $ext == "jpeg") { if ($newsImg["size"] > 2000000) { header("location:success.php?act=addnews&rst=2"); } else { $trueName = md5(time() . rand(0, 9) . rand(0, 9) . rand(0, 9) . rand(0, 9) . rand(0, 9)) . "." . $ext; $savePath = "newspicture/{$trueName}"; //保存路径 move_uploaded_file($newsImg["tmp_name"], "../{$savePath}"); } } else { header("location:success.php?act=addnews&rst=1"); } } //添加数据库 $userName = $_SESSION["userMsg"]["userName"]; $result = NewsArticles::addNews($content, $title, $typeId, $userName, $writer, $source, $savePath); if ($result > 0) { NewsTypes::addNums($typeId); //新闻数量加一 header("location:success.php?act=addnews&rst=3"); } else { header("location:success.php?act=addnews&rst=4"); } } $newsTypes = NewsTypes::getNewsTypes(); //所有分类 ?> <!DOCTYPE html> <html> <head> <title>添加新闻</title>
if ($content != NULL) { $result = Reviews::addReviews($articleId, $face, $content, $userName); if ($result > 0) { echo "<script type='text/javascript'>"; echo "\talert('发表评论成功!');"; echo "\twindow.location='news.php?articleId={$articleId}';"; echo "</script>"; } else { echo "<script type='text/javascript'>"; echo "\talert('发表评论失败!');"; echo "\twindow.location='news.php?articleId={$articleId}';"; echo "</script>"; } } //获得当前页面显示的新闻 $result3 = NewsArticles::getNewsById($articleId); //所有分类 $newsTypes = NewsTypes::getNewsTypes(); //获得该新闻的所有评论 $reviews = Reviews::getReviews($articleId); ?> <html> <head> <title>天天新闻网</title> <meta http-equiv="content-type" content="text/html;charset=utf-8"> <link href="css/news.css" type="text/css" rel="stylesheet" /> <script type="text/javascript" src="kindeditor/kindeditor.js"></script> <script type="text/javascript"> var editor;//编辑器对象 KindEditor.ready(function(e){ editor = e.create("[name=content]",{
header("content-type:text/html;charset=utf-8"); include_once 'nologin.php'; include_once '../dbio/NewsArticles.php'; $currentPage = $_POST["currentPage"]; //当前页 $currentPage = $currentPage == NULL ? 1 : $currentPage; //获得表单提交的数据 $keyword = $_POST["keyword"]; $searchType = $_POST["searchType"]; $articleId = $_GET["articleId"]; //删除新闻 if ($articleId != NULL) { $result = NewsArticles::delNews($articleId); header("location:success.php?act=delNews&rst={$result}"); } $result = NewsArticles::getAllNews($currentPage, $keyword, $searchType); $newsInfo = $result[0]; //记录 $totalPage = $result[1]; //总页数 ?> <html> <head> <title>修改新闻</title> <meta http-equiv="content-type" content="text/html;charset=utf-8"> <link href="../css/admin.css" type="text/css" rel="stylesheet" /> <script type="text/javascript" src="../jquery/jquery-1.4.js"></script> <script type="text/javascript"> function checkSearch() { if(document.frm.keyword.value == "")