How can the issue of data not being inserted into the database be troubleshooted in PHP?

Issue: If data is not being inserted into the database in PHP, it could be due to errors in the SQL query, connection issues, or improper handling of input data. To troubleshoot this issue, first, check the SQL query for any syntax errors or missing parameters. Make sure the database connection is established correctly and the appropriate database is selected. Also, validate and sanitize input data to prevent SQL injection attacks. 

<?php
// Establish database connection
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Sanitize input data
$name = mysqli_real_escape_string($conn, $_POST['name']);
$email = mysqli_real_escape_string($conn, $_POST['email']);

// Insert data into database
$sql = "INSERT INTO users (name, email) VALUES ('$name', '$email')";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();
?>

Keywords

MySQL SQL injection PDO error handling debugging

Related Questions