How can improper handling of SQL queries in PHP, such as attempting to fetch results from an INSERT statement, lead to errors and how can this be corrected?

Improper handling of SQL queries in PHP, such as attempting to fetch results from an INSERT statement, can lead to errors because INSERT queries do not return a result set. To correct this issue, you should use the appropriate method to execute the query and handle any errors that may occur. 

// Correct way to execute an INSERT query in PHP
$conn = new mysqli($servername, $username, $password, $dbname);

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

$sql = "INSERT INTO table_name (column1, column2, column3) VALUES ('value1', 'value2', 'value3')";

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

$conn->close();

Keywords

SQL injection fetch results INSERT statement error handling prepared statements

Related Questions