[eluser]WebbHelp[/eluser]
Controller:
Code:
function Blog()
{
parent::Controller();
$this->load->helper(array('form', 'url'));
$this->load->library('form_validation');
}
function index()
{
$generalquery = $this->db->query("SELECT title,header FROM general ORDER BY id DESC LIMIT 1");
if($generalquery->num_rows() > 0)
{
$row = $generalquery->row();
$data['title'] = $row->title;
$data['h1'] = $row->header;
}
$data['postquery'] = $this->db->get("inlagg");
if($data['postquery']->num_rows() == 0)
{
echo 'Inga poster i databasen';
}
$this->load->view('blog_view', $data);
}
function add()
{
if ($this->form_validation->run() == FALSE)
{
}
else
{
$insert = array(
'rubrik' => $_POST['subject'] ,
'message' => $_POST['message']
);
$this->db->insert('inlagg', $insert);
}
$this->load->view('add_view');
}
showblogg:
Code:
<h1><?php echo '<h1 align="center">'. $header .'</h1>'; ?></h1>
<?php
foreach ($postquery->result() as $row)
{
echo '<h1>'. $row->rubrik . '</h1>';
echo nl2br($row->message);
echo '<hr />';
}
?>
addblogpost:
Code:
<?php echo validation_errors(); ?>
<?php echo form_open('form'); ?>
Rubrik: <input type="text" name="subject" />
<br><br>
Meddelande:<br> <textarea name="message" cols="50" rows="7"></textarea>
<br>
<br>
<input type="submit" value="Lägg till" />
</form>