PHP Account::select方法代码示例

    public function signin() {
        $email = $this->f3->get('POST.email');
        $password = $this->f3->get('POST.password');

        $v = new Valitron\Validator(array('Email' => $email, 'Password' => $password));
        $v->rule('required', ['Email', 'Password']);
        $v->rule('email', 'Email');

        if ($v->validate()) {
            $account = new Account($this->db);
            $pwd = md5($password);
            $acc = $account->select("*", "email='$email' and password='$pwd'");
            if ($acc) {
                $this->f3->set('SESSION.acc', $acc);
                $acc = $acc[0];
                $acc['lastlogin'] = date('Y-m-d H:i:s');
                $account->update($acc,'id='.$acc['id']);
                $this->f3->reroute('/dashboard');
            } else {
                $this->f3->set('email', $email);
                $this->f3->set('errors', array(array('Login fail, wrong username or password')));
                echo Template::instance()->render('index.html');
            }
        } else {
            $this->f3->set('email', $email);
            $this->f3->set('errors', $v->errors());
            echo Template::instance()->render('index.html');
        }
    }

function parseBrowse($cId, $eId, $cmd)
{
    global $_PATHS, $_CONF;
    $objTpl = new HTML_Template_IT($_PATHS['templates']);
    $objTpl->loadTemplatefile("common.tpl.htm");
    switch ($cId) {
        case NAV_ACCOUNT:
            $objAccounts = Account::select("SELECT * FROM punch_account ORDER BY name");
            $arrDomain = explode('.', $_SERVER['HTTP_HOST']);
            $strRootDomain = count($arrDomain) > 2 ? str_replace(array_shift($arrDomain) . ".", "", $_SERVER['HTTP_HOST']) : $_SERVER['HTTP_HOST'];
            //*** Render list.
            foreach ($objAccounts as $objTempAccount) {
                $objTpl->setCurrentBlock("list-item");
                $objTpl->setVariable('ITEM_LINK', "http://" . $objTempAccount->getUri() . "." . $strRootDomain);
                $objTpl->setVariable('ITEM_LABEL', htmlentities($objTempAccount->getName()));
                $objTpl->setVariable('ITEM_EXPORT', "?cid=" . NAV_ACCOUNT . "&cmd=" . CMD_EXPORT . "&eid=" . $objTempAccount->getId());
                $objTpl->setVariable('ITEM_RESTORE', "?cid=" . NAV_ACCOUNT . "&cmd=" . CMD_RESTORE . "&eid=" . $objTempAccount->getId());
                $objTpl->setVariable('ITEM_EDIT', "?cid=" . NAV_ACCOUNT . "&cmd=" . CMD_EDIT . "&eid=" . $objTempAccount->getId());
                $objTpl->setVariable('ITEM_TYPE', "Account");
                $objTpl->setVariable('ITEM_ID', $objTempAccount->getId());
                $objTpl->parseCurrentBlock();
            }
            break;
        case NAV_ADMIN:
            break;
    }
    //*** Return the output.
    return $objTpl->get();
}

 function address()
 {
     $user_id = Account::getUserId();
     $field = array('country', 'region', 'province', 'city', 'district', 'address', 'postcode', 'mobile', 'tel');
     $m = new Account();
     $m->clear();
     $m->setField($field);
     $m->setTable('vcb_user_address');
     $m->setWhere('user_id', '=', $user_id);
     $data = $m->select();
     if (empty($data)) {
         header("location:transfer");
     }
     $this->assign('data', $data);
 }

<?php

$arrDomain = explode('.', $_SERVER['HTTP_HOST']);
$intCatId = Request::get("cid");
if (isset($_CONF['app']['singleInstance']) && $_CONF['app']['singleInstance']) {
    //*** Check if the account exists.
    $objAccounts = Account::select();
    if ($objAccounts->count() <= 0) {
        //*** Account does not exist.
        header("Location: " . Request::getURI("http") . "/?cid=" . NAV_MYPUNCH_NOACCOUNT);
        exit;
    } else {
        $objAccount = $objAccounts->current();
    }
    //*** Set the PunchId.
    $_CONF['app']['account'] = $objAccount;
    $_CONF['app']['pageTitle'] = sprintf($objLang->get('pageTitle'), $_CONF['app']['account']->getName(), APP_NAME, APP_VERSION);
} else {
    if ($intCatId != NAV_MYPUNCH_NOACCOUNT) {
        if (count($arrDomain) > 2) {
            $strDomain = $arrDomain[count($arrDomain) - 2] . "." . $arrDomain[count($arrDomain) - 1];
            $strSubName = $arrDomain[0];
            //*** Check if the account exists.
            $objAccount = Account::getByUri($strSubName);
            if (!is_object($objAccount)) {
                //*** Account does not exist.
                header("Location: " . Request::getURI("http") . "/?cid=" . NAV_MYPUNCH_NOACCOUNT);
                exit;
            }
            //*** Set the PunchId.
            $_CONF['app']['account'] = $objAccount;

 public function testSelectWithNoParameters()
 {
     // our mock adapter
     $adapter = $this->adapterMock;
     // prepare the mock to expect the variables passed, and return a row
     $adapter->expects($this->once())->method('select')->with('accounts', null, null, array());
     $accountsTable = new Account($adapter);
     // getInstance doesn't work well in testing
     $result = $accountsTable->select();
 }

<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title></title>
    </head>
    <body>
        <?php 
require 'autoloader.php';
Autoloader::register();
Config::load(array('dbconfig' => array('char' => array('user' => 'root', 'pass' => '', 'dsn' => 'mysql:host=127.0.0.1;dbname=characters'), 'auth' => array('user' => 'root', 'pass' => '', 'dsn' => 'mysql:host=127.0.0.1;dbname=auth'))));
$accounts = Account::select('id = 1');
foreach ($accounts as $account) {
    $account->delete();
}
DatabaseManager::get('auth')->queue->execute();
DatabaseManager::get('char')->queue->execute();
?>
    </body>
</html>