+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forum-21.html)
+--- Thread: db stuff (/thread-26237.html)
db stuff - El Forum - 01-09-2010
[eluser]sasori[/eluser]
is it mandatory to create a function first on the controller before
being allowed to execute an insert or any db stuff queries? :question:
e.g
I loaded the $this->load->database() from the constructor and then at the bottom I did these,
Code:
$data = array(
'url'=> 'www.mynewclient.com',
'name' => 'bigco inc',
'id' => '33',
);
$this->db->insert('sites',$data);then when I wrapped those query inside a function and it worked :gulp:
db stuff - El Forum - 01-09-2010
[eluser]Jamie Rumbelow[/eluser]
A T_FUNCTION error is a syntax error - are you sure your syntax is correct?
You should be able to directly query out of a controller function, but by the Model-View-Controller convention you should put any data-related functionality in the Model.
Jamie
db stuff - El Forum - 01-09-2010
[eluser]JHackamack[/eluser]
You should create a function on the controller first (such as index) so CI knows what to display by default.