从codeigniter中的数据库选择下拉列表 [英] making a select dropdown from database in codeigniter

问题描述

我是新的codeigniter.I想做一个选择dorpdown从数据库获取它的值和标题。我尝试一些代码，但它没有工作。有我的代码：

I am new with codeigniter.I want to make a select dorpdown that gets its value and title from database.I tried some codes but it did not work.There are my codes:

Model
    function get_sec_info(){
    $records=$this->db->query('SELECT sec_id,name FROM section');
    if($records->num_rows() > 0)
    return $records->result();}
Controller
    function sec_ifo(){
    $data['rec']=$this->mymodel->get_sec_info();
    $this->load->view('article',$data);}
View
    <select name="section">
    <?php foreach($rec as $row) {?>
    <option value="<?php echo $row->sec_id?>"><?php echo $row->name ?></option>"
    <?php } ?>

它不会显示任何错误和任何选项， / p>

It does not show any error and any option to show

推荐答案

在您的控制器中，您传递的值类似于

In your controller you are passing value like

$data['red']=$this->mymodel->get_sec_info();

b $ b

并且在您看来，您正在获取

and in you view you are taking value like

<?php foreach($rec as $row) {?>

所以将vairiable $ rec更改为$ red 在您的视图中像

So change the vairiable $rec to $red in your view like

<?php foreach($red as $row) {?>

这篇关于从codeigniter中的数据库选择下拉列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！