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

Ejemplo n.º 1

0

Mostrar archivo

Archivo: AddPs.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, "shopps");
$enews = ehtmlspecialchars($_GET['enews']);
$url = "<a href=ListPs.php" . $ecms_hashur['whehref'] . ">管理配送方式</a>&nbsp;>&nbsp;增加配送方式";
if ($enews == "EditPs") {
    $pid = (int) $_GET['pid'];
    $r = $empire->fetch1("select * from {$dbtbpre}enewsshopps where pid='{$pid}'");
    $url = "<a href=ListPs.php" . $ecms_hashur['whehref'] . ">管理配送方式</a>&nbsp;>&nbsp;修改配送方式：<b>" . $r[pname] . "</b>";
}
//--------------------html编辑器
include '../ecmseditor/infoeditor/fckeditor.php';
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">
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />
<link href="../adminstyle/<?php 
echo $loginadminstyleid;
?>

Ejemplo n.º 2

0

Mostrar archivo

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

  <tr class="header"> 
    <td width="6%" height="25"><div align="center">ID</div></td>
    <td width="22%" height="25">
<div align="center">碎片名称</div></td>
    <td width="19%"><div align="center">变量名</div></td>
    <td width="15%">
<div align="center">所属分类</div></td>
    <td width="14%"><div align="center">碎片类型</div></td>
    <td width="5%"><div align="center">状态</div></td>
    <td width="19%" height="25"><div align="center">操作</div></td>
  </tr>
  <?php 
while ($r = $empire->fetch($sql)) {
    $spclassname = '--';
    if ($r[cid]) {
        $scr = $empire->fetch1("select classname from {$dbtbpre}enewsspclass where classid='{$r['cid']}'");
        $spclassname = $scr['classname'];
    }
    if ($r[sptype] == 1) {
        $sptypename = '静态信息';
    } elseif ($r[sptype] == 2) {
        $sptypename = '动态信息';
    } else {
        $sptypename = '代码碎片';
    }
    ?>
  <tr bgcolor="#FFFFFF" onmouseout="this.style.backgroundColor='#ffffff'" onmouseover="this.style.backgroundColor='#C3EFFF'"> 
    <td height="32"><div align="center"> 
        <?php 
    echo $r[spid];
    ?>

Ejemplo n.º 3

0

Mostrar archivo

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

$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//验证权限
CheckLevel($logininid, $loginin, $classid, "template");
$gid = (int) $_GET['gid'];
$gname = CheckTempGroup($gid);
$urlgname = $gname . "&nbsp;>&nbsp;";
$cid = $_GET['cid'];
$enews = $_GET['enews'];
$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 = "";

Ejemplo n.º 4

0

Mostrar archivo

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

$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$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">

Ejemplo n.º 5

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.º 6

0

Mostrar archivo

Archivo: index.php Proyecto: novnan/meiju

<?php

require "../../class/connect.php";
$id = (int) $_GET['id'];
$classid = (int) $_GET['classid'];
$enews = $_GET['enews'];
if ($id && $classid) {
    include "../../class/db_sql.php";
    include "../../data/dbcache/class.php";
    include "../../class/q_functions.php";
    $link = db_connect();
    $empire = new mysqlquery();
    $editor = 1;
    if (empty($class_r[$classid][tbname]) || InfoIsInTable($class_r[$classid][tbname])) {
        printerror("ErrorUrl", "", 1);
    }
    //下一条记录
    if ($enews == "next") {
        $where = "id>{$id} and classid='{$classid}' order by id";
    } else {
        $where = "id<{$id} and classid='{$classid}' order by id desc";
    }
    $r = $empire->fetch1("select isurl,titleurl,classid,id from {$dbtbpre}ecms_" . $class_r[$classid][tbname] . " where " . $where . " limit 1");
    if (empty($r[id])) {
        printerror("NotNextInfo", "", 1);
    }
    $titleurl = sys_ReturnBqTitleLink($r);
    db_close();
    $empire = null;
    Header("Location:{$titleurl}");
}

Ejemplo n.º 7

0

Mostrar archivo

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

    $enews = $_GET['enews'];
}
if ($enews == "AddWorkflowItem") {
    AddWorkflowItem($_POST, $logininid, $loginin);
} elseif ($enews == "EditWorkflowItem") {
    EditWorkflowItem($_POST, $logininid, $loginin);
} elseif ($enews == "DelWorkflowItem") {
    DelWorkflowItem($_GET, $logininid, $loginin);
} elseif ($enews == "EditWorkflowItemTno") {
    EditWorkflowItemTno($_POST, $logininid, $loginin);
}
$wfid = (int) $_GET['wfid'];
if (!$wfid) {
    printerror('ErrorUrl', '');
}
$wfr = $empire->fetch1("select wfid,wfname from {$dbtbpre}enewsworkflow where wfid='{$wfid}'");
if (!$wfr['wfid']) {
    printerror('ErrorUrl', '');
}
$query = "select tid,tname,tno,lztype from {$dbtbpre}enewsworkflowitem where wfid='{$wfid}' order by tno,tid";
$sql = $empire->query($query);
$url = "<a href=ListWf.php>管理工作流</a> &gt; " . $wfr[wfname] . " &gt; <a href='ListWfItem.php?wfid={$wfid}'>管理节点</a>";
?>
<!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;
?>

Ejemplo n.º 8

0

Mostrar archivo

Archivo: payend.php Proyecto: novnan/meiju

//操作事件
$phome = getcvar('payphome');
if ($phome == 'PayToFen') {
} elseif ($phome == 'PayToMoney') {
} elseif ($phome == 'ShopPay') {
} elseif ($phome == 'BuyGroupPay') {
} else {
    printerror('您来自的链接不存在', '', 1, 0, 1);
}
$user = array();
if ($phome == 'PayToFen' || $phome == 'PayToMoney' || $phome == 'BuyGroupPay') {
    $user = islogin();
    //是否登陆
}
$paytype = 'chinabank';
$payr = $empire->fetch1("select * from {$dbtbpre}enewspayapi where paytype='{$paytype}' limit 1");
$v_mid = $payr['payuser'];
//商户号
$key = $payr['paykey'];
//密钥
//----------------------------------------------返回信息
$v_oid = trim($_POST['v_oid']);
$v_pmode = trim($_POST['v_pmode']);
$v_pstatus = trim($_POST['v_pstatus']);
$v_pstring = trim($_POST['v_pstring']);
$v_amount = trim($_POST['v_amount']);
$v_moneytype = trim($_POST['v_moneytype']);
$remark1 = trim($_POST['remark1']);
$remark2 = trim($_POST['remark2']);
$v_md5str = trim($_POST['v_md5str']);
//md5

Ejemplo n.º 9

0

Mostrar archivo

Archivo: InfoType.php Proyecto: novnan/meiju

 <form name="infotypeform" method="post" action="InfoType.php" onsubmit="return confirm('确认要提交?');">
 <?=$ecms_hashur['form']?>
   <input name="fmid" type="hidden" id="fmid" value="<?=$mid?>">
   <tr class="header"> 
     <td width="4%"><div align="center">选择 </div></td>
     <td width="6%"><div align="center">ID</div></td>
     <td width="4%"><div align="center">排序</div></td>
     <td width="32%" height="25"><div align="center">分类名称</div></td>
     <td width="21%"><div align="center">所属系统模型</div></td>
     <td width="16%" height="25"><div align="center">操作</div></td>
     <td width="17%">操作</td>
   </tr>
   <?php
 while($r=$empire->fetch($sql))
 {
 	$modr=$empire->fetch1("select mid,mname from {$dbtbpre}enewsmod where mid='$r[mid]'");
 	$turl=sys_ReturnBqInfoTypeUrl($r['typeid']);
 ?>
   <tr bgcolor="#FFFFFF"> 
     <td><div align="center"> 
         <input name="classid[]" type="checkbox" id="classid[]" value="<?=$r[typeid]?>">
       </div></td>
     <td><div align="center"> 
         <?=$r[typeid]?>
         <input name="typeid[]" type="hidden" id="typeid[]" value="<?=$r[typeid]?>">
       </div></td>
     <td><div align="center"> 
         <input name="myorder[]" type="text" id="myorder[]" value="<?=$r[myorder]?>" size="6">
       </div></td>
     <td height="25"> <div align="center"><a href="<?=$turl?>" target="_blank"> 
         <?=$r[tname]?>

Ejemplo n.º 10

0

Mostrar archivo

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

<?php

require "../class/connect.php";
require "../class/db_sql.php";
$link = db_connect();
$empire = new mysqlquery();
//关闭投稿
if ($public_r['addnews_ok']) {
    printerror("CloseQAdd", "", 1);
}
//验证IP
eCheckAccessDoIp('postinfo');
$mid = (int) $_GET['mid'];
if (empty($mid)) {
    printerror("ErrorUrl", "", 1);
}
$mr = $empire->fetch1("select mid,qenter,qmname from {$dbtbpre}enewsmod where mid='{$mid}'");
if (!$mr['mid'] || !$mr['qenter']) {
    printerror("ErrorUrl", "", 1);
}
$muserid = (int) getcvar('mluserid');
$musername = RepPostVar(getcvar('mlusername'));
if (empty($musername)) {
    $musername = "******";
}
$classjs = $public_r['newsurl'] . "d/js/js/addinfo" . $mid . ".js";
//导入模板
require ECMS_PATH . 'e/template/DoInfo/ChangeClass.php';
db_close();
$empire = null;

Ejemplo n.º 11

0

Mostrar archivo

Archivo: ShowInfo.php Proyecto: novnan/meiju

require '../data/dbcache/class.php';
require '../data/dbcache/MemberLevel.php';
$link = db_connect();
$empire = new mysqlquery();
$classid = (int) $_GET['classid'];
$id = (int) $_GET['id'];
$page = (int) $_GET['page'];
$page = RepPIntvar($page);
$mid = $class_r[$classid]['modid'];
$tbname = $class_r[$classid]['tbname'];
//验证IP
eCheckAccessDoIp('showinfo');
if (!$classid || !$id || !$mid || !$tbname || InfoIsInTable($tbname)) {
    printerror('此信息不存在', '', 1, 0, 1);
}
$r = $empire->fetch1("select * from {$dbtbpre}ecms_" . $tbname . " where id='{$id}' limit 1");
if (!$r['id'] || $classid != $r['classid']) {
    printerror('此信息不存在', '', 1, 0, 1);
}
//外部链接
if ($r['isurl']) {
    $titleurl = $r['titleurl'];
    Header("Location:{$titleurl}");
    exit;
}
//moreport
if (Moreport_ReturnMustDt()) {
    $class_r[$classid]['showdt'] = 2;
}
//是否支持动态内容页
if ($class_r[$classid]['showdt'] != 2) {

Ejemplo n.º 12

0

Mostrar archivo

Archivo: index.php Proyecto: novnan/meiju

require '../../data/dbcache/class.php';
require '../' . LoadLang('pub/fun.php');
$link = db_connect();
$empire = new mysqlquery();
$editor = 1;
$classid = (int) $_GET['classid'];
if (empty($classid)) {
    printerror("ErrorUrl", "history.go(-1)", 1);
}
$search = '&classid=' . $classid;
$tbname = $class_r[$classid][tbname];
$mid = $class_r[$classid][modid];
if (empty($tbname) || empty($mid) || InfoIsInTable($tbname)) {
    printerror("ErrorUrl", "history.go(-1)", 1);
}
$cr = $empire->fetch1("select classid,classpagekey,intro,classimg,cgroupid,islist,classtempid,listdt,bdinfoid,repagenum,islast,infos from {$dbtbpre}enewsclass where classid='{$classid}'");
if (empty($cr['classid'])) {
    printerror("ErrorUrl", "history.go(-1)", 1);
}
if ($class_r[$classid][islast] && $cr['bdinfoid']) {
    printerror("ErrorUrl", "history.go(-1)", 1);
}
//moreport
if (Moreport_ReturnMustDt()) {
    $class_r[$classid]['listdt'] = 1;
    $cr['repagenum'] = 0;
    $cr['listdt'] = 1;
}
//是否支持动态页
if (empty($class_r[$classid]['listdt']) && !$cr['repagenum']) {
    $classurl = sys_ReturnBqClassname($cr, 9);

Ejemplo n.º 13

0

Mostrar archivo

Archivo: index.php Proyecto: novnan/meiju

</strong>的查询结果</td>
							</tr>
						</table>
						
<?php 
$no = $offset;
$subnum = 120;
$formatdate = "Y-m-d H:i:s";
while ($r = $empire->fetch($sql)) {
    $tbname = $class_r[$r[classid]]['tbname'];
    if (empty($tbname)) {
        continue;
    }
    $titlefield = $schalltb_r[$tbname]['titlefield'];
    $smalltextfield = $schalltb_r[$tbname]['smalltextfield'];
    $infor = $empire->fetch1("select id,classid,titlepic,newstime,isurl,titleurl," . $titlefield . "," . $smalltextfield . " from {$dbtbpre}ecms_" . $tbname . " where id='{$r['id']}' limit 1");
    if (empty($infor['id'])) {
        continue;
    }
    $no++;
    $titleurl = sys_ReturnBqTitleLink($infor);
    $titlepic = $infor['titlepic'] ? $infor['titlepic'] : $public_r['newsurl'] . "e/data/images/notimg.gif";
    $smalltext = SubSchallSmalltext($infor[$smalltextfield], $subnum);
    $title = DoReplaceFontRed($infor[$titlefield], $keyboard);
    $smalltext = DoReplaceFontRed($smalltext, $keyboard);
    $newstime = date($formatdate, $infor['newstime']);
    ?>

						<h2 class="r"><span><?php 
    echo $no;
    ?>

Ejemplo n.º 14

0

Mostrar archivo

Archivo: AddAddress.php Proyecto: novnan/meiju

<?php

require "../../class/connect.php";
require "../../class/q_functions.php";
require "../../class/db_sql.php";
require "../../member/class/user.php";
require "../class/ShopSysFun.php";
$link = db_connect();
$empire = new mysqlquery();
$editor = 1;
eCheckCloseMods('shop');
//关闭模块
$user = islogin();
$enews = RepPostStr($_GET['enews'], 1);
if (empty($enews)) {
    $enews = "AddAddress";
}
$r = array();
$addressid = (int) $_GET['addressid'];
if ($enews == 'EditAddress') {
    $r = $empire->fetch1("select * from {$dbtbpre}enewsshop_address where addressid='{$addressid}' and userid='{$user['userid']}' limit 1");
}
//导入模板
require ECMS_PATH . DASHBOARD . '/template/ShopSys/AddAddress.php';
db_close();
$empire = null;

Ejemplo n.º 15

0

Mostrar archivo

Archivo: AddBuyGroup.php Proyecto: novnan/meiju

$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//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 = "";

Ejemplo n.º 16

0

Mostrar archivo

Archivo: SetSpace.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 = 1;
$user = islogin();
$addr = $empire->fetch1("select spacename,spacegg from {$dbtbpre}enewsmemberadd where userid='{$user['userid']}' limit 1");
//µ¼ÈëÄ£°å
require ECMS_PATH . 'e/template/member/mspace/SetSpace.php';
db_close();
$empire = null;

Ejemplo n.º 17

0

Mostrar archivo

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

if (strstr($enter, ',downpath,') || strstr($enter, ',onlinepath,')) {
    $downurlqz = "";
    $newdownqz = "";
    $downsql = $empire->query("select urlname,url,urlid from {$dbtbpre}enewsdownurlqz order by urlid");
    while ($downr = $empire->fetch($downsql)) {
        $downurlqz .= "<option value='" . $downr[url] . "'>" . $downr[urlname] . "</option>";
        $newdownqz .= "<option value='" . $downr[urlid] . "'>" . $downr[urlname] . "</option>";
    }
}
//html编辑器
if ($emod_r[$modid]['editorf'] && $emod_r[$modid]['editorf'] != ',') {
    include 'ecmseditor/infoeditor/fckeditor.php';
}
//预设投票
if ($enews == "AddNews") {
    $infoclassr = $empire->fetch1("select definfovoteid from {$dbtbpre}enewsclass where classid='{$classid}'");
    $definfovoteid = 0;
    if ($infoclassr['definfovoteid']) {
        $definfovoteid = $infoclassr['definfovoteid'];
    } elseif ($emod_r[$modid]['definfovoteid']) {
        $definfovoteid = $emod_r[$modid]['definfovoteid'];
    }
    if ($definfovoteid) {
        //投票
        $voter = $empire->fetch1("select * from {$dbtbpre}enewsvotemod where voteid='{$definfovoteid}'");
        if ($voter['voteid'] && $voter[votetext]) {
            $d_record = explode("\r\n", $voter[votetext]);
            for ($i = 0; $i < count($d_record); $i++) {
                $j = $i + 1;
                $d_field = explode("::::::", $d_record[$i]);
                $allvote .= "<tr><td width='9%'><div align=center>" . $j . "</div></td><td width='65%'><input name=vote_name[] type=text value='" . $d_field[0] . "' size=30></td><td width='26%'><input name=vote_num[] type=text value='" . $d_field[1] . "' size=6></td></tr>";

Ejemplo n.º 18

0

Mostrar archivo

Archivo: index.php Proyecto: novnan/meiju

require '../class/functions.php';
require '../class/t_functions.php';
require '../data/dbcache/class.php';
require LoadLang('pub/fun.php');
$link = db_connect();
$empire = new mysqlquery();
if (!$public_r['opentags']) {
    printerror('CloseTags', '', 1);
}
$add = '';
$search = '';
$GLOBALS['navclassid'] = 0;
//TAGS
$tagid = (int) $_GET['tagid'];
if ($tagid) {
    $tagr = $empire->fetch1("select tagname,num from {$dbtbpre}enewstags where tagid='{$tagid}'");
    if (!$tagr['tagname']) {
        printerror('HaveNotTags', '', 1);
    }
    $tagname = $tagr['tagname'];
    $num = $tagr['num'];
    $search .= "&tagid={$tagid}";
} else {
    $tagname = RepPostVar($_GET['tagname']);
    if (!$tagname) {
        printerror('HaveNotTags', '', 1);
    }
    $tagr = $empire->fetch1("select tagid,num from {$dbtbpre}enewstags where tagname='{$tagname}' limit 1");
    if (!$tagr['tagid']) {
        printerror('HaveNotTags', '', 1);
    }

Ejemplo n.º 19

0

Mostrar archivo

Archivo: AddVotetemp.php Proyecto: novnan/meiju

$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//ehash
$ecms_hashur = hReturnEcmsHashStrAll();
//验证权限
CheckLevel($logininid, $loginin, $classid, "template");
$gid = (int) $_GET['gid'];
$gname = CheckTempGroup($gid);
$urlgname = $gname . "&nbsp;>&nbsp;";
$enews = ehtmlspecialchars($_GET['enews']);
$url = $urlgname . "<a href=ListVotetemp.php?gid={$gid}" . $ecms_hashur['ehref'] . ">管理投票模板</a>&nbsp;>&nbsp;增加投票模板";
//复制
if ($enews == "AddVoteTemp" && $_GET['docopy']) {
    $tempid = (int) $_GET['tempid'];
    $r = $empire->fetch1("select tempid,tempname,temptext from " . GetDoTemptb("enewsvotetemp", $gid) . " where tempid={$tempid}");
    $url = $urlgname . "<a href=ListVotetemp.php?gid={$gid}" . $ecms_hashur['ehref'] . ">管理投票模板</a>&nbsp;>&nbsp;复制投票模板：<b>" . $r[tempname] . "</b>";
}
//修改
if ($enews == "EditVoteTemp") {
    $tempid = (int) $_GET['tempid'];
    $r = $empire->fetch1("select tempid,tempname,temptext from " . GetDoTemptb("enewsvotetemp", $gid) . " where tempid={$tempid}");
    $url = $urlgname . "<a href=ListVotetemp.php?gid={$gid}" . $ecms_hashur['ehref'] . ">管理投票模板</a>&nbsp;>&nbsp;修改投票模板：<b>" . $r[tempname] . "</b>";
}
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">

Ejemplo n.º 20

0

Mostrar archivo

Archivo: ChangeDataTableF.php Proyecto: novnan/meiju

$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//ehash
$ecms_hashur = hReturnEcmsHashStrAll();
//验证权限
CheckLevel($logininid, $loginin, $classid, "f");
$fid = (int) $_GET['fid'];
$tid = (int) $_GET['tid'];
$tbname = RepPostVar($_GET['tbname']);
if (!$fid || !$tid || !$tbname) {
    printerror("ErrorUrl", "history.go(-1)");
}
$fr = $empire->fetch1("select fid,f,fname,isadd,tid,tbname,tbdataf from {$dbtbpre}enewsf where fid='{$fid}'");
if (!$fr[fid]) {
    printerror("ErrorUrl", "history.go(-1)");
}
if (empty($fr[isadd])) {
    printerror("NotIsAdd", "history.go(-1)");
}
$tid = $fr[tid];
$tbname = $fr[tbname];
if ($fr[tbdataf]) {
    $doing = '字段转移到主表';
} else {
    $doing = '字段转移到副表';
}
$url = "数据表:[" . $dbtbpre . "ecms_" . $tbname . "]&nbsp;>&nbsp;<a href=ListF.php?tid={$tid}&tbname={$tbname}" . $ecms_hashur['ehref'] . ">字段管理</a>&nbsp;>&nbsp;" . $doing;
db_close();

Ejemplo n.º 21

0

Mostrar archivo

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

require "../../class/functions.php";
require "../../class/user.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'];
//验证权限
CheckLevel($logininid, $loginin, $classid, "spacedata");
$fid = (int) $_GET['fid'];
$r = $empire->fetch1("select fid,name,company,phone,fax,email,address,zip,title,ftext,userid,ip,uid,uname,addtime,userid from {$dbtbpre}enewsmemberfeedback where fid='{$fid}'");
if (!$r['fid']) {
    printerror('ErrorUrl', '', 1);
}
if ($r['uid']) {
    $r['uname'] = "<a href='../../space/?userid={$r['uid']}' target='_blank'>{$r['uname']}</a>";
} else {
    $r['uname'] = '游客';
}
$ur = $empire->fetch1("select " . $user_username . " from " . $user_tablename . " where " . $user_userid . "='{$r['userid']}'");
$username = doUtfAndGbk($ur[$user_username], 1);
db_close();
$empire = null;
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>

Ejemplo n.º 22

0

Mostrar archivo

Archivo: AddTask.php Proyecto: novnan/meiju

        }
        $options .= "<option value='" . $i . "'" . $select . ">" . $i . "</option>";
    }
    echo $options;
}
$enews = ehtmlspecialchars($_GET['enews']);
$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;

Ejemplo n.º 23

0

Mostrar archivo

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

        </div></td>
    </tr>
  </form>
</table>
<form name="form1" method="post" action="MemberFeedback.php" onsubmit="return confirm('确认要删除?');">
  <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class=tableborder>
    <tr class=header> 
      <td width="7%" height="23"><div align="center">ID</div></td>
      <td width="43%" height="23"><div align="center">标题(点击查看)</div></td>
      <td width="20%" height="23"><div align="center">空间主人</div></td>
      <td width="18%" height="23"><div align="center">发布时间</div></td>
      <td width="12%" height="23"><div align="center">操作</div></td>
    </tr>
    <?php 
while ($r = $empire->fetch($sql)) {
    $ur = $empire->fetch1("select " . $user_username . " from " . $user_tablename . " where " . $user_userid . "='{$r['userid']}'");
    $username = doUtfAndGbk($ur[$user_username], 1);
    if ($r['uid']) {
        $r['uname'] = "<a href='../../space/?userid={$r['uid']}' target='_blank'>{$r['uname']}</a>";
    } else {
        $r['uname'] = '游客';
    }
    ?>
    <tr bgcolor="#FFFFFF" onmouseout="this.style.backgroundColor='#ffffff'" onmouseover="this.style.backgroundColor='#C3EFFF'"> 
      <td height="25"><div align="center"> 
          <?php 
    echo $r[fid];
    ?>
        </div></td>
      <td height="25"><div align="left"><a href="#ecms" onclick="window.open('MemberShowFeedback.php?fid=<?php 
    echo $r[fid];

Ejemplo n.º 24

0

Mostrar archivo

Archivo: ListError.php Proyecto: novnan/meiju

  </form>
</table>
<form name="form1" method="post" action="ListError.php" onsubmit="return confirm('确认要删除？');">
<?php 
echo $ecms_hashur['form'];
?>
<input type=hidden name=cid value="<?php 
echo $cid;
?>
">
<?
while($r=$empire->fetch($sql))
{
	if($class_r[$r[classid]][tbname])
	{
		$tr=$empire->fetch1("select title,isurl,titleurl,classid,id from {$dbtbpre}ecms_".$class_r[$r[classid]][tbname]." where id='$r[id]' limit 1");
		$titleurl=sys_ReturnBqTitleLink($tr);
	}
	//分类
	$cr[classname]="---";
	if($r[cid])
	{
		$cr=$empire->fetch1("select classname,classid from {$dbtbpre}enewserrorclass where classid='$r[cid]' limit 1");
	}
?>
  <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
    <tr bgcolor="#FFFFFF" class="header"> 
      <td width="57%" height="25">信息标题：<a href="<?php 
echo $titleurl;
?>
" target=_blank>

Ejemplo n.º 25

0

Mostrar archivo

Archivo: AddInfoClass.php Proyecto: novnan/meiju

$r[num] = 0;
$r[renum] = 2;
$r[relistnum] = 1;
$r[insertnum] = 10;
$r[keynum] = 0;
$r[keeptime] = 0;
$r[smalltextlen] = 200;
$r[titlelen] = 0;
$r['getfirstspicw'] = $public_r['spicwidth'];
$r['getfirstspich'] = $public_r['spicheight'];
$pagetype0 = "";
$pagetype1 = " checked";
//复制结点
if ($docopy) {
    $classid = (int) $_GET['classid'];
    $r = $empire->fetch1("select * from {$dbtbpre}enewsinfoclass where classid='{$classid}'");
    //采集节点
    if ($r[newsclassid]) {
        $ra = $empire->fetch1("select * from {$dbtbpre}ecms_infoclass_" . $r[tbname] . " where classid='{$classid}'");
        $r = TogTwoArray($r, $ra);
    }
    if (empty($r[pagetype])) {
        $pagetype0 = " checked";
        $pagetype1 = "";
    } else {
        $pagetype0 = "";
        $pagetype1 = " checked";
    }
    $url = "采集&nbsp;>&nbsp;<a href=" . $listclasslink . $ecms_hashur['whehref'] . ">管理节点</a>&nbsp;>&nbsp;复制节点：" . $r[classname];
    $r[classname] .= "(1)";
}

Ejemplo n.º 26

0

Mostrar archivo

Archivo: index.php Proyecto: novnan/meiju

$empire = new mysqlquery();
$editor = 1;
$ecmsreurl = 2;
//验证IP
eCheckAccessDoIp('downinfo');
$id = (int) $_GET['id'];
$pathid = (int) $_GET['pathid'];
$classid = (int) $_GET['classid'];
if (!$classid || empty($class_r[$classid][tbname]) || !$id) {
    echo "<script>alert('此信息不存在');window.close();</script>";
    exit;
}
$mid = $class_r[$classid][modid];
$tbname = $class_r[$classid][tbname];
$query = "select * from {$dbtbpre}ecms_" . $tbname . " where id='{$id}' limit 1";
$r = $empire->fetch1($query);
if (!$r['id'] || $r['classid'] != $classid) {
    echo "<script>alert('此信息不存在');window.close();</script>";
    exit;
}
//副表
$finfor = $empire->fetch1("select " . ReturnSqlFtextF($mid) . " from {$dbtbpre}ecms_" . $tbname . "_data_" . $r[stb] . " where id='{$r['id']}' limit 1");
$r = array_merge($r, $finfor);
//区分下载地址
$path_r = explode("\r\n", $r[downpath]);
if (!$path_r[$pathid]) {
    echo "<script>alert('此信息不存在');window.close();</script>";
    exit;
}
$showdown_r = explode("::::::", $path_r[$pathid]);
//下载权限

Ejemplo n.º 27

0

Mostrar archivo

Archivo: ListMoreport.php Proyecto: novnan/meiju

      <td width="11%"><div align="center">强制动态页模式</div></td>
      <td width="11%"><div align="center">状态</div></td>
      <td width="19%" height="25"> <div align="center">操作</div></td>
    </tr>
    <?
  while($r=$empire->fetch($sql))
  {
	//主访问端
	if($r['pid']==1)
	{
		$r['pname']='<b>'.$r['pname'].'</b>';
		if(empty($r['purl']))
		{
			$r['purl']=$public_r['newsurl'];
		}
		$tgr=$empire->fetch1("select gid,gname,isdefault from {$dbtbpre}enewstempgroup where isdefault=1");
	}
	else
	{
		$tgr=$empire->fetch1("select gid,gname,isdefault from {$dbtbpre}enewstempgroup where gid='$r[tempgid]'");
	}
  ?>
    <tr bgcolor="#FFFFFF" onmouseout="this.style.backgroundColor='#ffffff'" onmouseover="this.style.backgroundColor='#C3EFFF'"> 
      <td height="25"> <div align="center"> 
          <?php 
echo $r[pid];
?>
        </div></td>
      <td height="25"> <div align="center"> 
	  <a href="<?php 
echo $r[purl];

Ejemplo n.º 28

0

Mostrar archivo

Archivo: MemberGbook.php Proyecto: novnan/meiju

>留言者IP</option>
          </select>
          <input type="submit" name="Submit" value="搜索">
          <input name="sear" type="hidden" id="sear" value="1">
        </div></td>
  </tr>
</form>
</table>
<form name=thisform method=post action=MemberGbook.php onsubmit="return confirm('确认要执行操作?');">
<?php 
echo $ecms_hashur['form'];
?>
<?
while($r=$empire->fetch($sql))
{
	$ur=$empire->fetch1("select ".egetmf('username')." from ".eReturnMemberTable()." where ".egetmf('userid')."='$r[userid]'");
	if($r['uid'])
	{
		$r['uname']="<b><a href='../../space/?userid=$r[uid]' target='_blank'>$r[uname]</a></b>";
	}
	$username=$ur['username'];
	$private='';
	if($r['isprivate'])
	{
		$private='<b>[悄悄话]</b>';
	}
?>
  <table width="700" border="0" align="center" cellpadding="3" cellspacing="1" class=tableborder>
    <tr class=header> 
      <td width="55%" height="23">发布者: 
        <?php

Ejemplo n.º 29

0

Mostrar archivo

Archivo: index.php Proyecto: novnan/meiju

$lpassword = '';
if ($lusername) {
    $lusername = RepPostVar($lusername);
    $lpassword = md5($lusername);
}
$id = (int) $_GET['id'];
$classid = (int) $_GET['classid'];
//专题
$doaction = $_GET['doaction'] == 'dozt' ? 'dozt' : '';
$rewritedoaction = 'doinfo';
if ($doaction == 'dozt') {
    $rewritedoaction = 'dozt';
    if (empty($classid)) {
        printerror("ErrorUrl", "history.go(-1)", 1);
    }
    $n_r = $empire->fetch1("select ztid,ztname,intro,ztimg,ztpagekey,restb from {$dbtbpre}enewszt where ztid='{$classid}'");
    if (!$n_r['ztid']) {
        printerror("ErrorUrl", "history.go(-1)", 1);
    }
    $pubid = '-' . $classid;
    $search = "&doaction=dozt&classid={$classid}";
    //标题链接
    $titleurl = sys_ReturnBqZtname($n_r);
    $title = stripSlashes($n_r['ztname']);
    $pagetitle = ehtmlspecialchars($title);
    //评分
    $infopfennum = 0;
    $pinfopfen = 0;
    $url = ReturnZtLink($n_r['ztid']) . "&nbsp;>&nbsp;" . $fun_r[pl];
} else {
    if (empty($id) || empty($classid)) {

Ejemplo n.º 30

0

Mostrar archivo

Archivo: BuyGroupPay.php Proyecto: novnan/meiju

//关闭模块
$link = db_connect();
$empire = new mysqlquery();
//是否登陆
$user = islogin();
//支付平台
$payid = intval($_POST['payid']);
if (!$payid) {
    printerror('请选择支付平台', '', 1, 0, 1);
}
//充值类型
$id = intval($_POST['id']);
if (!$id) {
    printerror('请选择充值类型', '', 1, 0, 1);
}
$payr = $empire->fetch1("select * from {$dbtbpre}enewspayapi where payid='{$payid}' and isclose=0 limit 1");
if (!$payr[payid]) {
    printerror('请选择支付平台', '', 1, 0, 1);
}
$buyr = $empire->fetch1("select * from {$dbtbpre}enewsbuygroup where id='{$id}'");
if (!$buyr['id']) {
    printerror('请选择充值类型', '', 1, 0, 1);
}
//权限
if ($buyr[buygroupid] && $level_r[$buyr[buygroupid]][level] > $level_r[$user[groupid]][level]) {
    printerror('此充值类型需要 ' . $level_r[$buyr[buygroupid]][groupname] . ' 会员级别以上', '', 1, 0, 1);
}
include 'payfun.php';
$money = $buyr['gmoney'];
if (!$money) {
    printerror('此充值类型金额有误', '', 1, 0, 1);

Ejemplos de mysqlquery::fetch1 en PHP