[Hoergold2]

Hi there,

I found this CRUD tool it is awsome, great, superb - what everyone waited for some years and someone finally did it! Thanky!

As I am quite acquainted with PHP but totally new to Codeigniter (that is needed by GroceryCRUD I do not get the idea how I can query the databse (using Codigniter-Helpers in a Callback function. What I want to do is to check a (German) postal code that is typed in in a form and lookup the state where it is located. The needed data sits in an own table.

What I tried:

$crud->callback_before_insert(array($this,'plz_code'));

and then:

   function plz_code($post_array)

   {

   

    $plz = $post_array['plz'];	 // $plz = $this->db->escape_str($post_array['plz']);

    $ort = $post_array['ort'];	  // $ort = $this->db->escape_str($post_array[ort]);

   

    $query = $this->db->query("SELECT plz, ort, land from orte WHERE PLZ = $plz and ort = $ort ");

    if (count($query->row_array() > 0 )) {

	    $result = $query->row_array();

		 $plz_code = $result['Land'];

    } else {

	 $plz_code = 'XXX';

    }

	

    $post_array['b_land'] = $plz_code;

    return $post_array;

   }

I hope - though it is more a Codeigniter problem (that I am totally new with) - you might help with some lines? I would appreciate it very much!

Thanks in advance,
Martin

[victor]

HI!

function plz_code($post_array)

{

	 $search_criteria = array('PLZ' => $post_array['plz'],'ort'=>$post_array['ort']);

	 $result = $this->db->get_where('orte', $search_criteria)->row_array();

     $post_array['b_land'] = $result['Land']?$result['Land']:'XXX';

	 return $post_array;

}

[José Sánchez Córdoba]

For good code. The functions for db insert in MODEL best that in CONTROLLER. Sorry my english. Good day.