René Marscheider: class FOO extends BAR

Beitrag lesen

Hi,

zwei Klassen wie kann ich von der Kind-Klasse auf die Vater-Klasse zugreifen. Ich erhalte bei meinen Versuchen diese Fehlermeldung:

-----
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in E:\projekt\page\classen\db_class.php on line 49
-----

class datenbank
{
 var $dbhost;
 var $dbuser;
 var $dbpass;
 var $dbname;
 var $conn;

function db_error($text)
 {
  $num = mysql_errno();
  $msg = mysql_error();

require($_SERVER['DOCUMENT_ROOT'] . '/classen/db_error.php');

echo $error_text;
  exit();
 }

function db_conn()
 {
  $this->conn = @mysql_connect($this->dbhost, $this->dbuser, $this->dbpass);
  if(!$this->conn) $this->db_error('Verbindungsfehler');

$this->sele = @mysql_select_db($this->dbname, $this->conn);
  if(!$this->sele) $this->db_error('Datenbankfehler');

return $this->conn;
 }

function db_query($query)
 {
  $this->result = @mysql_query($query, $this->conn);
  if(!$this->result) $this->db_error('Queryfehler');

return $this->result;
 }

function db_unbuffered_query($query)
 {
  $this->result = @mysql_unbuffered_query($query, $this->conn);
  return $this->result;
 }

function db_fetch_row($result)
 {
  $this->fetch_row = mysql_fetch_row($result);
  return $this->fetch_row;
 }

......

}

$db = new datenbank;

$db->dbhost = DB_HOST;
$db->dbuser = DB_USER;
$db->dbpass = DB_PASS;
$db->dbname = DB_NAME;

$db->db_conn();

/**********/

class user_delete extends datenbank
{
 var $zeit  = 0;
 var $user  = 0;
 var $dtemp = array();

function user()
 {
  $delete = 'SELECT id, reg\_time, activ FROM user';
  $result = parent::db_unbuffered_query($delete);

while($rows = parent::db_fetch_row($result))
  {
   if(($rows[1] + ($this->user * 86400)) < $this->zeit && $rows[2] == 0)
   {
    array_push($this->dtemp, $rows[0]);
   }
  }

if(sizeof($this->dtemp) > 0)
  {
   $del_query = 'DELETE FROM user WHERE id IN (' . implode(',', $this->dtemp) . ')';
   $opt_query = 'OPTIMIZE TABLE user';
   parent::db_query($del_query);
   parent::db_query($opt_query);
  }
 }
}

$del_user = new user_delete;

$del_user->zeit = $zeit;
$del_user->user = $del_user;

$del_user->user();