<?php require "../../../db.php"; require "../../../weixin.class.php"; require "../control/class.php"; $ret = wxcommon::getToken(); $ACCESS_TOKEN = $ret['access_token']; $wxuser = new wxuser($ACCESS_TOKEN); $status_string = "失败"; $flag = false; $message = null; $name = $_GET['name']; $oid = $_GET['oid']; $id = $_GET['id']; $sql = mysql_query("select * from kaosheng_baoming WHERE name='" . $name . "' AND last='" . $id . "' ORDER BY aid DESC LIMIT 1 ", $dbh); $sqlRs = mysql_fetch_assoc($sql); if ($sqlRs != null) { $status_string = "成功"; $flag = true; $message = "检索到您的以下报名信息:<br>姓名:" . $sqlRs["name"] . "<br>报名号:" . $sqlRs["aid"] . "<br>来源:" . $sqlRs["src"] . "<br>填报时间:" . $sqlRs["time"]; $wxuser->moveTo($oid, "109"); $name = $sqlRs["name"]; mysql_query("update mapping set Name='" . $name . "' where OpenId='" . $oid . "'", $dbh); $json = '{"foo":"' . $name . '"}'; $d = json_decode($json, true); $wxuser->setName($oid, $d['foo']); } else { $status_string = "失败"; $flag = false; $message = "未能查询到您的报名信息:您可能输入了错误的姓名或身份证号后六位或我们的数据库尚未更新<br>上次更新时间为:2016年3月3日13:00"; }
<?php require "../../db.php"; require "../../weixin.class.php"; $ret = wxcommon::getToken(); $ACCESS_TOKEN = $ret['access_token']; $wxuser = new wxuser($ACCESS_TOKEN); $status_string = "失败"; $flag = false; $message = null; $name = $_GET['name']; $type = $_GET['type']; $code = $_GET['code']; $stuid = $_GET['stuid']; if ($code == null) { $code = $stuid; } $oid = $_GET['oid']; mysql_query("update mapping set Name='" . $name . "' where OpenId='" . $oid . "'", $dbh); $json = '{"foo":"' . $name . '"}'; $d = json_decode($json, true); $wxuser->setName($oid, $d['foo']); $inst = substr($code, 5, 5); $sql = mysql_query("select * from inst where code=" . $inst, $dbh); $sqlRs = mysql_fetch_assoc($sql); if ($sqlRs == null) { if ($code == "OPTADMIN" && $type == "opt_admin") { mysql_query("update mapping set Pos='opt_admin' where OpenId='" . $oid . "'", $dbh); $message = "老师您好~感谢您使用微西光公众平台~ 如需要帮助可致电18813186628联系李同学。"; $status_string = "成功"; $wxuser->moveTo($oid, "100");