Static variable help ..

[nefarious986]

Ok, I am a little confused here, maybe you guys can clear it up.

 

What I am trying to do is create a db abstraction class that allows EACH user ONE db connection. 

 

How I was planning to go about this is to create ONE connection to the db, then store it in a static variable of Connection class.  Then, the class would not create any more connections if the static variable was a resource object.  Singleton pattern basically.

 

BUT .. I m not too sure about static variables.  Would ALL instances of that class share that value ?  In another word, would ALL users on my sites be sharing the SAME connection if I used a static variable to store the connection object ? 

 

Any thoughts guys?  Kinda hard to test for multiple connections since I am one developer.  LOL.

[trq]

BUT .. I m not too sure about static variables.  Would ALL instances of that class share that value ?  In another word, would ALL users on my sites be sharing the SAME connection if I used a static variable to store the connection object ?

 

No. Each user (request) would get there own single connection resource.