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


PHP database::select方法代码示例

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


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

示例1: adlib

function adlib($id, $type)
{
    // create adlib xml basic structure
    $XML = new simpleXmlElement("<?xml version='1.0' encoding='utf-8'?><adlibXML xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:noNamespaceSchemaLocation='http://www.adlibsoft.com/adlibXML.xsd' />");
    echoall("Start Adlib XML export");
    echoall("Connect database");
    $daba = new database();
    $daba->connect("localhost", "iggmp", "1s87J37r0");
    if ($daba->select("thesaurus")) {
        echoall("Database connected");
    } else {
        die("***ERROR - Database connection failed");
    }
    $termType = thesaurus::get_name($id);
    echoall("Starte bei <b>'" . thesaurus::get_name($id) . "'</b>");
    //------------------------------------------------------------------------------
    // create recordList
    xml_insert($XML, new simpleXmlElement("<recordList />"));
    // insert records in recordList
    $subXml = _subtree($id, $termType);
    if ($subXml) {
        xml_insert($XML->recordList, $subXml);
    }
    echoall("XML export completed<hr>");
    echoall($XML);
    return $XML->asXML();
}
开发者ID:nibble-arts,项目名称:openthesaurus,代码行数:27,代码来源:adlib.php

示例2: get

 public static function get($variable, $default)
 {
     $s = database::select("variables", array("variable_value"), "variable_name='%var'", array("%var" => $variable));
     if (($b = database::fetch($s, PDO::FETCH_COLUMN)) != null) {
         return json_decode($b, true);
     } else {
         return $default;
     }
 }
开发者ID:decima,项目名称:M2-platine,代码行数:9,代码来源:variable.module.php

示例3: challenge_login

 public static function challenge_login($user, $pass)
 {
     $result = false;
     $query = database::select('id, password')->tables('user')->where('username', '=', ':username')->where('status', '=', 1, 'and')->param(':username', $user)->limit(1)->execute();
     $query_result = $query->fetch();
     if ($query_result && bcrypt::verify(user::config()->get('salt') . $query_result->uid . $pass, $query_result->pass)) {
         $result = (int) $query_result->id;
     }
     return $result;
 }
开发者ID:pettam,项目名称:Manta,代码行数:10,代码来源:model.user.php

示例4: get_message_count

 public static function get_message_count($game_id)
 {
     if (safe_input::is_number($game_id)) {
         $db = new database();
         $db->select("message", "*", "gameID= {$game_id} ");
         return $db->number_of_rows();
     } else {
         return -1;
         //invalid game_id
     }
 }
开发者ID:uunuu,项目名称:dot_boxes,代码行数:11,代码来源:table_message.php

示例5: __construct

 public function __construct($argv)
 {
     self::$network_time = time();
     // network time, sets to self::$network_time until we recieve some info from a main server.
     $parser = new parser(CONFPATH . 'services.conf');
     // get the config values.
     self::$debug = $argv[1] == 'debug' ? true : false;
     // is debug mode running? y/n
     if (isset(self::$config->nickserv)) {
         self::$service_bots[] = 'nickserv';
     }
     if (isset(self::$config->chanserv)) {
         self::$service_bots[] = 'chanserv';
     }
     if (isset(self::$config->operserv)) {
         self::$service_bots[] = 'operserv';
     }
     // setup our $config->service_bots dir
     $this->timer = new timer();
     $this->mode = new mode();
     $this->services = new services();
     $this->commands = new commands();
     $this->modules = new modules();
     // setup all the subclasses.
     database::factory(self::$config->database->driver);
     // setup the db.
     self::$socket = self::connect();
     // connect to the socket
     self::protocol_init();
     // load the protocol class
     $select = database::select('core', array('max_users'), array('id', '=', '1'));
     $max_users = database::row($select);
     // get the max users
     self::$max_users = $max_users[0];
     // set a global variable
     timer::add(array('core', 'reset_flood_cache', array()), 120, 0);
     // add a timer to reset the flood cache every
     // 120 seconds, indefinatly
     if (self::$config->settings->loglevel != 'off' || !isset(self::$config->settings->loglevel)) {
         timer::add(array('core', 'save_logs', array()), 300, 0);
     }
     // add another timer to save logs every 5 mins
     timer::add(array('core', 'check_unused_chans', array()), 5, 0);
     // and another one to check for unused channels every 5 seconds XD
     if (is_resource(self::$socket)) {
         $this->main_loop();
     } else {
         exit;
     }
     // execute the main program loop
 }
开发者ID:rickihastings,项目名称:acorairc,代码行数:51,代码来源:core.php

示例6: getGameById

 public static function getGameById($game_id)
 {
     if (safe_input::is_number($game_id)) {
         $db = new database();
         $db->select("game", "*", "id= {$game_id} ");
         if ($db->number_of_rows() > 0) {
             return $db->fetch_row();
         } else {
             return FALSE;
         }
     } else {
         return false;
     }
 }
开发者ID:uunuu,项目名称:dot_boxes,代码行数:14,代码来源:table_game.php

示例7: _find_match

 public static function _find_match($term, $mode, $limit)
 {
     $new_term = str_replace('*', '%', $term);
     // search for a nickname
     // allow the ability to search with "*"'s
     $limit = database::quote($limit);
     $s_limit = explode('-', $limit);
     $offset = $s_limit[0];
     $max = $s_limit[1];
     // split up the limit and stuff ^_^
     if ($mode == 'suspended') {
         $results = database::select('users', array('id', 'display', 'last_hostmask', 'suspended', 'suspend_reason'), array('suspended', '=', '1', 'AND', 'display', 'LIKE', $new_term), '', array($offset => $max));
     } else {
         $results = database::select('users', array('id', 'display', 'last_hostmask', 'suspended', 'suspend_reason'), array('suspended', '=', '0', 'AND', 'display', 'LIKE', $new_term), '', array($offset => $max));
     }
     return $results;
 }
开发者ID:rickihastings,项目名称:acorairc,代码行数:17,代码来源:list.ns.php

示例8: database

<?php

session_start();
$pid = '';
if (isset($_GET['pid'])) {
    $pid = $_GET['pid'];
}
require_once "../../lib/server-config.php";
require_once "../../lib/connect.class.php";
$db = new database();
$db->connect2(trim($u), trim($p), trim($dbn));
$strSQL = sprintf("SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s'", mysql_real_escape_string("registerrecord"), mysql_real_escape_string($pid));
$resultRegister = $db->select($strSQL, false, true);
if (!$resultRegister) {
}
?>
<!doctype html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="description" content="Introducing Lollipop, a sweet new take on Android.">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>SIMANH South Africa</title>

    <!-- Page styles -->
    <link href="https://fonts.googleapis.com/css?family=Roboto:regular,bold,italic,thin,light,bolditalic,black,medium&amp;lang=en" rel="stylesheet">
    <link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet">
    <link rel="stylesheet" href="./css/material.min.css">
    <link rel="stylesheet" href="styles.css">
    <link rel="stylesheet"  type="text/css" href="css/style.css" />
开发者ID:tagoonp,项目名称:sa_simanh,代码行数:31,代码来源:index.php

示例9: database

<?php

$userdata = $this->_userData;
$has_ads_pin = $userdata['ads_pin'];
if ($has_ads_pin != NULL) {
    $ads_pin = $has_ads_pin;
    $selectPin = "disabled";
} else {
    $ads_pin = "";
    $selectPin = NULL;
}
$db = new database(DBTYPE, DBHOST, DBNAME, DBUSER, DBPASS);
$checkPin = $db->select("user_accounts", "acc_type", "agent_id = '{$has_ads_pin}'", "fetch");
if ($checkPin['acc_type'] == 'admin') {
    $selectPin = NULL;
}
$accType = $this->accType;
$bankList = $this->bankList;
$paymentMethodList = $this->paymentMethodList;
$accCode = $userdata['acc_type'];
$colSize = $accCode != "pb" ? "col-md-6" : "col-md-12";
$notPB = $accCode != "pb" ? TRUE : FALSE;
?>

<div class="col-xs-12">
    <h2 class="page-header">Account Setup</h2>
    <?php 
include 'menu.php';
?>
    <div>
        <div class="account-setup tab-content">
开发者ID:kronxblue,项目名称:1stg,代码行数:31,代码来源:payment.php

示例10: trim

<?php

session_start();
include "./server-config.php";
$strUsername = trim($_POST["data1"]);
$strPassword = trim($_POST["data2"]);
$strPassword = md5($strPassword);
require "connect.class.php";
$db = new database();
$db->connect2(trim($u), trim($p), trim($dbn));
$strSQL = sprintf("SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "useraccount WHERE username = '%s' and password = '%s' and status = '1'", mysql_real_escape_string($strUsername), mysql_real_escape_string($strPassword));
$resultaccount = $db->select($strSQL, false, true);
if ($resultaccount) {
    print "Y";
    $_SESSION['userSIMANHsession'] = session_id();
    $_SESSION['userSIMANHusername'] = $resultaccount[0]['username'];
    session_write_close();
} else {
    //print $strSQL;
    print "N";
}
$db->disconnect();
开发者ID:tagoonp,项目名称:sa_simanh,代码行数:22,代码来源:checkuseraccount.php

示例11: get_all_roles

 public static function get_all_roles()
 {
     return database::fetchAll(database::select("groups"));
 }
开发者ID:decima,项目名称:M2-platine,代码行数:4,代码来源:user_access.php

示例12: database

<?php

session_start();
include "./../lib/server-config.php";
require "./../lib/connect.class.php";
$db = new database();
$db->connect2(trim($u), trim($p), trim($dbn));
//Check user priviledge
$strSQL = sprintf("SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE username = '%s' and status = 1 and user_type_id = '%s'", mysql_real_escape_string("useraccount"), mysql_real_escape_string($_SESSION['userSIMANHusername']), mysql_real_escape_string(3));
$resultUser = $db->select($strSQL, false, true);
//If privilegde available
if ($resultUser) {
    $strSQL = sprintf("SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "%s \n\t\t\t\tWHERE record_id = '%s'", mysql_real_escape_string("outcome"), mysql_real_escape_string($_SESSION['userSIMANHmother_record']));
    $resultSelectOutcome = $db->select($strSQL, false, true);
    $no = 1;
    if ($resultSelectOutcome) {
        $no = sizeof($resultSelectOutcome);
    }
    $strSQL = sprintf("INSERT INTO " . substr(strtolower($tbf), 0, -2) . "%s \n\t\t\t\tVALUE ('','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s'\n\t\t\t\t,'%s','%s','%s')", mysql_real_escape_string("outcome"), mysql_real_escape_string($_POST['gender']), mysql_real_escape_string($_POST['alive']), mysql_real_escape_string($_POST['stillbirth']), mysql_real_escape_string($_POST['ag5']), mysql_real_escape_string($_POST['ag10']), mysql_real_escape_string($_POST['rbm']), mysql_real_escape_string($_POST['birth_wieght']), mysql_real_escape_string($_POST['hc']), mysql_real_escape_string($_POST['fetal_length']), mysql_real_escape_string($_POST['bdf']), mysql_real_escape_string($_POST['bdf_identify']), mysql_real_escape_string($_POST['bdn']), mysql_real_escape_string($_POST['ebf']), mysql_real_escape_string($_POST['bf']), mysql_real_escape_string($_POST['ff']), mysql_real_escape_string($_POST['skin2skin']), mysql_real_escape_string($_POST['pmctv_lb']), mysql_real_escape_string($_POST['nb_adm']), mysql_real_escape_string($_POST['nb_date_adm']), mysql_real_escape_string($_POST['nb_time_adm']), mysql_real_escape_string($_POST['nb_neonatal']), mysql_real_escape_string($_POST['nb_refer']), mysql_real_escape_string($_POST['nb_refer_facility']), mysql_real_escape_string("nb." . $_SESSION['userSIMANHmother_record'] . "-" . $no), mysql_real_escape_string($_SESSION['userSIMANHmother_record']));
    $resultInsert = $db->insert($strSQL, false, true);
    if ($resultInsert) {
        $strSQL = sprintf("SELECT record_id FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s' ", mysql_real_escape_string("outcome"), mysql_real_escape_string($_SESSION['userSIMANHmother_record']));
        $resultCheck = $db->select($strSQL, false, true);
        if ($resultCheck) {
            $db->disconnect();
            ?>
			<script>
					alert('Delivery information complete!');
					window.location = '../enter/main.php?id=4';
			</script>
			<?php 
开发者ID:tagoonp,项目名称:sa_simanh,代码行数:31,代码来源:saveOutcome.php

示例13: getMessages

 public static function getMessages($cond = NULL, $fetch = "fetchAll")
 {
     if ($cond != NULL) {
         $where = $cond;
     } else {
         $where = NULL;
     }
     $db = new database(DBTYPE, DBHOST, DBNAME, DBUSER, DBPASS);
     $data = $db->select("user_messages", "*", $where, $fetch);
     return $data;
 }
开发者ID:kronxblue,项目名称:1stg,代码行数:11,代码来源:user.php

示例14: complete

 function complete()
 {
     $userdata = $this->user;
     $agent_id = $userdata['agent_id'];
     $paymentComplete = TRUE;
     $db = new database(DBTYPE, DBHOST, DBNAME, DBUSER, DBPASS);
     $hasPayment = user::checkExist("user_payment", "agent_id = '{$agent_id}'");
     $paymentDetails = $db->select("user_payment", "payment_date, payment_time, from_acc, to_acc, payment_type", "agent_id = '{$agent_id}'", "fetch");
     if ($paymentDetails != FALSE) {
         foreach ($paymentDetails as $key => $value) {
             if (empty($value)) {
                 $paymentComplete = FALSE;
             }
         }
     } else {
         $paymentComplete = FALSE;
     }
     if (!$hasPayment or !$paymentComplete) {
         redirect::to("setup/payment");
     }
     $this->breadcrumb->add("Complete", "setup/complete");
     $this->view->breadcrumbs = $this->breadcrumb->get();
     $this->view->js = array('setup/js/setup.js');
     $this->view->render('setup/complete', 'backoffice');
 }
开发者ID:kronxblue,项目名称:1stg,代码行数:25,代码来源:setup.php

示例15: database

<?php

session_start();
include "./../lib/server-config.php";
require "./../lib/connect.class.php";
$db = new database();
$db->connect2(trim($u), trim($p), trim($dbn));
$key = $_POST["key"];
//Check user priviledge
$strSQL = sprintf("SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE username = '%s' and status = 1 and user_type_id = '%s'", mysql_real_escape_string("useraccount"), mysql_real_escape_string($_SESSION['userSIMANHusername']), mysql_real_escape_string(3));
$resultUser = $db->select($strSQL, false, true);
if ($resultUser) {
    $strSQL = "SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "registerrecord\n\t\t\t\tWHERE (pid like '" . $key . "%' or p_fname like '%" . $key . "%'  or p_lname like '%" . $key . "%'  or point_no = '%" . $key . "%'\n\t\t\t\t or folder_no = '%" . $key . "%') and confirm_status = '0' and username in (SELECT username FROM " . substr(strtolower($tbf), 0, -2) . "userdescription WHERE institute_id in (SELECT institute_id FROM " . substr(strtolower($tbf), 0, -2) . "userdescription WHERE username = '" . $_SESSION['userSIMANHusername'] . "'))";
    $resultSearch = $db->select($strSQL, false, true);
    if ($resultSearch) {
        ?>
		<table width="100%" border="0" cellspacing="0" cellpadding="0" >
          <tr>
            <td height="25" width="40" align="left"  style="padding-left:5px; color:#FFF; font-size:0.8em;" bgcolor="#669999"><strong>No
            </th>
            </strong>
            <td  align="left"  style="padding-left:5px; color:#FFF; font-size:0.8em;" bgcolor="#669999"><strong>Full name
            </th>
            </strong>
            <td  align="left" width="120"   style="padding-left:5px; color:#FFF; font-size:0.8em;" bgcolor="#669999"><strong>Admission date
            </th>
            </strong>
            <td  align="left" width="80"   style="padding-left:5px; color:#FFF; font-size:0.8em;" bgcolor="#669999"><strong>Status                         
            </strong>
            <td  align="left" width="150"   style="padding-left:5px; color:#FFF; font-size:0.8em;" bgcolor="#669999"><strong>Labour</strong>            </tr>
		<?php 
开发者ID:tagoonp,项目名称:sa_simanh,代码行数:31,代码来源:rearchRecord2_back.php


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