how to make mysqli connect function

Question

I'm having a problem with a function that connects me to the database using mysqli. What I'm aiming to have is to just type getConnected(); where I need the connection.

This is the code:

function getConnected()
{
    $host = 'localhost';
    $user = 'logintest';
    $pass = 'logintest';
    $db = 'vibo';

    $mysqli = new mysqli($host, $user, $pass, $db);

    if ($mysqli->connect_error) {
        die('Connect Error (' . mysqli_connect_errno() . ') '
            . mysqli_connect_error());
    }
}

Answer 1

let’s have a look how to make mysqli connect function:

function connected_demo($host,$user,$pass,$db) {

 

   $mysqli = new mysqli($host, $user, $pass, $db);

 

   if($mysqli->connect_error) 

     die('Connect Error (' . mysqli_connect_errno() . ') '. mysqli_connect_error());

 

   return $mysqli;

}

It is  the function returning the mysqli instance.

Function call:

$mysqli = Connected_demo('localhost','user','password','database');