function ShowDiff($group_id, $from, $to, &$summary) { $mysql = new SaeMysql(); $sql = "SELECT url FROM `url` WHERE `group_id`=" . $group_id; $urls = $mysql->getData( $sql ); $results = array(); for($i = 0; $i < sizeof($urls); ++$i) { $title = ""; $content_diff = ""; $sql_from = "SELECT content FROM `web_content` WHERE `url`='" . $urls[$i]['url'] . "' AND `date`='" . $from . "'"; $sql_to = "SELECT content FROM `web_content` WHERE `url`='" . $urls[$i]['url'] . "' AND `date`='" . $to . "'"; $content_from = $mysql->getVar( $sql_from ); $content_to = $mysql->getVar( $sql_to ); if (!$content_from || !$content_to) { array_attach($results, foutput('failed', $urls[$i]['url'], NULL, $summary)); } else { if ($content_from !== $content_to) { $content_diff = GetFormattedDiff($content_from, $content_to); if (is_string($content_diff)) { array_attach($results, foutput('changed', $urls[$i]['url'], $content_diff, $summary)); } else { array_attach($results, foutput('error', $urls[$i]['url'], NULL, $summary)); } } else { array_attach($results, foutput('identical', $urls[$i]['url'], NULL, $summary)); } } } $mysql->closeDb(); return $results; }
static function countPrinters() { $mysql = new SaeMysql(); $sql = "SELECT count(*) FROM `wx_printers`"; $data = $mysql->getVar($sql); return $data; }
static function getTaskImage($print_code) { $mysql = new SaeMysql(); $sql = "SELECT `image_url` FROM `wx_images` WHERE `print_code` = '{$print_code}'"; $data = $mysql->getVar($sql); $sql = "DELETE FROM `wx_images` WHERE `image_url` = '{$data}'"; $mysql->runSql($sql); $mysql->closeDb(); return $data; }
//用户以前是否关注过 $everFollowed = "select openid,name from wechat_user WHERE openid='{$event->FromUserName}'"; $user = $mysql->getLine($everFollowed); //用户第一次关注 if ($user === false) { $signup = "insert into wechat_user(openid,followTime) VALUES ('{$event->FromUserName}','" . date("Y/m/d-H:i:s") . "')"; $mysql->runSql($signup); sae_log("用户第一次关注"); $mysql->closeDb(); return Message::make('news')->items($welcome); } else { //MySQL如何修改现有的一行数据? //更新关注时间、关注状态,获取用户姓名 $update = "update wechat_user set followTime = '" . date("Y/m/d-H:i:s") . "',isFollow = 1 WHERE\n openid='{$event->FromUserName}' "; $mysql->runSql($update); $name = $mysql->getVar("select name from wechat_user WHERE openid = '{$event->FromUserName}'"); if (is_bool($name)) { $name = ""; sae_log("名字不存在" . $name); } $mysql->closeDb(); return Message::make('news')->items(function () use($name, $welcome) { return $welcome($name); }); } }); //取消关注 $server->on('event', 'unsubscribe', function ($event) { sae_log("用户取消关注: " . $event->openid); $mysql = new SaeMysql(); $signup = "update wechat_user set isFollow = 0, unfollowTime = '" . date("Y/m/d-H:i:s") . "'WHERE\n openid='{$event->FromUserName}'";
$action = $_GET["action"]; $action = string::un_script_code($action); $action = string::un_html($action); //是否删除 if ($action == "del") { //获取部门ID号传入 $class_id = intval($_GET["class_id"]); //获取当前时间 $nowtime = date("Y/m/d H:i:s", time()); $mysql->runSql("update class set status=0,edittime='{$nowtime}' where class_id={$class_id}"); echo "<script>alert('操作成功!');location='class_manager.php?page={$page}';</Script>"; exit; } //列表数据获取、分页 //计算总数 $count = $mysql->getVar("select COUNT(*) from class where status=1"); //如果数据表里有数据 if ($count) { //每页显示记录数 $page_num = 2; //如果无页码参数则为第一页 if ($page == 0) { $page = 1; } //计算开始的记录序号 $from_record = ($page - 1) * $page_num; //获取符合条件的数据 $class_list = $mysql->getData("select A.class_id,A.class_name,B.class_name as fclass_name\n from class A left join class B on A.class_fid=B.class_id where A.status=1 \n order by A.class_id desc \n limit {$from_record},{$page_num}"); //分页函数 $multi = multi($count, $page_num, $page, "class_manager.php"); }
<?php session_start(); //查询数据库,openid是否已经存在 //用SAEMySQL的getdata方法,如果结果为空,会返回false,但没有错误 $openid = $_GET['openid']; $_SESSION['openid'] = $openid; $mysql = new SaeMysql(); $query = "SELECT openid,name FROM wechat_user WHERE openid='{$openid}'"; //根据openid取出考号,以降序排列,默认查询考号最大的一次 $examid = "select examid from cet WHERE openid='{$openid}' ORDER BY examid DESC"; //从数组取出两个变量 $query = $mysql->getLine($query); $examid = $mysql->getVar($examid); //数据库保存的openid $openid_db = $query['openid']; $name = $query['name']; $_SESSION['examid'] = $examid; $_SESSION['name'] = $name; //var_dump($examid); //var_dump($mysql->getLine($query)); //var_dump($mysql->getVar($query)); //sae_log(json_encode($openid . "-" . $examid)); //用户尚未注册 if (empty($openid_db)) { $signup = "INSERT INTO wechat_user (openid) VALUES ('{$openid}') "; $bool = $mysql->runSql($signup); if (!$bool) { echo $debug = sprintf("注册失败 %d : %s", $mysql->errno(), $mysql->errmsg()); sae_log($debug); } else {
$action = $_GET["action"]; $action = string::un_script_code($action); $action = string::un_html($action); //是否删除 if ($action == "del") { //获取问题ID号传入 $question_id = intval($_GET["question_id"]); //获取当前时间 $nowtime = date("Y/m/d H:i:s", time()); $mysql->runSql("update question set status=0 where question_id={$question_id}"); echo "<script>alert('操作成功!');location='question_manager.php?page={$page}';</Script>"; exit; } //列表数据获取、分页 //计算总数 $count = $mysql->getVar("select COUNT(*) from question_tb where status=1"); //如果数据表里有数据 if ($count) { //每页显示记录数 $page_num = 10; //如果无页码参数则为第一页 if ($page == 0) { $page = 1; } //计算开始的记录序号 $from_record = ($page - 1) * $page_num; //获取符合条件的数据 $class_list = $mysql->getData("select *\n from question_tb \n order by question_id desc \n limit {$from_record},{$page_num}"); //分页函数 $multi = multi($count, $page_num, $page, "question_manager.php"); }
.H1{ font-size:23px;/*设置文字字号为12px*/ color:red; } </style> </head> <?php $mysql = new SaeMysql(); //团委 $sql = "select count(*) from `BasicInfo` where C_Department='11'"; $data11 = $mysql->getVar($sql); $sql = "select count(*) from `BasicInfo` where C_Department='12'"; $data12 = $mysql->getVar($sql); $sql = "select count(*) from `BasicInfo` where C_Department='13'"; $data13 = $mysql->getVar($sql); //学生会 $sql = "select count(*) from `BasicInfo` where C_Department='21'"; $data21 = $mysql->getVar($sql); $sql = "select count(*) from `BasicInfo` where C_Department='22'"; $data22 = $mysql->getVar($sql); $sql = "select count(*) from `BasicInfo` where C_Department='23'"; $data23 = $mysql->getVar($sql); $sql = "select count(*) from `BasicInfo` where C_Department='24'"; $data24 = $mysql->getVar($sql); $sql = "select count(*) from `BasicInfo` where C_Department='25'"; $data25 = $mysql->getVar($sql);