database connection class

[sunilvadranapu]

Hi,

  I want to write a class for database connection to mySQL. could any one help in sharing their ideas:

  my class is like this:

 

  variables:

 

Host                DB servername

Database          DB name

User                  DB username

Password          DB password

Connection_id    holds the connection state(fail/success)

Errno 

ErrorString

 

Functions:

ConnectDB ();     

queryDB();

fetchResult();

totRows();

conClose();

 

am i need to add any more methods

 

[sunilvadranapu]

 

is this desing for databse connection class is OK? or am i need to do any modifications to my desing?

 

if any one already desinged and using any Database class, please share with me.

 

-thanks in advance

[fenway]

Aren't there literally tens of such classes around?

[sunilvadranapu]

i could not figure it out. could you list them? or pls give me the link where i can find the stuff

 

thanks

[fenway]

i could not figure it out. could you list them? or pls give me the link where i can find the stuff

 

thanks

I've never worked with such things... perhaps someone else can chime in?