PHP [Commands out of sync; you can't run this command now] on new mysqli();

Question

I have created a class in PHP to handle most of the work dealing with the MySQL database. Here is a code example:

class DataAccessBase
{
protected $sql_wr;
protected $sql_ro;

function __construct()
{
    $this->sql_wr = new mysqli();
    $this->sql_ro = new mysqli();

    $this->sql_wr->ssl_set(DB_WR_SSLKEY, DB_WR_SSLCERT, DB_WR_SSLCA, NULL, NULL);
    $this->sql_ro->ssl_set(DB_RO_SSLKEY, DB_RO_SSLCERT, DB_RO_SSLCA, NULL, NULL);
}

When the constructor runs, I get "Commands out of sync..." error on the new mysqli();. Both of them.
All of the searching I have done discusses incorrect code trying to do multiple queries. I get the error before I even open the connection.
What am I missing?
I have tried using the mysqli_init() also and it returns the same error.

Do you really have no parameters in the `new mysqli()` [See manual](http://php.net/manual/en/mysqli.construct.php) — RiggsFolly, Jun 02 '17 at 14:24
Probably Duplicate of https://stackoverflow.com/questions/3657765/php-to-mysql-ssl-connections — RiggsFolly, Jun 02 '17 at 14:30
I read thru the article, thank you for the link. I have the server setup properly. I can connect to it using ssl from within PHPStorm, Visual Studio, and MySQL Workbench. — Bill Soranno, Jun 02 '17 at 14:35

score 0 · Answer 1 · answered Jun 02 '17 at 14:56

0

I change my code to add the parameters to the mysqli() call.

$this->sql_wr = new mysqli(DB_WR_HOST, DB_WR_USER, DB_WR_PASS, DBNAME);

I no longer get the error on the new.
I now have other errors, but I will open a new question if needed.

answered Jun 02 '17 at 14:56

Bill Soranno

63
1
1
6

PHP [Commands out of sync; you can't run this command now] on new mysqli();

1 Answers1