How can I use $_POST to update data in a database?
In update.php
, you can update the database record:
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "test_db";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
if ($_SERVER["REQUEST_METHOD"] === "POST") {
$id = $_POST["id"];
$name = $_POST["name"];
// Prepare and bind
$stmt = $conn->prepare("UPDATE users SET name = ? WHERE id = ?");
$stmt->bind_param("si", $name, $id);
// Execute the query
if ($stmt->execute()) {
echo "Record updated successfully";
} else {
echo "Error updating record: " . $conn->error;
}
$stmt->close();
}
$conn->close();
?>
This script uses a prepared statement to update a record securely. Prepared statements help prevent SQL injection by separating SQL code from data.
03 Aug 2024 | 7
asked by ~ Megha
Top related questions
What is the difference between array_push() and array_unshift()?
18 Aug 2024
| 14
How do GET and POST differ in terms of security in PHP?
18 Aug 2024
| 16
What is the difference between mysql_query() and mysqli_query()?
18 Aug 2024
| 16
How does array_key_exists() differ from isset()?
18 Aug 2024
| 14
What is the Difference Between `==` and `===` in PHP?
18 Aug 2024
| 0
How do `echo` and `print` differ in PHP?
18 Aug 2024
| 28
How do `POST` and `GET` methods differ in PHP?
18 Aug 2024
| 20
What Are the Differences Between `include` and `require` in PHP?
18 Aug 2024
| 14
How Does `include_once` Differ from `require_once`?
18 Aug 2024
| 17
How Do `isset()` and `empty()` Differ in PHP?
18 Aug 2024
| 19
How do foreach and for loops differ in PHP?
18 Aug 2024
| 13
Difference Between Procedural and OOPs in PHP
18 Aug 2024
| 14
How do return and echo differ in PHP functions?
18 Aug 2024
| 12