PHP mysqli_ssl_set() Function

Definition and Usage

The mysqli_ssl_set() function establishes a secured connection using SSL with MySQL server.

Syntax

mysqli_ssl_set($con, $key, $cert, $ca, $capath, $cipher);

Parameters

Return Values

This function returns the boolean value which is true in case of success and false incase of failure.

PHP Version

This function was first introduced in PHP Version 5 and works works in all the later versions.

Example

Following example demonstrates the usage of the mysqli_ssl_set() function (in procedural style) −

<?php
   //Creating a connection
   $con = new mysqli("localhost", "root","password","test");

   //Securing the connection
   $con->ssl_set("key.pem", "cert.pem", "cacert.pem", NULL, NULL);

   //Creating the connection
   $con = $con->real_connect("localhost","root","password","test");
   if($con){
      print("Connection Established Successfully");
   }else{
      print("Connection Failed ". mysqli_connect_error());
   }
?>

This will produce following result −

Connection Established Successfully

Example

In object oriented style the syntax of this function is $con-> ssl_set(); Following is the example of this function in object oriented style $minus;

<?php
   //Creating a connection
   $con = new mysqli("localhost", "root","password","test");

   //Securing the connection
   $con->ssl_set("key.pem", "cert.pem", "cacert.pem", NULL, NULL);

   //Creating the connection
   $con = $con->real_connect("localhost","root","password","test");
   if($con){
      print("Connection Established Successfully");
   }else{
      print("Connection Failed ". mysqli_connect_error());
   }
?>

This will produce following result −

Connection Established Successfully