微信通过数据库创建菜单

-->

$velocityCount -->

-->

1. [文件] menuCreate.php

<?php /** * 微信公众平台-自定义菜单功能开发源代码 * ================================ * Copy 2013-2014 David Tang * //m.sbmmt.com/ * ================================ * Author: * 个人微信：mchina_tang * 公众微信：博士伦订阅号菜单 * Date:2013-08-25 */ header('Content-Type: text/html; charset=UTF-8'); $APPID="######"; $APPSECRET="######"; /////$TOKEN_URL="https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid=wx34c6e7c75afa2749&secret=88388ddeb5b9f523f562cb161699912c"; $TOKEN_URL="https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid=".$APPID."&secret=".$APPSECRET; $json=file_get_contents($TOKEN_URL); $result=json_decode($json,true); $ACC_TOKEN= $result['access_token']; require_once("wx-config.php"); $sql="select MsgType,Content,Location,KeyWords from menumsg order by Location"; $result = mysql_query($sql,$dbh); $menuArray = array(); while($row = mysql_fetch_array($result)){ $menuArray[$row["Location"]][0]= $row["KeyWords"]; $menuArray[$row["Location"]][1]= $row["MsgType"]; $menuArray[$row["Location"]][2]= $row["Content"]; } $data='{ "button":[ { "name":"'.$menuArray[1][0].'", "sub_button":['; if(!empty($menuArray[11][0])){ if($menuArray[11][1]=='click'){ $data .=' { "type":"'.$menuArray[11][1].'", "name":"'.$menuArray[11][0].'", "key":"V1001_Product011" },'; }else{ $data .=' { "view":"'.$menuArray[11][1].'", "name":"'.$menuArray[11][0].'", "url":"'.$menuArray[11][2].'" },'; } } if(!empty($menuArray[12][0])){ if($menuArray[12][1]=='click'){ $data.=' { "type":"'.$menuArray[12][1].'", "name":"'.$menuArray[12][0].'", "key":"V1001_Product012" },'; }else{ $data .=' { "view":"'.$menuArray[12][1].'", "name":"'.$menuArray[12][0].'", "url":"'.$menuArray[12][2].'" },'; } } if(!empty($menuArray[13][0])){ if($menuArray[13][1]=='click'){ $data .=' { "type":"'.$menuArray[13][1].'", "name":"'.$menuArray[13][0].'", "key":"V1001_Product013" },'; }else{ $data .=' { "view":"'.$menuArray[13][1].'", "name":"'.$menuArray[13][0].'", "url":"'.$menuArray[13][2].'" },'; } } if(!empty($menuArray[14][0])){ if($menuArray[14][1]=='click'){ $data .=' { "type":"'.$menuArray[14][1].'", "name":"'.$menuArray[14][0].'", "key":"V1001_Product014" },'; }else{ $data .=' { "view":"'.$menuArray[14][1].'", "name":"'.$menuArray[14][0].'", "url":"'.$menuArray[14][2].'" },'; } } if(!empty($menuArray[15][0])){ if($menuArray[15][1]=='click'){ $data .=' { "type":"'.$menuArray[15][1].'", "name":"'.$menuArray[15][0].'", "key":"V1001_Product015" }'; }else{ $data .=' { "view":"'.$menuArray[15][1].'", "name":"'.$menuArray[15][0].'", "url":"'.$menuArray[15][2].'" },'; } } $data .='] }, { "name":"'.$menuArray[2][0].'", "sub_button":[ '; if(!empty($menuArray[21][0])){ if($menuArray[21][1]=='click'){ $data .=' { "type":"'.$menuArray[21][1].'", "name":"'.$menuArray[21][0].'", "key":"V1001_Personal021" },'; }else{ $data .=' { "view":"'.$menuArray[21][1].'", "name":"'.$menuArray[21][0].'", "url":"'.$menuArray[21][2].'" },'; } } if(!empty($menuArray[22][0])){ if($menuArray[22][1]=='click'){ $data .=' { "type":"'.$menuArray[22][1].'", "name":"'.$menuArray[22][0].'", "key":"V1001_Personal022" },'; }else{ $data .=' { "view":"'.$menuArray[22][1].'", "name":"'.$menuArray[22][0].'", "url":"'.$menuArray[22][2].'" },'; } } if(!empty($menuArray[23][0])){ if($menuArray[23][1]=='click'){ $data .=' { "type":"'.$menuArray[23][1].'", "name":"'.$menuArray[23][0].'", "key":"V1001_Personal023" },'; }else{ $data .=' { "view":"'.$menuArray[23][1].'", "name":"'.$menuArray[23][0].'", "url":"'.$menuArray[23][2].'" },'; } } if(!empty($menuArray[24][0])){ if($menuArray[24][1]=='click'){ $data .=' { "type":"'.$menuArray[24][1].'", "name":"'.$menuArray[24][0].'", "key":"V1001_Personal024" },'; }else{ $data .=' { "view":"'.$menuArray[24][1].'", "name":"'.$menuArray[24][0].'", "url":"'.$menuArray[24][2].'" },'; } } if(!empty($menuArray[25][0])){ if($menuArray[25][1]=='click'){ $data .=' { "type":"'.$menuArray[25][1].'", "name":"'.$menuArray[25][0].'", "key":"V1001_Personal025" }'; }else{ $data .=' { "view":"'.$menuArray[25][1].'", "name":"'.$menuArray[25][0].'", "url":"'.$menuArray[25][2].'" }'; } } $data .='] }, { "name":"'.$menuArray[3][0].'", "sub_button":['; if(!empty($menuArray[31][0])){ if($menuArray[31][1]=='click'){ $data .=' { "type":"'.$menuArray[31][1].'", "name":"'.$menuArray[31][0].'", "key":"V1001_Activity031" },'; }else{ $data .=' { "view":"'.$menuArray[31][1].'", "name":"'.$menuArray[31][0].'", "url":"'.$menuArray[31][2].'" }'; } } if(!empty($menuArray[32][0])){ if($menuArray[32][1]=='click'){ $data .=' { "type":"'.$menuArray[32][1].'", "name":"'.$menuArray[32][0].'", "key":"V1001_Activity032" },'; }else{ $data .=' { "view":"'.$menuArray[32][1].'", "name":"'.$menuArray[32][0].'", "url":"'.$menuArray[32][2].'" }'; } } if(!empty($menuArray[33][0])){ if($menuArray[33][1]=='click'){ $data .=' { "type":"'.$menuArray[33][1].'", "name":"'.$menuArray[33][0].'", "key":"V1001_Activity033" },'; }else{ $data .=' { "view":"'.$menuArray[33][1].'", "name":"'.$menuArray[33][0].'", "url":"'.$menuArray[33][2].'" }'; } } if(!empty($menuArray[34][0])){ if($menuArray[34][1]=='click'){ $data .=' { "type":"'.$menuArray[34][1].'", "name":"'.$menuArray[34][0].'", "key":"V1001_Activity034" },'; }else{ $data .=' { "view":"'.$menuArray[34][1].'", "name":"'.$menuArray[34][0].'", "url":"'.$menuArray[34][2].'" }'; } } if(!empty($menuArray[35][0])){ if($menuArray[35][1]=='click'){ $data .=' { "type":"'.$menuArray[35][1].'", "name":"'.$menuArray[35][0].'", "key":"V1001_Activity035" }'; }else{ $data .=' { "view":"'.$menuArray[35][1].'", "name":"'.$menuArray[35][0].'", "url":"'.$menuArray[35][2].'" }'; } } $data .=' ] }] }'; //echo " "; //echo $data; ///echo " "; $MENU_URL= "https://api.weixin.qq.com/cgi-bin/menu/create?access_token=".$ACC_TOKEN; $ch = curl_init($MENU_URL); curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST"); curl_setopt($ch, CURLOPT_POSTFIELDS, $data); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/json','Content-Length:'.strlen($data))); $info = curl_exec($ch); //创建成功返回：{"errcode":0,"errmsg":"ok"} $menu = json_decode($info); var_dump($menu); /* if($menu->errmsg == "ok"){ echo "菜单创建成功"; }else{ echo "菜单创建失败"; } */ ?>

微信通过数据库创建菜单

Related articles