Is it better to open and close the database connection for every DB execution or to open it at the beginning of the script and close it before the HTML output?

It is generally better to open the database connection at the beginning of the script and close it before the HTML output. This approach reduces the overhead of opening and closing the connection for every database execution, resulting in better performance. Additionally, keeping the connection open throughout the script allows for multiple queries to be executed without reconnecting each time. 

<?php
// Open the database connection
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

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

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

// Perform database operations

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

Keywords

PHP database connection performance best practice HTML output

Related Questions