PHP SaeMysql::errno方法代码示例

function mysqlc($content)
{
    $mysql = new SaeMysql();
    if ($content == 'help') {
        $data = 'Select' . "\n" . 'Insert' . "\n" . 'Update' . "\n" . 'Delete' . "\n" . 'Create' . "\n" . 'Drop' . "\n" . 'Index' . "\n" . 'Alter';
    } else {
        if (preg_match('#^(select)#i', $content)) {
            $sqlresult = $mysql->getData($content);
            if ($mysql->errno() != 0) {
                $data = "Error:" . $mysql->errmsg();
            } else {
                $data = 'mysql> ' . $content . "\n" . '-----------------' . "\n";
                foreach ($sqlresult as $row) {
                    foreach ($row as $key => $value) {
                        $data .= $key . ':' . $value . "\n";
                    }
                    $data .= '------------------' . "\n";
                }
            }
        } else {
            $mysql->runSql($content);
            if ($mysql->errno() != 0) {
                $data = "Error:" . $mysql->errmsg();
            }
        }
    }
    return $data;
}

function syncPhone($id, $oldPhone, $newPhone)
{
    $url = 'http://x.suzhoumaker.com/syncAction.php';
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_POST, 1);
    curl_setopt($ch, CURLOPT_POSTFIELDS, "oldPhone=" . $oldPhone . "&newPhone=" . $newPhone);
    // receive server response ...
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    $server_output = curl_exec($ch);
    curl_close($ch);
    $syncAction = 3;
    // further processing ....
    $mysql = new SaeMysql();
    if ($server_output == "OK") {
        $syncAction = 0;
    }
    $sql = "UPDATE Member SET m_sync_action = " . $syncAction . ", m_updated_on=now() WHERE m_num=" . $id;
    $mysql->runSql($sql);
    if ($mysql->errno() != 0) {
        die("Error:" . $mysql->errmsg());
    } else {
        //
    }
    $mysql->closeDb();
}

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

    $old_class_id = intval($old_class_id);
    $class_name = string::un_script_code($class_name);
    $class_fid = intval($class_fid);
    //默认参数
    $nowtime = date("Y/m/d H:i:s", time());
    //如果是修改
    if ($old_class_id) {
        //修改部门名称、所属、更新时间
        $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 

<?php

$lvyi_db = new SaeMysql();
//install
$sql = file_get_contents('./db.sql');
//do
runquery($sql);
//report
if ($lvyi_db->errno() != 0) {
    die("Error:" . $lvyi_db->errmsg());
}
$lvyi_db->closeDb();
//include success template
function runquery($sql)
{
    global $lvyi_db;
    $sql = str_replace("\r", "\n", $sql);
    $ret = array();
    $num = 0;
    foreach (explode(";\n", trim($sql)) as $query) {
        $queries = explode("\n", trim($query));
        foreach ($queries as $query) {
            $ret[$num] .= $query[0] == '#' || $query[0] . $query[1] == '--' ? '' : $query;
        }
        $num++;
    }
    unset($sql);
    $strtip = "";
    foreach ($ret as $query) {
        $query = trim($query);
        if ($query) {

            $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}'";
    $mysql->runSql($signup);
    sae_log($mysql->errno() . "-" . $mysql->errmsg());
    $mysql->closeDb();
});
//文字消息处理，调用图灵机器人
$server->on('message', 'text', function ($message) use($welcome) {
    //四六级查分-备份考号
    return handleText($message->Content, $message->FromUserName, $welcome);
});
//图片处理，调用微软API
$server->on('message', 'image', function ($image) {
    $picUrl = $image->PicUrl;
    $face = new Face($picUrl);
    $info = $face->info;
    if ($info !== false) {
        $amount = count($info);
        $description = "";

$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 {
        //        echo "你已成功注册" . "<br/>";
        //        echo "即将跳转到备份的页面";
        //        echo "if 111111";
        //跳到填写考号和姓名的页面
        header("Location:http://5.n1gel.sinaapp.com/cet_query.php");
        //填写之后，更新session，更新数据库
    }
    //用户已注册，为备份考号和姓名
} elseif (empty($examid)) {
    //    echo "即将跳转到备份的页面";
    //    echo "if 222222222";
    header("Location:http://5.n1gel.sinaapp.com/cet_query.php");
    //页面获取exanid和姓名直接查询，将查询结果存到数据库并显示到页面，生成一个模板图片，让用户保存

require_once "../../config/saemysql.class.php";
$uid = intval($_COOKIE["user_id"]);
$qid = intval($_POST["qid"]);
$post_answer = trim($_POST["answer"]);
$sql = "select * from `judge_answer` where `user_id`={$uid} and `ques_id`={$qid}";
$mysql = new SaeMysql();
$row = $mysql->getLine($sql);
$mysql->closeDb();
if (false != $row) {
    // echo "执行更新操作";
    $sql = "update `judge_answer` set `answer`={$post_answer} where `user_id`={$uid} and `ques_id`={$qid}";
    $mysql = new SaeMysql();
    $mysql->runSql($sql);
    if ($mysql->errno() == 0) {
        echo "答案更新成功";
    } else {
        echo "答案更新失败，请重试";
    }
    $mysql->closeDb();
} else {
    // echo "执行插入操作";
    $sql = "insert into `judge_answer` (`user_id`,`ques_id`,`answer`) values ({$uid},{$qid},{$post_answer}) ";
    $mysql = new SaeMysql();
    $mysql->runSql($sql);
    if ($mysql->errno() == 0) {
        echo "答案提交成功";
    } else {
        echo "答案提交失败，请重试";
    }
    $mysql->closeDb();
}

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

function upuserlock($lock, $username)
{
    $mysql = new SaeMysql();
    $sql = "UPDATE `wx_users` SET  `lock` =  '{$lock}' WHERE  `openid` =  '{$username}'";
    $mysql->runSql($sql);
    if ($mysql->errno() != 0) {
        die("Error:" . $mysql->errmsg());
    }
    $mysql->closeDb();
}

 public function saveping($source, $destination, $min, $avg, $max, $loss)
 {
     $mysql = new SaeMysql();
     $sql = "INSERT INTO `ping` (`source`, `destination`, `min`, `avg`, `max`, `loss`, `time`)" . " VALUES ('" . $mysql->escape($source) . "', '" . $mysql->escape($destination) . "', " . $min . ", " . $avg . ", " . $max . ", " . $loss . ", NOW())";
     $mysql->runSql($sql);
     if ($mysql->errno() != 0) {
         log_message('error', "MySQL Error: " . $mysql->errmsg());
         //die( "Error: " . $mysql->errmsg() );
         die($sql);
     }
     $mysql->closeDb();
 }

if ($row1 != false) {
    //更新答案操作
    $sql = "update `choice_answer` set `answer`='{$post_answer}' where `user_id`={$uid} and `ques_id`={$qid}";
    $mysql->runSql($sql);
    $str = "答案修改成功";
    if ($user_answer == $right_answer && $post_answer != $right_answer) {
        //原答案正确并且现答案错误，则执行减分操作
        $sql = "update `qs_user` set `grade`=`grade`-{$score} where `id`={$uid}";
        $mysql->runSql($sql);
    } else {
        if ($user_answer != $right_answer && $post_answer == $right_answer) {
            //原答案错误并且现答案正确，执行加分操作
            $sql = "update `qs_user` set `grade`=`grade`+{$score} where `id`={$uid}";
            $mysql->runSql($sql);
        }
    }
} else {
    //插入答案操作
    $sql = "insert into `choice_answer` (`user_id`,`ques_id`,`answer`) values ({$uid},{$qid},'{$post_answer}') ";
    $mysql->runSql($sql);
    $str = "答案提交成功";
    if ($post_answer == $right_answer && $mysql->errno() == 0) {
        //提交答案正确，执行加分操作
        $sql = "update `qs_user` set `grade`=`grade`+{$score} where `id`={$uid}";
        $mysql->runSql($sql);
    }
}
if ($mysql->errno() == 0) {
    echo $str;
}
$mysql->closeDb();