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 == "")
