Submit button in Insert Statement

[eluser]brianw1975[/eluser]
I'm surprised Colin didn't mention that you should check and process all of your data using $this->input->post("item_name") (or get or get_post, etc, check the userguide for more info) as CI does a bit of "data integrity" (XSS, etc) checking by default

Then create an appropriate array e.g.

Code:

$data = array("username"=>$this->input->post("username"),"password"=>$-this->input->post("password");

$this->db->insert('bus',$data);

Some people would argue that it's unnecessary if the site is password protected, or a intranet only application, but I postulate that at some point someone other than the existing user base will (hopefully) try to use the system (new employee for example) and could possibly do something naughty by quirk or design.