當前位置: 首頁>>代碼示例>>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；未經允許，請勿轉載。