Explore how to delete news using PHP

If you are a PHP developer, you must often face websites that need to manage content, such as news websites. In these websites, it is often necessary to delete some old or no longer needed news. In this article, we will explore how to delete news using PHP.

First, we need to understand how data is stored in the database. We will use MySQL as the database example. A typical news table may contain the following fields: news ID, title, content, release time, etc. If you have already designed your own database tables, you can skip directly to the next step. Otherwise, you need to create a new table in MySQL:

CREATE TABLE news (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(255),
content TEXT ,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

The above code creates a table named news, which contains an auto-increment ID, title, content and news release time.

So, how to delete a piece of news? First, we need to select the news to delete from the database. In PHP, we can use the mysqli extension to connect to MySQL and use the relevant SQL statements to perform delete operations. Here is a simple example:

$mysqli = new mysqli('localhost', 'username', 'password', 'database');

$id = $_GET['id '];
$sql = "SELECT * FROM news WHERE id = $id";
$result = $mysqli->query($sql);

if ($result-> ;num_rows === 0) {

die('News not found');

}

$news = $result->fetch_assoc();

In the code, we first get the requested data from the URL Delete the news ID, and then use the SELECT statement to retrieve the news from the database. If the news is not found in the database, we will prompt a "News not found" error. Otherwise, we will save information about this news.

Next, we need to display information to let the user confirm whether they want to delete the news. There are many ways to accomplish this, such as using JavaScript to pop up a confirmation box, or using a form on an HTML page to submit a deletion request. Here, we will use the latter.

< ?php if ($news) { ?>

<h1>Delete News</h1>
<p>Are you sure you want to delete "<?php echo $news[&#39;title&#39;]; ?>"?</p>
<form method="POST" action="delete-news.php">
  <input type="hidden" name="id" value="<?php echo $news[&#39;id&#39;]; ?>">
  <button type="submit">Delete</button>
</form>

<p>News not found.</p>

The above code displays a deletion confirmation page, which asks the user if they want to delete the news. If the user confirms the deletion, a POST request will be made to a page named "delete-news.php".

Finally, we need to implement this operation on the delete-news.php page. On this page, we need to select the news to be deleted from the database again and delete it from the database using the DELETE statement:

$mysqli = new mysqli('localhost', 'username', 'password', 'database');

$id = $_POST['id'];
$sql = "SELECT * FROM news WHERE id = $id";
$result = $mysqli->query($sql);

if ($result->num_rows === 0) {

die('News not found');

}

$ mysqli->query("DELETE FROM news WHERE id = $id");

echo 'News deleted successfully.';
?>

If the deletion operation is successful, we A confirmation message will be displayed.

In this article, we have discussed how to delete news using PHP. Although this is just a very basic example, it can provide some basic ideas and methods for your actual projects.

The above is the detailed content of Explore how to delete news using PHP. For more information, please follow other related articles on the PHP Chinese website!