<?php require_once "globalData.php"; $globalData = new GlobalData(); $conn = new mysqli($globalData->getMysqlHost(), $globalData->getMysqlUsername(), $globalData->getMysqlPassword(), $globalData->getMysqlDatabase()); function getTeacherInformation($openId, $conn) { $jsonArray = array(); //1,获取个人基本信息 $query = "set names utf8"; $result = $conn->query($query); $query = "select * from T_teacher where openId = '{$openId}'"; $result = $conn->query($query); $row = $result->fetch_assoc(); $jsonArray = $row; $jsonArray["options"] = array("name" => array(), "code" => array(), "typeCode" => array()); $jsonArray["certificate"] = array("desc" => array(), "imgUrl" => array()); //2,获取可教科目 $query = "set names utf8"; $result = $conn->query($query); $query = "select name,code,typeCode from T_offers where teacherOpenId = '{$openId}' and status != 'D'"; $result = $conn->query($query); while ($row = $result->fetch_assoc()) { array_push($jsonArray["options"]["name"], $row["name"]); array_push($jsonArray["options"]["code"], $row["code"]); array_push($jsonArray["options"]["typeCode"], $row["typeCode"]); } //3,获取证书 $query = "set names utf8"; $result = $conn->query($query); $query = "select description, imageUrl from T_teacher_certifications where teacherOpenId = '{$openId}'";