Using $this->input->post in a SQL Query Update

[eluser]Derek Jones[/eluser]
I personally like to create a new associative array of field names with values. It's cleaner in the code to me, and more explicit about what's being set to what, and encourages you to think about validation and security. Then simply:

Code:

$this->db->update('table_name', $data_array);

Let CI escape it for you. If you prefer manually written SQL, that's fine too, just make sure you use $this->db->escape() or $this->db->escape_str() as necessary. Either way, you'll need to either break out of the string to execute that, or do it before hand and set it to a variable.