Mangler kontakt mellem PhpMyAdminMy DB og PHP

Kode 

class database
{
	
private $connectlink;	//Database Connection Link
private $username = "root";
private $password = "";
private $database = "databasenavn";
private $hostname = "localhost";
private $resultlink;	//Database Result Recordset link
public $rows;		//Stores the rows for the resultset
public $count;		//Stores the row count for the requested table

	function __construct()
	{
		$this->connectlink = mysql_connect($this->hostname,$this->username,$this->password);
		if(!($this->connectlink))
		{
			//throw new DatabaseConnectionException("Error Connecting to the Database".mysql_error(),"101");
		}
		else
		{
			mysql_select_db($this->database);
		}	
	}
	
	function __destruct()
	{
		@mysql_close($this->connectlink);
	}
	
	public function query($sql)
	{
		$this->resultlink = mysql_query($sql);
		return $this->resultlink;
	}
 
	public function fetch_rows($sql)
	{
		$result = $this->query($sql);
		$rows = array();
		if($result)
		{
			while($row = mysql_fetch_array($result))
			{
				$rows[] = $row;
			}
		}
		else
		{
			//throw new RetrieveRecordsException("Error Retrieving Records".mysql_error(),"102");
			$rows = null;
		}
		$this->rows = $rows;
		return $this->rows;
	}	
	
	public function count_rows($sql)
	{
		$count = $this->query($sql);
		
		while ($row_count = mysql_fetch_array($count))
		{
			$count_row = $row_count;
			$this->count_row = $count_row;
			return $this->count_row;
		}
	}
}
?>

Kode 

<?php
require_once('STIEN TIL DATABASECLASS.php');

$db = new database();
?>

Kode 

$db->fetch_rows("SELECT ID, Username FROM usertable") or die(mysql_error());

$variabel = $db->rows[0][ID]  // array der henter første entry i row "ID"
echo $variabel;

Kode 

$db->fetch_rows("SELECT ID, Username, COUNT(ID) FROM usertable") or die(mysql_error());

while ($i = 1; $rows[0]['COUNT(ID)'] >= $i; i++)
{
	$login_Output[$i][0] = $rows[$i-1]['ID'];
	$login_Output[$i][1] = $rows[$i-1]['Username'];
}

echo $login_Output[3][0];
echo $login_Output[3][1];

Kode 

$db->fetch_rows("SELECT ID, Username, COUNT(ID) FROM usertable") or die(mysql_error());

while ($i = 1; $rows[0]['COUNT(ID)'] >= $i; i++)
{
	$login_Output[$i][0] = $rows[$i-1]['ID'];
	$login_Output[$i][1] = $rows[$i-1]['Username'];

	echo $login_Output[$i][0];
	echo $login_Output[$i][1];
}

Kode 

$link = mysql_connect("localhost","username","password");
mysql_select_db("databasenavn", $link);

Kode 

<?php

//Flere

mysql_connect("localhost", "root", "");
mysql_select_db("databoxme");

$query = mysql_query("Select * FROM phonebook");

while($row = mysql_fetch_array($query))
{
	echo $row['ID'];
}
?>

<?php

//Enkel

mysql_connect("localhost", "root", "");
mysql_select_db("databoxme");

$query = mysql_query("Select * FROM phonebook");
$row = mysql_fetch_array($query);

echo $row['ID'];
?>

Kode 

$forbindelse = mysql_connect("localhost", "root", "") or die("Forbindelsesfejl:" . mysql_error());
mysql_select_db("blog", $forbindelse) or die("Databasevalgsfejl:" . mysql_error());