PHP实例之
新闻发布系统
Create TABLE `news` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`p_time` DATETIME NOT NULL ,
`title` VARCHAR( 80 ) NOT NULL ,
`detail` TEXT NOT NULL
) TYPE = innodb;
create table news(id int not null auto_increment primary key,
p_time datetime not null,
title varchar(80)not null,
detail text not null
)type=innodb;
数据库连接:conn.
php
<?
$conn = @mysql_connect('localhost','root','')or die(mysql_error()."不能连接到数据库!"); //连接数据库；
$db = mysql_select_db('news',$conn);
$page_size = 8; //每页最多显示
新闻条数；
?>
添加
新闻页面:new.
php
<?
$title="
新闻发布系统";
include("inc/header.inc");//头文件
?>
<style type="text/css">
<!--
.STYLE1 {font-size: 12px}
.title {
font-size: 12px;
border-top-style: none;
border-right-style: none;
border-bottom-style: none;
border-left-style: none;
font-family: "宋体";
color: #993300;
line-height: normal;
height: 16px;
}
.field {
font-family: "宋体";
font-size: 12px;
color: #993333;
}
.STYLE2 {
font-size: 16px;
font-weight: bold;
}
-->
</style>
<p align="center" class="STYLE2">
PHP+Mysql
新闻发布</p>
<form action="post.
php" method="post" name="frm" id="frm">
<table width="500" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#0066FF">
<tr>
<td height="1" bgcolor="#FFFFFF"><span class="STYLE1">标题：</span></td>
</tr>
<tr>
<td height="1" bgcolor="#FFFFFF"><input name="title" type="text" class="title" id="title" size="60" maxlength="80"></td>
</tr>
<tr>
<td height="1" bgcolor="#FFFFFF"><span class="STYLE1">内容： </span></td>
</tr>
<tr>
<td height="1" bgcolor="#FFFFFF"><textarea name="textfield" cols="58" rows="6" class="field"></textarea></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><input name="submit" type="submit" value="发布"></td>
</tr>
</table>
</form>
<?
include("inc/navbar.inc");//底部
?>
新闻处理页面:post.
php
<?
include"conn.
php";
$title=htmlspecialchars($_POST['title']);
$textfield=htmlspecialchars($_POST['textfield']);
$pub_time=date('Y')."-".date('m')."-".date('d')." ".date('H').":".date('i').":".date('s');
$query="insert into news(title,detail,p_time)values ('$title','$textfield','$pub_time')";
$result=mysql_query($query);
if($result)
{
echo "发布成功！<br>";
echo "<a href='list.
php'>
新闻列表</a> <a href='new.
php'>继续发布</a>";
}
else
{
echo mysql_error()."<br>";
echo "发布失败！请<a >返回</a>";
}
?>
新闻列表:list.
php
<?
include "conn.
php";
$query = "Select COUNT(*) FROM news";
$result = mysql_query($query);
$num = mysql_num_rows($result);
$page_count = ceil($num/$page_size);
//$offset = ($page_count-1)*$page_size;
if(empty($_GET['page']))
{
$page = 1;
}else
{
$page = $_GET['page'];
if($page<=0)
{
$page = 1;
}else
{
$page >= $page_count;
$page = $page_count-1;
}
}
$query ="Select * FROM `news` orDER BY `id` DESC LIMIT ".($page-1)*$page_count.","."$page_size";
$result = mysql_query($query);
?>
<table width="571" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#0066FF">
<tr>
<td width="5" bgcolor="#FFFFFF"><div align="center"></div></td>
<td width="343" bgcolor="#FFFFFF"><div align="center">标题</div></td>
<td width="189" bgcolor="#FFFFFF"><div align="center">时间</div></td>
</tr>
<?
php
while($l_result = mysql_fetch_array($result))
{
?>
<tr>
<td bgcolor="#FFFFFF"><div align="center"><?
php echo $l_result['id'];?></div>
</td>
<td bgcolor="#FFFFFF"><div align="center"><a href="<?
php echo "><?
php echo $l_result['title'];?></a></div></td>
<td bgcolor="#FFFFFF"><div align="center"><a href="<?
php echo "><?
php echo $l_result['p_time'];?></a></div></td>
</tr>
<?
php
}
?>
</table><br>
<center><a href="new.
php">发布信息</a><br></center>
<?
php //页码显示
for ($i=1;$i<=($page_count-1);$i++){
echo "<a page=".$i.">".$i."</a> ";
}
//页码显示
?>
新闻显示页面:view.
php
<?
include "conn.
php";
$query = "Select * FROM news where id=".$_GET['id'];
$result = mysql_query($query);
$v_result = @mysql_fetch_array($result);
?>
<table width="60%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#0066FF">
<tr>
<td bgcolor="#FFFFFF">标题：</td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><?
php echo $v_result['title'];?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF">内容：</td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><?
php echo $v_result['detail'];?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><a href="list.
php">返回</a></td>
</tr>
</table>
2
3543
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
