基于微信平台的学生公寓管理系统

基于微信平台的学生公寓管理系统组员：苏琳枫、陈海1.数据库2.代码<?php/*** wechat php test*///define your tokendefine("TOKEN", "yitian");$wechatObj = new wechatCallbackapiTest();$wechatObj->responseMsg();function sushe($a){if (!$a) //验证是否为空{$b="您输入的名字为空";return $b;}$dbname = 'app_cyluqi'; //数据库名称$host = getenv('SAE_MYSQL_HOST_M'); //主库域名$port = getenv('SAE_MYSQL_PORT'); //端口$user = getenv('SAE_MYSQL_USER'); //用户名$pwd = getenv('SAE_MYSQL_PASS'); //密码// 连主库$link=mysql_connect(SAE_MYSQL_HOST_M.':'.SAE_MYSQL_PORT,SAE_MYSQL_USER,SAE_MYSQL _PASS);// 连从库//$link=mysql_connect(SAE_MYSQL_HOST_S.':'.SAE_MYSQL_PORT,SAE_MYSQL_USER,SAE_MYSQL _PASS);if(!$link) {die("Connect Server Failed: " . mysql_error($link));}/*连接成功后立即调用mysql_select_db()选中需要连接的数据库*/if(!mysql_select_db($dbname,$link)){die("Select Database Failed: " . mysql_error($link));}mysql_query("set names GBK",$link);//通过sql语句查询$sql="SELECT * FROM `DepartmentManage` WHERE `Name`='" . iconv("UTF-8","GBK",$a) . "'";$query=mysql_query($sql);$rs=mysql_fetch_array($query);$n= $rs['Name'];$c= $rs['Class'];$d= $rs['Department'];$p= $rs['PhoneNum'];$bn= $rs['BedNum'];$w= $rs['WeixinNum'];$b="姓名：{$a}"."，专业班级：".iconv("GBK","UTF-8",$c)."，联系电话：".iconv("GBK","UTF-8",$p)."，宿舍号：".iconv("GBK","UTF-8",$d)."，床号：".iconv("GBK","UTF-8",$bn)."，微信号：".iconv("GBK","UTF-8",$w);if (empty($n)) $b="对不起,找不到该名字宿舍信息，请核对是否输入正确";return $b;mysql_close($link);}function chaxun($a){if (!$a) //验证是否为空{$b="您输入的名字为空";return $b;}$dbname = 'app_cyluqi'; //数据库名称$host = getenv('SAE_MYSQL_HOST_M'); //主库域名$port = getenv('SAE_MYSQL_PORT'); //端口$user = getenv('SAE_MYSQL_USER'); //用户名$pwd = getenv('SAE_MYSQL_PASS'); //密码// 连主库$link=mysql_connect(SAE_MYSQL_HOST_M.':'.SAE_MYSQL_PORT,SAE_MYSQL_USER,SAE_MYSQL _PASS);// 连从库//$link=mysql_connect(SAE_MYSQL_HOST_S.':'.SAE_MYSQL_PORT,SAE_MYSQL_USER,SAE_MYSQL _PASS);if(!$link) {die("Connect Server Failed: " . mysql_error($link));}/*连接成功后立即调用mysql_select_db()选中需要连接的数据库*/if(!mysql_select_db($dbname,$link)){die("Select Database Failed: " . mysql_error($link));}mysql_query("set names GBK",$link);//通过sql语句查询$sql="SELECT `SID` FROM `ccdgutSI` WHERE `Name`='" . iconv("UTF-8","GBK",$a) . "'";$query=mysql_query($sql);$rs=mysql_fetch_array($query);$c= $rs['SID'];$b="{$a}的学号为：".iconv("GBK","UTF-8",$c);if (empty($c)) $b="对不起,找不到该名字信息，请核对是否输入正确";return $b;mysql_close($link);}function huazhou($a){if (!$a) //验证是否为空{$b="您输入的名字为空";return $b;}$dbname = 'app_cyluqi'; //数据库名称$host = getenv('SAE_MYSQL_HOST_M'); //主库域名$port = getenv('SAE_MYSQL_PORT'); //端口$user = getenv('SAE_MYSQL_USER'); //用户名$pwd = getenv('SAE_MYSQL_PASS'); //密码// 连主库$link=mysql_connect(SAE_MYSQL_HOST_M.':'.SAE_MYSQL_PORT,SAE_MYSQL_USER,SAE_MYSQL _PASS);// 连从库//$link=mysql_connect(SAE_MYSQL_HOST_S.':'.SAE_MYSQL_PORT,SAE_MYSQL_USER,SAE_MYSQL _PASS);if(!$link) {die("Connect Server Failed: " . mysql_error($link));}/*连接成功后立即调用mysql_select_db()选中需要连接的数据库*/if(!mysql_select_db($dbname,$link)){die("Select Database Failed: " . mysql_error($link));}mysql_query("set names GBK",$link);//通过sql语句查询$sql="SELECT * FROM `huazhouSI` WHERE `name`='" . iconv("UTF-8","GBK",$a) . "'";$query=mysql_query($sql);$rs=mysql_fetch_array($query);$m= $rs['major'];$n= $rs['name'];$c= $rs['phone'];$d= $rs['sortphone'];$e= $rs['QQ'];$f= $rs['department'];$b="姓名：{$a}"."，专业班级：".iconv("GBK","UTF-8",$m)."，联系电话：".iconv("GBK","UTF-8",$c)."，短号：".iconv("GBK","UTF-8",$d)."，QQ：".iconv("GBK","UTF-8",$e)."，宿舍：".iconv("GBK","UTF-8",$f);if (empty($n)) $b="对不起,找不到该名字信息，请核对是否输入正确";return $b;mysql_close($link)3.效果。