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


PHP Zend_Db_Table::fetchAll方法代码示例

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


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

示例1: getMenuTree

 /**
  * Получаем дерево разделов определённого меню
  *
  * @param int $menuId
  * @return array
  */
 public function getMenuTree($menuId)
 {
     $menu = $this->getMenu($menuId);
     if (!sizeof($menu)) {
         return array();
     }
     $sections = $this->_modelItems->fetchAll($this->_modelItems->select()->where('menu_id = ?', $menu->menu_id)->order('sort', 'item_id'));
     if ($menu->type == 'router') {
         $routerTree = Modules_Router_Model_Router::getInstance()->getItem($menu->parent_route_id);
         $_makeTreeFromRouter = function ($routerTree, $sections, $parentDisable) use(&$_makeTreeFromRouter) {
             $return = array();
             foreach ($routerTree as $i => $row) {
                 if (1 == $row['disable']) {
                     continue;
                 }
                 $return[$i] = $row;
                 $return[$i]['type'] = 'from_router';
                 $return[$i]['item_id'] = $row['route_id'];
                 $return[$i]['parent_id'] = $row['parent_route_id'];
                 $return[$i]['disable'] = $parentDisable;
                 unset($return[$i]['route_id'], $return[$i]['parent_route_id'], $return[$i]['childs']);
                 if (sizeof($sections)) {
                     foreach ($sections as $item) {
                         if ($item->route_id == $row['route_id']) {
                             $return[$i]['disable'] = $item->disable || $parentDisable;
                             $return[$i]['name'] = $item->name ? $item->name : $row['name'];
                         }
                     }
                 }
                 $return[$i]['childs'] = $_makeTreeFromRouter($row['childs'], $sections, $return[$i]['disable']);
             }
             return $return;
         };
         $sections = $_makeTreeFromRouter($routerTree['childs'], $sections, false);
     } else {
         $_makeUrl = function ($sections) use(&$_makeUrl) {
             $return = array();
             foreach ($sections as $i => $item) {
                 $return[$i] = $item;
                 if ($item['external_link']) {
                     $return[$i]['url'] = $item['external_link'];
                 } else {
                     $return[$i] += Modules_Router_Model_Router::getInstance()->getItem($item['route_id']);
                 }
                 $return[$i]['childs'] = $_makeUrl($item['childs']);
             }
             return $return;
         };
         $sections = System_Functions::toForest($sections->toArray(), 'item_id', 'parent_id');
         $sections = $_makeUrl($sections);
     }
     $this->_setCurrents($sections);
     return $sections;
 }
开发者ID:kytvi2p,项目名称:ZettaFramework,代码行数:60,代码来源:Menu.php

示例2: getTrustedSites

 /**
  * Returns array of all trusted/untrusted sites for given user identified
  * by $id
  *
  * @param string $id user identity URL
  * @return array
  */
 public function getTrustedSites($id)
 {
     $select = $this->_sitesTable->select()->where('openid = ?', $id);
     $rows = $this->_sitesTable->fetchAll($select);
     $array = $rows->toArray();
     $array['trusted'] = unserialize($array['trusted']);
     return $array;
 }
开发者ID:heiglandreas,项目名称:Zend-Framework-OpenID-Provider,代码行数:15,代码来源:Db.php

示例3: getReceivers

 public function getReceivers($pairs = false)
 {
     $triggersTable = new Zend_Db_Table('email_triggers_recipient');
     if ($pairs) {
         $select = $triggersTable->select();
         return $triggersTable->getAdapter()->fetchPairs($select);
     } else {
         return $triggersTable->fetchAll()->toArray();
     }
 }
开发者ID:PavloKovalov,项目名称:seotoaster,代码行数:10,代码来源:EmailTriggersMapper.php

示例4: _init

 private function _init()
 {
     global $logger;
     $oTable = new Zend_Db_Table('path');
     foreach ($oTable->fetchAll($oTable->select())->toArray() as $xt) {
         $this->_path[] = $xt['name'];
     }
     $oTable = new Zend_Db_Table('container');
     $t = array();
     foreach ($oTable->fetchAll($oTable->select())->toArray() as $xt) {
         $t[] = $xt['name'];
     }
     $this->_extensions = implode(',', $t);
     $logger->log('Valid extensions are : ' . $this->_extensions, Zend_Log::DEBUG);
 }
开发者ID:ka2er,项目名称:mmc-flex,代码行数:15,代码来源:FilmMapper.php

示例5: getTable

 function getTable($name)
 {
     if (!($result = $this->_cache->load($this->_options[$name]['table']))) {
         $table = new Zend_Db_Table($this->_options[$name]['table']);
         if ($name == 'privilege') {
             $sql = new Zend_Db_Select($table->getDefaultAdapter());
             $sql->from(array('acl' => $this->_options['privilege']['table']), array('acl.ID_PERFIL'))->join(array('r' => $this->_options['resource']['table']), 'acl.ID_MENU=r.ID_MENU', array('r.URL_MENU', 'acl.PERMISO'));
             $result = $table->getAdapter()->fetchAll($sql);
         } else {
             $result = $table->fetchAll();
         }
         $this->_cache->save($result, $this->_options[$name]['table']);
     }
     return $result;
 }
开发者ID:josmel,项目名称:DevelEntretenimientoEntel,代码行数:15,代码来源:Acl.php

示例6: load

 /**
  * retourne tous les parametres
  *
  * @return Settings
  */
 public function load()
 {
     global $logger;
     $this->_init();
     foreach ($this->_tables as $holder => $table) {
         $oTable = new Zend_Db_Table($table);
         $xt = array();
         foreach ($oTable->fetchAll($oTable->select()->order('id ASC'))->toArray() as $o) {
             $xsetting = new Setting();
             $xsetting->name = $o['name'];
             $xsetting->id = $o['id'];
             $xt[] = $xsetting;
         }
         $t[$holder] = $xt;
     }
     $s = new Settings($this->_description, $t[0], $t[1], $t[2], $t[3], $t[4], $t[5], $t[6], $t[7], $t[8]);
     return $s;
 }
开发者ID:ka2er,项目名称:mmc-flex,代码行数:23,代码来源:SettingsMapper.php

示例7: fetchAll

 public function fetchAll($where = null, $order = null, $count = null, $offset = null)
 {
     $res = parent::fetchAll($where, $order, $count, $offset)->toArray();
     // do Bacula ACLs
     return $this->bacula_acl->doBaculaAcl($res, 'name', 'client');
 }
开发者ID:staser,项目名称:webacula,代码行数:6,代码来源:Client.php

示例8: getYnModulesOnYourSite

        public function getYnModulesOnYourSite($modules,$yours)
        {
            
            $lst_modules = array();
            $db = Engine_Api::_()->getDbtable('license', 'younetcore')->getAdapter();
            if( $db ) {
                try {
                    $table = new Zend_Db_Table(array(
                    'adapter' => $db,
                    'name' => 'engine4_core_modules',
                    ));
                    foreach( $table->fetchAll() as $row ) {
                        $lst_modules[$row->name] = $row->toArray();
                    }
                } catch( Exception $e ) {

                }
            }
            $modules_yn = array();
            if(count($lst_modules)>0)
            {
                foreach($lst_modules as $key =>$m)
                {
                    $t = false;
                    if(count($yours) >0)
                    {
                        if(array_key_exists($m['name'],$yours))
                        {
                            $t = true;
                        }
                    }
                    if(array_key_exists($m['name'],$modules) && $t == false && $m['name']!="younet-core")
                    {
                        if($this->checkMainifest($m['name']) == 2)
                        {
                            $modules_yn[$m['name']] = array(
                                'title' => $m['title'],
                                'name' => $m['name'],
                                'type' => 'module',
                                'current_version' => $m['version'],
                                'lasted_version' => $m['version'],
                                'is_active' =>$m['enabled'],
                                //'sort_description' =>$m['sort_description'],
                            );
                            $db->beginTransaction();
                            try {
                                $table = Engine_Api::_()->getDbtable('License', 'YounetCore');
                                $st = $table->createRow();
                                $st->setFromArray($modules_yn[$m['name']]);
                                $st->save();
                                $db->commit();
                            } catch (Exception $e) {
                                
                                $db->rollback();
                                //throw $e;
                            }
                        }
                        else
                        {
                            $db->beginTransaction();
                            try {
                                $table = Engine_Api::_()->getDbtable('License', 'YounetCore');
                                $where = $table->getAdapter()->quoteInto('name = ?', $m['name']);
                                $table->delete($where);
                                $db->commit();
                            } catch (Exception $e) {
                                
                                $db->rollback();
                                //throw $e;
                            }
                        }
                        
                        
                        
                    }

                }
            }
            return $modules_yn;
        }
开发者ID:hoalangoc,项目名称:ftf,代码行数:80,代码来源:Core.php

示例9: fetchUserFriends

 public function fetchUserFriends($id)
 {
     $id = (int) $id;
     $table = new Zend_Db_Table('friends');
     $select = $table->select()->setIntegrityCheck(false);
     $select->from(array('f' => 'friends'), array('f.id_friend'));
     $select->where('f.id_user = ?', $id);
     $select->joinInner(array('u' => 'users'), 'f.id_friend = u.id', array('u.username'));
     return $table->fetchAll($select)->toArray();
 }
开发者ID:Arteaga2k,项目名称:nolotiro,代码行数:10,代码来源:User.php

示例10: fetchAll

 public function fetchAll($where = null, $order = null, $count = null, $offset = null)
 {
     $result = parent::fetchAll($where, $order, $count, $offset);
     return $result;
 }
开发者ID:jaybill,项目名称:Bolts,代码行数:5,代码来源:Abstract.php

示例11: _updateContractsFields

 /**
  * adds "start_date", "end_date" to contract and removes "status", "cleared", "cleared_in"
  */
 protected function _updateContractsFields()
 {
     $adminGroup = Tinebase_Group::getInstance()->getDefaultAdminGroup();
     $groupMembers = Tinebase_Group::getInstance()->getGroupMembers($adminGroup->getId());
     if (count($groupMembers) > 0) {
         $user = Tinebase_User::getInstance()->getUserById($groupMembers[0]);
         Tinebase_Core::set(Tinebase_Core::USER, $user);
         // cleared, cleared_in, status gets deleted, if the update is not called on cli
         $controller = Sales_Controller_Contract::getInstance();
         $table = new Zend_Db_Table(SQL_TABLE_PREFIX . 'sales_contracts', new Zend_Db_Table_Definition(array('id' => array('name' => 'id'), 'status' => array('name' => 'status'), 'cleared' => array('name' => 'cleared'), 'cleared_in' => array('name' => 'cleared_in'), 'description' => array('name' => 'description'), 'last_modified_time' => array('name' => 'last_modified_time'))));
         $count = 50;
         $offset = 0;
         $more = true;
         $updateDescription = $statusConfig = $clearedConfig = $setEndDate = array();
         $appId = Tinebase_Application::getInstance()->getApplicationByName('Tinebase')->getId();
         $pref = Tinebase_Core::getPreference('Tinebase');
         Tinebase_Core::setupUserLocale($pref->locale);
         $t = Tinebase_Translation::getTranslation('Sales', Tinebase_Core::getLocale());
         $config = Sales_Config::getInstance()->get('contractStatus');
         foreach ($config['records'] as $cfg) {
             $statusConfig[$cfg['id']] = $cfg['value'];
         }
         $config = Sales_Config::getInstance()->get('contractCleared');
         foreach ($config['records'] as $cfg) {
             $clearedConfig[$cfg['id']] = $cfg['value'];
         }
         while ($more) {
             $results = $table->fetchAll(NULL, NULL, $count, $offset)->toArray();
             foreach ($results as $row) {
                 if ($row['status'] == 'CLOSED') {
                     $setEndDate[$row['id']] = $row['last_modified_time'];
                 }
                 $desc = $row['description'];
                 $desc .= PHP_EOL . '---' . PHP_EOL . PHP_EOL;
                 $contents = FALSE;
                 if (!empty($row['status'])) {
                     $desc .= $t->_('Status') . ': ';
                     $desc .= isset($statusConfig[$row['status']]) ? $t->_($statusConfig[$row['status']]) : $row['status'];
                     $desc .= PHP_EOL;
                     $contents = TRUE;
                 }
                 if (!empty($row['cleared'])) {
                     $desc .= $t->_('Cleared') . ': ';
                     $desc .= isset($clearedConfig[$row['cleared']]) ? $t->_($clearedConfig[$row['cleared']]) : $row['cleared'];
                     $desc .= PHP_EOL;
                     $contents = TRUE;
                 }
                 if (!empty($row['cleared_in'])) {
                     $desc .= $t->_('Cleared In') . ': ';
                     $desc .= $row['cleared_in'];
                     $desc .= PHP_EOL;
                     $contents = TRUE;
                 }
                 if ($contents) {
                     $updateDescription[$row['id']] = $desc . PHP_EOL;
                 }
             }
             if (count($updateDescription) > 50) {
                 foreach ($controller->getMultiple(array_keys($updateDescription)) as $contr) {
                     $contr->description = $updateDescription[$contr->getId()];
                     $controller->update($contr, FALSE);
                 }
                 $updateDescription = array();
             }
             if (count($results) < $count) {
                 $more = FALSE;
             } else {
                 $offset = $offset + $count;
             }
         }
         try {
             foreach ($controller->getMultiple(array_keys($updateDescription)) as $contr) {
                 $contr->description = $updateDescription[$contr->getId()];
                 $controller->update($contr, FALSE);
             }
         } catch (Tinebase_Exception_AccessDenied $tead) {
             // could not update contracts ...
             Tinebase_Exception::log($tead);
         }
     }
     // remove deprecated sales contract fields
     foreach (array('status', 'cleared_in', 'cleared') as $colToDrop) {
         try {
             $this->_backend->dropCol('sales_contracts', $colToDrop);
         } catch (Zend_Db_Statement_Exception $zdse) {
             Tinebase_Exception::log($zdse);
         }
     }
     // add new sales contract fields
     $fields = array('<field>
         <name>start_date</name>
         <type>datetime</type>
     </field>', '
     <field>
         <name>end_date</name>
         <type>datetime</type>
     </field>');
//.........这里部分代码省略.........
开发者ID:bitExpert,项目名称:Tine-2.0-Open-Source-Groupware-and-CRM,代码行数:101,代码来源:Release8.php

示例12: fetchAllMaster

 public function fetchAllMaster($where = null, $order = null, $count = null, $offset = null)
 {
     $this->_db = CrFramework_Db_Control::getMasterAdapter();
     $this->setDefaultAdapter($this->_db);
     logStd(get_class($this) . '->fetchAll()', 'Read from MASTER');
     $rowset = parent::fetchAll($where, $order, $count, $offset);
     return $rowset;
 }
开发者ID:xinghao,项目名称:shs,代码行数:8,代码来源:Table.php

示例13: indexAction

 public function indexAction()
 {
     $contact = new Zend_Db_Table('contacts');
     $query = $contact->select()->order('name');
     $this->view->contacts = $contact->fetchAll($query);
 }
开发者ID:alannet,项目名称:example,代码行数:6,代码来源:ContactsController.php

示例14: getAdListAllHome

 public function getAdListAllHome($ad_type)
 {
     $table = new Zend_Db_Table('ads');
     $select = $table->select()->setIntegrityCheck(false);
     $select->from(array('a' => 'ads'), array('a.*'));
     $select->joinLeft(array('c' => 'commentsAdCount'), 'a.id = c.id_comment', array('c.count as comments_count'));
     $select->joinLeft(array('r' => 'readedAdCount'), 'a.id = r.id_ad', array('r.counter as readings_count'));
     $select->join(array('u' => 'users'), 'a.user_owner = u.id', array('u.username'));
     //show only if user is active and not locked
     $select->where('u.active = ?', 1);
     $select->where('u.locked = ?', 0);
     $select->where('a.type = ?', $ad_type);
     $select->where('a.status = ?', 'available');
     $select->order('a.date_created DESC');
     $select->limit(20);
     $result = $table->fetchAll($select)->toArray();
     return $result;
 }
开发者ID:Arteaga2k,项目名称:nolotiro,代码行数:18,代码来源:Ad.php

示例15: getMessagesFromThread

 /**
  * get messages in a thread
  *
  * @param thread_id
  * @return array of messages
  */
 public function getMessagesFromThread($id)
 {
     if (!$id) {
         return null;
     }
     $messages_table = new Zend_Db_Table('messages');
     $select = $messages_table->select()->setIntegrityCheck(false)->from('messages', array('user_from', 'user_to', 'date_created', 'body'))->where('thread_id = ?', $id)->join(array('u' => 'users'), 'user_from = u.id', array('username_from' => 'u.username'))->order('date_created');
     $result = $messages_table->fetchAll($select)->toArray();
     return $result;
 }
开发者ID:Arteaga2k,项目名称:nolotiro,代码行数:16,代码来源:Message.php


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