CodeIgniter Forums
db stuff - Printable Version

+- 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);
when I ran the page, I received a T_Function error.
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.