当前位置:Gxlcms > PHP教程 > php微信接口

php微信接口

时间:2021-07-01 10:21:17 帮助过:58人阅读

$contentStr =$view_sql.$view[Title];
这句话可以返回SQL语句,但是为什么不能讲数据查询出来呢。$view[Title];


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 = "                                       %s                                       0             ";             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编码的
这样就造成查询不出数据

人气教程排行