This is an old revision of the document!

Code Igniter Notes

Been looking at nettuts video tutorials and I am going to save some code snippets here so I can pick them up at work.

controller from lesson 5 CRUD

<?php
 
class Site extends Controller 
{
	function index()
	{
		$data = array();
 
		if($query = $this->site_model->get_records())
		{
			$data['records'] = $query;
		}
 
		$this->load->view('options_view', $data);
	}
 
	function create()
	{
		$data = array(
			'title' => $this->input->post('title'),
			'content' => $this->input->post('content')
		);
 
		$this->site_model->add_record($data);
		$this->index();
	}
 
	function update()
	{
		$data = array(
			'title' => 'My Freshly UPDATED Title',
			'content' => 'Content should go here; it is updated.'	
		);
 
		$this->site_model->update_record($data);
	}
 
 
	function delete()
	{
		$this->site_model->delete_row();
		$this->index();
	}
}

site model

<?php
 
class Site_model extends Model {
 
	function get_records()
	{
		$query = $this->db->get('data');
		return $query->result();
	}
 
	function add_record($data) 
	{
		$this->db->insert('data', $data);
		return;
	}
 
	function update_record($data) 
	{
		$this->db->where('id', 12);
		$this->db->update('data', $data);
	}
 
	function delete_row()
	{
		$this->db->where('id', $this->uri->segment(3));
		$this->db->delete('data');
	}
 
}

view

<?php
 
class Site extends Controller 
{
	function index()
	{
		$data = array();
 
		if($query = $this->site_model->get_records())
		{
			$data['records'] = $query;
		}
 
		$this->load->view('options_view', $data);
	}
 
	function create()
	{
		$data = array(
			'title' => $this->input->post('title'),
			'content' => $this->input->post('content')
		);
 
		$this->site_model->add_record($data);
		$this->index();
	}
 
	function update()
	{
		$data = array(
			'title' => 'My Freshly UPDATED Title',
			'content' => 'Content should go here; it is updated.'	
		);
 
		$this->site_model->update_record($data);
	}
 
 
	function delete()
	{
		$this->site_model->delete_row();
		$this->index();
	}
}

javascript - pass data to php and get json array back

been working on this for a while

$(document).ready(function() {
$('#submit_item').click(function(){
var wpt = $('select#wpt_pick').val();
alert(wpt);
$.post("/coords/index.php/pickcoords/chosen", { chosen: $('select#wpt_pick').val() },
 
       function(data) {
        $("#lat").html(data[0].lat);
       $("#lon").html(data[0].lon);
        },"json")
});
 
});