function add()
{
$select = new Sql_Select(new PWEL_SQL());
$select->from("accounts");
$add = new Sql_Add($select);
$add->addValues(array("ID" => 2, "username" => "hallo", "passwort" => "abc123"))->add();
}
/**
* delete line from database
* @return bool
*/
public function delete()
{
if (!preg_match("/(.*)WHERE(.*)/i", $this->generateQuery())) {
return false;
}
if ($this->selectClass->queryString($this->generateQuery()) == false) {
return false;
}
}
/**
* Update the database
* @return bool
*/
public function update()
{
if ($this->selectClass->queryString($this->generateQuery()) == false) {
return false;
}
}
/**
* Returns the account data from current user
*
* @param string $session
* @return resource/bool
*/
public function GetUserData($session)
{
$sql = new Sql_Select($this->connectorClass);
$result = $sql->from($this->table_name)->where(array($this->column_session => $session))->query();
return $result;
}