PHP SaeMysql::getVar方法代码示例

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);