PHP从MySQL数据库读出数据用在微信大众号上

程序员文章站 2023-12-28 11:18:16

...

PHP从MySQL数据库读出数据用在微信公众号上

本帖最后由 u014294325 于 2015-06-19 09:51:33 编辑做微信公众平台在php页面从数据库中读取数据，用在微信公众平台的关注自动回复上
求指教怎么做


public function handleEvent($postObj)
	{

		 //header('Content-type:text/html;charset=utf-8');                                 //定义输出格式编码为utf-8
   $db = new mysqli('127.0.0.1','root','123','weixin');                               //建立mysql数据库连接
   $_ROWS = $db->query('SELECT * FROM event_subscribe');                          //用sql语句获取数据
   //mysql_query("set names utf8");//设置编码utf8
   while($_ROW = $_ROWS->fetch_assoc())
        //$title= $_ROW->ess_Title;
    	//$Description= $_ROW->ess_Description;
    	//$PicUrl= $_ROW->ess_PictureUrl;
    	//$Url= $row->ess_Url;  

        $title= $_ROW['ess_Title'];
    	$Description= $_ROW['ess_Description'];
    	$PicUrl= $_ROW['ess_PictureUrl'];
    	$Url= $row['ess_Url'];  
		//$contentStr = "欢迎关注哟";  
		$fromUsername = $postObj->FromUserName;
		$toUsername = $postObj->ToUserName;
		$msgType = "news";  
		$time = time();
		$textTpl = "


%s

1









1
";

		$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time,$title,$Description,$PicUrl,$Url);
        echo $resultStr;

------解决思路----------------------
新的代码


public function handleEvent($postObj)
    {

   //header('Content-type:text/html;charset=utf-8');                                 //定义输出格式编码为utf-8
   $db = new mysqli('127.0.0.1','root','123','weixin');                               //建立mysql数据库连接
   $db->query("SET NAMES utf8");//防止乱码
   $_ROWS = $db->query('SELECT * FROM event_subscribe where IsPublic=1');                          //用sql语句获取数据
   $_ROW = mysqli_fetch_assoc($_ROWS);
      $textTpl = "


%s

1









1
";

        $resultStr = sprintf($textTpl, $postObj->FromUserName, $postObj->ToUserName, time(),$_ROW['ess_Title'],$_ROW['ess_Description'],$_ROW['ess_PictureUrl'],$_ROW['ess_Url']);

        return $resultStr;
    }