$contentStr =$view_sql.$view[Title];
这句话可以返回SQL语句,但是为什么不能讲数据查询出来呢。$view[Title];
<?php include ("admin/install/config.php"); $conn=@mysql_connect($host,$user,$pass) or die ("数据连接错误"); mysql_select_db($database,$conn); mysql_query("set names 'GBK'"); define("TOKEN", "shiyudir1978"); define("MESS","输入点啥吧"); $wechatObj = new wechatCallbackapiTest(); //$wechatObj->valid(); $wechatObj->responseMsg(); class wechatCallbackapiTest { public function valid() { $echoStr = $_GET["echostr"]; if($this->checkSignature()){ echo $echoStr; exit; } } public function responseMsg() { $postStr = $GLOBALS["HTTP_RAW_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> <FuncFlag>0<FuncFlag> </xml>"; if(!empty( $keyword )) { $view_sql="select * from news where Title like '%$keyword%'"; $view=mysql_fetch_array(mysql_query($view_sql)); $msgType = "text"; $contentStr =$view_sql.$view[Title]; //$contentStr = $view[Title]; $resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr); echo $resultStr; }else{ echo MESS; } }else { echo MESS; exit; } } private function checkSignature() { $signature = $_GET["signature"]; $timestamp = $_GET["timestamp"]; $nonce = $_GET["nonce"]; $token =TOKEN; $tmpArr = array($token, $timestamp, $nonce); sort($tmpArr); $tmpStr = implode( $tmpArr ); $tmpStr = sha1( $tmpStr ); if( $tmpStr == $signature ){ return true; }else{ return false; } } } ?>
没有人支持一下呢,这个问题困扰我很长时间了
还是没有人回复,真是可怜
没怎么看懂,你是说$view[Title]没有值吗
是的,我也搞不清楚了,很简单的东西,SQL语句查询,查询后自动回复。弄的我都死了
我基本找到问题了,可能我的MYSQL是GBK的编码,而微信是UTF8编码的
这样就造成查询不出数据