PHP SQLHelper示例

示例#1

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

示例#2

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

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

示例#5

文件： Apply.class.php 项目： banketree/lemon-grass

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

示例#6

文件： SQLHelper.class.php 项目： banketree/lemon-grass

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

示例#7

文件： DBPgsqlFunctions.php 项目： byjg/anydataset

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