Guest User

Untitled

a guest
Jan 22nd, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1. public function get_titles() {
  2. $title = $this->db->get('TB_TITLES');
  3. return $title->result_array();
  4. }
  5.  
  6. public 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.  
  24. CREATE TABLE IF NOT EXISTS tb_titles(
  25. ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
  26. NAME VARCHAR(100) NOT NULL,
  27. DESCRIPTION VARCHAR(500),
  28. VALUE DOUBLE NOT NULL,
  29. PAID_OUT_AT TIMESTAMP NOT NULL,
  30. REGISTERED_AT TIMESTAMP DEFAULT CURRENT_TIMESTAMP(),
  31. UPDATED_AT TIMESTAMP DEFAULT CURRENT_TIMESTAMP()
  32. );
Add Comment
Please, Sign In to add comment