How can I correctly add data records using PHP code in a MySQL database?

To correctly add data records using PHP code in a MySQL database, you can use the mysqli extension to connect to the database, prepare an SQL INSERT statement with placeholders for the data values, bind the values to the placeholders, and execute the query to insert the data into the database. 

<?php

// Database connection parameters
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

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

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

// Prepare and bind the SQL statement
$stmt = $conn->prepare("INSERT INTO table_name (column1, column2) VALUES (?, ?)");
$stmt->bind_param("ss", $value1, $value2);

// Set the values of the data records
$value1 = "value1";
$value2 = "value2";

// Execute the query to insert the data
$stmt->execute();

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

?>

Keywords

PHP MySQL data records database code.

Related Questions