<code php> <?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(); } }

</code>

<code php> <?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'); }

}

</code>

<code php> <?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(); } }

</code>

<code php> /** * Note the use of row_array to get * array of one row instead of object * this will matter later in the whole * array that is passed to the view * @param string $wfield * the column we want to average * @param string $avgname * this is for the “as” clause * @param string $tablename * the name of the table the column is in * @return array * */ function get_avg($wfield,$avgname,$tablename) { $this→db→select_avg($wfield,$avgname); $query = $this→db→get($tablename) ; $avgdata = $query→row_array() ; return $avgdata ; }

}

</code>

<code javascript> $(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”) });

}); </code>