How to add, delete, check and modify news information in PHP

PHP is an open source server-side scripting language that is often used to dynamically generate Web pages. Compared with other programming languages, PHP's syntax is simple and easy to understand, and it is easy to get started. Even beginners can get started quickly.

In web development, news management is a very important task. With the development of the Internet, news information is updated faster and faster, requiring an efficient way to manage it. PHP is just right for this task. It can add, delete, check, and modify news, making news management work easier and more efficient.

1. Design of News Management System

Before designing a news management system, the first thing to consider is the design of the database. Under normal circumstances, a news management system needs at least two tables, one is a table that stores news information, and the other is a table that stores news classification information. Next, let’s take a look at the specific design.

1. News information table

The news information table needs to contain the following fields:

• id (news number)
• title (News title)
• category_id (category number)
• content (News content)
• addtime (News release time)

2. News classification table

The news classification table only needs to contain the following fields:

• id (category number)
• name (category name)

With the database design in place, you can start writing the code for the news management system.

2. Add, delete, check and modify news information

1. Add news information

In PHP, use the mysqli extension library to To connect to the database, you can use the mysqli_connect() function to connect. After the connection is successful, you can execute SQL statements to add news information to the database.

The following is a simple code example for adding news information:

//连接数据库
$con = mysqli_connect("localhost", "root", "123456", "news");

if (!$con) {
    die("连接错误: " . mysqli_connect_error());
}

//获取表单数据
$title = $_POST["title"];
$category_id = $_POST["category_id"];
$content = $_POST["content"];
$addtime = date("Y-m-d H:i:s");

//插入数据
$sql = "INSERT INTO news (title, category_id, content, addtime) 
VALUES ('$title', '$category_id', '$content', '$addtime')";

//执行SQL语句并判断是否成功
if (mysqli_query($con, $sql)) {
    echo "新闻添加成功！";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($con);
}

//关闭连接
mysqli_close($con);

2. Query for news information

The query for news information is compared in the management system For common operations, you can use the SELECT statement to query the required data from the database. The following is a simple code example for querying news information:

//连接数据库
$con = mysqli_connect("localhost", "root", "123456", "news");

if (!$con) {
    die("连接错误: " . mysqli_connect_error());
}

//查询数据
$sql = "SELECT * FROM news";

$result = mysqli_query($con, $sql);

//输出查询结果
if (mysqli_num_rows($result) > 0) {
    while($row = mysqli_fetch_assoc($result)) {
        echo "标题: " . $row["title"]. " - 分类: " . $row["category_id"]. " - 时间: " . $row["addtime"]. "<br>";
    }
} else {
    echo "0 结果";
}

//关闭连接
mysqli_close($con);

3. Modification of news information

Modification of news information requires using the UPDATE statement to update the value of the corresponding field. The following is a simple code example for modifying news information:

//连接数据库
$con = mysqli_connect("localhost", "root", "123456", "news");

if (!$con) {
    die("连接错误: " . mysqli_connect_error());
}

//获取表单数据
$id = $_POST["id"];
$title = $_POST["title"];
$category_id = $_POST["category_id"];
$content = $_POST["content"];

//更新数据
$sql = "UPDATE news SET title='$title', category_id='$category_id', content='$content' WHERE id=$id";

//执行SQL语句并判断是否成功
if (mysqli_query($con, $sql)) {
    echo "新闻修改成功！";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($con);
}

//关闭连接
mysqli_close($con);

4. Deletion of news information

Deletion of news information requires using the DELETE statement to delete the corresponding data record. The following is a simple code example for deleting news information:

//连接数据库
$con = mysqli_connect("localhost", "root", "123456", "news");

if (!$con) {
    die("连接错误: " . mysqli_connect_error());
}

//获取需要删除的数据id
$id = $_GET["id"];

//删除数据
$sql = "DELETE FROM news WHERE id=$id";

//执行SQL语句并判断是否成功
if (mysqli_query($con, $sql)) {
    echo "新闻删除成功！";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($con);
}

//关闭连接
mysqli_close($con);

3. Summary

Through the above code example, we can see that PHP is implementing the addition and deletion of news information. It is extremely simple to check and correct. In actual development, the code can also be further optimized to improve execution efficiency and achieve a more efficient news management system.

The above is the detailed content of How to add, delete, check and modify news information in PHP. For more information, please follow other related articles on the PHP Chinese website!