How can PHP values be transferred to a SQL database?

To transfer PHP values to a SQL database, you can use SQL queries within your PHP code to insert, update, or retrieve data from the database. You can establish a connection to the database using functions like mysqli_connect() or PDO and then execute SQL queries using functions like mysqli_query() or PDO::query(). Make sure to properly sanitize and validate user input to prevent SQL injection attacks. 

// Establish connection to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";

$conn = mysqli_connect($servername, $username, $password, $dbname);

// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

// Example of inserting PHP values into a SQL database
$value1 = "John";
$value2 = "Doe";

$sql = "INSERT INTO users (first_name, last_name) VALUES ('$value1', '$value2')";

if (mysqli_query($conn, $sql)) {
    echo "Record inserted successfully";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

// Close connection
mysqli_close($conn);

Keywords

PHP SQL database data transfer SQL queries database connection

Related Questions