RE: [PHP-DB] MySQL Connection Class

Jas, I can't know whether or not that's right for you. It all depends on what you need to do.. If you only have one database connection with one userid/pass combination, then yes it might be the solution you are looking for. But if you want to be able to reuse your code for different types of databases, userids, then you can write a class with different functions and variables to do so. For example you can something like class myDBConnClass { var $user; var $pass; var $host; var $database; function setUser($username) { $this -> user = $username; } function setPass($password) { $this -> pass = $password; } function setHost($hostname) { $this -> host = $hostname) } function setDatabasename($databasename) { $this -> database= $databasename; } function mySQLconn($username, $password, $hostname, $databasename) { mysql_pconnect("$username", "$password", "$hostname"); mysql_select_db($databasename); } function mySQL() { mysql_pconnect("($this -> host).", ".($this -> user).", ".($this -> pass)." ); mysql_select_db($this -> database); } . . . . } // end of class myDBConnClass Say you have saved this into myDBConnClass.php .. Then in your php pages you would first require this file with require("myDBConnClass.php"); statement, and then you would create another class extending this or just an instance of this class (depending upon what you actually have in your class and pages. Keep in mind that this is a very primitive and kind of useless class.. You can always have more properties of the class and more functions.. If you prefer you can hardcode the login, databasename info to the class and call the connection fucntions without arguments, or you can set the variables of the class and use it so, you can also have more functions to connect to the different databases (PostGreSQL, Oracle, etc.) . Does this help??? Gurhan -----Original Message----- From: jas [mailto:jlgerfen@hotmail.com] Sent: Wednesday, January 30, 2002 12:33 AM To: php-db@lists.php.net Subject: Re: [PHP-DB] MySQL Connection Class So all I would need to do is create a file named db_connection.php3 and put in the functions $db = mysql_connection("localhost","username","password") or die("could not connect"); and then put an include statement on the top of each page that needs the db connectiong? Please correct me if I am wrong, I have never really used class files for my own scripts before. Thanks again. "Gurhan Ozen" <c-gurhan.ozen@wcom.com> wrote in message news:NEBBJFKICMBBMAOHJDFOKEPOCLAA.c-gurhan.ozen@wcom.com... > Are you trying to write classes to connect to the database using PHP's > native DB connection functions?? If yes, you should only check those > database functions' tutorials and just use them inside your class.. > > Gurhan > > > -----Original Message----- > From: jas [mailto:jlgerfen@hotmail.com] > Sent: Wednesday, January 30, 2002 12:09 AM > To: php-db@lists.php.net > Subject: [PHP-DB] MySQL Connection Class > > > I know this may seem a little vague but I would like to know where a good > tutorial on creating database connection class files would be. I have been > looking and as of yet I have not found one that deals specifically with this > question. Thanks in advance. > Jas > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net