How can SQL statements be effectively used in PHP to manipulate database records?

SQL statements can be effectively used in PHP to manipulate database records by establishing a connection to the database, preparing an SQL query, executing the query, and handling any errors that may occur during the process. This allows PHP developers to insert, update, delete, or retrieve data from a database using SQL commands within their PHP scripts. 

// Establish a connection to the database
$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);
}

// Prepare an SQL query to insert data into a table
$sql = "INSERT INTO table_name (column1, column2, column3) VALUES ('value1', 'value2', 'value3')";

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

// Close the connection
$conn->close();

Keywords

SQL statements PHP database records manipulation error handling

Related Questions