PHP class problemer
Hej eksperter jeg har 4 filer, og tror det er min extends den er gal med!:index.php
connection.cls.php
query.cls.php
user.cls.php
index.php, includer_once user.cls.php
connectiion.cls.php, laver database forbindelsen
query.cls.php, laver selve forspørgelserne til databasen, og extender fra Connection
user.cls.php, mit ikke færdige login system, som extender fra Query
Fejlen jeg modtager: Fatal error: Call to undefined method User::noConnection() in cls/query.cls.php on line 8
index.php --------------------------------------------------------
<?PHP
error_reporting(~0);
include_once("cls/user.cls.php");
$userObj = new User();
if($_SERVER['REMOTE_ADDR'] == "83.73.249.171") {
if(isset($_POST['sub_login'])) {
$userObj->userLogin($_POST['user'], $_POST['pass']);
} else {
?>
<form action="" method="post">
<table width="100%" cellpadding="0" cellspacing="0">
<tr>
<td align="left" valign="top"> </td>
<td colspan="2" align="left" valign="top" style="height: 25px;">Cookies skal være sat til for at kunne logge ind.</td>
</tr>
<tr>
<td align="right" valign="top">Brugernavn:</td>
<td align="right" valign="top"> </td>
<td align="left" valign="top"><input type="text" name="user" value="Brugernavn" onFocus="if(this.value=='Brugernavn') { this.value = ''; }" onblur="if(this.value=='') { this.value = 'Brugernavn'; }" /></td>
</tr>
<tr>
<td align="right" valign="top">Kodeord:</td>
<td align="right" valign="top"> </td>
<td align="left" valign="top"><input type="password" name="pass" value="Kodeord" onFocus="if(this.value=='Kodeord') { this.value = ''; }" onblur="if(this.value=='') { this.value = 'Kodeord'; }" /></td>
</tr>
<tr>
<td colspan="2" align="right" valign="top"> </td>
<td align="left" valign="top"><input type="submit" name="sub_login" value="Login" /></td>
</tr>
</table>
</form>
<?PHP
}
}
?>
connection.cls.php -----------------------------------------------
<?PHP
class Connetion {
protected $host = "********";
protected $user = "********";
protected $password = "********";
protected $database = "********";
protected $dbhandler;
protected $db2handler;
protected $show_errors = true;
function __construct() {
$msg = "";
$mysql_connect = mysql_connect($this->host, $this->user, $this->password);
if(!$mysql_connect) {
$msg .= "<span class=\"errorMsg\">Cannot connect to the database. ".mysql_error()."</span>";
} else {
$mysql_select_db = mysql_select_db($this->database, $mysql_connect);
}
if(!$mysql_select_db) {
$msg .= "<br /><span class=\"errorMsg\">Cannot selected the database. ".mysql_error()."</span>";
}
if(!$mysql_connect || !$mysql_select_db) {
$this->noConnection($msg);
}
$this->dbhandler = $mysql_connect;
$this->db2handler = $mysql_select_db;
return;
} // ends the function __construct
public function noConnection($error) {
/*if($this->show_errors)
$error = "<br />\n<b>".$error."</b>";
else
$error = "";
*/
exit("<span style=\"font-family: Verdana; font-size: 10px; color: #FF0000;\">Server opgraderes, dette kan tage op til 15 minutter!".stripslashes($error)."</span>");
} // end the function noConnection
function __destruct() {
@mysql_close($this->dbhandler);
} // ends the function __destruct
} // ens the class connection
?>
query.cls.php ----------------------------------------------------
<?PHP
include_once("connection.cls.php");
class Query extends Connetion {
public function returnSQL($sql) {
if(!(strstr(strtoupper($sql), "INSERT") || strstr(strtoupper($sql), "DELETE") || strstr(strtoupper($sql), "UPDATE"))) {
// ONLY SELECT STATESMENT IS ILLEGAL!
$query = @mysql_query($sql, $this->dbhandler) or Die($this->noConnection(mysql_error()));;
//if(!$query)
//$this->noConnection("There is an error with this sql string. String is: ".$sql."<br />\n".mysql_error());
$lines = array();
while ($row = mysql_fetch_assoc($query)) {
$lines[] = $row;
}
return $lines;
} else {
$this->noConnection("Illegal sql commando : NO ".substr($sql, 0, 6)."!<br />\n".$sql);
}
} // end the function returnSQL
public function execSQL($sql) {
if(!strstr(strtolower($sql), "SELECT")) {
$query = @mysql_query($sql, $this->dbhandler) OR $this->noConnection("There is an error with this sql string. String is: ".$sql."<br />\n".mysql_error());
if($query)
return true;
else
return false;
} else {
$this->noConnection("Illegal sql commando<br />\n".$sql);
}
}
} // end the class Query
?>
user.cls.php -----------------------------------------------------
<?PHP
include_once("query.cls.php");
class User extends Query {
protected $user;
protected $pass;
public function userLogin($user, $pass) {
if(strlen($user) > 0 && strlen($pass) > 0) {
$user = trim($user);
$pass = md5($pass);
$this->LogMeIn($user, $pass);
} else {
return false;
}
}
public function LogMeIn($user, $pass) {
$sql = "SELECT COUNT(*) as cnt FROM sn_user WHERE email = '".$user."' AND usr_pass = '".$pass."';";
$query = parent::returnSQL($sql);
if($query[0]['cnt'] == 1) {
//setcookie()
return "Velkommen";
} else {
return "fejl";
}
}
} // end class User
?>
