[eluser]chejnik[/eluser]
Hello, I would like to built dynamically a table (based on database values from Database settings table) with form elements and fill these elements from sql query made on Dictionary database with dictionary values)
my model function
Code:
function findExactWord($id)
{
$this->db->where('id', $id);
$query = $this->db->get('is-cs');
return $query->result_array();
}
my controller
Code:
function editWord($id)
{
$this->load->model('Dictionary_model');
//returns array
$word = $this->Dictionary_model->findExactWord($id);
$data = $this->makePageHeadwordFill($word);
$this->load->view('editheadwordview', $data);
}
function makePageHeadwordFill($word)
{
$this->load->model('Settings_model');
// returns array
$page = $this->Settings_model->select_makePage($this->session->userdata('i'));
$i=0; $j=0;
foreach ($page as $item) {
$i++; $j++;
$headings[$i]= $item["onWeb"];
switch ($item["nameInputElement"]) {
// hidden element
case '0':
$elements[$i]=$item["onWeb"];
$i++;
$elements[$i]= form_hidden($item["databaseRowName"], $word[$j];
break;
// input element
case '1':
$elements[$i]=$item["onWeb"];
$i++;
$elements[$i]= form_input($item["databaseRowName"], $word[$j];
break;
// text element
case '2':
$elements[$i]=$item["onWeb"];
$i++;
$elements[$i]= form_textarea($item["databaseRowName"], $word[$j]);
break;
default:
}
}
$output ='';
$table = $this->table->make_columns($elements, 2);
$data["completePage"] = $this->table->generate($table);
return $data;
}
my view
Actually I am having troubles with using the array $word. I do not know how to output the values.
Thank you.
With regards Ales