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