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


PHP DatabaseConnection::Result方法代码示例

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


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

示例1: GetList

 /**
  * Returns a sorted array of objects that match given conditions
  * @param multidimensional array {("field", "comparator", "value"), ("field", "comparator", "value"), ...} 
  * @param string $sortBy 
  * @param boolean $ascending 
  * @param int limit 
  * @return array $groupList
  */
 static function GetList($fcv_array, $sortBy = '', $ascending = true, $limit = '')
 {
     $sqlLimit = $limit != '' && $sortBy == '' ? "LIMIT {$limit}" : '';
     if (sizeof($fcv_array) > 0) {
         $groupList = array();
         $Database = new DatabaseConnection();
         $pog_query = "select groupid from `group` where ";
         for ($i = 0, $c = sizeof($fcv_array) - 1; $i < $c; $i++) {
             $pog_query .= "`" . $fcv_array[$i][0] . "` " . $fcv_array[$i][1] . " '" . $Database->Escape($fcv_array[$i][2]) . "' AND";
         }
         $pog_query .= "`" . $fcv_array[$i][0] . "` " . $fcv_array[$i][1] . " '" . $Database->Escape($fcv_array[$i][2]) . "' order by groupid asc {$sqlLimit}";
         $Database->Query($pog_query);
         for ($i = 0; $i < $Database->Rows(); $i++) {
             $group = new Group();
             $group->Get($Database->Result($i, "groupid"));
             $groupList[] = $group;
         }
         if ($sortBy != '') {
             $f = '';
             $group = new Group();
             if (isset($group->pog_attribute_type[strtolower($sortBy)]) && $group->pog_attribute_type[strtolower($sortBy)][0] == "NUMERIC") {
                 $f = 'return $group1->' . $sortBy . ' > $group2->' . $sortBy . ';';
             } else {
                 if (isset($group->pog_attribute_type[strtolower($sortBy)])) {
                     $f = 'return strcmp(strtolower($group1->' . $sortBy . '), strtolower($group2->' . $sortBy . '));';
                 }
             }
             usort($groupList, create_function('$group1, $group2', $f));
             if (!$ascending) {
                 $groupList = array_reverse($groupList);
             }
             if ($limit != '') {
                 $limitParts = explode(',', $limit);
                 if (sizeof($limitParts) > 1) {
                     return array_slice($groupList, $limitParts[0], $limitParts[1]);
                 } else {
                     return array_slice($groupList, 0, $limit);
                 }
             }
         }
         return $groupList;
     }
     return null;
 }
开发者ID:dreamvishnu,项目名称:tire-inventory,代码行数:52,代码来源:class.group.php

示例2: DatabaseConnection

<?php

require "common_all.php";
if (isset($_POST["reset"])) {
    $db = new DatabaseConnection();
    $email = $db->Escape($_POST["email"]);
    $password = "";
    for ($i = 1; $i <= 6; $i++) {
        $password .= chr(mt_rand(97, 122)) . chr(mt_rand(65, 90));
    }
    $db->Query("UPDATE onlineuser SET pass_word=PASSWORD('{$password}') WHERE email='{$email}'");
    $db->Query("SELECT first_name, last_name FROM onlineuser WHERE email='{$email}'");
    if ($db->Rows() > 0) {
        $fname = $db->Result(0, "first_name");
        $lname = $db->Result(0, "last_name");
        $headers = "From: noreply@fastfoodjobsuk.co.uk\r\n";
        $headers .= "X-Mailer: CJS_MailSystem\r\n";
        $headers .= "MIME-Version: 1.0\r\n";
        $headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
        $message = "<HTML><pre>";
        $message .= "Dear {$fname} {$lname}\n\n";
        $message .= "You password is: {$password} and if you need any further help please e-mail\n";
        $message .= "support@fastfoodjobsuk.co.uk\n\n";
        $message .= "Regards,\n\n";
        $message .= "The Fast Food Jobs Support Team.";
        $message .= "</pre></html>";
        mail($email, "Fastfoodjobsuk Password Reset", $message, $headers);
    }
    header("Location: forgotten_password_success.php");
    exit;
}
开发者ID:BackupTheBerlios,项目名称:scrapbook,代码行数:31,代码来源:forgotten_password.php

示例3: getCVId

 function getCVId()
 {
     $db = new DatabaseConnection();
     $result = $db->Query("select cvid from `cv` where onlineuser_onlineuserid='" . $this->onlineuserId . "'");
     return $db->Result(0, "cvid");
 }
开发者ID:BackupTheBerlios,项目名称:scrapbook,代码行数:6,代码来源:class.onlineuser.php

示例4: DatabaseConnection

$errorText = "";
if (isset($_GET["code"])) {
    if (strlen($code) > 20) {
        $errorText .= "<LI>Please enter a valid code";
    }
    if (strlen($email) > 45) {
        $errorText .= "<LI>Please enter a valid email address";
    }
    if ($errorText == "") {
        $db = new DatabaseConnection();
        $code = $db->Escape($_GET["code"]);
        $email = $db->Escape($_GET["email"]);
        $db->Query("SELECT onlineuserid FROM onlineuser WHERE email='{$email}'");
        if ($db->Rows() > 0) {
            $user = new OnlineUser();
            $user = $user->Get($db->Result(0, "onlineuserid"));
            if ($code == strtotime($user->dt_created)) {
                $user->user_status = "active";
                $user->Save();
                //$_SESSION["onlineuser"]=$user;
                header("Location: register_activated.php");
            }
        }
        $errorText = "<LI>Either the email address or code you entered is incorrect";
    } else {
        $errorText = "<ul>{$errorText}</ul>";
    }
}
require "top.php";
?>
开发者ID:BackupTheBerlios,项目名称:scrapbook,代码行数:30,代码来源:register_activate.php


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