php微信接口
程序员文章站
2024-02-03 14:33:22
...
$contentStr =$view_sql.$view[Title];
这句话可以返回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 = ""; 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; } } } ?> %s 0
回复讨论(解决方案)
没有人支持一下呢,这个问题困扰我很长时间了
还是没有人回复,真是可怜
没怎么看懂,你是说$view[Title]没有值吗
是的,我也搞不清楚了,很简单的东西,SQL语句查询,查询后自动回复。弄的我都死了
我基本找到问题了,可能我的MYSQL是GBK的编码,而微信是UTF8编码的
这样就造成查询不出数据