database connection inside a class

[olaf]

Hallo,
i want to use the this vars and php-function inside a class:

$conn_str = mysql_pconnect($hostname, $username, $password) or die(mysql_error());

where do i have to place this, inside a function or just inside the class?

and where do i set the "mysql_select_db" command?

[Weedpacket]

Depends on what you want to do with the class. Is the class supposed to handle its own connection (in which case database-specific functionality like connection would be inside the class), or are you going to create a connection and set an object's "$connection" property to contain the connection resource? Either is feasible.

[olaf]

Hallo Weedpacket,

after posting this thread i searched a little bit more and noticed that people do it different.

Maybe its better to tell what i want to do inside the class.

I use the database several times while executing a script, first check if a recpord already exist, if not create a new one and after this (in both cases) show a result . I want to connect and select to the databse only ones.

[olaf]

Hallo,

i tried something and it works a little...

	function db_connect() {
		$this->db = mysql_pconnect($this->hostname, $this->db_user, $this->db_password);
		mysql_select_db($this->database);
	}

Now i can use the variable "db" inside diff. methods.

Now i like to use a default value for the hostname. Where can i place them?