mysqli_ssl_set()

The mysqli_ssl_set() function is used to establish encrypted connections using the SSL protocol. This is essential when your application connects to the server over untrusted networks.

EXAMPLE

<?php
// 1. First, initialize an empty connection object
$obj = mysqli_init();

if (!$obj) {
    die("mysqli_init initialization failed.");
}

// 2. Set up SSL certificates and private keys for a secure encrypted connection
// NOTE: The function must be called BEFORE connecting to the server.The arguments in order represent 
// the path to: client private key, client certificate, CA certificate, certificate directory, and 
// the list of allowed algorithms (ciphers).
mysqli_ssl_set($obj, "client-key.pem", "client-cert.pem", "server-ca.pem", NULL, NULL);

// 3. Establish the actual connection via the secure SSL protocol
$server = "localhost";
$username = "root";
$password = "";
$database = "mysqli_database";

if (!mysqli_real_connect($obj, $server, $username, $password, $database)) {
    die("Secure SSL connection failed: " . mysqli_connect_error());
} else {
    echo "Encrypted SSL connection was successfully established!";
}

mysqli_close($obj);
?>

RESULT

The result will be displayed here...

connection: Required connection object (created with mysqli_init()).
key: The path to the key file (Private Key).
cert: The path to the certificate file (Certificate).
ca: The path to the certificate authority file (Certificate Authority).
capath: The path to a directory containing certificates in PEM format.
cipher: A list of allowable ciphers for encryption.

Important: This function only works if OpenSSL support is enabled on the server. You must call it before using the mysqli_real_connect() function.

Enables data encryption between the website and the database.
Protects against interception of passwords and sensitive data.
Requires use in combination with mysqli_init() and mysqli_real_connect().