Dropdown from database

[eluser]hrg.vincent[/eluser]

Code:

//Controller
public function getEntryType()
{
$this->load->helper('form');
$this->load->helper('url');
$data['entry_type'] = $this->Data_m->getEntryType($data);
  
$this->load->view('ajax/new_request_form', $data);
}

//Models
function getEntryType($data)
{
$this->db->select(PARAMETER_TABLE.'.gid, '.PARAMETER_TABLE.'.pname');  
$this->db->from(PARAMETER_TABLE);

$result = $this->db->get();
$return = array();
if($result->num_rows() > 0) {
  foreach($result->result_array() as $row) {
   $return[$row['gid']] = $row['pname'];
  }
}
return $return;
}

//Views
<?php echo form_dropdown('gid', $entry_type); ?>

I get error from dropdown. "Message: Undefined variable: entry_type"
And the dropdown is empty.

[eluser]hrg.vincent[/eluser]
anyone can help pls?

[eluser]CroNiX[/eluser]
$data['entry_type'] = $this->Data_m->getEntryType($data);

Where is $data defined that you are passing to getEntryType()? Further, it doesn't seem you use it within that method anyway.

In Controller, try:

Code:

$data['entry_type'] = $this->Data_m->getEntryType();

In Model, try:

Code:

function getEntryType()
{
$this->db->select('gid, pname');  
$result = $this->db->get(PARAMETER_TABLE);
$return = array();
if($result->num_rows() > 0) {
  foreach($result->result_array() as $row) {
   $return[$row['gid']] = $row['pname'];
  }
}
return $return;
}

And I assume you actually do have PARAMETER_TABLE defined somewhere.

[eluser]hrg.vincent[/eluser]
I've define the parameter custom.php under config

Code:

$myDBPre = 'vap_';
define('PARAMETER_TABLE' , $myDBPre.'parameter');

CroNiX, I've tried your code but still the same
Severity: Notice
Message: Undefined variable: entry_type
Filename: ajax/new_request_form.php

Actually I'm new to codeigniter. From my code, I've multiple php file in models, controllers and view.