function handle()
{
$open_id = $this->user_id;
$mapper = new Student_infoMapper();
$rs = $mapper->select(new Student_infoDomain(array("open_id" => $open_id)));
if (!empty($rs)) {
$aes = new aes();
$aes->setKey('yiW7BPNI8ax0O39opkKCCFQS');
$student_id = $aes->decode($rs->get("student_id"));
$student_name = $aes->decode($rs->get("name"));
$class = substr($student_id, 0, strlen($student_id) - 2);
//数据库连接常量，修改此处
$dbname = 'afwdb';
$host = '55bcb9ddc1a3f.sh.cdb.myqcloud.com';
$port = '6055';
$dsn = "mysql:dbname={$dbname};host={$host};port={$port}";
$user = '******';
$password = '******';
$pdo = new PDO($dsn, $user, $password);
$pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->exec("set names utf8");
$response = "【期末考试自助查询】\n";
$response .= "姓名：" . $student_name . "\n";
$response .= "班级：" . $class . "\n";
$response .= "-----------------\n";
$stmt = $pdo->query("SELECT * FROM `examination_arrangement` WHERE `class`='" . $class . "'");
foreach ($stmt as $row) {
$response .= "课程名称：" . $row['course_name'] . "\n";
$response .= "任课教师：" . $row['teacher_name'] . "\n";
$response .= "考试时间：" . $row['time'] . "\n";
$response .= "考试地点：" . $row['class_room'] . "\n";
$response .= "-----------------\n";
}
$response .= "©njuptservice";
$this->response = new WechatTextResponse($response);
} else {
$this->response = new WechatTextResponse("【绑定信息】\n您尚未绑定请点击“i查询”菜单进入进行任意一功能绑定。");
}
}
<?php
require_once 'student_info.php';
require_once 'student_password.php';
require_once 'aes.php';
$open_id = $_GET['open_id'];
$mapper = new Student_infoMapper();
$rs = $mapper->select(new Student_infoDomain(array("open_id" => $open_id)));
if (!empty($rs)) {
$aes = new aes();
$aes->setKey('yiW7BPNI8ax0O39opkKCCFQS');
$student_id = $aes->decode($rs->get("student_id"));
$student_name = $aes->decode($rs->get("name"));
$class = substr($student_id, 0, strlen($student_id) - 2);
//数据库连接常量，修改此处
$dbname = 'afwdb';
$host = '55bcb9ddc1a3f.sh.cdb.myqcloud.com';
$port = '6055';
$dsn = "mysql:dbname={$dbname};host={$host};port={$port}";
$user = '******';
$password = '******';
$pdo = new PDO($dsn, $user, $password);
$pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->exec("set names utf8");
$response = "【期末考试自助查询】\n";
$response .= "姓名：" . $student_name . "\n";
$response .= "班级：" . $class . "\n";
$response .= "-----------------\n";
$stmt = $pdo->query("SELECT * FROM `examination_arrangement` WHERE `class`='" . $class . "'");
foreach ($stmt as $row) {
$this->_secret_key = $key;
}
public function encode($data)
{
$td = mcrypt_module_open(MCRYPT_RIJNDAEL_256, '', MCRYPT_MODE_CBC, '');
$iv = mcrypt_create_iv(mcrypt_enc_get_iv_size($td), MCRYPT_RAND);
mcrypt_generic_init($td, $this->_secret_key, $iv);
$encrypted = mcrypt_generic($td, $data);
mcrypt_generic_deinit($td);
return $iv . $encrypted;
}
public function decode($data)
{
$td = mcrypt_module_open(MCRYPT_RIJNDAEL_256, '', MCRYPT_MODE_CBC, '');
$iv = mb_substr($data, 0, 32, 'latin1');
mcrypt_generic_init($td, $this->_secret_key, $iv);
$data = mb_substr($data, 32, mb_strlen($data, 'latin1'), 'latin1');
$data = mdecrypt_generic($td, $data);
mcrypt_generic_deinit($td);
mcrypt_module_close($td);
return trim($data);
}
}
$aes = new aes();
$aes->setKey('key');
// 加密
$string = $aes->encode('string');
echo $string;
// 解密
$aes->decode($string);
echo $aes;