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(); }
$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 echo $class_value["class_name"];
echo "<h1>警告</h1>"; echo "<h3>版本" . $_SERVER['HTTP_APPVERSION'] . "已完成安装!请删除/install/目录!</h3>"; echo "<h3>如果重新安装请先删除storage内的 saestor_" . $_SERVER['HTTP_APPVERSION'] . "/data/install.lock 文件</h3>"; } else { // 判断是否已经初始化了storage,mc,mysql if (is_storage() && is_mc() && is_mysql()) { $fp = @fopen(dirname(__FILE__) . "/ecshop4sae.sql", "r") or die("不能打开SQL文件 {$file_name}"); //打开文件 if ($fp) { $mysql = new SaeMysql(); echo "正在执行导入操作:"; while ($SQL = GetNextSQL()) { $SQL = str_replace("`ecs_", "`" . TABLE_PREFIX, $SQL); // echo $SQL."<BR/>"; if (!$mysql->runSql($SQL)) { echo "执行出错:" . $mysql->errmsg() . ""; echo "SQL语句为:" . $SQL . ""; exit; } } echo "导入完成<br/>"; echo "<h1>安装成功</h1>"; echo "点击<a href='/admin'>/admin</a> 进入后台,管理员帐号为admin 密码为123<br/><br/><h2>注意</h2>为确保安全请登入后台后修改密码!并使用svn删除/install目录!"; @fclose($fp); $s = new SaeStorage(); $s->write(SAESTOR_NAME, "saestor_" . $_SERVER['HTTP_APPVERSION'] . "/data/install.lock", '1'); } else { echo "<h1>错误</h1>"; echo "ecshop4sae.sql文件不存在!"; } } else {
<?php $title = $_POST['title']; $abstract = $_POST['abstract']; $url = $_POST["url"]; $thumbnail = $_POST['thumbnail']; $type = $_POST["type"]; $status = $_POST["status"]; $reviewer = $_POST["reviewer"]; $deliver = $_POST["deliver"]; $create_at = $_POST["create_at"]; $delete = $_POST["delete"]; if (empty($title)) { die("{\"s_status\": \"ERROR\",\"s_message\": \"Empty data\",\"s_code\": 0}"); } $mysql = new SaeMysql(); $sql = "INSERT INTO `android_digest_review`( `title`, `abstract`, `url`, `thumbnail`, `type`, `status`, `reviewer`, `deliver`, `create_at`, `delete`) " . "VALUES ('" . $title . "', '" . $abstract . "', '" . $url . "', '" . $thumbnail . "', '" . $type . "', '" . $status . "', '" . $reviewer . "', '" . $deliver . "', '" . $create_at . "', '" . $delete . "') "; $mysql->runSql($sql); if ($mysql->errno() != 0) { die("{\"s_status\": \"ERROR\",\"s_message\": \"" . $mysql->errmsg() . "\",\"s_code\": 1}"); } else { die("{\"s_status\": \"OK\",\"s_message\": \"\",\"s_code\": 200}"); } $mysql->closeDb();
<?php $amount = $_POST[amount]; $memberId = $_POST[memberId]; //echo $amount." ".$memberId; $sql1 = "insert into income (amount,time,member_id) values ({$amount},now(),{$memberId})"; $sql2 = "update depot set updatetime = now(), balance = balance+{$amount}"; $sql3 = "update member set updatetime = now(),balance = balance+{$amount} where id = {$memberId}"; $mysql = new SaeMysql(); $mysql->runSql($sql1); if ($mysql->errno() != 0) { die("Error:" . $mysql->errmsg()); } $mysql->runSql($sql2); if ($mysql->errno() != 0) { die("Error:" . $mysql->errmsg()); } $mysql->runSql($sql3); if ($mysql->errno() != 0) { die("Error:" . $mysql->errmsg()); } $mysql->closeDb(); echo "<SCRIPT LANGUAGE='JavaScript'>"; echo "location.href='income.php'"; echo "</SCRIPT>";
<?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 = "";
$mysql->runSql("UPDATE python SET state=0 WHERE FromUserName='******'"); $data = '已退出Python终端...'; } else { $data = python($content); } } elseif ($result[0]['state'] == 2) { if ($content == 'quit') { $mysql->runSql("UPDATE python SET state=0 WHERE FromUserName='******'"); $data = '已退出Mysql终端...'; } elseif ($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(); } }
$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和姓名直接查询,将查询结果存到数据库并显示到页面,生成一个模板图片,让用户保存
include 'astro_common.php'; $astros = getAstrosData(); $mysql = new SaeMysql(); $day = date('Ymd', strtotime("+1 day")); if (!empty($astros)) { foreach ($astros as $one) { $astro_name = strtolower($one['astro_name_en']); $tmp = getAstroMonth($astro_name); $tmp['astro_id'] = $one['astro_id']; $data[] = $tmp; $sql = getAstroMonthSql($tmp); $mysql->runSql($sql); } if ($mysql->errno() != 0) { print_r("Error:" . $mysql->errmsg()); } } $mysql->closeDb(); function getAstroMonthSql($params) { $sql = 'replace ' . tname("astro_month") . '('; foreach ($params as $attribute => $value) { $sql .= "`" . $attribute . "`,"; } $sql .= ') values ('; foreach ($params as $attribute => $value) { $value = trim($value); $sql .= "'" . $value . "',"; } $sql .= ');';
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(); }
</script> <?php } else { $is_name = true; } if ($is_examid && $is_name) { $_SESSION['examid'] = $examid; $_SESSION['name'] = $name; //更新数据库 $mysql = new SaeMysql(); $update = "insert into cet (examid,name,openid) VALUES ('{$examid}','{$name}','{$openid}')"; $updata_wx = "update wechat_user set name='{$name}' WHERE openid='{$openid}'"; $bool = $mysql->runSql($update); $bool = $mysql->runSql($updata_wx); if (!$bool) { sae_log("插入考号姓名出错" . $mysql->errmsg()); } $mysql->closeDb(); //跳转 header("Location:http://5.n1gel.sinaapp.com/cet_result.php"); } } //endregion ?> <!doctype> <html lang="zh"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width,user-scalable=no,initial-scale=1"/> <link rel="stylesheet" href="http://cdn.rmbz.net/bootstrap-3.3.5-dist/css/bootstrap.min.css"> <title>四六级查分</title>
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(); }