<?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}'";
