新浪sae+mysql操作.docVIP

?php /** * wechat php test */ //define your token define(TOKEN, weixin); $wechatObj = new wechatCallbackapiTest(); $wechatObj-responseMsg(); class wechatCallbackapiTest { public function valid() { $echoStr = $_GET[echostr]; //valid signature , option if($this-checkSignature()){ echo $echoStr; exit; } } public function responseMsg() { //get post data, May be due to the different environments $postStr = $GLOBALS[HTTP_RAW_POST_DATA]; //extract post data if (!empty($postStr)){ $postObj = simplexml_load_string($postStr, SimpleXMLElement, LIBXML_NOCDATA); $fromUsername = $postObj-FromUserName; $toUsername = $postObj-ToUserName; $keyword = trim($postObj-Content); $time = time(); $textTpl = xml ToUserName![CDATA[%s]]/ToUserName FromUserName![CDATA[%s]]/FromUserName CreateTime%s/CreateTime MsgType![CDATA[%s]]/MsgType Content![CDATA[%s]]/Content FuncFlag0/FuncFlag /xml; if(!empty( $keyword )) { $msgType = text; /* * SAE_MYSQL_USER:用户名 * SAE_MYSQL_PASS：密码： * SAE_MYSQL_HOST_M：主库域名 * SAE_MYSQL_HOST_S：从库域名 * SAE_MYSQL_PORT：端口： * SAE_MYSQL_DB数据库名 * * 详细说明：页面的编码要和数据库的编码一样，不然会出现乱码 * 或者在连接数据库时设置mysql_set_charset() * */ $link = mysql_connect ( SAE_MYSQL_HOST_M . : . SAE_MYSQL_PORT, SAE_MYSQL_USER, SAE_MYSQL_PASS ); if ($link) { mysql_select_db ( SAE_MYSQL_DB, $link ); mysql_set_charset(gbk); $sql = SELECT * FROM `UserInfo` WHERE `name`=.iconv(UTF-8,GBK,$fromUsername). LIMIT 0 , 30;