热搜:NVER node 开发 php

php微信接口

2024-09-07 16:55:02
php微信接口

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