kqHpzP9E

1public function get_titles() {
2    $title = $this->db->get('TB_TITLES');
3    return $title->result_array();
4}
5	
6public function titulosCadastrados($page = 'titulosCadastrados') {
7    if (!file_exists(APPPATH.'views/pages/titulos/'.$page.'.php')) {
8        show_404();
9    }
10    $data['titles'] = $this->title_model->get_titles();
11    $this->load->view('templates/system-header');
12    $this->load->view('pages/titulos/titulosCadastrados', $data);
13    $this->load->view('templates/system-footer');
14}
15	
16<tbody>
17    <tr>  
18        <?php foreach ($titles as $title) { ?>
19            <tr><?php echo $title->name ?></tr>
20        <?php } ?>
21    </tr>
22</tbody>
23	
24CREATE TABLE IF NOT EXISTS tb_titles(
25ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
26NAME VARCHAR(100) NOT NULL,
27DESCRIPTION VARCHAR(500),
28VALUE DOUBLE NOT NULL,
29PAID_OUT_AT TIMESTAMP NOT NULL,
30REGISTERED_AT TIMESTAMP DEFAULT CURRENT_TIMESTAMP(),
31UPDATED_AT TIMESTAMP DEFAULT CURRENT_TIMESTAMP()
32);