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

PHP mysqlquery类代码示例

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


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

示例1: get_success_happy_drop_down

 function get_success_happy_drop_down($arg_success_item_id, $arg_share_id)
 {
     if (strlen($arg_success_item_id)) {
         // Gimme rafl happy results
         $query = "SELECT DISTINCT {$_SESSION['RealS_prefix']}members.mb_firstname, {$_SESSION['RealS_prefix']}members.mb_surmame\r\n\t\t\t\t          FROM {$_SESSION['RealS_prefix']}items\r\n\t\t\t\t          \tINNER JOIN {$_SESSION['RealS_prefix']}webcells ON {$_SESSION['RealS_prefix']}webcells.webcell_id = {$_SESSION['RealS_prefix']}items.item_webcell\r\n\t\t\t\t          \tINNER JOIN {$_SESSION['RealS_prefix']}rafl_res ON {$_SESSION['RealS_prefix']}items.item_id = {$_SESSION['RealS_prefix']}rafl_res.rafl_res_item \r\n\t\t\t\t          \tINNER JOIN {$_SESSION['RealS_prefix']}items AS successes ON successes.item_id = {$_SESSION['RealS_prefix']}items.item_parent_item \r\n\t\t\t\t          \tINNER JOIN {$_SESSION['RealS_prefix']}items AS tasks ON tasks.item_id = successes.item_parent_item \r\n\t\t\t\t          \tINNER JOIN {$_SESSION['RealS_prefix']}items AS units ON units.item_id = tasks.item_parent_item \r\n\t\t\t\t          \tINNER JOIN {$_SESSION['RealS_prefix']}share ON {$_SESSION['RealS_prefix']}share.share_item = units.item_id \r\n\t\t\t\t          \tINNER JOIN {$_SESSION['RealS_prefix']}share_cohort_members ON ({$_SESSION['RealS_prefix']}share_cohort_members.s_c_m_share = {$_SESSION['RealS_prefix']}share.share_id AND {$_SESSION['RealS_prefix']}webcells.webcell_member = {$_SESSION['RealS_prefix']}share_cohort_members.s_c_m_member)\r\n\t\t\t\t          \tINNER JOIN {$_SESSION['RealS_prefix']}members ON {$_SESSION['RealS_prefix']}members.mb_id = {$_SESSION['RealS_prefix']}share_cohort_members.s_c_m_member\r\n\t\t\t\t          WHERE {$_SESSION['RealS_prefix']}items.item_parent_item = " . GetSQLValueString($arg_success_item_id, "int") . "\r\n\t\t\t\t          \tAND {$_SESSION['RealS_prefix']}share.share_id =  " . GetSQLValueString($arg_share_id, 'int') . "\r\n\t\t\t\t          \tAND {$_SESSION['RealS_prefix']}members.mb_type != 'cohort'\r\n\t\t\t\t          \tAND {$_SESSION['RealS_prefix']}items.item_default_type = 6\r\n\t\t\t\t          \tAND rafl_res_rate = 2\r\n\t\t\t\t          ORDER BY {$_SESSION['RealS_prefix']}members.mb_firstname, {$_SESSION['RealS_prefix']}members.mb_surmame";
         // Debugging
         //echo $query;
         $mysql = new mysqlquery();
         $rows = $mysql->getrows($query);
         if (count($rows)) {
             $drop_down = '<select size="1" class="who_is">';
             //$drop_down .= '		<option>who is happy?</option>';
             foreach ($rows as $row) {
                 $drop_down .= '	<option>' . trim($row['mb_firstname'] . ' ' . $row['mb_surmame']) . '</option>';
             }
             $drop_down .= '</select>';
             return $drop_down;
         } else {
             return '&nbsp;';
         }
     } else {
         return '&nbsp;';
     }
 }
开发者ID:nadavkav，项目名称:MoodleTAO，代码行数:24，代码来源:class_rafl.php

示例2: define

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
require "../../class/functions.php";
require "../" . LoadLang("pub/fun.php");
require "../../data/dbcache/class.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, "downerror");
//删除单个报告
function DelError($errorid, $userid, $username)
{
    global $empire, $dbtbpre;
    //验证权限
    CheckLevel($userid, $username, $classid, "downerror");
    $errorid = (int) $errorid;
    if (empty($errorid)) {
        printerror("EmptyDelErrorid", "history.go(-1)");
开发者ID:novnan，项目名称:meiju，代码行数:31，代码来源:ListError.php

示例3: define

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
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">
开发者ID:novnan，项目名称:meiju，代码行数:31，代码来源:BqtempClass.php

示例4: define

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
require "../../class/functions.php";
require "../" . LoadLang("pub/fun.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, "moreport");
//增加访问端
function AddMoreport($add, $userid, $username)
{
    global $empire, $dbtbpre;
    if (!$add[pname] || !$add[ppath] || !$add[purl] || !$add[postpass] || !$add[tempgid]) {
        printerror("EmptyMoreport", "history.go(-1)");
    }
    //验证权限
    CheckLevel($userid, $username, $classid, "moreport");
    $add['pname'] = hRepPostStr($add['pname'], 1);
开发者ID:novnan，项目名称:meiju，代码行数:31，代码来源:ListMoreport.php

示例5: define

<?php

define('EmpireCMSAdmin', '1');
require "../class/connect.php";
require "../class/db_sql.php";
require "../class/functions.php";
require "../data/dbcache/class.php";
$link = db_connect();
$empire = new mysqlquery();
//验证用户
$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, "cj");
//显示无限级结点[增加结点时]
function ShowClass_AddInfoClass($obclassid, $bclassid, $exp, $enews = 0)
{
    global $empire, $dbtbpre;
    if (empty($bclassid)) {
        $bclassid = 0;
        $exp = "|-";
    } else {
        $exp = "&nbsp;&nbsp;" . $exp;
    }
    $sql = $empire->query("select classid,classname,bclassid from {$dbtbpre}enewsinfoclass where bclassid='{$bclassid}' order by classid");
开发者ID:novnan，项目名称:meiju，代码行数:31，代码来源:AddInfoClass.php

示例6: define

<?php

define('EmpireCMSAdmin', '1');
require "../class/connect.php";
require "../class/db_sql.php";
require "../class/functions.php";
require LoadLang("pub/fun.php");
require "../data/dbcache/class.php";
$link = db_connect();
$empire = new mysqlquery();
//验证用户
$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, "searchkey");
//删除搜索关键字
function DelSearchKey($onclick, $userid, $username)
{
    global $empire, $dbtbpre;
    //验证权限
    CheckLevel($userid, $username, $classid, "searchkey");
    $onclick = (int) $onclick;
    if (empty($onclick)) {
        printerror("EmptySearchOnclick", "history.go(-1)");
    }
开发者ID:novnan，项目名称:meiju，代码行数:31，代码来源:SearchKey.php

示例7: define

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
require "../../class/functions.php";
require "../../member/class/user.php";
require "../" . LoadLang("pub/fun.php");
require "../../data/dbcache/MemberLevel.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, "member");
$addgethtmlpath = "../";
$enews = $_POST['enews'];
if (empty($enews)) {
    $enews = $_GET['enews'];
}
//导入处理会员函数
if ($enews) {
    hCheckEcmsRHash();
开发者ID:novnan，项目名称:meiju，代码行数:31，代码来源:ListMember.php

示例8: define

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
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);
开发者ID:BGCX261，项目名称:zjh-dev-svn-to-git，代码行数:31，代码来源:MemberShowFeedback.php

示例9: define

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
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, "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; 修改充值类型";
}
//----------会员组
开发者ID:novnan，项目名称:meiju，代码行数:31，代码来源:AddBuyGroup.php

示例10: define

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
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, "member");
$url = "<a href=ListMemberGroup.php>管理会员组</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;
?>
/adminstyle.css" rel="stylesheet" type="text/css">
</head>
开发者ID:BGCX261，项目名称:zjh-dev-svn-to-git，代码行数:31，代码来源:ListMemberGroup.php

示例11: define

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
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, "player");
//验证文件
function CheckPlayerFilename($filename)
{
    if (strstr($filename, "\\") || strstr($filename, "/") || strstr($filename, "..")) {
        printerror("PlayerFileNotExist", "history.go(-1)");
    }
    //文件是否存在
    if (!file_exists("../../DownSys/play/" . $filename)) {
        printerror("PlayerFileNotExist", "history.go(-1)");
    }
}
开发者ID:novnan，项目名称:meiju，代码行数:31，代码来源:player.php

示例12: define

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
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, "spacedata");
//删除留言
function hDelMemberGbook($add, $userid, $username)
{
    global $empire, $dbtbpre;
    $gid = intval($add['gid']);
    if (!$gid) {
        printerror("NotDelMemberGbookid", "history.go(-1)");
    }
    $sql = $empire->query("delete from {$dbtbpre}enewsmembergbook where gid='{$gid}'");
    if ($sql) {
        //操作日志
开发者ID:novnan，项目名称:meiju，代码行数:31，代码来源:MemberGbook.php

示例13: db_connect

<?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;
}
开发者ID:tanny2015，项目名称:DataStructure，代码行数:31，代码来源:changetable.php

示例14: eCheckCloseMods

<?php

require "../../class/connect.php";
require "../../class/db_sql.php";
require "../../class/q_functions.php";
require "../../member/class/user.php";
require "../../data/dbcache/class.php";
require "../../data/dbcache/MemberLevel.php";
require "../class/DownSysFun.php";
eCheckCloseMods('down');
//关闭模块
$link = db_connect();
$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;
开发者ID:novnan，项目名称:meiju，代码行数:31，代码来源:index.php

示例15: define

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
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'];
//验证权限
CheckLevel($logininid, $loginin, $classid, "pay");
//设置接口
function EditPayApi($add, $userid, $username)
{
    global $empire, $dbtbpre;
    $add[payid] = (int) $add[payid];
    if (empty($add[payname]) || !$add[payid]) {
        printerror("EmptyPayApi", "history.go(-1)");
    }
    $add[isclose] = (int) $add[isclose];
    $add[myorder] = (int) $add[myorder];
    $add[paymethod] = (int) $add[paymethod];
    $sql = $empire->query("update {$dbtbpre}enewspayapi set isclose='{$add['isclose']}',payname='{$add['payname']}',paysay='{$add['paysay']}',payuser='{$add['payuser']}',paykey='{$add['paykey']}',payfee='{$add['payfee']}',payemail='{$add['payemail']}',myorder='{$add['myorder']}',paymethod='{$add['paymethod']}' where payid='{$add['payid']}'");
    if ($sql) {
开发者ID:BGCX261，项目名称:zjh-dev-svn-to-git，代码行数:31，代码来源:PayApi.php


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