php db class with mysqli, which support multiple connections

Question

The thing is that I need to write a db class with mysqli and it should support multiple connections to different databases. I know that multiple connections is bad, but I don't have any other choice.

If there is any good example of class which supports multiple connections?

Do you know any tips that I should take into consideration when I will start writing the class? What is the best practice in my case?

Thanks in advance,

You could have a look at stackoverflow.com/questions/1384191/… and stackoverflow.com/questions/274892/… to get a first idea. — Quasdunk
– Quasdunk, Commented Aug 3, 2011 at 17:08
Why 'multiple connections is bad'? What other way to connect to two ro more servers or use asynchronous queries? — Mchl
– Mchl, Commented Aug 3, 2011 at 17:45
@Quasdunk thanks, I already looked over this topic and other which I found on the StackOverflow. — kaha
– kaha, Commented Aug 3, 2011 at 18:49
@Mchi, because I read it and heard couple of times it is better to have all your tables in one database, rather than having them in different databases — kaha
– kaha, Commented Aug 3, 2011 at 18:51
@user616822: This is not true. Sure, as far as a single application is concerned, usually having just one database is best. However sometimes you just need to work with several databases sitting on different servers (often running different database systems). Multiple connections is bad can also mean something different. In PHP application, you usually should create just one connection per database used i.e. don't create a new connection before each query - reuse existing connection) — Mchl
– Mchl, Commented Aug 3, 2011 at 19:14

Mchl · Accepted Answer · 2011-08-03 18:08:31Z

2

First thing that comes to mind, is a container class, that stores MySQLi object in it. Something like this:

class MySQLiContainer extends SplObjectStorage{
  public function newConnection($host = null, $username = null, $passwd = null, $dbname = null, $port = null, $socket = null) {
    $mysqli = new mysqli($host, $username, $passwd, $dbname, $port, $socket);
    $this->attach($mysqli);
    return $mysqli;
  }
}

//usage

$mysqliContainer = new MySQLiContainer();

$c1 = $mysqliContainer->newConnection('localhost','root','root','localDatabase');
$c1->query('SELECT ....');

$c2 = $mysqliContainer->newConnection('mysql.remotehost.net','hackermom','bobbytables','schoolDatabase');

$name = 'Robert\'); DROP TABLE students;--';

$c2->multi_query("SELECT * FROM students WHERE name = '$name'");

Without knowing more about functionality required, it's hard to say if this is a good idea though ;)

More info about SplObjectStorage class.

edited Aug 3, 2011 at 18:08

answered Aug 3, 2011 at 17:52

Mchl

62.4k9 gold badges121 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

kaha Over a year ago

@Mchi, Thank you very much, I looked over your code. It is pretty clear. Not sure exactly what functionality is needed. I'm currently reading about mysqli. If I will have any questions related to this I will write it here.

Mchl Over a year ago

You should probably ask a new question with more detail. If not, remember you can edit your question. Don't add any new information in comments ;)

Collectives™ on Stack Overflow

php db class with mysqli, which support multiple connections

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related