php微信公众号开发之答题连闯三关

本文实例为大家分享了php微信公众号开发之答题闯关的具体代码，供大家参考，具体内容如下

连闯三关

核心代码如下：

 public function responmsg() {  //get post data, may be due to the different environments  $poststr = $globals["http_raw_post_data"];  //extract post data  if (!empty($poststr)){    $postobj = simplexml_load_string($poststr, 'simplexmlelement', lib注册外贸公司xml_nocdata);    $fromurname = $postobj->fromurname;    $tourname = $postobj->tourname;    $type = $postobj->msgtype;    $customevent = $postobj->event;    $latitude = $postobj->location_x;    $longitude = $postobj->location_y;    $keyword = trim($postobj->content);    $time = time();    $texttpl = "<xml>        <tourname><![cdata[%s]]></tourname>        <fromurname><![cdata[%s]]></fromurname>        <createtime>%s</createtime>        <msgtype><![cdata[%s]]></msgtype>        <content>%s</content>        <funcflag>0</funcflag>       </xml>";     include("coon.php");       $array=array("河北"=>"石家庄","山西"=>"太原","广东"=>"广州","黑龙江"=>"哈尔滨","广西"=>"南宁","浙江"=>"杭州","江苏"=>"南京","山东"=>"济南","河南"=>"郑州");    if($keyword=="8")    {     $a=array_rand($array,3);     $contentstr="第一题".$a[0]."省会是哪里？";     $a=implode(",",$a);      $sql="lect * from `menu2` where `ur`= '{$fromurname}'";     $query=mysql_query($sql);     $rm=mysql_fetch_array($query);      $ur=$rm['ur'];     if (empty($ur))     {      $sql="inrt into `menu经典英语句子2` (`id` ,`ur` ,`c`,`answer`,`num`)values (null , '{$fromurname}', '8','{$a}','0')";      mysql_query($sql);     }      el     {      $sql="update `menu2` t `c`='8',`answer`='{$a}', `num`='0' where `ur`= '{$fromurname}'";      mysql_query($sql);     }    }    el    {     $sql="lect * from `menu2` where `ur`= '{$fromurname}'";     $query=mysql_query($sql);     $rm=mysql_fetch_array($query);     $c=$rm['c'];     $answer=$rm['answer'];     $answer=explode(",",$answer);     $num=$rm['num'];       if($c=="8")     {      if($num=="0")      {       if($keyword==$array[$answer[0]])       {        $contentstr="恭喜你，答对了。\n第二题".$answer[1]."省会是哪里？";        $sql="update `menu2` t `num`='1' where `ur`= '{$fromurname}'";        mysql_query($sql);       }       el       {        $contentstr="很遗憾，你错了，重新来玩吧。";        $sql="update `menu2` t `c`='' where `ur`= '{$fromurname}'";        mysql_query($sql);       }      }       elif($num=="1")      {       if($keyword==$array[$answer[1]])       {        $contentstr="恭喜你，答对了。\n第三题".$answer[2]."省会是哪里？";        $sql="update `menu2` t `num`='2' where `ur`= '{$fromurname}'";        mysql_query($sql);       }       el       {        $contentstr="很遗憾，再努力一把，重新来玩吧。";        $sql="update `menu2` t `c`='' where `ur`= '{$fromurname}'";        mysql_query($sql);       }      }      elif($num=="2")      {       if($keyword==$array[$answer[2]]){       $contentstr="恭喜你，连闯三关！";       $sql="update `menu2` t `c`='' where `ur`= '{$fromurname}'";       mysql_query($sql);      }      el      {       $contentstr="很遗憾，就差一步，重新来玩吧。";       $sql="update `menu2` t `c`='' where `ur`= '{$fromurname}'";       mysql_query($sql);      }     }    }     el     {     $contentstr="请先输入8";    }   }   $msgtype="text";   $resultstr = sprintf($texttpl, $fromurname, $tourname, $time, $msgtype, $contentstr);   echo $resultstr;  } }

menu2.sql 数据库代码如下：

-- phpmyadmin sql dump-- version 3.3.8.1-- http://www.phpmyadmin.net---- 主机: w.rdc.sae.sina.com.cn:3307-- 生成日期: 2018 年 08 月 26 日 14:10-- 服务器版本: 5.6.23-- php 版本: 5.3.3t sql_mode="no_auto_value_on_zero";/*!40101 t @old_character_t_client=@@character_t_client */;/*!40101 t @old_character_t_results=@@character_t_results */;/*!40101 t @old_collation_connection=@@collation_connection */;/*!40101 t names utf8 */;---- 数据库: `app_dq095`---- ------------------------------------------------------------ 表的结构 `menu2`--create table if not exists `menu2` ( `id` int(3) not null auto_increment, `ur` varchar(255) not null, `c` int(1) not null, `answer` varchar(10) not null, `n对男朋友说的暖心的话um` int(4) not null, primary key (`id`)) engine=innodb default chart=utf8 auto_increment=3 ;---- 转存表中的数据 `menu2`--inrt into `menu2` (`id`, `ur`, `c`, `answer`, `num`) values(1, 'ood-ow-c8zigaihscjn54pawpu2g', 8, '广东,江苏,山东', 1),(2, 'ood-ow-c8zigaihscjn54pawpu2g', 8, '广东,江苏,山东', 1);

coon.php 连接数据库代码如下：

<?php  //用 户 名 : $ur  //密　　码 : $pwd  //主库域名 : $host  //从库域名 : sae_mysql_host_s  //端　　口 : $port  //数据库名 : $dbname  $dbname = "app_dq095";  $host = "w.rdc.sae.sina.com.cn";  $port = "3306";  $ur = "4k514n103z";  $pwd = "2402314li2j1i5im1xy2xizj5y332w2x41k2z203";  /*接着调用mysql_connect()连接服务器*/  // 连主库  $db = mysql_connect($host,$ur,$pwd);  if(!$db){   die("connect rver failed: " . mysql_error($db));  }  /*连接成功后立即调用mysql_lect_db()选中需要连接的数据库*/  if (!mysql_lect_db($dbname)) {   die("lect databa failed: " . mysql_error($db));  }  mysql_query("t names utf-8",$db);  /*至此连接已完全建立，就可对当前数据库进行相应的操作了*/  /*！！！注意，无法再通过本次连接调用mysql_lect_db来切换到其它数据库了！！！*/  /* 需要再连接其它数据库，请再使用mysql_connect+mysql_lect_db启动另一个连接*/  /**    * 接下来就可以使用其它标准php mysql函数操作进行数据库操作  */

index.php整体代码如下：

<?php/** * wechat php test *///define your tokendefine("token", "weixin");$wechatobj = new wechatcallbackapitest();$wechatobj->responmsg();class wechatcallbackapitest{ public function valid() {  $echostr = $_get["echostr"];  //valid signature , option  if($this->checksignature()){   echo $echostr;   exit;  } } public function responmsg() {  //get post data, may be due to the different environments  $poststr = $globals["http_raw_post_data"];  //extract post data  if (!empty($poststr)){    $postobj = simplexml_load_string($poststr, 'simplexmlelement', libxml_nocdata);    $fromurname = $postobj->fromurname;    $tourname = $postobj->tourname;    $type = $postobj->msgtype;    $customevent = $postobj->event;    $latitude = $postobj->location_x;    $longitude = $postobj->location_y;    $keyword = trim($postobj->content);    $time = time();    $texttpl = "<xml>        <tourname><![cdata[%s]]></tourname>        <fromurname><![cdata[%s]]></fromurname>        <createtime>%s</createtime>        <msgtype><![cdata[%s]]></msgtype>        <content>%s</content>        <funcflag>0</funcflag>       </xml>";     include("coon.php");       $array=array("河北"=>"石家庄","山西"=>"太原","广东"=>"广州","黑龙江"=>"哈尔滨","广西"=>"南宁","浙江"=>"杭州","江苏"=>"南京","山东"=>ertong;"济南","河南"=>"郑州");    if($keyword=="8")    {     $a=array_rand($array,3);     $contentstr="第一题".$a[0]."省会是哪里？";     $a=implode(",",$a);      $sql="lect * from `menu2` where `ur`= '{$fromurname}'";     $query=mysql_query($sql);     $rm=mysql_fetch_array($query);      $ur=$rm['ur'];     if (empty($ur))     {      $sql="inrt into `menu2` (`id` ,`ur` ,`c`,`answer`,`num`)values (null , '{$fromurname}', '8','{$a}','0')";      mysql_query($sql);     }      el     {      $sql="update `menu2` t `c`='8',`answer`='{$a}', `num`='0' where `ur`= '{$fromurname}'";      mysql_query($sql);     }    }    el    {     $sql="lect * from `menu2` where `ur`= '{$fromurname}'";     $query=mysql_query($sql);     $rm=mysql_fetch_array($query);     $c=$rm['c'];     $answer=$rm['answer'];     $answer=explode(",",$answer);     $num=$rm['num'];       if($c=="8")     {      if($num=="0")      {       if($keyword==$array[$answer[0]])       {        $contentstr="恭喜你，答对了。\n第二题".$answer[1]."省会是哪里？";        $sql="update `menu2` t `num`='1' where `ur`= '{$fromurname}'";        mysql_query($sql);       }       el       {        $contentstr="很遗憾，你错了，重新来玩吧。";        $sql="update `menu2` t `c`='' where `ur`= '{$fromurname}'";        mysql_query($sql);       }      }       elif($num=="1")      {       if($keyword==$array[$answer[1]])       {        $contentstr="恭喜你，答对了。\n第三题".$answer[2]."省会是哪里？";        $sql="update `menu2` t `num`='2' where `ur`= '{$fromurname}'";        mysql_query($sql);       }       el       {        $contentstr="很遗憾，再努力一把，重新来玩吧。";        $sql="update `menu2` t `c`='' where `ur`= '{$fromurname}'";        mysql_query($sql);       }      }      elif($num=="2")      {       if($keyword==$array[$answer[2]]){       $contentstr="恭喜你，连闯三关！";       $sql="update `menu2` t `c`='' where `ur`= '{$fromurname}'";       mysql_query($sql);      }      el      {       $contentstr="很遗憾，就差一步，重新来玩吧。";       $sql="update `menu2` t `c`='' where `ur`= '{$fromurname}'";       mysql_query($sql);      }     }    }     el     {     $contentstr="请先输入8";    }   }   $msgtype="text";   $resultstr = sprintf($texttpl, $fromurname, $tourname, $time, $msgtype, $contentstr);   echo $resultstr;  } } private function checksignature() {  $signature = $_ge摇晃的椅子t["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;  }el{   return fal;  } }}?>

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持www.887551.com。