Yes it does, thanks... now that I have a better understanding of classes now I just need to write one. Thanks again. jas "Gurhan Ozen" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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:[EMAIL PROTECTED]] > Sent: Wednesday, January 30, 2002 12:33 AM > To: [EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > 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:[EMAIL PROTECTED]] > > Sent: Wednesday, January 30, 2002 12:09 AM > > To: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] >
Advertising
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
