PHP Mysql::get_records方法代码示例

 /**
  * Zeigt die Gallery an, genauer einen Teil der Bilder zu der gehörenden Gallery.
  * Eine Gallery kann in mehrere Seiten unterteilt sein, je nach der Anzahl der Bilder.
  * Eine Gallery kann eine übergeordnete Kategorie haben, jedoch keine übergeordnete Gallery.
  * @global int gallery_pics_x Number of pictures in x
  * @global int $gallery_pics_y Number of pictures in y
  * @param int $gal_ID Gallery-ID
  */
 private function _showGallery($gal_ID)
 {
     $this->_tplfile = 'gallery_album.tpl';
     /* Anzeige-Config-Daten auslesen */
     include_once USER_DIR . 'config/user-config.inc.php';
     /*Aktuelle Seite ermitteln */
     $page = Page::get_current_page($this->_gpc['GET']);
     //Ein paar Daten berechnen
     $bildproseite = (int) (GALLERY_PICS_X * GALLERY_PICS_Y);
     $start = (int) (($page - 1) * $bildproseite);
     //Anzahl Eintraege
     $this->_mysql->query("SELECT * FROM gallery_eintraege WHERE fid_album = '{$gal_ID}'");
     $number = $this->_mysql->num_rows();
     //Eintraege und Albenname abrufen
     $this->_mysql->query("SELECT `gallery_eintraege`.`fid_bild` as 'img_ID', `gallery_alben`.`name`, `gallery_alben`.`ref_ID`\n\t\t\t\t\t\t\tFROM `gallery_eintraege`,`gallery_alben`\n\t\t\t\t\t\t\tWHERE `gallery_alben`.`ID` = '{$gal_ID}' AND `gallery_eintraege`.`fid_album` = '{$gal_ID}'\n\t\t\t\t\t\t\tORDER BY `gallery_eintraege`.`sequence`\n\t\t\t\t\t\t\tLIMIT {$start},{$bildproseite}");
     $this->_mysql->saverecords('assoc');
     $gallery_imgs = $this->_mysql->get_records();
     $gallery_name = $gallery_imgs[0]['name'];
     $cat_ID = $gallery_imgs[0]['ref_ID'];
     $pages_array = Page::get_static_pagesnav_array($number, $bildproseite, $this->_gpc['GET']);
     $root = $this->_getRoot($cat_ID, true);
     //Smarty-Variablen belegen
     $this->_smarty->assign('root', $root);
     $this->_smarty->assign("pages", $pages_array);
     $this->_smarty->assign("gallery", $gallery_imgs);
     $this->_smarty->assign(array('thispage' => $page, 'number' => $number, 'gal_ID' => $gal_ID, 'top_ID' => $root[count($root) - 1]['ID'], 'gallery_name' => $gallery_name, 'breakline' => GALLERY_PICS_X));
 }

    private function _view()
    {
        $this->_tpl_file = "members.tpl";
        $members = array();
        $this->_mysql->query('Select members_ID, members_name, members_spitzname, 
		DATE_FORMAT(`members_birthday`, \'%W, %e.%m.%Y\') as members_birthday, members_song, members_hobby, 
		members_job, members_motto, members_FIDimage FROM `members` 
		ORDER BY `members`.`members_birthday` ASC Limit 0,30');
        $this->_mysql->saverecords('assoc');
        $members = $this->_mysql->get_records();
        $this->_smarty->assign('members', $members);
    }

 /**
  * Zeigt die einzelnen Contents an.
  *
  * @param int $number Anzahl Einträge pro Seite
  */
 private function _view($number = 15)
 {
     $this->_tplfile = 'content.tpl';
     $this->_mysql->query("SELECT COUNT(*) as 'count' FROM `content`");
     $count = $this->_mysql->fetcharray('assoc');
     $count = $count['count'];
     $page = Page::get_current_page($this->_gpc['GET']);
     $pages_nav = Page::get_static_pagesnav_array($count, $number, $this->_gpc['GET']);
     $start = ($page - 1) * $number;
     $this->_mysql->query("SELECT `content_ID` , `content_title` , `content_text` ,\n\t\tDATE_FORMAT(`content_time`, '{$this->_timeformat}') as 'content_time', `content_archiv`\n\t\tFROM `content` \n\t\tORDER BY `content_archiv` ASC, `content_time`,`content_changed_time` LIMIT {$start}, {$number}");
     $this->_mysql->saverecords('assoc');
     $content_data = $this->_mysql->get_records();
     $this->_smarty->assign('contents', $content_data);
     $this->_smarty->assign('pages', $pages_nav);
 }

 /**
  * Zeigt die einzelnen Contents an.
  *
  * @param int $number Anzahl Einträge pro Seite
  */
 private function _view($number = 20)
 {
     $this->_tplfile = 'module.tpl';
     if ($this->_isformsend()) {
         $this->_updmods();
     }
     $this->_mysql->query("SELECT COUNT(*) as 'count' FROM `modules`");
     $count = $this->_mysql->fetcharray('assoc');
     $count = $count['count'];
     $page = Page::get_current_page($this->_gpc['GET']);
     $pages_nav = Page::get_static_pagesnav_array($count, $number, $this->_gpc['GET']);
     $start = ($page - 1) * $number;
     $this->_mysql->query("SELECT `modules_ID`, `modules_name`, `modules_file`, `modules_template_support`, `modules_mail_support`, `modules_status` FROM `modules` LIMIT {$start}, {$number}");
     $this->_mysql->saverecords('assoc');
     $modules_data = $this->_mysql->get_records();
     $this->_smarty->assign('modules', $modules_data);
     $this->_smarty->assign('pages', $pages_nav);
     $this->_smarty->assign('info', $this->_getinfo(true));
 }

 /**
  * Kontrolliert, ob die angegebenen Spalten vorhanden sind
  * @see _get_tabledata
  *
  * @param array $table_data
  * @return boolean
  */
 private function _check_mailtable()
 {
     $table_infos = array();
     $colums_names = array();
     $columns_search = array($this->mail_tbl['column_ID'], $this->mail_tbl['column_name'], $this->mail_tbl['column_email']);
     $this->_mysql->query("SHOW COLUMNS FROM `{$this->mail_tbl['table']}`");
     $this->_mysql->saverecords('assoc');
     $table_infos = $this->_mysql->get_records();
     //Zuschneiden von $table_infos (komplexes Array) in ein einfaches Array
     foreach ($table_infos as $key => $value) {
         $colums_names[$key] = $table_infos[$key]['Field'];
     }
     //Sind die angebenen Spalten vorhanden?
     foreach ($columns_search as $value) {
         if (in_array($value, $colums_names) === false) {
             return false;
         }
     }
     return true;
 }