Paste_Image.png
article.manage.php
<?php
require_once('../connect.php');
$sql = "select * from article order by dateline desc";
$query = mysql_query($sql);
if($query&&mysql_num_rows($query)){
while($row =mysql_fetch_assoc($query)){
$data[] = $row;//data是二位数组
}
}else{
$data = array();
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<style type="text/css">
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
</style>
</head>
<body>
<table width="100%" height="520" border="0" cellpadding="8" cellspacing="1" bgcolor="#000000">
<tr>
<td height="89" colspan="2" bgcolor="#FFFF99"><strong>后台管理系统</strong></td>
</tr>
<tr>
<td width="156" height="287" align="left" valign="top" bgcolor="#FFFF99"><p><a href="article.add.php">发布文章</a></p>
<p><a href="article.manage.php">管理文章</a></p></td>
<td width="837" valign="top" bgcolor="#FFFFFF"><table width="743" border="0" cellpadding="8" cellspacing="1" bgcolor="#000000">
<tr>
<td colspan="3" align="center" bgcolor="#FFFFFF">文章管理列表</td>
</tr>
<tr>
<td width="37" bgcolor="#FFFFFF">编号</td>
<td width="572" bgcolor="#FFFFFF">标题</td>
<td width="82" bgcolor="#FFFFFF">操作</td>
</tr>
<?php
if(!empty($data)){
foreach($data as $value){
?>
<tr>
<td bgcolor="#FFFFFF"> <?php echo $value['id']?></td>
<td bgcolor="#FFFFFF"> <?php echo $value['title']?></td>
<td bgcolor="#FFFFFF"><a href="article.del.handle.php?id=<?php echo $value['id']?>">删除</a> <a href="article.modify.php?id=<?php echo $value['id']?>">修改</a></td>
</tr>
<?php
}
}
?>
</table></td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFFF99"><strong>版权所有</strong></td>
</tr>
</table>
</body>
</html>
article.del.handle.php
<?php
require_once ('connect.php');
$id=$_GET['id'];
$deletesql="delete from article where id =$id";
if(mysql_query($deletesql)){
echo "<script>alert('删除文章成功');location.href='article.manage.php'</script>";
}else{
echo "<script>alert('删除文章失败');location.href='article.manage.php'</script>";
}
?>
article.modify.handle.php
<?php
require_once('connect.php');
$id=$_POST['id'];
$title=$_POST['title'];
$author=$_POST['author'];
$description=$_POST['description'];
$content=$_POST['content'];
$dateline=time();
$updatesql="update article set title='$title',author='$author',description='$description',content='$content',dateline=$dateline WHERE id=$id";
if(mysql_query($updatesql)){
echo "<script>alert('修改文章成功');window.location.href='article.manage.php'</script>";
}else{
echo "<script>alert('修改文章失败');window.location.href='article.manage.php'</script>";
}
?>
Paste_Image.png
