Select box hierarchically list

5 views
Skip to first unread message

PROSEL

unread,
Dec 25, 2013, 5:36:25 AM12/25/13
to codei...@googlegroups.com
Hi,
Like the example attached, How can i edit my code to list all the data hierarchically in select box?

[strong]VIEWS[/strong]
form_dropdown('page', $page);

[strong]CONTROLLERS[/strong]
[code]
$page = $this->MGenel->dropDown('page','',['lang'=>'en']);
[/code]

[strong]MODELS[/strong]
[code]
    function dropDown($table,$veriler='',$where='',$orderby='',$groupby='')
 {
  $this->db->from($table);
  
  if($where) $this->db->where($where);
  if($orderby) $this->db->order_by($orderby);
  if($groupby) $this->db->group_by($groupby);
  
  $query = $this->db->get();
  $return = array();
  if($query->num_rows() > 0):
  
   if(empty($veriler)): 
   $return[''] = '- Select -'; else:
 
    foreach($veriler as $ust => $ustu):
     if($ustu['ust'] == 0):
       $return[''] = '- Select -';
      else:
       $this->db->select('adi');
       $this->db->from($table);
       $queryust = $this->db->get();
       foreach($queryust->result_array() as $row):
       $return[$ustu['ust']] = $row['adi'];
       endforeach;
     endif;
    endforeach;
    
   endif;

   foreach($query->result_array() as $row) $return[$row['id']] = $row['adi'];
   
  endif;
  
  return $return;
  $query->free_result();
 }
[/code]

[strong]DATABASE[/strong]
[code]
CREATE TABLE IF NOT EXISTS `page` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL COMMENT 'Page Name',
  `topID` int(11) NOT NULL COMMENT 'Top of Page ID',
  `lang` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

INSERT INTO `page` (`id`, `name`, `topID`, `lang`) VALUES
(1, 'HOME', 0, 'en'),
(2, 'ABOUT US', 0, 'en'),
(3, 'Certificates', 2, 'en'),
(4, 'Organizational Structure', 2, 'en'),
(5, 'News & Announcements', 2, 'en');
[/code]

I'm using CodeIgniter V 1.7.2
select-box.gif
Reply all
Reply to author
Forward
0 new messages