Welcome Guest, Not a member yet? Register   Sign In
Select box hiyerarşik listeleme
#1

[eluser]kodkanyon[/eluser]
Hi,
Like the example attached, How can i edit my code to list all the data hierarchically in select box?

VIEWS
form_dropdown('page', $page);

CONTROLLERS
Code:
$page = $this->MGenel->dropDown('page','',['lang'=>'en']);

MODELS
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();
}

DATABASE
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');

I'm using CodeIgniter V 1.7.2




Theme © iAndrew 2016 - Forum software by © MyBB