How can MySQL be configured to provide feedback on the success or failure of an INSERT query in PHP?

To provide feedback on the success or failure of an INSERT query in PHP using MySQL, you can use the mysqli_affected_rows() function to check the number of affected rows after executing the query. If the function returns a value greater than 0, it means the INSERT query was successful. Otherwise, it indicates a failure. 

// Connect to MySQL database
$connection = mysqli_connect("hostname", "username", "password", "database");

// Execute INSERT query
$query = "INSERT INTO table_name (column1, column2) VALUES ('value1', 'value2')";
$result = mysqli_query($connection, $query);

// Check for success or failure
if (mysqli_affected_rows($connection) > 0) {
    echo "INSERT query successful";
} else {
    echo "INSERT query failed";
}

// Close database connection
mysqli_close($connection);

Keywords

MySQL configuration feedback INSERT query PHP

Related Questions