function addMessage($con) { $sql = "insert into chat (sender,getter, content,sendTime) values('Admin','Guest','{$con}',now())"; $sqlhelper = new SQLHelper(); $sqlhelper->execute_dml($sql); $sqlhelper->close_connect(); }
function getMessage() { // if (Session::has('email')) { $sql = "select * from chat where sent=0 and sender='Guest'"; // }else{ // $sql = "select * from chat where sent=0 and sender='Admin'"; // } //file_put_contents("C:/Users/bij0520/Documents/chatlog.log",$sql."/r/n",FILE_APPEND); $sqlhelper = new SQLHelper(); $array = $sqlhelper->execute_dql($sql); $messageInfo = "<mes>"; for ($i = 0; $i < count($array); $i++) { $row = $array[$i]; $messageInfo .= "<mesid>{$row['id']}</mesid><sender>{$row['sender']}</sender>\n\n<getter>{$row['getter']}</getter><con>{$row['content']}</con>\n\n<sendTime>{$row['sendTime']}</sendTime>"; } $messageInfo .= "</mes>"; // if (Session::has('email')) { $sql = "update chat set sent=1 where sender='Guest'"; // }else{ // $sql = "update chat set sent=1 where sender='Admin'"; // } $sqlhelper->execute_dml($sql); //file_put_contents("C:/Users/bij0520/Documents/chatlog.log",$messageInfo."/r/n",FILE_APPEND); return $messageInfo; $sqlhelper->close_connect(); }
function addMessage($con) { if (isset($_SESSION['email'])) { $sql = "insert into chat (sender,getter, content,sendTime) values('Admin','Guest','{$con}',now())"; file_put_contents("C:/Users/bij0520/Documents/chatlog.log", $_SESSION['email'] . "/r/n", FILE_APPEND); } else { $sql = "insert into chat (sender,getter, content,sendTime) values('Guest','Admin','{$con}',now())"; file_put_contents("C:/Users/bij0520/Documents/chatlog.log", $sql . "/r/n", FILE_APPEND); } $sqlhelper = new SQLHelper(); $sqlhelper->execute_dml($sql); $sqlhelper->close_connect(); }
function getMessage() { $sql = "select * from chat where sent=0"; $sqlhelper = new SQLHelper(); $array = $sqlhelper->execute_dql($sql); $messageInfo = "<mes>"; for ($i = 0; $i < count($array); $i++) { $row = $array[$i]; $messageInfo .= "<mesid>{$row['id']}</mesid><sender>{$row['sender']}</sender>\n\n<getter>{$row['getter']}</getter><con>{$row['content']}</con>\n\n<sendTime>{$row['sendTime']}</sendTime>"; } $messageInfo .= "</mes>"; file_put_contents("chatlog.log", $messageInfo . "/r/n", FILE_APPEND); $sql = "update chat set sent=1"; $sqlhelper->execute_dml($sql); return $messageInfo; $sqlhelper->close_connect(); }