php简易增删改查
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>声明：该文观点仅代表作者本人，入门客AI创业平台信息发布平台仅提供信息存储空间服务，如有疑问请联系rumenke@qq.com。
- 上一篇： Javascript Jquery 中的数组定义与操作
- 下一篇：没有了
