Implementation of added functions of PHP development news management system
To implement the modification function, let’s look at the following flow chart
Let’s look at the code for the following added page: news.php
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title></title>
<style type="text/css">
*{margin:0px;padding:0px;}
body{background:#ccc;}
.add{width:450px;height:280px;background:#eee;float:left;}
.cont{width:500px;height:350px;margin-top:5px;margin-left:5px;}
form{margin-left:10px;padding-top:30px;}
.sub{width:100px;height:40px;border:1px solid #ccc;}
.sub:hover{background:#f90}
</style>
</head>
<body>
<div class="add">
<div class="cont">
<form method="post" action="addnews.php">
标题：<input type="text" name="title"></br></br>
内容：<textarea cols="50" rows="5" name="content"></textarea></br></br>
<input type="submit" value="添加" class="sub">
</form>
</div>
</div>
</body>
</html>As above As you can see from the code, the form is submitted to the addnews.php file
Let’s look at the code of the addnews.php file below:
First we need to connect to the database and add to get information from the form Add it to the database, so we need to connect to the database
The code is as follows:
header("Content-type: text/html; charset=utf-8"); //Set encoding
$con =@mysql_connect("localhost","root","root") or die("Database connection failed");
mysql_select_db('news') or die("Specified The database cannot be opened");
mysql_query("set names utf8");//Set the character set of the database
Then get the form information:
$title = $_POST['title'];
$content = $_POST['content'];
$messtime = time();
Before adding to the database , we first need to judge whether the title and content of the text box are empty. If they are empty, we will give a prompt. The code is as follows:
if(empty($title)){
Echo "& lt; script & gt; alert ('Please enter the title'); History.go (-1); & lt;/script & gt; ;script>alert('Please enter content');history.go(-1);</script>";
}
We can only do this when the content is not empty Add content to the database, the code is as follows:
$sql = "insert into new (title,content,messtime) values('$title','$content','$messtime')";
$result =mysql_query($sql); if($result){
echo "<script>alert('Article added successfully');location.href='newlist.php'< /script>";
echo "
#The complete source code is as follows:
<?php
//链接数据库
header("Content-type: text/html; charset=utf-8");//设置编码
$con =@mysql_connect("localhost","root","root") or die("数据库连接失败");
mysql_select_db('news') or die("指定的数据库不能打开");
mysql_query("set names utf8");//设置数据库的字符集
//添加操作
$title = $_POST['title'];
$content = $_POST['content'];
$messtime = time();
if(empty($title)){
echo "<script>alert('请输入标题');history.go(-1);</script>";
}elseif(empty($content)){
echo "<script>alert('请输入内容');history.go(-1);</script>";
}else{
$sql = "insert into new (title,content,messtime) values('$title','$content','$messtime')";
$result =mysql_query($sql);
if($result){
echo "<script>alert('添加文章成功');location.href='newlist.php'</script>";
}else{
echo "<script>alert('添加文章失败');history.go(-1);</script>";
}
}
?>Next Section