function update_mes($sender, $getter)
{
$sqlHelper = new sqlHelper();
$sql = "update message set mes_received = 1 where sender= '{$getter}' and getter = '{$sender}'";
$res = $sqlHelper->execute_dml($sql);
return $res;
}
function addMessage($sender, $receiver, $content)
{
$sql = "insert into message (sender,receiver,content,sendTime) values('{$sender}','{$receiver}','{$content}',now())";
file_put_contents("F:/GitHub/Ajax-Practice/mylog2.log", $sql . "\r\n", FILE_APPEND);
$sqlHelper = new sqlHelper();
$sqlHelper->execute_dml($sql);
}
public function del_emp_by_id($id)
{
$sqlHelper = new sqlHelper();
$sql = "delete from emp where id=" . $id;
return $sqlHelper->execute_dml($sql);
}
public function dql_update_emp($id, $name, $grade, $email, $salary)
{
$sql = "update emp set name='{$name}',grade={$grade},email='{$email}',salary={$salary} where id =" . $id;
$sqlHelper = new sqlHelper();
return $sqlHelper->execute_dml($sql);
}
