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) { $sql = "insert into chat (sender,getter, content,sendTime) values('Admin','Guest','{$con}',now())"; $sqlhelper = new SQLHelper(); $sqlhelper->execute_dml($sql); $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(); }
public function update($attr, $id) { $DB = $this->get_write_pdo(); $attr['handle_time'] = date('Y-m-d H:i:s'); return \SQLHelper::update($DB, self::$TABLE, $attr, $id); }
public static function insert_update_multi(PDO $DB, $table, $attr, $return_row_count = true) { $sql = self::create_insert_update_multi_sql($table, array_keys($attr[0]), count($attr)); $params = Utils::array_flatten($attr); $state = $DB->prepare($sql); $result = $state->execute($params); self::$info = $state->errorInfo(); return $result && $return_row_count ? $state->rowCount() : $result; }
function executeAndGetInsertedId($dbdataset, $sql, $param, $sequence = null) { $id = parent::executeAndGetInsertedId($dbdataset, $sql, $param); $it = $dbdataset->getIterator(SQLHelper::createSafeSQL("select currval(':sequence') id", array(':sequence' => $sequence))); if ($it->hasNext()) { $sr = $it->moveNext(); $id = $sr->getField("id"); } return $id; }