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();