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