Codeigniter - SQL query from view

Question

I know its not meant to be done, but could someone show me how to run an SQL query from a view.

Cheers

user229044 · Accepted Answer · 2010-12-05 05:17:41Z

1

I assume you mean you want access to your models? You can get the main CodeIgniter object/controller with get_instance(), and then access the model through that:

$ci =& get_instance();

$ci->Model_name->find(...);

answered Dec 5, 2010 at 5:17

user229044♦

241k41 gold badges347 silver badges350 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Chris Over a year ago

Thanks for that .... Im fairly new to CI ... So i enter that into my view? ... and then replace the 'find' with 'query' ?? could you give me an example of using that to write a query

user229044 Over a year ago

You replace find with whatever method you've written to perform the query.

Collectives™ on Stack Overflow

Codeigniter - SQL query from view

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related