Får feilmelding på tilkobling (oop)

[Thomas.]

 

 <?php
error_reporting(E_ALL);


 class ActiveRelationalRecord

 {

	 private $db_pk	  = null;


	 /**
	  * EKS: addRelation('brukere', 'nick', 'admin');
	  * ==== select * from brukere where nick = admin
	  */
	 function addRelation($table,$fk='',$pk='', $felt)
	 {
		 $fk = strlen($fk)>0 ? $fk : $this->db_pk;
		 $pk = strlen($fk)>0 ? $pk : $this->db_pk;

		 $rs = mysql_query('select * from ' . $table . ' where ' . $fk . ' = '. $pk . '');				
		 echo $rs;
		 while($row = mysql_fetch_array($rs)) {
			 echo $row[$felt];
		 }

	 }

 }


 class MAL {

		 private $host		= 'x';
		 private $user		= 'x';
		 private $password	= 'x';
		 private $database	= 'x';

		 function __construct($host='',$user='',$password='',$database='')
		 {
			 $this->host = $host;
			 $this->user = $user;
			 $this->password = $password;
			 $this->database = $database;
		 }

		 function execute($sql)
		 {
			 mysql_connect($this->host,$this->user,$this->password); 
				mysql_select_db($this->database);
		 }

 }

 $dal =  new MAL('localhost','root','','test');	
 $am = new ActiveRelationalRecord();


 $am->addRelation('brukere','nick','admin', 'nick');

?>

 

 

 

Jeg får feilmeldingene:

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\wamp\www\mafiasosVER2\data\sql\sql.php on line 22

 

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\wamp\www\mafiasosVER2\data\sql\sql.php on line 22

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\mafiasosVER2\data\sql\sql.php on line 24

 

 

Håper på hjelp

[AlecTBM]

Du har ikke tilkoblet databasen via MAL

Mulig løsning:

Bytt ut

$rs = mysql_query('select * from ' . $table . ' where ' . $fk . ' = '. $pk . '');

med

$rs = MAL::execute('select * from ' . $table . ' where ' . $fk . ' = '. $pk . '');

 

Hvilken php versjon kjører du?

 

Beklager, litt trøtt

du må også endre litt i execute

			 function execute($sql)
		 {
			 mysql_connect($this->host,$this->user,$this->password);
				mysql_select_db($this->database);
			 return mysql_query($sql);
		 }

 

Eller så legger du database tilkoblinga i __construct() istedet for å kjøre en til funksjon

Endret 27. februar 2009 av AlecTBM