PHP SQLHelper::execute_dml 예제들

예제 #1

파일: sendMessage-admin.php 프로젝트: bij0520/TourONTO-contact

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

예제 #2

파일: getMessage-admin.php 프로젝트: bij0520/TourONTO-contact

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

예제 #3

파일: sendMessage.php 프로젝트: bij0520/TourONTO-contact

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

예제 #4

파일: getMessage.php 프로젝트: hilmysyarif/sic

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