What common mistakes can lead to a PHP form not submitting data to a database?

One common mistake that can lead to a PHP form not submitting data to a database is not properly connecting to the database or not selecting the correct database. Ensure that your database connection code is correct and that you have selected the right database before attempting to insert data. Additionally, make sure that the form fields are correctly mapped to the database columns in your SQL query. 

// Correct database connection and selection
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";

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

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

// Correctly map form fields to database columns in SQL query
$sql = "INSERT INTO table_name (column1, column2, column3) VALUES ('" . $_POST['field1'] . "', '" . $_POST['field2'] . "', '" . $_POST['field3'] . "')";

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

$conn->close();

Keywords

SQL injection incorrect database credentials missing form action attribute incorrect form method PHP syntax error

Related Questions