1、新建数据库 news,blogs
+ htis int(11)
2、php连接数据库（conn.php）
<?php
header('Content-type:text/html;charset=utf-8');
@mysql_connect("localhost:3306","root","admin123")or die("mysql连接失败");
@mysql_select_db("news")or die("db连接失败");
//mysql_query("set names 'gbk'");
mysql_set_charset("utf8");
?>
3、显示数据页面<后台首页>（index.php）
<a href="add.php" target="_blank">添加内容</a>
<hr />
<form action="" method="get">
<input type="text" name="keys">
<input type="submit" name="subs" value="搜索">
</form>
<?php
include("conn.php");
if(!empty($_GET['keys'])){
$w = " `title` like '%".$_GET['keys']."%' ";
}else{
$w=1;
}
$sql = "select * from `blog` where $w order by id desc limit 10";
$query = mysql_query($sql);
while ($rs = mysql_fetch_array($query)) {
?>
<h2>
标题: <a href="view.php?id=<?php echo $rs['id'] ?>" target="_blank"><?php echo $rs['title'] ?></a>
|<a href="edit.php?id=<?php echo $rs['id'] ?>" target="_blank">编辑</a> |
<a href="del.php?del=<?php echo $rs['id'] ?>" target="_blank">删除</a> |
</h2>
<li><?php echo $rs['dates'] ?></li>
<p><?php echo iconv_substr($rs['contents'], 0,2,"utf-8") ?>...</p>
<hr />
<?php
}
?>
4、添加数据页面（add.php）
<?php
include("conn.php");
if(!empty($_POST['sub'])){
$title = $_POST['title'];
$con = $_POST['con'];
$sql = "insert into `blog`(`id` , `title` , `dates` , `contents`) values (null , '$title' , now() , '$con')";
mysql_query($sql);
echo "插入成功 ";
}
?>
<form action="add.php" method="post">
标题<input type="text" name="title"><br />
内容<textarea rows="5" cols="50" name="con"></textarea><br />
<input type="submit" name="sub" value="发表">
</form>
5、编辑页面（edit.php）
<?php
include("conn.php");
if(!empty($_GET['id'])){
$sql = "select * from blog where `id` = '".$_GET['id']."'";
$query = mysql_query($sql);
$rs = mysql_fetch_array($query);
}
if(!empty($_POST['sub'])){
$title = $_POST['title'];
$con = $_POST['con'];
$hid = $_POST['hid'];
$sql = "update `blog` set `title`='$title' , contents='$con' where id='$hid'";
mysql_query($sql);
echo "<script>alert('更新成功');location.href='index.php'</script>";
}
?>
<form action="edit.php" method="post">
<input type="hidden" name="hid" value="<?php echo $rs['id'] ?>">
标题<input type="text" name="title" value="<?php echo $rs['title'] ?>"><br />
内容<textarea rows="5" cols="50" name="con"><?php echo $rs['contents'] ?></textarea><br />
<input type="submit" name="sub" value="发表">
</form>
6、删除数据(del.php)
<?php
include("conn.php");
if(!empty($_GET['del'])){
$d = $_GET['del'];
$sql = "delete from `blog` where `id`='$d'";
mysql_query($sql);
echo "删除成功";
}
?>
7、前台显示(view.php)
<?php
include("conn.php");
if(!empty($_GET['id'])){
$sql = "select * from blog where `id` = '".$_GET['id']."'";
$query = mysql_query($sql);
$rs = mysql_fetch_array($query);
$sqlup="update blog set hits = hits+1 where `id` = '".$_GET['id']."'";
mysql_query($sqlup);
}
?>
<h1><?php echo $rs['title'] ?></h1>
<h1><?php echo $rs['dates'] ?></h1>
<h3>点击量：<?php echo $rs['hits'] ?></h3>
<hr />
<p><?php echo $rs['contents'] ?></p>
8、登录
<?PHP
include("conn.php");
?>
<!DOCTYPE html>
<html>
<head>
<title>login</title>
<link rel="stylesheet" type="text/css" href="login.css">
</head>
<body>
<div class="login_in">
<form name="form" method="post" action="" >
<ul>
<li><span>用户名：</span><input type="text" class="input" name="username" id="username" placeholder="请输入用户名" /></li>
<li> <span>密 码：</span><input type="password" class="input" name="password" id="password" placeholder="请输入密码" /></li>
<li class="denglu_btn"><input type="submit" name="sub" id="sub" value="登录" /></li>
</ul>
</form>
<?php
if(!empty($_POST['sub'])){
$username=$_POST['username'];
$password=$_POST['password'];
$sql="select * from `userflag` where username='$username' and password='$password'";
$query = mysql_query($sql);
$rs = mysql_fetch_array($query);
if($rs['password']==$password && $password!=null){
echo "<script>alert('登录成功');location.href='log/php/index.php'</script>";
}else{
echo "<script>alert('密码错误，请重新输入');</script>";
}
}
?>
</div>
</body>
</html>