Sorry, I deleted some text I guess...
> I'm struggling with the best way to best way to pass around a database
> handle to storage classes, and I'm not sure what the best way to do it is.
>
> Let's say I have a class like this (grossly oversimplified one) --
> ideally I could call these as static methods, but it's not a requirement:
>
> class Users {
>
> public function SetUser(User $user) {
>
> // Inserts a user into the database
> $sql = "Some SQL Goes Here";
>
> $result = $DB->query($sql);
> $DB::ifError($result) {
> die(DB::getError($result));
> }
> return true;
> }
>
> What's the best way to make my database object ($DB) available to the
> methods?
>
> I could setup the connection in the constructor, but I have storage classes
> for several data objects, many of which get instantiated
> simultaneously. I don't want to take the performance hit of making seven
> separate database connections.
>
> I could setup the connection in a global config file, and pass it as an
> argument to the constructor.
>
> This is what I've been doing, but it adds a lot of "bootstrapping" work
> to the client code, and prevents me from just doing User::set($user); in
> the client code, which would be so much nicer.
>
> class User {
>
> private $DB;
>
> function _constructor(DB $DB) {
> $this->DB = $DB;
> }
>
> public function SetUser(User $user) {
>
> // Inserts a user into the database
> $sql = "Some SQL Goes Here";
>
> $result = $this->DB->query($sql);
> $this->DB::ifError($result) {
> die($this->DB::getError($result));
> }
> return true;
> }
> }
>
> I could make the handle a superglobal, but I'm afraid that it limits my
> options, should I need to swap it out for a connection pool later.
> Maybe it doesn't -- just wondering if anyone has a good solution.
>
> Thanks,
> Jeromie
>
>
> The php_mysql group is dedicated to learn more about the PHP/MySQL web
> database possibilities through group learning.
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
The php_mysql group is dedicated to learn more about the PHP/MySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
