Ejemplos de código de mysqlquery::query en PHP

Ejemplo n.º 1

0

Mostrar archivo

Archivo: task.php Proyecto: novnan/meiju

//执行
if ($ecms == 'dotask') {
    $id = (int) $_GET['id'];
    if (empty($id)) {
        exit;
    }
    $r = $empire->fetch1("select id,filename,lastdo,doweek,doday,dohour,dominute,userid,taskname from {$dbtbpre}enewstask where id={$id} and isopen=1 limit 1");
    $file = '../tasks/' . $r['filename'];
    if (empty($r['id']) || empty($r['filename']) || !file_exists($file)) {
        exit;
    }
    $lasttime = CheckDoTask($r);
    if ($lasttime) {
        echo "<script>parent.WriteTaskLog('任务 <" . $r['taskname'] . "> 开始执行......');</script>";
        require_once $file;
        $usql = $empire->query("update {$dbtbpre}enewstask set lastdo='{$lasttime}' where id={$id}");
        echo "<script>parent.WriteTaskLog('任务 <" . $r['taskname'] . "> 执行完毕，最后执行时间：" . date("Y-m-d H:i:s", $lasttime) . "');</script>";
    }
} elseif ($ecms == 'retask') {
    echo "<meta http-equiv=\"refresh\" content=\"" . $retasktime . ";url=task.php?ecms=retask" . $ecms_hashur['href'] . "\">";
    ?>
	<script>
	function AddTaskDiv(divid,taskid){
		if(parent.document.getElementById(divid)!=null)
		{
			parent.document.getElementById('page'+divid).src='task.php?<?php 
    echo $ecms_hashur['href'];
    ?>
&ecms=dotask&id='+taskid;
		}
		else

Ejemplo n.º 2

0

Mostrar archivo

Archivo: ListSp.php Proyecto: BGCX261/zjh-dev-svn-to-git

}
//栏目
$classid = (int) $_GET['classid'];
if ($classid) {
    $add .= $and . "classid='{$classid}'";
    $search .= "&classid={$classid}";
}
if ($add) {
    $add = ' where ' . $add;
}
$query = "select spid,spname,varname,cid,classid,isclose,sptype,sptime from {$dbtbpre}enewssp" . $add;
$totalquery = "select count(*) as total from {$dbtbpre}enewssp" . $add;
$num = $empire->gettotal($totalquery);
//取得总条数
$query = $query . " order by spid desc limit {$offset},{$line}";
$sql = $empire->query($query);
$returnpage = page2($num, $line, $page_line, $start, $page, $search);
$url = "<a href=ListSp.php>管理碎片</a>";
//分类
$scstr = "";
$scsql = $empire->query("select classid,classname from {$dbtbpre}enewsspclass order by classid");
while ($scr = $empire->fetch($scsql)) {
    $select = "";
    if ($scr[classid] == $cid) {
        $select = " selected";
    }
    $scstr .= "<option value='" . $scr[classid] . "'" . $select . ">" . $scr[classname] . "</option>";
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>

Ejemplo n.º 3

0

Mostrar archivo

Archivo: BqtempClass.php Proyecto: novnan/meiju

require "../../class/functions.php";
$link = db_connect();
$empire = new mysqlquery();
$editor = 1;
//验证用户
$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//ehash
$ecms_hashur = hReturnEcmsHashStrAll();
//验证权限
CheckLevel($logininid, $loginin, $classid, "template");
$sql = $empire->query("select classid,classname from {$dbtbpre}enewsbqtempclass order by classid desc");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title></title>
<link href="../adminstyle/<?php 
echo $loginadminstyleid;
?>
/adminstyle.css" rel="stylesheet" type="text/css">
</head>

<body>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1">
  <tr>

Ejemplo n.º 4

0

Mostrar archivo

Archivo: ChangeTable.php Proyecto: laiello/netos-cms

require "class/connect.php";
include "class/config.php";
include "class/db_sql.php";
include "class/functions.php";
$loginin = getcvar('bakusername');
$rnd = getcvar('bakrnd');
islogin($loginin, $rnd);
$link = db_connect();
$empire = new mysqlquery();
$mydbname = RepPostVar($_GET['mydbname']);
if (empty($mydbname)) {
    printerror("NotChangeDb", "history.go(-1)");
}
//选择数据库
$udb = $empire->query("use `" . $mydbname . "`");
//存放目录
$mypath = $mydbname . "_" . date("YmdHis");
if ($phpsafemod) {
    $mypath = "safemod";
}
//导入设置
$loadfile = RepPostVar($_GET['savefilename']);
if (strstr($loadfile, '.') || strstr($loadfile, '/') || strstr($loadfile, "\\")) {
    $loadfile = '';
}
if (empty($loadfile)) {
    $loadfile = 'def';
}
$loadfile = 'setsave/' . $loadfile;
@(include $loadfile);

Ejemplo n.º 5

0

Mostrar archivo

Archivo: ListMember.php Proyecto: novnan/meiju

//审核
$schecked = (int) $_GET['schecked'];
if ($schecked) {
    $and = $add ? ' and ' : ' where ';
    if ($schecked == 1) {
        $add .= $and . egetmf('checked') . "=0";
    } else {
        $add .= $and . egetmf('checked') . "=1";
    }
    $search .= "&schecked={$schecked}";
}
$totalquery = "select count(*) as total from " . eReturnMemberTable() . $add;
$num = $empire->gettotal($totalquery);
$query = "select " . eReturnSelectMemberF('*') . " from " . eReturnMemberTable() . $add;
$query .= " order by " . egetmf('userid') . " desc limit {$offset},{$line}";
$sql = $empire->query($query);
$returnpage = page2($num, $line, $page_line, $start, $page, $search);
//----------会员组
$sql1 = $empire->query("select * from {$dbtbpre}enewsmembergroup order by level");
while ($l_r = $empire->fetch($sql1)) {
    if ($groupid == $l_r[groupid]) {
        $select = " selected";
    } else {
        $select = "";
    }
    $group .= "<option value=" . $l_r[groupid] . $select . ">" . $l_r[groupname] . "</option>";
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

Ejemplo n.º 6

0

Mostrar archivo

Archivo: ListMemberGroup.php Proyecto: BGCX261/zjh-dev-svn-to-git

        <input type="button" name="Submit5" value="增加会员组" onclick="self.location.href='AddMemberGroup.php?enews=AddMemberGroup';">
      </div></td>
  </tr>
</table>
<br>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
  <tr class="header"> 
    <td width="6%" height="25"> <div align="center">ID</div></td>
    <td width="35%" height="25"> <div align="center">会员组名称</div></td>
    <td width="11%"><div align="center">级别值</div></td>
    <td width="16%"><div align="center">发送短信息</div></td>
    <td width="14%"><div align="center">注册地址</div></td>
    <td width="18%" height="25"> <div align="center">操作</div></td>
  </tr>
  <?php 
$sql = $empire->query("select * from {$dbtbpre}enewsmembergroup order by groupid");
while ($r = $empire->fetch($sql)) {
    ?>
  <tr bgcolor="#FFFFFF" onmouseout="this.style.backgroundColor='#ffffff'" onmouseover="this.style.backgroundColor='#C3EFFF'"> 
    <td height="25"> <div align="center"> 
        <?php 
    echo $r[groupid];
    ?>
      </div></td>
    <td height="25"> <div align="center"> 
        <?php 
    echo $r[groupname];
    ?>
      </div></td>
    <td><div align="center"> 
        <?php

Ejemplo n.º 7

0

Mostrar archivo

Archivo: AddNews.php Proyecto: BGCX261/zjh-dev-svn-to-git

    $ecmsfirstpost = 1;
} else {
    if (!$doselfinfo['doeditinfo']) {
        printerror("NotEditInfoLevel", "history.go(-1)");
    }
    $filepass = $id;
    $word = '修改信息';
    $ecmsfirstpost = 0;
}
//模型
$modid = $class_r[$classid][modid];
$enter = $emod_r[$modid]['enter'];
//导航
$url = AdminReturnClassLink($classid) . '&nbsp;>&nbsp;' . $word;
//会员组
$sql1 = $empire->query("select groupid,groupname from {$dbtbpre}enewsmembergroup order by level");
while ($l_r = $empire->fetch($sql1)) {
    $ygroup .= "<option value=" . $l_r[groupid] . ">" . $l_r[groupname] . "</option>";
}
if ($enews == "AddNews") {
    $group = str_replace(" value=" . $class_r[$classid][groupid] . ">", " value=" . $class_r[$classid][groupid] . " selected>", $ygroup);
}
//初始化数据
$r = array();
$newstime = time();
$r[newstime] = date("Y-m-d H:i:s");
$todaytime = $r[newstime];
$r[checked] = $class_r[$classid][checked];
$r[newspath] = date($class_r[$classid][newspath]);
$r[onclick] = 0;
$r[userfen] = 0;

Ejemplo n.º 8

0

Mostrar archivo

Archivo: ClassInfoType.php Proyecto: novnan/meiju

}
$classid = (int) $_GET['classid'];
if (!$classid) {
    printerror("ErrorUrl", "history.go(-1)");
}
$cr = $empire->fetch1("select classid,bclassid,modid,classname,islast from {$dbtbpre}enewsclass where classid='{$classid}'");
if (!$cr['classid'] || !$cr['islast'] || !$cr['modid']) {
    printerror("ErrorUrl", "history.go(-1)");
}
$caddr = $empire->fetch1("select ttids from {$dbtbpre}enewsclassadd where classid='{$classid}'");
$url = $cr['classname'] . ' &gt; 设置标题分类';
if ($cr['bclassid']) {
    $bcr = $empire->fetch1("select classid,classname from {$dbtbpre}enewsclass where classid='{$cr['bclassid']}'");
    $url = $bcr['classname'] . ' &gt; ' . $url;
}
$sql = $empire->query("select typeid,tname from {$dbtbpre}enewsinfotype where mid='{$cr['modid']}' order by myorder,typeid");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>设置栏目标题分类</title>
<link href="adminstyle/<?php 
echo $loginadminstyleid;
?>
/adminstyle.css" rel="stylesheet" type="text/css">
<script>
function CheckAll(form)
  {
  	for (var i=0;i<form.elements.length;i++)
    {

Ejemplo n.º 9

0

Mostrar archivo

Archivo: url.php Proyecto: novnan/meiju

    $enews = $_GET['enews'];
}
if ($enews) {
    hCheckEcmsRHash();
}
//增加前缀
if ($enews == "AddDownurl") {
    AddDownurl($_POST, $logininid, $loginin);
} elseif ($enews == "EditDownurl") {
    EditDownurl($_POST, $logininid, $loginin);
} elseif ($enews == "DelDownurl") {
    $urlid = $_GET['urlid'];
    DelDownurl($urlid, $logininid, $loginin);
} else {
}
$sql = $empire->query("select urlid,urlname,url,downtype from {$dbtbpre}enewsdownurlqz order by urlid desc");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>管理下载地址前缀</title>
<link href="../adminstyle/<?php 
echo $loginadminstyleid;
?>
/adminstyle.css" rel="stylesheet" type="text/css">
</head>

<body>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1">
  <tr>

Ejemplo n.º 10

0

Mostrar archivo

Archivo: DoRehtml.php Proyecto: novnan/meiju

$ecms_hashur = hReturnEcmsHashStrAll();
$add = $_GET;
$havehtml = (int) $add['havehtml'];
$add[classid] = RepPostVar($add[classid]);
$add[from] = RepPostStrUrl($add[from]);
$add[retype] = RepPostStr($add[retype], 1);
$add[startday] = RepPostStr($add[startday], 1);
$add[endday] = RepPostStr($add[endday], 1);
$add[startid] = RepPostVar($add[startid]);
$add[endid] = RepPostVar($add[endid]);
$tbname = $add['tbname'];
$count = count($tbname);
//刷新所有表
if (!$count) {
    $j = 0;
    $tsql = $empire->query("select tbname from {$dbtbpre}enewstable where intb=0 order by tid");
    while ($tr = $empire->fetch($tsql)) {
        $tbname[$j] = $tr[tbname];
        $j++;
    }
    $count = count($tbname);
}
esetcookie("retablenum", $count, 0, 1);
esetcookie("rechecktablenum", 0, 0, 1);
$url = "../ecmschtml.php?enews=ReNewsHtml&classid={$add['classid']}&from=" . urlencode($add[from]) . "&retype={$add['retype']}&startday={$add['startday']}&endday={$add['endday']}&startid={$add['startid']}&endid={$add['endid']}&havehtml={$havehtml}&reallinfotime=" . time() . $ecms_hashur['href'];
echo "<link href='../adminstyle/" . $loginadminstyleid . "/adminstyle.css' rel='stylesheet' type='text/css'><center>要刷新的表的总个数为:<font color=red>{$count}</font>个</center><br>";
for ($i = 0; $i < $count; $i++) {
    $tbname[$i] = RepPostVar($tbname[$i]);
    $trueurl = $url . "&tbname=" . $tbname[$i];
    echo "<table width='100%' border=0 align=center cellpadding=3 cellspacing=1 class=tableborder><tr class=header><td>刷新数据表：" . $tbname[$i] . "</td></tr><tr><td bgcolor='#ffffff'><iframe frameborder=0 height=35 id='" . $tbname[$i] . "' scrolling=no \n            src=\"" . $trueurl . "\" \n            width=\"100%\"></iframe></td></tr></table>";
}

Ejemplo n.º 11

0

Mostrar archivo

Archivo: AddTable.php Proyecto: novnan/meiju

$loginadminstyleid = $lur['adminstyleid'];
//ehash
$ecms_hashur = hReturnEcmsHashStrAll();
//验证权限
CheckLevel($logininid, $loginin, $classid, "table");
$enews = RepPostStr($_GET['enews'], 1);
$url = "<a href=ListTable.php" . $ecms_hashur['whehref'] . ">管理数据表</a>&nbsp;>&nbsp;新建数据表";
//修改
if ($enews == "EditTable") {
    $tid = (int) $_GET['tid'];
    $url = "<a href=ListTable.php" . $ecms_hashur['whehref'] . ">管理数据表</a>&nbsp;>&nbsp;修改数据表";
    $r = $empire->fetch1("select tid,tbname,tname,tsay,yhid,intb from {$dbtbpre}enewstable where tid='{$tid}'");
}
//优化方案
$yh_options = '';
$yhsql = $empire->query("select id,yhname from {$dbtbpre}enewsyh order by id");
while ($yhr = $empire->fetch($yhsql)) {
    $select = '';
    if ($r[yhid] == $yhr[id]) {
        $select = ' selected';
    }
    $yh_options .= "<option value='" . $yhr[id] . "'" . $select . ">" . $yhr[yhname] . "</option>";
}
db_close();
$empire = null;
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>新建数据表</title>

Ejemplo n.º 12

0

Mostrar archivo

Archivo: AddM.php Proyecto: novnan/meiju

    $mid = (int) $_GET['mid'];
    $mtype = "";
    $r = $empire->fetch1("select * from {$dbtbpre}enewsmod where mid='{$mid}' and tid='{$tid}'");
    $url = "数据表:[" . $dbtbpre . "ecms_" . $tbname . "]&nbsp;>&nbsp;<a href=ListM.php?tid={$tid}&tbname={$tbname}" . $ecms_hashur['ehref'] . ">系统模型管理</a>&nbsp;>&nbsp;复制系统模型: " . $r['mname'];
}
//修改系统模型
if ($enews == "EditM") {
    $postword = '修改';
    $mid = (int) $_GET['mid'];
    $mtype = "";
    $url = "数据表:[" . $dbtbpre . "ecms_" . $tbname . "]&nbsp;>&nbsp;<a href=ListM.php?tid={$tid}&tbname={$tbname}" . $ecms_hashur['ehref'] . ">系统模型管理</a>&nbsp;>&nbsp;修改系统模型";
    $r = $empire->fetch1("select * from {$dbtbpre}enewsmod where mid='{$mid}' and tid='{$tid}'");
}
//取得字段
$no = 0;
$fsql = $empire->query("select f,fname,iscj,dotemp,tbdataf from {$dbtbpre}enewsf where isshow=1 and tid='{$tid}' order by myorder,fid");
while ($fr = $empire->fetch($fsql)) {
    $no++;
    $bgcolor = "ffffff";
    if ($no % 2 == 0) {
        $bgcolor = "#F8F8F8";
    }
    $like = $field . $fr[f] . $record;
    $slike = "," . $fr[f] . ",";
    //录入项
    if (strstr($r[enter], $like)) {
        $enterchecked = " checked";
        //取得字段标识
        $dor = explode($like, $r[enter]);
        if (strstr($dor[0], $record)) {
            $dor1 = explode($record, $dor[0]);

Ejemplo n.º 13

0

Mostrar archivo

Archivo: AddMemberForm.php Proyecto: BGCX261/zjh-dev-svn-to-git

    $ftype = "";
    $r = $empire->fetch1("select * from {$dbtbpre}enewsmemberform where fid='{$fid}'");
    $url = "<a href='ListMemberForm.php'>管理会员表单</a>&nbsp;>&nbsp;复制会员表单: " . $r['fname'];
    $postword = '复制会员表单';
}
//修改
if ($enews == "EditMemberForm") {
    $fid = (int) $_GET['fid'];
    $ftype = "";
    $url = "<a href='ListMemberForm.php'>管理会员表单</a>&nbsp;>&nbsp;修改会员表单";
    $postword = '修改会员表单';
    $r = $empire->fetch1("select * from {$dbtbpre}enewsmemberform where fid='{$fid}'");
}
//取得字段
$no = 0;
$fsql = $empire->query("select f,fname from {$dbtbpre}enewsmemberf order by myorder,fid");
while ($fr = $empire->fetch($fsql)) {
    $no++;
    $bgcolor = "ffffff";
    if ($no % 2 == 0) {
        $bgcolor = "#F8F8F8";
    }
    $like = $field . $fr[f] . $record;
    $slike = "," . $fr[f] . ",";
    //录入项
    $enterchecked = "";
    if (strstr($r[enter], $like)) {
        $enterchecked = " checked";
        //取得字段标识
        $dor = explode($like, $r[enter]);
        if (strstr($dor[0], $record)) {

Ejemplo n.º 14

0

Mostrar archivo

Archivo: ListInfoDoc.php Proyecto: novnan/meiju

} else {
    $thisclassr = $empire->fetch1("select listorder from {$dbtbpre}enewsclass where classid='{$classid}'");
    if (empty($thisclassr[listorder])) {
        $doorder = "id desc";
    } else {
        $doorder = $thisclassr[listorder];
    }
}
$search .= "&totalnum={$num}";
$search1 = $search;
$search .= "&myorder={$myorder}";
$returnpage = page2($num, $line, $page_line, $start, $page, $search);
$phpmyself = urlencode(eReturnSelfPage(1));
//标题分类
$tts = '';
$ttsql = $empire->query("select typeid,tname from {$dbtbpre}enewsinfotype where mid='{$modid}' order by myorder");
while ($ttr = $empire->fetch($ttsql)) {
    $select = '';
    if ($ttr[typeid] == $ttid) {
        $select = ' selected';
    }
    $tts .= "<option value='{$ttr['typeid']}'" . $select . ">{$ttr['tname']}</option>";
}
$stts = $tts ? "<select name='ttid'><option value='0'>标题分类</option>{$tts}</select>" : "";
//栏目链接
$getcurlr['classid'] = $classid;
$classurl = sys_ReturnBqClassname($getcurlr, 9);
//导入页面
$deftempfile = ECMS_PATH . DASHBOARD . '/data/html/list/doclistinfo.php';
if ($infomod_r[listfile]) {
    $tempfile = ECMS_PATH . DASHBOARD . '/data/html/list/doc' . $infomod_r[listfile] . '.php';

Ejemplo n.º 15

0

Mostrar archivo

Archivo: changetable.php Proyecto: tanny2015/DataStructure

<?php

require 'global.php';
echo '';
require 'class/connect.php';
require 'class/db_sql.php';
require 'class/functions.php';
$rnd = $lur['rnd'];
$link = db_connect();
$empire = new mysqlquery();
$mydbname = RepPostVar($_GET['mydbname']);
if (empty($mydbname)) {
    printerror('NotChangeDb', 'history.go(-1)');
}
$udb = $empire->query('use `' . $mydbname . '`');
$mypath = $mydbname . '_' . date('YmdHis');
if ($phpsafemod) {
    $mypath = 'safemod';
}
$loadfile = RepPostVar($_GET['savefilename']);
if (strstr($loadfile, '.') || strstr($loadfile, '/') || strstr($loadfile, "\\")) {
    $loadfile = '';
}
if (empty($loadfile)) {
    $loadfile = 'def';
}
$loadfile = 'setsave/' . $loadfile;
@(include $loadfile);
if ($dmypath) {
    $mypath = $dmypath;
}

Ejemplo n.º 16

0

Mostrar archivo

Archivo: ChangeDb.php Proyecto: novnan/meiju

$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//ehash
$ecms_hashur = hReturnEcmsHashStrAll();
//验证权限
CheckLevel($logininid, $loginin, $classid, "dbdata");
//默认数据库
if (!empty($public_r['ebakthisdb'])) {
    echo "正转到默认的数据库,请稍等......<script>self.location.href='ChangeTable.php?mydbname=" . $ecms_config['db']['dbname'] . $ecms_hashur['ehref'] . "'</script>";
    exit;
}
$sql = $empire->query("SHOW DATABASES");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>选择数据库</title>
<link href="../adminstyle/<?php 
echo $loginadminstyleid;
?>
/adminstyle.css" rel="stylesheet" type="text/css">
<script>
function DoDrop(dbname)
{var ok;
ok=confirm("确认要删除此数据库?");
if(ok)

Ejemplo n.º 17

0

Mostrar archivo

Archivo: player.php Proyecto: novnan/meiju

if (empty($enews)) {
    $enews = $_GET['enews'];
}
if ($enews) {
    hCheckEcmsRHash();
}
//增加播放器
if ($enews == "AddPlayer") {
    AddPlayer($_POST, $logininid, $loginin);
} elseif ($enews == "EditPlayer") {
    EditPlayer($_POST, $logininid, $loginin);
} elseif ($enews == "DelPlayer") {
    $id = $_GET['id'];
    DelPlayer($id, $logininid, $loginin);
}
$sql = $empire->query("select id,player,filename,bz from {$dbtbpre}enewsplayer order by id");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>增加播放器</title>
<link href="../adminstyle/<?php 
echo $loginadminstyleid;
?>
/adminstyle.css" rel="stylesheet" type="text/css">
</head>

<body>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1">
  <tr>

Ejemplo n.º 18

0

Mostrar archivo

Archivo: infotop.php Proyecto: novnan/meiju

    $sql = $empire->query($query);
    while ($r = $empire->fetch($sql)) {
        $classurl = sys_ReturnBqClassname($r, 9);
        $titleurl = sys_ReturnBqTitleLink($r);
        echo "<tr bgcolor='#ffffff' height='23'><td>[<a href='" . $classurl . "' target='_blank'>" . $class_r[$r[classid]][classname] . "</a>] <a href='{$titleurl}' target='_blank' title='发布时间：" . date("Y-m-d H:i:s", $r[newstime]) . "'>" . stripSlashes($r[title]) . "</a></td><td>" . $r[$field] . "</td></tr>";
    }
    echo "</table>";
}
$where = '';
//数据表
$tbname = RepPostVar($_GET['tbname']);
if (empty($tbname)) {
    $tbname = $public_r['tbname'];
}
$htb = 0;
$tbsql = $empire->query("select tbname,tname from {$dbtbpre}enewstable order by tid");
while ($tbr = $empire->fetch($tbsql)) {
    $select = "";
    if ($tbr[tbname] == $tbname) {
        $htb = 1;
        $select = " selected";
    }
    $tbs .= "<option value='" . $tbr[tbname] . "'" . $select . ">" . $tbr[tname] . "</option>";
}
if ($htb == 0) {
    printerror('ErrorUrl', '');
}
//栏目
$classid = (int) $_GET['classid'];
if ($classid) {
    $and = $where ? ' and ' : ' where ';

Ejemplo n.º 19

0

Mostrar archivo

Archivo: AddBuyGroup.php Proyecto: novnan/meiju

//ehash
$ecms_hashur = hReturnEcmsHashStrAll();
//验证权限
CheckLevel($logininid, $loginin, $classid, "buygroup");
$enews = ehtmlspecialchars($_GET['enews']);
$r[gmoney] = 10;
$r[gfen] = 0;
$r[gdate] = 0;
$url = "<a href=ListBuyGroup.php" . $ecms_hashur['whehref'] . ">管理充值类型</a> &gt; 增加充值类型";
if ($enews == "EditBuyGroup") {
    $id = (int) $_GET['id'];
    $r = $empire->fetch1("select * from {$dbtbpre}enewsbuygroup where id='{$id}' limit 1");
    $url = "<a href=ListBuyGroup.php" . $ecms_hashur['whehref'] . ">管理充值类型</a> &gt; 修改充值类型";
}
//----------会员组
$sql = $empire->query("select groupid,groupname from {$dbtbpre}enewsmembergroup order by level");
while ($level_r = $empire->fetch($sql)) {
    if ($r[ggroupid] == $level_r[groupid]) {
        $select = " selected";
    } else {
        $select = "";
    }
    $group .= "<option value=" . $level_r[groupid] . $select . ">" . $level_r[groupname] . "</option>";
    if ($r[gzgroupid] == $level_r[groupid]) {
        $zselect = " selected";
    } else {
        $zselect = "";
    }
    $zgroup .= "<option value=" . $level_r[groupid] . $zselect . ">" . $level_r[groupname] . "</option>";
    if ($r[buygroupid] == $level_r[groupid]) {
        $bselect = " selected";

Ejemplo n.º 20

0

Mostrar archivo

Archivo: MenuClass.php Proyecto: BGCX261/zjh-dev-svn-to-git

    MenuClassToShow();
    //操作日志
    insert_dolog("del={$del}");
    printerror("EditMenuClassSuccess", "MenuClass.php");
}
$enews = $_POST['enews'];
if (empty($enews)) {
    $enews = $_GET['enews'];
}
if ($enews == "AddMenuClass") {
    AddMenuClass($_POST, $logininid, $loginin);
} elseif ($enews == "EditMenuClass") {
    EditMenuClass($_POST, $logininid, $loginin);
} else {
}
$sql = $empire->query("select classid,classname,issys,myorder,classtype from {$dbtbpre}enewsmenuclass order by myorder,classid");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>管理菜单</title>
<link href="../adminstyle/<?php 
echo $loginadminstyleid;
?>
/adminstyle.css" rel="stylesheet" type="text/css">
<script>
function CheckAll(form)
  {
  for (var i=0;i<form.elements.length;i++)
    {

Ejemplo n.º 21

0

Mostrar archivo

Archivo: PostUrlData.php Proyecto: BGCX261/zjh-dev-svn-to-git

      <td height="25">会员控制面板模板</td>
    </tr>
    <tr> 
      <td height="25"> <div align="center"> 
          <input name="postdata[]" type="checkbox" id="postdata[]7" value="e/class/config.php,e/data/dbcache/class.php,e/data/dbcache/class1.php,e/data/dbcache/ztclass.php,e/data/dbcache/MemberLevel.php!!!1">
        </div></td>
      <td height="25">缓存包 (/e/class/config.php,e/data/dbcache/class.php)</td>
      <td height="25">系统设置的一些参数缓存</td>
    </tr>
    <tr> 
      <td height="25" bgcolor="#DBEAF5"> <div align="center"></div></td>
      <td height="25" bgcolor="#DBEAF5"><strong>站点目录包 (/)</strong></td>
      <td height="25" bgcolor="#DBEAF5">信息栏目存放目录</td>
    </tr>
    <?php 
$sql = $empire->query("select classid,classurl,classname,classpath from {$dbtbpre}enewsclass where bclassid=0 order by classid desc");
while ($r = $empire->fetch($sql)) {
    if ($r[classurl]) {
        $classurl = $r[classurl];
    } else {
        $classurl = "../../" . $r[classpath];
    }
    ?>
    <tr> 
      <td height="25"> <div align="center"> 
          <input name="postdata[]" type="checkbox" id="postdata[]10" value="<?php 
    echo $r[classpath];
    ?>
!!!0">
        </div></td>
      <td height="25"><a href='<?php

Ejemplo n.º 22

0

Mostrar archivo

Archivo: AdminStyle.php Proyecto: BGCX261/zjh-dev-svn-to-git

}
$enews = $_POST['enews'];
if (empty($enews)) {
    $enews = $_GET['enews'];
}
//增加后台样式
if ($enews == "AddAdminStyle") {
    AddAdminstyle($_POST, $logininid, $loginin);
} elseif ($enews == "EditAdminStyle") {
    EditAdminStyle($_POST, $logininid, $loginin);
} elseif ($enews == "DefAdminStyle") {
    DefAdminStyle($_GET['styleid'], $logininid, $loginin);
} elseif ($enews == "DelAdminStyle") {
    DelAdminStyle($_GET['styleid'], $logininid, $loginin);
}
$sql = $empire->query("select styleid,stylename,path,isdefault from {$dbtbpre}enewsadminstyle order by styleid");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title></title>
<link href="../adminstyle/<?php 
echo $loginadminstyleid;
?>
/adminstyle.css" rel="stylesheet" type="text/css">
</head>

<body>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1">
  <tr>

Ejemplo n.º 23

0

Mostrar archivo

Archivo: AddTags.php Proyecto: BGCX261/zjh-dev-svn-to-git

$loginadminstyleid = $lur['adminstyleid'];
//验证权限
CheckLevel($logininid, $loginin, $classid, "tags");
$enews = $_GET['enews'];
$postword = '增加TAGS';
$url = "<a href=ListTags.php>管理TAGS</a> &gt; 增加TAGS";
$fcid = (int) $_GET['fcid'];
//修改
if ($enews == "EditTags") {
    $postword = '修改TAGS';
    $tagid = (int) $_GET['tagid'];
    $r = $empire->fetch1("select tagid,tagname,cid from {$dbtbpre}enewstags where tagid='{$tagid}'");
    $url = "<a href=ListTags.php>管理TAGS</a> -&gt; 修改TAGS：<b>" . $r[tagname] . "</b>";
}
//分类
$csql = $empire->query("select classid,classname from {$dbtbpre}enewstagsclass order by classid");
while ($cr = $empire->fetch($csql)) {
    $select = "";
    if ($r[cid] == $cr[classid]) {
        $select = " selected";
    }
    $cs .= "<option value='" . $cr[classid] . "'" . $select . ">" . $cr[classname] . "</option>";
}
db_close();
$empire = null;
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../adminstyle/<?php

Ejemplo n.º 24

0

Mostrar archivo

Archivo: InfoType.php Proyecto: novnan/meiju

$page_line=12;//每页显示链接数
$offset=$page*$line;//总偏移量
$query="select typeid,tname,mid,myorder,tpath from {$dbtbpre}enewsinfotype";
$totalquery="select count(*) as total from {$dbtbpre}enewsinfotype";
$add='';
$mid=(int)$_GET['mid'];
if($mid)
{
	$add=" where mid='$mid'";
	$search.='&mid='.$mid;
}
$query.=$add;
$totalquery.=$add;
$num=$empire->gettotal($totalquery);//取得总条数
$query=$query." order by myorder,typeid limit $offset,$line";
$sql=$empire->query($query);
$returnpage=page2($num,$line,$page_line,$start,$page,$search);
//模型
$mstr="";
$msql=$empire->query("select mid,mname from {$dbtbpre}enewsmod where usemod=0 order by myorder,mid");
while($mr=$empire->fetch($msql))
{
	$select="";
	if($mr[mid]==$mid)
	{
		$select=" selected";
	}
	$mstr.="<option value='".$mr[mid]."'".$select.">".$mr[mname]."</option>";
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

Ejemplo n.º 25

0

Mostrar archivo

Archivo: index.php Proyecto: BGCX261/zjh-dev-svn-to-git

<?php

require "../../../class/connect.php";
require "../../../class/q_functions.php";
require "../../../class/db_sql.php";
require "../../../class/user.php";
$link = db_connect();
$empire = new mysqlquery();
$editor = 2;
$user = islogin();
$mid = (int) $_GET['mid'];
$out = $_GET['out'];
if (empty($mid)) {
    printerror("HaveNotMsg", "", 1);
}
$r = $empire->fetch1("select mid,title,msgtext,from_userid,from_username,msgtime,haveread,issys from {$dbtbpre}enewsqmsg where mid={$mid} and to_username='******'username']}' limit 1");
if (empty($r[mid])) {
    printerror("HaveNotMsg", "", 1);
}
if ($r['issys']) {
    $r[from_username] = "<b>系统信息</b>";
}
if (!$r['haveread']) {
    $usql = $empire->query("update {$user_tablename} set " . $user_havemsg . "=0 where " . $user_userid . "='{$user['userid']}'");
    $usql = $empire->query("update {$dbtbpre}enewsqmsg set haveread=1 where mid={$mid}");
}
//导入模板
require ECMS_PATH . 'e/template/member/ViewMsg.php';
db_close();
$empire = null;

Ejemplo n.º 26

0

Mostrar archivo

Archivo: AddTask.php Proyecto: novnan/meiju

$url = "<a href='ListTask.php" . $ecms_hashur['whehref'] . "'>管理计划任务</a>  &gt; 增加计划任务";
$postword = '增加计划任务';
$r['isopen'] = 1;
$r['doday'] = '*';
$r['doweek'] = '*';
$r['dohour'] = '*';
$r['dominute'] = ',';
if ($enews == "EditTask") {
    $id = (int) $_GET['id'];
    $r = $empire->fetch1("select * from {$dbtbpre}enewstask where id='{$id}'");
    $url = "<a href='ListTask.php" . $ecms_hashur['whehref'] . "'>管理计划任务</a>  &gt; 修改计划任务：<b>" . $r[taskname] . "</b>";
    $postword = '修改计划任务';
}
//用户
$userselect = '';
$usersql = $empire->query("select userid,username from {$dbtbpre}enewsuser order by userid");
while ($ur = $empire->fetch($usersql)) {
    $select = "";
    if ($ur[userid] == $r[userid]) {
        $select = " selected";
    }
    $userselect .= "<option value='" . $ur[userid] . "'" . $select . ">" . $ur[username] . "</option>";
}
db_close();
$empire = null;
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link href="../adminstyle/<?php

Ejemplo n.º 27

0

Mostrar archivo

Archivo: AddJstemp.php Proyecto: BGCX261/zjh-dev-svn-to-git

$r[showdate] = "[m-d]";
$url = $urlgname . "<a href=ListJstemp.php?gid={$gid}>管理JS模板</a>&nbsp;>&nbsp;增加JS模板";
//复制
if ($enews == "AddJstemp" && $_GET['docopy']) {
    $tempid = (int) $_GET['tempid'];
    $r = $empire->fetch1("select * from " . GetDoTemptb("enewsjstemp", $gid) . " where tempid={$tempid}");
    $url = $urlgname . "<a href=ListJstemp.php?gid={$gid}>管理JS模板</a>&nbsp;>&nbsp;复制JS模板: " . $r[tempname];
}
//修改
if ($enews == "EditJstemp") {
    $tempid = (int) $_GET['tempid'];
    $r = $empire->fetch1("select * from " . GetDoTemptb("enewsjstemp", $gid) . " where tempid={$tempid}");
    $url = $urlgname . "<a href=ListJstemp.php?gid={$gid}>管理JS模板</a>&nbsp;>&nbsp;修改JS模板: " . $r[tempname];
}
//系统模型
$msql = $empire->query("select mid,mname from {$dbtbpre}enewsmod where usemod=0 order by myorder,mid");
while ($mr = $empire->fetch($msql)) {
    if ($mr[mid] == $r[modid]) {
        $select = " selected";
    } else {
        $select = "";
    }
    $mod .= "<option value=" . $mr[mid] . $select . ">" . $mr[mname] . "</option>";
}
//分类
$cstr = "";
$csql = $empire->query("select classid,classname from {$dbtbpre}enewsjstempclass order by classid");
while ($cr = $empire->fetch($csql)) {
    $select = "";
    if ($cr[classid] == $r[classid]) {
        $select = " selected";

Ejemplo n.º 28

0

Mostrar archivo

Archivo: PayApi.php Proyecto: BGCX261/zjh-dev-svn-to-git

        printerror("SetPayFenSuccess", "SetPayFen.php");
    } else {
        printerror("DbError", "history.go(-1)");
    }
}
$enews = $_POST['enews'];
if (empty($enews)) {
    $enews = $_GET['enews'];
}
//增加用户
if ($enews == "EditPayApi") {
    EditPayApi($_POST, $logininid, $loginin);
} elseif ($enews == "SetPayFen") {
    SetPayFen($_POST, $logininid, $loginin);
}
$sql = $empire->query("select payid,paytype,payfee,paylogo,paysay,payname,isclose from {$dbtbpre}enewspayapi order by myorder,payid");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>支付接口</title>
<link href="../adminstyle/<?php 
echo $loginadminstyleid;
?>
/adminstyle.css" rel="stylesheet" type="text/css">
</head>

<body>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1">
  <tr>

Ejemplo n.º 29

0

Mostrar archivo

Archivo: index.php Proyecto: novnan/meiju

    $num = $empire->gettotal($totalquery);
} else {
    //需审核
    if ($class_r[$classid][checkpl]) {
        $totalquery = "select count(*) as total from {$dbtbpre}enewspl_" . $n_r['restb'] . " where pubid='{$pubid}' and checked=0";
        $num = $empire->gettotal($totalquery);
    } else {
        $num = $n_r['plnum'];
    }
}
//排序
$addorder = 'plid desc';
$myorder = (int) $_GET['myorder'];
if ($myorder == 1) {
    $addorder = 'plid';
    $search .= '&myorder=' . $myorder;
}
$query .= " order by " . $addorder . " limit {$offset},{$line}";
$sql = $empire->query($query);
//伪静态
$pagefunr = eReturnRewritePlUrl($classid, $id, $rewritedoaction, $myorder, $rewritetempid, 0);
$pagefunr['repagenum'] = 0;
//分页
if ($pagefunr['rewrite'] == 1) {
    $listpage = InfoUsePage($num, $line, $page_line, $start, $page, $search, $pagefunr);
} else {
    $listpage = page1($num, $line, $page_line, $start, $page, $search);
}
@(require ECMS_PATH . DASHBOARD . '/data/filecache/template/pl' . $tempid . '.php');
db_close();
$empire = null;

Ejemplo n.º 30

0

Mostrar archivo

Archivo: ListField.php Proyecto: novnan/meiju

//ehash
$ecms_hashur = hReturnEcmsHashStrAll();
//验证权限
CheckLevel($logininid, $loginin, $classid, "dbdata");
//数据库
$mydbname = RepPostVar($_GET['mydbname']);
$mytbname = RepPostVar($_GET['mytbname']);
if (empty($mydbname) || empty($mytbname)) {
    printerror("NotChangeBakTable", "history.go(-1)");
}
$form = RepPostVar($_GET['form']);
if (empty($form)) {
    $form = 'ebakchangetb';
}
$usql = $empire->usequery("use `{$mydbname}`");
$sql = $empire->query("SHOW FIELDS FROM `" . $mytbname . "`");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>表字段列表</title>
<link href="../adminstyle/<?php 
echo $loginadminstyleid;
?>
/adminstyle.css" rel="stylesheet" type="text/css">
<script>
function ChangeAutoField(f)
{
	var tbname="<?php 
echo $mytbname;

Ejemplos de mysqlquery::query en PHP