Search code examples
phpmysqlcodeignitercodeigniter-3codeigniter-database

Displaying values in select box dynamically is not working in codeigniter


I am trying to get values in select box as dynamic is not working here is the my controller code below:

public function CreateNewAsset() 
{
    $data['courselist'] = $this->Dashboard_model->getDashboardCourses();
    $this->form_validation->set_error_delimiters('<div class="error">', '</div>');

    //Validating Name Field
    $this->form_validation->set_rules('topicname', 'Topicname', 'required');

   if ($this->form_validation->run() == FALSE) {
        $this->load->view('template/header');
        $this->load->view('Dashboard/CreateNewAsset');
        $this->load->view('template/footer');
    } else {

        //Setting values for tabel columns           
        $data = array(
            'courseid' => $this->input->post('courseid'),
            'topicname' => $this->input->post('topicname'),
            'refid' => $this->input->post('refid'),
            'startdate' => $this->input->post('startdate'),
            'expectedend' => $this->input->post('expectedend')
        );

        //Transfering data to Model
        $this->Dashboard_model->assetInsert($data);
        $data['message'] = 'Data Inserted Successfully';

        //Loading View
        $this->load->view('template/header');
        $this->load->view('Dashboard/CreateNewAsset', $data);
        $this->load->view('template/footer');
    }
}

Here is the my view below:

<form action="<?php echo base_url();?>Dashboard/CreateNewAsset" method="post">
    <div class="form-row">
        <div class="col-md-3">Course:</div>
        <div class="col-md-9"> 
         <select name="courseid" class="form-control">
               <option value="0">Select Course</option>
            <?php foreach ($courselist as $course) { ?>
                <option value="<?php echo $course->id; ?>"><?php echo $course->coursename; ?></option>
            <?php } ?>
        </select>
        </div>
    </div>
</form>

I have added both getting values and insert in the same function. is this the problem I am not getting values in drop-down can anyone help me what is the mistake and I am getting an error as Undefined variable: courselist


Solution

  • Change the insert part like this since u overriding $data:

      $insert_data = array(
            'courseid' => $this->input->post('courseid'),
            'topicname' => $this->input->post('topicname'),
            'refid' => $this->input->post('refid'),
            'startdate' => $this->input->post('startdate'),
            'expectedend' => $this->input->post('expectedend')
        );
        $this->Dashboard_model->assetInsert($insert_data);
    

    The whole code should be like this :

    NOTE : make sure u have loaded form_validation library and method getDashboardCourses return some data

    public function CreateNewAsset() 
    {
       $data['courselist'] = $this->Dashboard_model->getDashboardCourses();
       $this->form_validation->set_error_delimiters('<div class="error">', '</div>');
       $this->form_validation->set_rules('topicname', 'Topicname', 'required');
    
       if ($this->form_validation->run() == FALSE) {
            $this->load->view('template/header');
            $this->load->view('Dashboard/CreateNewAsset',$data);
            $this->load->view('template/footer');
       } 
       else 
       {
          $insert_data = array(
                'courseid' => $this->input->post('courseid'),
                'topicname' => $this->input->post('topicname'),
                'refid' => $this->input->post('refid'),
                'startdate' => $this->input->post('startdate'),
                'expectedend' => $this->input->post('expectedend')
            );
            $this->Dashboard_model->assetInsert($insert_data);
            $data['message'] = 'Data Inserted Successfully';
            $this->load->view('template/header');
            $this->load->view('Dashboard/CreateNewAsset', $data);
            $this->load->view('template/footer');
        }
    }