Model\Message::getMessageById PHP Method

getMessageById() public static method

Get message by id
public static getMessageById ( $id ) : mixed
$id
return mixed
    public static function getMessageById($id)
    {
        $stn = DB::getInstance()->prepare("SELECT * FROM message WHERE id=?");
        $stn->bindValue(1, $id, DB::PARAM_INT);
        $stn->execute();
        return $stn->fetchObject(__CLASS__);
    }

Usage Example

Beispiel #1
0
 /**
  * 查询
  * @JSON
  */
 public function query()
 {
     $result = array('error' => 1, 'message' => 'Request failed');
     $result['message_id'] = $_GET['message_id'];
     if ($_GET['message_id'] != null) {
         $rs = MessageModel::getMessageById(trim($_GET['message_id']));
         $rs->pushTime = date('Y-m-d H:i:s', $rs->pushTime);
         $rs->pushEndTime = date('Y-m-d H:i:s', $rs->pushEndTime);
         $rs->content = Utils::br2nl($rs->content);
         if ($rs) {
             $result = array('error' => 0, 'message' => 'success', 'modal' => $rs);
         }
     }
     return $result;
 }