Thread

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
 

class News_model extends CI_Model {

 public function __construct() {
 
  $this->load->database("newsDB");
 }
 
 public function get_news($slug = FALSE) {
 
  if ($slug === FALSE) {
   $query = $this->db->get('news');
   return $query->result_array();
  }
   
  $query = $this->db->get_where('news', array('slug' => $slug));
  return $query->row_array();
 }
 

public function set_news()
{
 $this->load->helper('url');
 
 $slug = url_title($this->input->post('title'), 'dash', TRUE);
 
 $data = array(
  'title' => $this->input->post('title'),
  'slug' => $slug,
  'text' => $this->input->post('text')
 );
 
 return $this->db->insert('news', $data);
}
 
}

 
 
/* End of file: ./application/models/news_model.php */

<?php
class News extends CI_Controller {

 public function __construct()
 {
  parent::__construct();
  $this->load->model('news_model');
 }

 public function index()
{
 $data['news'] = $this->news_model->get_news();
 $data['title'] = 'News archive';
 $this->load->view('templates/header', $data);
 $this->load->view('news/index', $data);
 $this->load->view('templates/footer');
}

 public function view($slug)
{
 $data['news_item'] = $this->news_model->get_news($slug);

 if (empty($data['news_item']))
 {
  show_404();
 }

 $data['title'] = $data['news_item']['title'];

 $this->load->view('templates/header', $data);
 $this->load->view('news/view', $data);
 $this->load->view('templates/footer');
}  
 
 public function create()
{
 $this->load->helper('form');
 $this->load->library('form_validation');
 
 $data['title'] = 'Create a news item';
 
 $this->form_validation->set_rules('title', 'Title', 'required');
 $this->form_validation->set_rules('text', 'text', 'required');
 
 if ($this->form_validation->run() === FALSE)
 {
  $this->load->view('templates/header', $data); 
  $this->load->view('news/create');
  $this->load->view('templates/footer');
  
 }
 else
 {
  $this->news_model->set_news('');
  $this->load->view('templates/header', $data); 
  $this->load->view('news/success');
  $this->load->view('templates/footer');
 
 }
}
}

$active_group = 'newsDB';
$active_record = TRUE;

$db['newsDB']['hostname'] = 'localhost';
$db['newsDB']['username'] = 'root';
$db['newsDB']['password'] = '';
$db['newsDB']['database'] = 'newsDB';
$db['newsDB']['dbdriver'] = 'mysql';
$db['newsDB']['dbprefix'] = '';
$db['newsDB']['pconnect'] = TRUE;
$db['newsDB']['db_debug'] = FALSE;
$db['newsDB']['cache_on'] = FALSE;
$db['newsDB']['cachedir'] = '';
$db['newsDB']['char_set'] = 'utf8';
$db['newsDB']['dbcollat'] = 'utf8_general_ci';
$db['newsDB']['swap_pre'] = '';
$db['newsDB']['autoinit'] = TRUE;
$db['newsDB']['stricton'] = FALSE;
$db['newsDB']['port'] = 5432;