How to change database content from a form using php?

2 years ago
William Carter
2 minutes

To modify the database content from a form, you need to use PHP to handle the form data and update it in the database. Below is a simple example to demonstrate how to perform these operations:

  1. Create an HTML page with a form, such as one with text boxes and a submit button, to input content to update the database.
<form method="POST" action="update.php">
  <input type="text" name="new_content">
  <input type="submit" value="更新数据库">
</form>
  1. update page
<?php
// 连接到数据库
$conn = mysqli_connect("localhost", "username", "password", "database");

// 检查连接是否成功
if (!$conn) {
    die("数据库连接失败: " . mysqli_connect_error());
}

// 获取表单提交的新内容
$newContent = $_POST['new_content'];

// 更新数据库内容
$sql = "UPDATE your_table SET column_name = '$newContent' WHERE condition";
if (mysqli_query($conn, $sql)) {
    echo "数据库内容更新成功";
} else {
    echo "更新失败: " . mysqli_error($conn);
}

// 关闭数据库连接
mysqli_close($conn);
?>

Please note that in the above code, “your_table” and “column_name” should be replaced with the actual table name and column name you want to update, and “condition” should be replaced with a suitable query condition.

  1. update page

This is just a simple example to demonstrate how to modify database content from a form. The actual situation may be more complicated, depending on your application requirements and database structure. Remember to perform proper data validation and security measures in real applications to prevent potential security risks.

bannerAds