[Sohibe Elmigo]

Hello everyone

can you please tell me how to edit data inside auto generated field (type: select "ComboBox") without changing html (design)

means i don't want to use my own html i want to use the same auto generated field html but custom data.

Thank you


i'll show you what i want to do exactly :

please take a look at db.png first

$crud->set_table('employee');



$crud->set_relation('BankBranch_idBankBranch', 'BankBranch', '{Bank_idBank} / {BankBranchName}');

this code will show the id of the bank but i want the name of the bank

i managed to make a callback to get the bankName / BankBranchName but without the auto field html (design)

Thank you again

[deib97]

u can use change_field_type with enum on mysql

[davidoster]

u can use change_field_type with enum on mysql

 

How this will help [member=deib97]?

 

Because you need information from another table there is no way from a set_relation to get data from multiple tables (unless you use set_relation_n_n).

 

This can be done by using a custom model,

 

check this sample code:

 

/* model */
function get_activities($table)
{
	$this->db->select('id, year, description');
	$this->db->order_by('id desc');
	return $this->db->get($table);
}


/* controller */
$this->load->model('itemmodel');
$activities = $this->itemmodel->get_activities("activities");
foreach ($activities->result() as $row)
{
	$myarray[$row->id] .= $row->description;
}
$this->grocery_crud->field_type('interest_for','multiselect',$myarray);

[deib97]

thanks davidoster, i will try with your code. :)