Differences

This shows you the differences between two versions of the page.

--- codeigniter [2010/05/26 19:37] – created rfile
+++ codeigniter [2011/03/07 21:09] (current) – rfile
@@ Line 5: / Line 5: @@
 [[http://codeigniter.com/wiki/Category:Help::Tutorials|tutorial list]]
+[[http://net.tutsplus.com/articles/news/codeigniter-from-scratch-day-5-crud/| tutorial 5]]
 <box 70% blue | controller from lesson 5 CRUD>
 <code php>
@@ Line 140: / Line 143: @@
 </code>
 </box>
+<box|use of row_array()>
+<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>
+</box>
+<box | second database>
+<code php>
+<?php
+class Model_old_info extends CI_Controller {
+       function __construct()
+       {
+            parent::__construct();
+            // Your own constructor code
+            $CI =& get_instance() ;
+       $CI->oldbp = $this->load->database('oldbp', TRUE);
+       $this->oldbp =& $CI->oldbp;
+       }
+       function get_old_records() {
+       $table_name = 'old_blood_pressure' ;
+       $oldbprec = $this->oldbp->get($table_name);
+       foreach ($oldbprec->result()as $row) {
+             $table_data[] = $row ;
+          }
+          return $table_data;
+   }
+       }
+</code>
+'oldbp' is in the codeigniter database config file
+</box>
+===== javascript - pass data to php and get json array back =====
+<box  green 70% |been working on this for a while>
+<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>
+</box>