i am tring to extend from DataAccess to Module... but is showing an error:
location: Library/database.php
<?php
Class DatabaseAccess
{
public $db;
public $sqlQuery;
public function ConnectDB($host,$user,$password,$database){
$this->db = mysqli_connect($host,"",$password);
if (mysqli_connect_errno()) {
echo '<p>Cannot connect to DB: ' . mysqli_connect_error() . '</p>';
}
$this->db &= mysqli_select_db($this->db,$database);
}
public function SqlQuery($sql)
{
return mysqli_query($this->db,$sql);//or die("Error:".mysqli_error()."<br />The Query:<b>$sql</b>");
}
}
?>
The Module class
Location:Library/module.php
<?php
Class Module extends DatabaseAccess
{
public function DoInsert($tableName,$fields = array(),$values = array())//delete from table
{
$fields = implode(",", $fields);
$values = implode("','", $values);
return $this->db->SqlQuery ("INSERT INTO $tableName($fields) VALUES('$values')");//The error is here!!!!!!!!!!!!!!!!
}
}
?>
and the controller file name:
newProfile.php
this is the cdode
include "config.php";
include "Library/database.php";
include "Library/module.php";
$db = new DatabaseAccess;
$db->ConnectDB(MYSQL_HOST_NAME,MYSQL_USER_NAME,MYSQL_PASSWORD,MYSQL_DATABASE);//define in config.php
$db->Module = New Module;
$db->Module->DoInsert("twitter_profiles",
array(profile_user_name,profile_password,user_id),
array($_POST['userName'],$_POST['password'],$userID));//DoInsert(tableName,Fields,Values)
echo sysMessage("NewProfile.txt");
the error:
Fatal error: /home/omerbsh/blalalala.com/tra/Library/module.php on line 59
the error is in the modle class where the comment: "The error is here!!!!!!!!!!!!!!!!"
its cant to fine SqlQuery object but why???
thanks