[RESOLVED] Class Help

[iNFERiON]

Hi all,

I'm trying to learn how classes work, they seem useful 🙂
I am trying to create a class to handle all my database actions, so I can handle all database stuff with simple commands like $DB->connect(); and such.

I have create a class called DB and am trying to set some constants (the SQL info). The first function I am creating is just a test function to see if the connection to the database is made properly, however it won't parse. This is my code:

// Database class
class DB {
	// Get database info and set as constants
	const sqlhost = 'localhost';
	const sqluser = 'root';
	const sqlpass = 'topsecret';
	const sqldb = 'testdb';

function connecttest() {
	$sql = mysql_connect($sqlhost,$sqluser,$sqlpass) or die('Unable to connect to MySQL server.');
	mysql_select_db($sqldb) or die('Unable to select database.');
	$this->result = echo "Connection Succesful !";
	mysql_close($sql);
	return $this->result;
}
}

I get this parsing error:

parse error, unexpected T_CONST, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}'

Why is the const unexpected ? I get the same error when I copy/paste exactly this sample code from php.net:

class MyClass
{
   const constant = 'constant value';

   function showConstant() {
       echo  self::constant . "\n";
   }
}

echo MyClass::constant . "\n";

$class = new MyClass();
$class->showConstant();

Is it something with my server configuration ? I really don't understand.

[m_tt]

    var $sqlhost = 'localhost'; 
    var $sqluser = 'root'; 
    var $sqlpass = 'topsecret'; 
    var $sqldb = 'testdb'; 

[iNFERiON]

That doesn't work either, but I already figured out why, turns out that the class handling has changed since PHP5 and my server runs PHP4, so gotta find an older manual.

[iNFERiON]

Found out more about PHP4 classes, this is my properly working class with query execution function:

//Database class
class Database {
	// Define SQL settings
	var $sql = array(host=>"localhost",user=>"root",pass=>"topsecret",db=>"testdb");

function query($query) {
	// Conect to MySQL Server
	$conn = mysql_connect($this->sql[host],$this->sql[user],$this->sql[pass]) or die('Unable to connect to MySQL server.');
	// Select database
	mysql_select_db($this->sql[db]) or die('Unable to select database.');
	// Run the query
	$runquery = mysql_query($query) or die('Unable to execute query:<br>' . mysql_error() . '');
	// Get the results
	$result = mysql_fetch_assoc($runquery);
	// Close the database connection
	mysql_close($conn);
	// Return the result and end the function
	return $result;
}
}
// End of Class

// Test function to test query function
function testquery() {
	// Initiate class Database as $DB
	$DB = new Database();
	// Set the query to be run
	$qry = $DB->query("SELECT `text` FROM `test`");
	// Output results
	echo $qry['text'];
}

Hope this will help other people that are stuck with classes.