OO mysqli

[johnsmith153]

I am using mysqli, OO, to connect to MySQL.

 

I have only today started looking at this and am used to:

<?php
$con = mysql_connect();//etc
mysql_close($connection);
?>

 

Am I right that with mysqli (OO) that I don't need to set a connection variable wither when connecting or closing??

<?php
mysqli::connect();//etc
mysqli::close();
?>

 

What about with multiple databases, does mysqli keep track for me, as I am used to this:

<?php
$con1 = mysql_connect();//db1
$con2 = mysql_connect();//db2
?>
//etc

[Mchl]

When you use OO interface of mysqli you do

$connection = new mysqli(..);

 

so with more connections you do

$connection1 = new mysqli(...);
$connection2 = new mysqli(...);

 

where $connection1 and $connection2 are MySQLi objects, that 'know' which connection to use.

 

[johnsmith153]

Would this do the same?

 

class myMySQLiAccess extends mysqli {

  //connect
  mysqli::connect();//etc

}

$con1 = new myMySQLiAccess();
$con2 = new myMySQLiAccess();

 

 

---

 

 

And would this be how I close them (based on my example)?

 

$con1->mysqli::close();
$con2->mysqli::close();
$con3->mysqli::close();

[Mchl]

Would this do the same?

 

Not really. More like this:

 

class myMySQLiAccess extends mysqli {

  public function __construct($host = null, $username = null, $passwd = null, $dbname = null, $port = null, $socket = null) {
    parent::__construct($host, $username, $passwd, $dbname, $port, $socket);
  }
}

 

if you want to hardcode your access credentials (not really a good idea) it would look like this

 

class myMySQLiAccess extends mysqli {

  public function __construct($host = null, $username = null, $passwd = null, $dbname = null, $port = null, $socket = null) {
    parent::__construct('localhost', 'root', 'password', 'mydatabase');
  }
}

$con = new myMySQLiAccess();

 

closing is done like this

$con->close();

 

but in most cases you can safely let PHP close the connection for you (it does it automatically when script ends, or when the scope of $con is destroyed)

[johnsmith153]

Thanks for all your help - I'm there I think !