Can a MYSQLI connection be reopened WITHOUT instantiating a new object

Question

Just a quick question here:

If I choose the object oriented style to interact with my database, ie...

$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

And I then use $mysqli->close(); to close the connection at some point...

Can I reopen that connection by simply initiating another query $mysqli->query();, or do I have to instantiate a new MYSQLI object?

Answer 1

No, you have to instantiate a new MYSQLI object. You can use the same variable $mysqli though but you have to write this code again:

 $mysqli = new mysqli("localhost", "my_user", "my_password", "world");

Answer 2

Although it is not in the documentation, mysqli::connect() is a method, and you can use it to "reconnect" your object -appears to just be an alias for the constructor.

<?php
$host = '127.0.0.1';
$user = 'user';
$pass = 'pass';
$name = 'storage';

$mysqli = new mysqli($host, $user, $pass, $name);
// Do stuff...
$mysqli->close();
// Later on...
$mysqli->connect($host, $user, $pass, $name);