Code:
public function handleEvent($postObj)
{
//header('Content-type:text/html;charset=utf-8'); //定义输出格式编码为utf-8
$db = new mysqli('127.0.0.1','root','123','weixin'); //建立mysql数据库连接
$db->query("SET NAMES utf8");//防止乱码
$_ROWS = $db->query('SELECT * FROM event_subscribe where IsPublic=1'); //用sql语句获取数据
$_ROW = mysqli_fetch_assoc($_ROWS);
$textTpl = "<xml>
<ToUserName><![CDATA[%s]]></ToUserName>
<FromUserName><![CDATA[%s]]></FromUserName>
<CreateTime>%s</CreateTime>
<MsgType><![CDATA[news]]></MsgType>
<ArticleCount>1</ArticleCount>
<Articles>
<item>
<Title><![CDATA[%s]]></Title>
<Description><![CDATA[%s]]></Description>
<PicUrl><![CDATA[%s]]></PicUrl>
<Url><![CDATA[%s]]></Url>
</item>
</Articles>
<FuncFlag>1</FuncFlag>
</xml>";
$resultStr = sprintf($textTpl, $postObj->FromUserName, $postObj->ToUserName, time(),$_ROW['ess_Title'],$_ROW['ess_Description'],$_ROW['ess_PictureUrl'],$_ROW['ess_Url']);
return $resultStr;
}