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>";
        }
    }
?>

Continuing Learning

new file

<?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>"; } } ?>

submit Reset Code

Automatic operation

Implementation of added functions of PHP development news management system

ElementaryImperial CMS enterprise imitation website tutorial

ElementaryNewbies with zero foundation in WordPress build personal blogs and corporate websites

ElementaryUltimate CMS zero-based website building instruction video

ElementaryFront-end project-Shangyou [HTML/CSS/JS technology comprehensive practice]

IntermediateVue3.0 from 0 to build a universal backend management system project practice

ElementaryZero-based front-end course [Vue advanced learning and practical application]

ElementaryWEB front-end tutorial [HTML5+CSS3+JS]

ElementaryQuick introduction to apipost

IntermediateVue3+TypeScript practical tutorial-enterprise-level project practice

ElementaryLet's briefly talk about starting a business in PHP

IntermediateVUE e-commerce project (front-end & back-end dual project actual combat)

ElementaryApipost practical application [api, interface, automated testing, mock]