PHP SQLHelper::execute_dql Beispiele

Beispiel #1

Datei: getMessage-admin.php Projekt: 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();
}

Beispiel #2

Datei: getMessage.php Projekt: 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();
}