How can a PHP script determine if a connection to MySQL already exists?

To determine if a connection to MySQL already exists in a PHP script, you can check if the MySQL connection object is already set or not. If the connection object is set, then a connection already exists. You can use this check to avoid creating duplicate connections to the database. 

// Check if a MySQL connection already exists
if(isset($conn)){
    echo "Connection to MySQL already exists.";
} else {
    // Create a new MySQL connection
    $conn = mysqli_connect($servername, $username, $password, $dbname);

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

Keywords

PHP MySQL connection check exists

Related Questions