Thread

The Active Record plugin allows you to use CodeIgniter’s Active Record database pattern in the form of a template tag. It is meant as a replacement for the standard query module.

For example, you can replace this:

{exp:query sql="SELECT member_id, username FROM exp_members WHERE group_id = 1"}
    {username} - {member_id}

{/exp:query}

With this:

{exp:activerecord select="member_id, username" from="members" where:group_id="1"}
    {username} - {member_id}

{/exp:activerecord}

Download & Documentation

If you like this plugin, please rate and/or favorite it on Devot://ee 😊

Nice plugin but I couldn’t get limit to work and I was also wondering if it’s possible to pass ee tags into any of the parameters?

Start a thread here with some more details on your limit problem and I’ll get it sorted out: http://devot-ee.com/add-ons/support/activerecord/viewforum/1237/

To answer your second question, yes, you should be able to pass ee tags as parameters.

I finally got around to fixing the limit bug—limit was not working without pagination before, now it is.