当前位置: 首页>>代码示例>>PHP>>正文

PHP mysqlquery::fetch1方法代码示例

本文整理汇总了PHP中mysqlquery::fetch1方法的典型用法代码示例。如果您正苦于以下问题：PHP mysqlquery::fetch1方法的具体用法？PHP mysqlquery::fetch1怎么用？PHP mysqlquery::fetch1使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类mysqlquery的用法示例。


在下文中一共展示了mysqlquery::fetch1方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: hReturnEcmsHashStrAll

//验证用户
$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;
?>
开发者ID:novnan，项目名称:meiju，代码行数:31，代码来源:AddPs.php

示例2: elseif

  <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];
    ?>
开发者ID:BGCX261，项目名称:zjh-dev-svn-to-git，代码行数:31，代码来源:ListSp.php

示例3: CheckTempGroup

$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 = "";
开发者ID:BGCX261，项目名称:zjh-dev-svn-to-git，代码行数:31，代码来源:AddJstemp.php

示例4: 

$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">
开发者ID:BGCX261，项目名称:zjh-dev-svn-to-git，代码行数:31，代码来源:AddTags.php

示例5: mysqlquery

<?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='{$user['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;
开发者ID:BGCX261，项目名称:zjh-dev-svn-to-git，代码行数:30，代码来源:index.php

示例6: mysqlquery

<?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}");
}
开发者ID:novnan，项目名称:meiju，代码行数:31，代码来源:index.php

示例7: AddWorkflowItem

    $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;
?>
开发者ID:BGCX261，项目名称:zjh-dev-svn-to-git，代码行数:31，代码来源:ListWfItem.php

示例8: getcvar

//操作事件
$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
开发者ID:novnan，项目名称:meiju，代码行数:31，代码来源:payend.php

示例9: confirm

 <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]?>
开发者ID:novnan，项目名称:meiju，代码行数:31，代码来源:InfoType.php

示例10: mysqlquery

<?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;
开发者ID:BGCX261，项目名称:zjh-dev-svn-to-git，代码行数:30，代码来源:ChangeClass.php

示例11: mysqlquery

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) {
开发者ID:novnan，项目名称:meiju，代码行数:31，代码来源:ShowInfo.php

示例12: LoadLang

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);
开发者ID:novnan，项目名称:meiju，代码行数:31，代码来源:index.php

示例13: SubSchallSmalltext

</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;
    ?>
开发者ID:novnan，项目名称:meiju，代码行数:31，代码来源:index.php

示例14: mysqlquery

<?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;
开发者ID:novnan，项目名称:meiju，代码行数:26，代码来源:AddAddress.php

示例15: hReturnEcmsHashStrAll

$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 = "";
开发者ID:novnan，项目名称:meiju，代码行数:31，代码来源:AddBuyGroup.php


注：本文中的mysqlquery::fetch1方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。