/** * 调用微信接口,重新获取access_token * @return string */ private function _getNewAccessToken() { // 获取新的access_token $apiUrl = sprintf($this->_apiUrl, APP_ID, APP_SECRET); $newAccessToken = Curl::doCurl($apiUrl); // 判断是否获取成功 if (!$newAccessToken['errcode'] && !empty($newAccessToken['access_token'])) { // 将新获取的access_token更新到数据库 $c_time = time() - 200; // 将获取到的时间提前一点 $mysql = new SaeMysql(); $sql = "SELECT `c_time`, `t_value` FROM `weixin_access_token`"; $data = $mysql->getData($sql); //$data = DbPDO::table('weixin_access_token')->find(); if (!$data) { // 首次插入 //DbPDO::table('weixin_access_token')->where(array('id'=>1))->add(array('c_time' => $c_time, 't_value' => $newAccessToken['access_token'])); $sql = "INSERT INTO `weixin_access_token` (`c_time`, `t_value`) VALUES ({$c_time}, " . $newAccessToken['access_token'] . ")"; } else { // 修改 //DbPDO::table('weixin_access_token')->where(array('id'=>1))->save(array('c_time' => $c_time, 't_value' => $newAccessToken['access_token'])); $sql = "UPDATE `weixin_access_token` SET `c_time` = {$c_time} , `t_value` = " . $newAccessToken['access_token'] . " WHERE id = 1"; } $mysql->runSql($sql); $mysql->closeDb(); } else { throw new Exception($newAccessToken['errcode'] . '-' . $newAccessToken['errmsg']); } return $newAccessToken['access_token']; }
static function getPrintCode($uid) { $mysql = new SaeMysql(); // 获取当前的 print code $sql = "SELECT `print_code` FROM `printers` WHERE `uid` = '" . $uid . "'"; $old_code = $mysql->getVar($sql); // 清空所有 print code 为 old code 的数据 $sql = "DELETE FROM `wx_images` WHERE `print_code` = '{$old_code}'"; $mysql->runSql($sql); // 为了避免重复,先取出所有的print code $sql = "SELECT `code` FROM `printers`"; $codes = $mysql->getData($sql); // 生成新的print code $new_code = mt_rand(1000, 9999); $canAdd = false; while (!$canAdd) { $canAdd = true; foreach ($codes as $codeItem) { if ($codeItem['code'] == $new_code) { $new_code = mt_rand(1000, 9999); $canAdd = false; break; } } } $sql = "UPDATE `printers` SET `code` = '" . $new_code . "' WHERE `uid` = '" . $uid . "'"; $mysql->runSql($sql); $mysql->closeDb(); return $new_code; }
function getAstrosData() { $mysql = new SaeMysql(); $sql0 = "SELECT * FROM `" . tname("astro") . "` LIMIT 12"; $astros = $mysql->getData($sql0); return $astros; }
function TimingTask() { // load urls $mysql = new SaeMysql(); $sql = "SELECT url FROM `url`"; $data = $mysql->getData( $sql ); $mysql->closeDb(); $queue = new SaeTaskQueue('task_queue_0_2'); $array = array(); for($i = 0; $i < sizeof($data); ++$i) { //$array[] = array('url'=>"http://urlwatcher.sinaapp.com/url_watch.php", "postdata"=>"target=".$data[$i], "prior"=>true); $array[] = array('url'=>"http://urlwatcher.sinaapp.com/url_watch.php?target=" . $data[$i]["url"], "postdata"=>NULL, "prior"=>true); } $queue->addTask($array); $ret = $queue->push(); if ($ret === false) { var_dump($queue->errno(), $queue->errmsg()); echo "Failed."; } else { echo "Success."; print_r($array); } }
public function index() { $mysql = new SaeMysql(); $sql = "SELECT * FROM `scrawl` WHERE sid = 1"; $data = $mysql->getData($sql); if ($mysql->errno() != 0) { die("Error:" . $mysql->errmsg()); } $this->assign('svg', $data[0]['data']); $this->display(); }
function get_book_count($bookid) { if (empty($bookid)) { return "数量异常"; } $mysql = new SaeMysql(); $sql = "SELECT count FROM bookinfo WHERE id = '" . $bookid . "'"; $data = $mysql->getData($sql); if (empty($data[0][0])) { return "数量异常"; } //取到总备货数量 $count1 = intval($data[0][0]); $sql = "SELECT SUM(count) FROM sellinfo WHERE bookid = '" . $bookid . "' GROUP BY null"; $data = $mysql->getData($sql); $count2 = 0; if (!empty($data[0][0])) { $count2 = intval($data[0][0]); } return strval($count1 - $count2); }
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; }
public function update(){ $query = "update toupiao set {$this->pingwei} = {$this->score} where keshi_name = '{$this->jiemu}'"; //echo $query; $mysql = new SaeMysql(); $query_submit = "select didSubmit from score_pingwei where score like '{$this->pingwei}'"; $resultOfQuery_submit = $mysql->getData($query_submit); //var_dump($this->pingwei); //var_dump($resultOfQuery_submit); if ($resultOfQuery_submit[0]["didSubmit"] > 1 || ($this -> score>100)|| ($this -> score<75)) { # code... $this->show_error(); }else{ $mysql->runSql( $query ); $mysql->closeDb(); $this->show_success(); } }
<?php include 'header.php'; $mysql = new SaeMysql(); $sql = "select * from member"; $result = $mysql->getData($sql); ?> <P> <H2>New Income:</H2> <P> <form method="post" action="addIncome.php"> <table border="0"> <tr> <td>amount:</td> <td><input type="text" maxlength="255" size="30" name="amount" /><font color="red">(*number only)</font></td> </tr> <tr> <td>from:</td> <td> <select name="memberId"> <?php foreach ($result as $member) { ?> <option value="<?php echo $member[id]; ?> "/><?php echo $member[name]; ?> </option> <?php
<h1 align="center">医务科后台</h1> <?php //creat timestamp for record $t = time(); $datestamp = date("Y-m-d H:i", $t); echo "<h6 align='center'>现在时间:" . $datestamp . "</h6>"; //connect database require_once 'conn.php'; //define openid //getdata for person $sql = "SELECT * FROM personalinformation_records WHERE 'check_rsk'='checked' ORDER BY id DESC"; $mysql = new SaeMysql(); //echo the result echo "<table border='1' align='center' class='datalist'>"; $num = 0; $query_sql = $mysql->getData($sql); $numoflist = count($query_sql); //$get_data =mysql_query("select * from waimai where class='{$class}' ORDER BY ord DESC");//查询 if ($numoflist <= 10) { //如果总数小于等于10则全部生成 // makeList($get_data); } else { //总数大于10则分页 if (!isset($_GET['limit'])) { $limitHead = 0; } else { $limitHead = $_GET['limit']; } //如果没有传递参数 那么初始化为0 $limitEnd = $limitHead + 10; if ($limitEnd >= $numoflist) {
} //列表数据获取、分页 //计算总数 $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"); } ?> <!--页面名称--> <h3>部门管理<a href="class_add.php">新增部门>></a></h3> <!--列表开始--> <table border=1> <tr> <td>序号</td><td>部门名称</td><td>所属上级</td><td>操作</td> </tr> <?php if ($class_list) { foreach ($class_list as $value) {
public function update() { $check_caozuo = "select caozuo from toupiao where id ={$this->jiemu}"; $query = "update toupiao set {$this->pingwei} = {$this->score} where id = {$this->jiemu}"; //echo $query; $mysql = new SaeMysql(); $mysql_caozuo = new SaeMysql(); $result_check = $mysql_caozuo->getData($check_caozuo); //var_dump($result_check); if ($result_check[0]['caozuo'] == "1") { # code... $result = $mysql->runSql($query); if ($result) { $this->show_success(); } else { $this->show_fail(); } } else { $this->show_error(); } //$result->free(); //$mysqli->close(); }
$sql = "update class set class_name='{$class_name}',class_fid='{$class_fid}',edittime='{$nowtime}'\n where class_id={$old_class_id}"; $mysql->runSql($sql); } else { //新增 $sql = "insert into class (class_name,class_fid,addtime,edittime,status) values ('{$class_name}',\n '{$class_fid}','{$nowtime}','{$nowtime}',1)"; $mysql->runSql($sql); } if ($mysql->errno() != 0) { echo "<script>alert('" . $mysql->errmsg() . "');history.back();</Script>"; exit; } else { echo "<script>alert('操作成功!');location='class_add.php?class_id={$old_class_id}';</Script>"; exit; } } $class_list = $mysql->getData("select class_name,class_id from class where status=1 order by class_fid asc"); ?> <!--页面名称--> <h3>部门添加/修改<a href="class_manager.php">返回>></a></h3> <!--表单开始--> <form action="?" method="post" name="class_add" id="class_add" enctype="multipart/form-data"> <p> 部门名称:<input type="text" value="<?php echo $class_value["class_name"]; ?> " name="class_name"> </p> <p> 上级部门: <select name="class_fid"> <option value="0">无上级部门</option>
$mysql = new SaeMysql(); $pagesize = 10; $sql = "select count(*) as num from income"; $myrow = $mysql->getLine($sql); $num = $myrow["num"]; $pages = intval($num / $pagesize); if ($num % $pagesize) { $pages++; } if (empty($_GET['page'])) { $page = 1; } else { $page = intval($_GET['page']); } $offset = $pagesize * ($page - 1); $datas = $mysql->getData("select t.* from (select a.id,a.amount,a.member_id,a.time,b.name from income a ,member b where a.member_id = b.id order by a.time desc)t limit {$offset},{$pagesize}"); echo "<table>\n"; if (is_array($datas)) { foreach ($datas as $data) { ?> <tr> <td align="right">amount:</td><td align="left"><B><?php echo $data["amount"]; ?> </B></td> <td align="right">from:</td><td align="left"><B><?php echo $data["name"]; ?> </B></td> <td align="right">time:</td><td align="left"><B><?php echo $data["time"];
<th>节目序号</th> <th>节目名称</th> <th>表演者</th> <th>小组</th> <th>总分</th> <th>平均分</th> <th>(去)总分</th> <th>(去)平均分</th> </tr> <?php //connect database $mysql = new SaeMysql(); //mysqli_query($mysqli,"SET NAMES utf8"); $query = "select * from toupiao"; $result = $mysql->getData($query); //var_dump($result); $array_pingfeng = array(); //创建数组 存储qu平均分后的数组 记录id和平均分 for ($i = 0; $i < count($result); $i++) { $row = $result[$i]; // var_dump($row); $num_child_row = count($row) - 5; $array_score = array_slice($row, 5); //off 5 argues sort($array_score); $total_score = array_sum($array_score); $total_pingjun_score = $total_score / $num_child_row; array_pop($array_score); array_shift($array_score); $delete_score = array_sum($array_score);
function makeTimu($min, $max, $num, $i) { if ($num != 0 && $num > 0) { # code... $num = intval($num) + $i - 1; $hasRan = array(); while ($i <= $num) { srand((double) microtime() * 1000000); $a = rand($min, $max); //只要是随机的生成还没有存在于数组中 if (!in_array($a, $hasRan)) { # code... array_push($hasRan, $a); $mysql = new SaeMysql(); //链接数据库 $sql = "select * from zhiShiJingDa_TiKu where id = {$a}"; $data = $mysql->getData($sql); //var_dump($data); //list($id,$timu,$xuanxiang01,$xuanxiang02,$xuanxiang03,$xuanxiang04,$daan) = $data[0]; //echo $timu; echo ' <div class="panel"> <div class="panel-wrapper"> <h2 class="title">第' . ($i + 1) . '题</h2> <p> <span class="vote_title">' . $data[0]["timu"] . '</span> <input name="timu[' . $i . '][timu_id]" type="text" hidden="true" value="' . $data[0]["id"] . '" /> <br/> <br/> <input name="timu[' . $i . '][timu_daan]" type="radio" value="A" /> <span>A、' . $data[0]["xuanxiang01"] . '</span></li> <br/> <input name="timu[' . $i . '][timu_daan]" type="radio" value="B" /> <span>B、' . $data[0]["xuanxiang02"] . '</span></li> <br/> <input name="timu[' . $i . '][timu_daan]" type="radio" value="C" /> <span>C、' . $data[0]["xuanxiang03"] . '</span> </p> </div> '; $i++; } } } }
} //列表数据获取、分页 //计算总数 $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"); } ?> <!--页面名称--> <h3>题目管理<a href="question_add.php">新增题目>></a></h3> <!--列表开始--> <table border=1> <tr> <td>序号</td><td>题目名称</td><td>选项</td><td>答案</td><td>操作</td> </tr> <?php if ($class_list) { foreach ($class_list as $value) {
function DBinsert($userid, $username) { $mysql = new SaeMysql(); $sql_1 = "SELECT * FROM `users` WHERE `weiboid` =" . $userid; //$sql_1 = "SELECT * FROM `users` LIMIT 10"; $data = $mysql->getData($sql_1); if ($mysql->errno() != 0) { die("Error_1:" . $mysql->errmsg()); } if (count($data) == 0) { $sql_2 = "INSERT INTO `users` ( `weiboid` , `weiboname` ) VALUES ('" . $userid . "','" . $username . "') "; $mysql->runSql($sql_2); } else { foreach ($data as $v1) { echo '<p/>'; echo 'weiboname: ' . $v1['weiboname'] . '<br/>'; } } $sql_3 = "SELECT `pynames` FROM `users` WHERE `weiboid` =" . $userid; $data = $mysql->getData($sql_3); if ($mysql->errno() != 0) { die("Error_3:" . $mysql->errmsg()); } if (checkArray($data)) { echo 'pyname is null <br/>'; } else { //echo "length of data=".count($data).'<br/>'; foreach ($data as $v1) { //echo '<p/>'; //echo 'pynames: ' . $v1['pynames'] . '<br/>'; $ps = explode(",", $v1['pynames']); //echo "length of ps=".count($ps).'<br/>'; foreach ($ps as $v2) { //echo '<p/>'; //echo 'pynames: ' . $v2 . '<br/>'; $sql_4 = "SELECT `pynames` FROM `users` WHERE `weiboid` =" . $v2; $data_4 = $mysql->getData($sql_4); if ($mysql->errno() != 0) { die("Error_4:" . $mysql->errmsg()); } if (count($data_4) == 0) { echo '<p/>'; echo 'pynames: ' . $v2 . ' 还没有使用本服务<br/>'; } else { echo 'pynames: ' . $v2 . ' 选中的有:'; foreach ($data_4 as $v3) { //echo '<p/>'; echo $v3['pynames'] . '<br/>'; if (strpos($v3['pynames'], (string) $userid, 0) === false) { //echo '没有找到'; } else { echo '用户' . $v2 . '也选择了您!'; } } } } //SelectTag($ps); } } $mysql->closeDb(); }
<?php include 'header.php'; $mysql = new SaeMysql(); $mysql->runSql("set names 'utf8'"); $sql = "select * from member"; $members = $mysql->getData($sql); echo "<table>\n"; foreach ($members as $member) { ?> <tr> <td align="right">name:</td><td align="left"><B><?php echo $member["name"]; ?> </B></td> <td align="right">updateTime:</td><td align="left"><B><?php echo $member["updatetime"]; ?> </B></td> </tr> <tr> <td colspan="2">balance:<FONT <?php if ($member["balance"] < 0) { echo "color=\"red\""; } ?> ><?php echo $member["balance"]; ?> </FONT></td> </tr>
private function getAnalysedRepory($reports) { $kv = new SaeKV(); $kv->init(); $maxDaysOfMonth = $kv->get('maxDaysOfMonth'); $increaseRate = $kv->get('increaseRate'); $salesTarget = $kv->get('salesTarget'); $manTarget = $kv->get('manTarget'); $cosmeticsTarget = $kv->get('cosmeticsTarget'); $mysql = new SaeMysql(); $month = $reports[0][1]; $day = $reports[0][2]; $sql = "SELECT SUM(`dailySales`) FROM `sales_amount` WHERE `date` = '2016-" . $month . "-" . $day . "'"; $data = $mysql->getData($sql); $lastYearDailySales = $data[0]['SUM(`dailySales`)']; $sql = "SELECT SUM(`monthlySales`) FROM `sales_amount` WHERE `date` = '2016-" . $month . "-" . $day . "'"; $data = $mysql->getData($sql); $lastYearMonthlySales = $data[0]['SUM(`monthlySales`)']; $dailyTarget = $this->sum($reports, 3); $realSales = $this->sum($reports, 4); $totalSales = $this->sum($reports, 6); $cosmeticsSales = $this->sum($reports, 7); $manSales = $this->sum($reports, 8); $line1 = "华东大区," . $month . "月" . $day . "日,时间进度" . round($day / $maxDaysOfMonth * 100) . "%,当月目标增长率" . $increaseRate . "%\r\n"; $line2 = "1)当日指标:" . $dailyTarget . ",实际销量:" . $realSales . ",当日达成率:" . round($realSales / $dailyTarget * 100, 1) . "%,同比增长:" . round(($realSales / $lastYearDailySales - 1) * 100, 1) . "%;\r\n"; $line3 = "2)当月指标:" . $salesTarget . ",累计销售:" . $totalSales . ",累计达成率:" . round($totalSales / $salesTarget * 100, 1) . "%,同比增长:" . round(($totalSales / $lastYearMonthlySales - 1) * 100, 1) . "%;\r\n"; $line4 = "3)重点品:男士销售:" . $manSales . "元,男士指标达成:" . round($manSales / $manTarget * 100, 1) . "%;彩妆销售:" . $cosmeticsSales . "元,彩妆指标达成:" . round($cosmeticsSales / $cosmeticsTarget * 100, 1) . "%;\r\n"; $line5 = "4)执行反馈:无"; return $line1 . $line2 . $line3 . $line4 . $line5; }
<?php if (!(isset($_COOKIE['name']) && $_COOKIE['islogin'] === '1')) { //echo "111"; header("location:login.html"); exit; } else { //如果传入的name在评委数据库中没有查到 就提示查无此人 及返回重新登入,如果正确则获取相对应的score值 //include("conn.php"); $mysql = new SaeMysql(); $check_pingwei = "SELECT * FROM `personalinformation_users` WHERE `user` like '%" . $_COOKIE['name'] . "%'"; //$result_check= $mysqli->query($check_pingwei); $result_check = $mysql->getData($check_pingwei); ///var_dump($result_check); //echo "222"; if (empty($result_check)) { header("location:login.html"); exit; } } error_reporting(E_ALL ^ E_NOTICE ^ E_WARNING); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" /> <meta name="Description" content="登入页面" /> <meta name="Keywords" content="登入" /> <link href="login.css" rel="stylesheet" type="text/css" media="all" /> <title>个人信息录入</title> <script src='jquery-1.11.1.min.js'>
//echo $link; $pagesize = 10; $sql = "select count(*) as num from outcome"; $myrow = $mysql->getLine($sql); $num = $myrow["num"]; $pages = intval($num / $pagesize); if ($num % $pagesize) { $pages++; } if (empty($_GET['page'])) { $page = 1; } else { $page = intval($_GET['page']); } $offset = $pagesize * ($page - 1); $rs = $mysql->getData("select t.* from (select * from outcome order by time desc)t limit {$offset},{$pagesize}"); echo "<table>\n"; if (is_array($rs)) { foreach ($rs as $data) { ?> <tr> <td align="right">amount:</td><td align="left"><B><?php echo $data["amount"]; ?> </B></td> <td align="right">reason:</td><td align="left"><B><?php echo $data["reason"]; ?> </B></td> <td align="right">personNum:</td><td align="left"><B><?php echo $data["personnum"];
<?php header("Content-Type:application/json;charset=UTF-8"); $code = $_GET['code']; $poc = array("poc_1" => 1, "poc_2" => 2, "poc_3" => 3, "poc_4" => 4, "poc_5" => 5, "poc_6" => 6, "poc_7" => 7, "poc_8" => 8, "poc_9" => 9, "poc_10" => 10); //参数 code验证 if (strpos($code, "||") == false) { echo json_encode(array("status" => false, "msg" => "error code!")); exit; } list($key, $value) = explode("||", $code); if ($value != strtoupper(substr(md5("hongcha" . $key . "android"), 1, -1))) { echo json_encode(array("status" => false, "msg" => "error code!")); exit; } $mysql = new SaeMysql(); $sql = "select * from result where code ='" . $mysql->escape($code) . "'"; $data = $mysql->getData($sql); $result = array(); if ($data) { $tmpdata = $data[0]; foreach ($tmpdata as $key => $value) { if ($key != "code" && $key != "id" && $key != "token" && $key != "ua") { $result[$key] = intval($value); } } echo json_encode(array("status" => true, "msg" => $result)); } else { echo json_encode(array("status" => false, "msg" => "query empty!")); } $mysql->closeDb();
</div> <div class="daterange"> <label for="from">From</label> <input type="text" id="from" name="from"/> <label for="to">to</label> <input type="text" id="to" name="to"/> <select id="url_group" name="url_group"> <?php include_once( 'saemysql.class.php' ); $mysql = new SaeMysql(); $sql = "SELECT * FROM `url_group`"; $groups= $mysql->getData( $sql ); for ($i = 0; $i < sizeof($groups); $i++) { echo '<option value="' . $groups[$i]['group_id'] . '">' . $groups[$i]['group_name'] . '</option>'; } $mysql->closeDb(); ?> </select> <button id="go" name="go">GO</button > </div> <div class="error" id="errortext">
<table class="table table-hover"> <thead> <tr> <th>题目编号</th> <th>描述</th> <th>正确答案</th> <th>查看</th> <th>修改</th> <th>删除</th> </tr> </thead> <tbody> <?php $mysql = new SaeMysql(); $sql = "select `id`,`question`,`right_answer` from `choice_question` order by `id` DESC"; $rows = $mysql->getData($sql); $mysql->closeDb(); // print_r($rows); foreach ($rows as $row) { echo "<tr>"; echo "<td>" . $row["id"] . "</td>"; echo "<td>" . substr_cut($row["question"], 50) . "</td>"; echo "<td><code>" . $row["right_answer"] . "</code></td>"; echo "<td><a class=\"btn btn-info\" href=\"./index.php?id=7&qid=" . $row["id"] . "\">查看</a></td>"; echo "<td><a class=\"btn btn-primary\" href=\"./index.php?id=8&qid=" . $row["id"] . "\">修改</a></td>"; echo "<td><a class=\"btn btn-danger\" href=\"../function/admin/common-action.php?cmd=delete-choice&id=" . $row["id"] . "\">删除</a></td>"; echo "</tr>"; } ?> </tbody> </table>
<?php $channel = new SaeChannel(); $name = 'user' . time() . '-' . rand(0, 10000); $duration = 3600; $url = $channel->createChannel($name, $duration); $mysql = new SaeMysql(); $sql = "SELECT name FROM online LIMIT 1"; $sqlback = $mysql->getData($sql); if ($sqlback[0]['name']) { $to = $sqlback[0]['name']; $mysql->runSql("delete from online where name='{$to}'"); } else { $mysql->runSql("insert into online(name) values('{$name}')"); }
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, time(), $msgType, "你已经退出当前答题,寻求帮助请输入“help”,重新挑战请输入“go”!"); echo $resultStr; exit; } //用户查询最好成绩 if (strtolower($form_Content) == "best") { $question_value = $mysql->getLine("select * from answer_tb where answer_user='******' order by answer_time asc limit 0,1"); //回复消息 $msgType = "text"; $resultStr = sprintf($textTpl, $fromUsername, $toUsername, time(), $msgType, "你最好的成绩为:" . $question_value["answer_time"] . "秒\n\n完成时间为:" . $question_value["create_time"]); echo $resultStr; exit; } //用户查询历史成绩,最新的10次 if (strtolower($form_Content) == "history") { $question_list = $mysql->getData("select * from answer_tb where answer_user='******' \n \t\t\torder by create_time desc limit 0,10"); $out_str = ""; foreach ($question_list as $key => $value) { $out_str .= $key + 1 . ". 在" . $value["create_time"] . "完成答题,成绩为答错" . $value["answer_error"] . "次,用时" . $value["answer_time"] . "秒\n\n"; } //回复消息 $msgType = "text"; $resultStr = sprintf($textTpl, $fromUsername, $toUsername, time(), $msgType, $out_str); echo $resultStr; exit; } //开始答题 if (strtolower($form_Content) == "go") { //从题库中随机抽取5道题目 $question_list = $mysql->getData("select *\n from question_tb \n where question_id >=\n (select floor(80+rand()*((select max(question_id) from question_tb)-(select min(question_id) from question_tb)) + \n (select min(question_id) from question_tb)))\n order by question_id limit " . $question_nums); //将数组序列化存放到缓存,创建当前用户题库,时间设定10分钟
function matchEngine($content) { global $reg_arr, $biaoqing; foreach ($reg_arr as $key => $value) { if (preg_match($key, $content, $matches)) { switch ($value) { case 'dream': $data = dream($matches[2]); break; case 'translate': $data = translateAPI($matches[2]); break; case 'biaoqing': $data = $biaoqing[rand(0, count($biaoqing) - 1)]; break; case 'changeSimsimiKey': $s = new SaeStorage(); $s->write('simsimi', 'simi.txt', $matches[2]); $data = '更改成功!'; break; case 'md5': $data = md5($matches[2]); break; case 'qrcode': $qrcode = 'http://chart.apis.google.com/chart?cht=qr&chs=400x400&choe=UTF-8&chl=' . $matches[2]; $data = array(array('title' => $matches[2], 'cover' => $qrcode, 'link' => $qrcode)); break; case 'bingSearch': $bingweb = bing($matches[2], 'Web'); $bingimage = bing($matches[2], 'Image'); $data = array(array('title' => $matches[2], 'note' => '', 'cover' => $bingimage[0], 'link' => '')); //max:7 for ($i = 0; $i < 5; $i++) { array_push($data, array('title' => $bingweb[$i]['title'] . "\n" . '------------------------------------------', 'note' => $bingweb[$i]['description'], 'cover' => '', 'link' => $bingweb[$i]['url'])); } break; case 'wiki': $wiki = wiki($matches[2], $lng); $data = array(); for ($i = 0; $i < 5; $i++) { array_push($data, array('title' => $wiki[$i]['title'] . "\n" . '------------------------------------------', 'note' => $wiki[$i]['snippet'], 'cover' => '', 'link' => 'http://zh.wikipedia.org/wiki/' . $wiki[$i]['title'])); } break; case 'doubanMovie1': $m = doubanMovies($matches[2]); $data = array(array('title' => $m[0]['title'], 'note' => $m[0]['year'] . ' ' . $m[0]['average'], 'cover' => $m[0]['images']->large, 'link' => $m[0]['alt'])); for ($i = 1; $i <= 5; $i++) { array_push($data, array('title' => $m[$i]['title'], 'note' => '又名:' . $m[$i]['original_title'] . "\n" . '上映日期:' . $m[$i]['year'] . "\n" . '评价:' . $m[$i]['average'], 'cover' => $m[$i]['images']->small, 'link' => $m[$i]['alt'])); } break; case 'doubanMovie2': $m = doubanMovies($matches[2]); $movie = doubanMovie($m[0]['id']); $xinxi = '又名:'; foreach ($movie['aka'] as $value) { $xinxi .= $value . '/'; } $xinxi .= "\n" . '上映日期:' . $movie['year'] . "\n" . '制片国家:'; foreach ($movie['countries'] as $value) { $xinxi .= $value . '/'; } $xinxi .= "\n" . '类型:'; foreach ($movie['genres'] as $value) { $xinxi .= $value . '/'; } $xinxi .= "\n" . '评价:' . $movie['average']; $data = array(array('title' => $movie['title'], 'cover' => $movie['images'], 'link' => $movie['mobile_url']), array('note' => $xinxi, 'link' => $movie['mobile_url']), array('title' => '简介', 'note' => $movie['summary'], 'link' => $movie['mobile_url']), array('title' => '导演', 'note' => $movie['directors'][0]->name, 'cover' => $movie['directors'][0]->avatars->small, 'link' => $movie['directors'][0]->alt), array('title' => '主演', 'note' => $movie['casts'][0]->name, 'cover' => $movie['casts'][0]->avatars->small, 'link' => $movie['casts'][0]->alt)); break; case 'doubanBook1': $b = doubanBooks($matches[2]); $data = array(array('title' => $b[0]['title'], 'note' => $b[0]['author'][0] . ' ' . $b[0]['average'], 'cover' => $b[0]['images']->large, 'link' => $b[0]['alt'])); for ($i = 1; $i <= 4; $i++) { array_push($data, array('title' => $b[$i]['title'], 'note' => '作者:' . $b[$i]['author'][0] . "\n" . '出版社:' . $b[$i]['publisher'] . "\n" . '出版日期:' . $b[$i]['pubdate'] . "\n" . '价格:' . $b[$i]['price'] . "\n" . '评价:' . $b[$i]['average'] . "\n" . '导言:' . $b[$i]['summary'], 'cover' => $b[$i]['images']->small, 'link' => $b[$i]['alt'])); } break; case 'doubanBook2': $b = doubanBooks($matches[2]); $bk = doubanBook($b[0]['id']); $data = array(array('title' => $bk['title'], 'cover' => $bk['images'], 'link' => $bk['alt']), array('note' => '作者:' . $bk['author'][0] . "\n" . '出版社:' . $bk['publisher'] . "\n" . '出版日期:' . $bk['pubdate'] . "\n" . '价格:' . $bk['price'] . "\n" . '评价:' . $bk['average'], 'link' => $bk['alt']), array('title' => '导言:', 'note' => $bk['summary'], 'link' => $bk['alt'])); break; case 'doubanMusic1': $m = doubanMusics($matches[2]); $data = array(array('title' => $m[0]['title'], 'note' => $m[0]['average'], 'cover' => $m[0]['image'], 'link' => $m[0]['alt'])); for ($i = 1; $i <= 4; $i++) { array_push($data, array('title' => $m[$i]['title'], 'note' => '作者:' . $m[$i]['author'][0]->name . "\n" . '出版社:' . $m[$i]['publisher'][0] . "\n" . '出版日期:' . $m[$i]['pubdate'][0] . "\n" . '表演者:' . $m[$i]['singer'][0] . "\n" . '评价:' . $m[$i]['average'] . "\n" . '类型:' . $m[$i]['version'][0], 'cover' => $m[$i]['image'], 'link' => $m[$i]['alt'])); } break; case 'doubanMusic2': $m = doubanMusics($matches[2]); $mu = doubanMusic($m[0]['id']); $data = array(array('title' => $mu['title'], 'cover' => $mu['image'], 'link' => $mu['mobile_link']), array('note' => '表演者:' . $mu['singer'][0] . "\n" . '专辑类型:' . $mu['version'][0] . "\n" . '发行时间:' . $mu['pubdate'][0] . "\n" . '作者:' . $mu['author'][0]->name . "\n" . '出版者:' . $mu['publisher'][0] . "\n" . '评价:' . $mu['average'], 'link' => $mu['mobile_link']), array('title' => '简介:', 'note' => $mu['summary'], 'link' => $mu['mobile_link'])); break; case 'moments1': $moment = $matches[2]; $time = time(); $date = date("Y-m-d H:i:s", time()); $mysql = new SaeMysql(); $res = $mysql->getData("SELECT alias FROM info WHERE FromUserName='******'"); $alias = $res[0]['alias']; if (!$alias) { $data = '由于你是第一次发送动态,请按照以下格式回复基本信息:' . "\n" . '昵称:+你的昵称'; } else { $mysql->runSql("INSERT INTO moments(FromUserName,alias,moment,time,date) VALUES ('{$openid}','{$alias}','{$moment}',{$time},'{$date}')"); $data = "发送成功,你可以现在上传一张图片作为配图,当然也可以不上传啦。回复[动态]查看"; } break; case 'moments2': $alias = $matches[2]; $mysql = new SaeMysql(); $res = $mysql->getData("SELECT * FROM info"); $num = 0; while ($res[$num]) { if ($alias == $res[$num]['alias'] || $alias == '小u' || $alias == 'urinx') { $t = 1; } elseif ($openid == $res[$num]['FromUserName']) { $u = 1; } $num++; } if ($t) { $data = '该用户名已被注册,请重新输入'; } else { if ($u) { $mysql->runSql("UPDATE info SET alias='{$alias}' WHERE FromUserName='******'"); $data = '更改成功!'; } else { $mysql->runSql("INSERT INTO info(FromUserName,alias) VALUES ('{$openid}','{$alias}')"); $data = '注册成功!'; } } break; default: # code... break; } } } return $data; }
<?php if (defined('SAE_MYSQL_DB')) { $sql = new SaeMysql(); } else { require 'x/mysql.class.php'; } $list = $sql->getData('SELECT * FROM imouto_article ORDER BY created DESC LIMIT 0,15'); $h = '<?xml version="1.0" encoding="UTF-8"?>' . "\n" . '<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/">' . "\n" . '<channel>' . "\n" . ' <title>卜卜口</title>' . "\n" . ' <link>http://mouto.org/</link>' . "\n" . ' <description>94年少年。</description>' . "\n" . ' <lastBuildDate>' . date('D, d M Y H:i:s ', $list[0]['created']) . '</lastBuildDate>' . "\n" . ' <language>zh-CN</language>' . "\n"; foreach ($list as $p) { $h .= ' <item>' . "\n" . ' <title><![CDATA[' . $p['title'] . ']]></title>' . "\n" . ' <link>http://mouto.org/#!' . $p['pid'] . '</link>' . "\n" . ' <category>' . $p['category'] . '</category>' . "\n" . ' <pubDate>' . date('D, d M Y H:i:s ', $p['created']) . '</pubDate>' . "\n" . ' <description><![CDATA['; if ($p['cover']) { $h .= '<p><img src="http://ww2.sinaimg.cn/large/' . $p['cover'] . '.jpg"></p>'; } $h .= $p['text'] . ']]></description>' . "\n" . ' </item>' . "\n"; } $h .= '</channel>' . "\n" . '</rss>'; header('Content-type: application/rss+xml;charset=utf-8'); exit($h); file_put_contents('rss.xml', $h);
$ghost = array('短篇鬼故事' => 1, '长篇鬼故事' => 2, '校园鬼故事' => 3, '医院鬼故事' => 4, '家里鬼故事' => 5, '民间鬼故事' => 6, '灵异事件' => 7, '听鬼故事' => 10, '中国灵异' => 25, '灵异知识库' => 26, '推理小说' => 46); $help = '这是目前小u有的功能:' . "\n" . '-----------------' . "\n" . '[小u]' . "\n" . ':查看小u的基本信息,以及功能介绍和近期更新' . "\n" . '-----------------' . "\n" . '[帮助]' . "\n" . ':查看使用帮助' . "\n" . '-----------------' . "\n" . '[查水表]' . "\n" . ':查询寝室的水电费(华科)' . "\n" . '-----------------' . "\n" . '[每日一句]' . "\n" . ':每天更新一句英语,中英对照' . "\n" . '-----------------' . "\n" . '[点歌]' . "\n" . ':小u每天会为大家推荐好的歌曲,希望大家喜欢。如果想给某人点歌的话,可以直接跟我说哦' . "\n" . '-----------------' . "\n" . '[笑话]' . "\n" . ':郁闷时看看笑话吧,小u这里有好多笑话等着你呢' . "\n" . '-----------------' . "\n" . '[新闻]' . "\n" . ':没事的时候大家多看看新闻吧,小u不懈的为你奉送中' . "\n" . '-----------------' . "\n" . '[彩票]' . "\n" . ':每天的彩票信息一目了然' . "\n" . '-----------------' . "\n" . '翻译' . "\n" . ':发送"#+你要翻译的内容",即可收到详细结果,例如:#doofus' . "\n" . '-----------------' . "\n" . '天气+找小u' . "\n" . ':点击下面的“+”,发送你的的位置信息,即可收到本地的天气预报,并且看到你和小u的距离哟。' . "\n" . '-----------------' . "\n" . 'bing搜索' . "\n" . ':发送"%+你要搜索的内容",即可收到详细结果,例如:%dweeb' . "\n" . '-----------------' . "\n" . '维基百科' . "\n" . ':发送"&+你要搜索的内容",小u会根据你的输入自动判断查询中文维基或是英文,(*^__^*) 嘻嘻。例如:&spaz' . "\n" . '-----------------' . "\n" . '二维码' . "\n" . ':发送"*+你要生成的内容",小u会返回生成的二维码。例如:*嘟嘟噜' . "\n" . '-----------------'; $help .= "\n" . '豆瓣' . "\n" . '1.书' . "\n" . ' bs:关键字 搜索相关的书籍' . "\n" . ' b:书名 查看详细内容' . "\n" . '2.音乐' . "\n" . ' ms:关键字 搜索相关的音乐' . "\n" . ' m:音乐名 查看详细内容' . "\n" . '3.电影' . "\n" . ' vs:关键字 搜索相关的电影' . "\n" . ' v:电影名 查看详细内容' . "\n" . '-----------------'; $help .= "\n" . '动态' . "\n" . ':发送":+你要分享的文字"即可,大家可以回复[动态]查看,都可以看到哦。例如 :这是我发的第一个说说' . "\n" . '-----------------'; $help .= "\n" . '美女识别' . "\n" . ':上传图片,看看小u的眼力吧' . "\n" . '-----------------' . "\n" . '周公解梦' . "\n" . ':发送"梦到xxx",小u来预测吉凶,例如"梦到小u"' . "\n" . '-----------------' . "\n" . '手机号码查询' . "\n" . ':直接发送手机号' . "\n" . '-----------------'; $help .= "\n" . '[鬼故事]' . "\n" . ':小u精心为你准备的鬼故事哟,超吓人的说,午夜凌晨看一看好阔怕。。' . "\n" . '-----------------' . "\n" . '[短篇鬼故事]' . "\n" . ':让喜欢鬼故事的读者在这里快速感受到不一样的诡异,篇幅较短,适合想快速阅读完鬼故事的朋友' . "\n" . '-----------------' . "\n" . '[长篇鬼故事]' . "\n" . ':篇幅较长,情节曲折,剧情跌宕起伏,一个好的长篇鬼故事,就是一次刺激的心灵旅行' . "\n" . '-----------------' . "\n" . '[校园鬼故事]' . "\n" . ':这里的鬼故事都与校园有关或者是发生在学校里的鬼故事,让喜爱鬼故事的读者了解更多的校园鬼故事' . "\n" . '-----------------' . "\n" . '[医院鬼故事]' . "\n" . ':我们在恐怖鬼片里也常见到发生在医院里的鬼故事事件,但有更多的鬼故事等待你去发现,一起来看医院鬼故事吧' . "\n" . '-----------------' . "\n" . '[家里鬼故事]' . "\n" . ':发生在家里的鬼故事比较多,快来看看都有哪些恐怖的家里鬼故事吧' . "\n" . '-----------------'; $help .= "\n" . '[民间鬼故事]' . "\n" . ':中国民间鬼故事来源于古代的传奇小说,和现代的民间流传奇闻中。同时鬼故事网也搜集了国外吸血鬼的故事,欢迎大家阅读民间鬼故事' . "\n" . '-----------------' . "\n" . '[灵异事件]' . "\n" . ':灵异事件在世界各地每个角落经常发生,你身边是否也有灵异事件呢?灵异事件频道最全面的记录最新真实灵异事件,中国灵异事件,国外灵异事件,灵异鬼故事大全,带你进入灵异鬼故事的世界' . "\n" . '-----------------' . "\n" . '[中国灵异]' . "\n" . ':整理最全的中国真实灵异事件大全,将会带您走入从古到今发生在中国的灵异事件' . "\n" . '-----------------' . "\n" . '[灵异知识库]' . "\n" . ':灵异知识大全,例如如何避鬼,招鬼,阵法、鬼魂禁忌等等详细内容' . "\n" . '-----------------'; $help .= "\n" . '[推理小说]' . "\n" . ':内容涵盖惊悚、悬疑、侦探、武侠等,一切以推理为出发点,挑战思维极限,考验缜密的逻辑。风格:先锋、酷炫、丰富多彩、可读性强。杂志力推原创,名家新秀携手亮相,联手打造包罗万象,令人耳目一新、心驰神往的异度空间' . "\n" . '-----------------' . "\n" . '[听鬼故事]' . "\n" . ':张震讲鬼故事,吓死你不偿命' . "\n" . '-----------------'; $help .= "\n" . '#[xx]内的内容xx是指你发送给小u的'; // 接收位置 if ($type == 'location') { $uriID = 'oTHwbt_9H0QVjJn8AdI-fmkHdKgM'; $X = $xml->Location_X; $Y = $xml->Location_Y; $sql = "SELECT Location_X,Location_Y FROM info WHERE FromUserName='******'"; $sqlback = $mysql->getData($sql); $pre_X = $sqlback[0]['Location_X']; $pre_Y = $sqlback[0]['Location_Y']; $wData = weatherAPI($X, $Y); //天气查询 $distance = W::getDistance($X, $Y, $pre_X, $pre_Y); //计算距离 if ($openid == $uriID) { $mysql->runSql("UPDATE info SET Location_X='{$X}',Location_Y='{$Y}' WHERE FromUserName='******'"); $data = '主人的位置已上传' . "\n" . 'X:' . $X . "\n" . 'Y:' . $Y . "\n" . '相距上次位置' . $distance . 'km'; } else { $data = '哦哦,你和我的距离只有' . $distance . 'km哟'; } $data .= "\n" . '------------------------------' . "\n" . $wData; } elseif ($type == 'text') { $result = $mysql->getData("SELECT * FROM python WHERE FromUserName='******'");