Help with classes

[miles_rich]

I am trying to get my head around coding classes, i have coded a basic class below that connects to mysql.

Is it any good?

Where else can i go with it?

<?php

/**
 *
 * This class is a basic mysql class.
 *
 **/
class MySQL
{
var $link;

	/**
	 *
	 * This function connects to mysql.
	 *
	 **/
	function connect($host, $user, $pass)
	{
		$this->link = mysql_connect($host, $user, $pass) or die ($this->mysql_error("Mysql: ".mysql_error()));
		return "1. Connected<br>";
	}

	/**
	 *
	 * This function selects the database to use.
	 *
	 **/
	function select($selected)
	{
		$this->link = mysql_select_db("$selected") or die ($this->mysql_error("Mysql: ".mysql_error()));
		return "2. Selected<br>";
	}

	/**
	 *
	 * This function display errors to the screen.
	 *
	 **/
	function mysql_error($error_message)
	{
		echo $error_message;
	}
}

$database = new MySQL;
echo $database->connect("localhost", "username", "password");
echo $database->select("db_test");
?>

[renaun]

Looks fine for a starter class.

You can try and make a DB abstraction out of it.

Take the class, and change the name to something Generic.

Then have a function (or do it in the constructor) that sets the Database you want to use.

Then in each function (like connect) make specific code for each Database.

// Would connect to Mysql
$dbConn = new DBAbstract('mysql');
$dbConn->connect($host, $user, $pass);

// Would connect to Oracle
$dbConn = new DBAbstract('oracle');
$dbConn->connect($host, $user, $pass);

There are many things you can do with classes. Have fun creating new them.