Does Expression Engine have a database abstraction layer or API?

Question

It seems that the only way to get entries out of EE is to use template tags or write SQL. I'd rather not write SQL since it's not very portable. I would expect EE to have some DAL so I could do something like:

// load entry of type "Post" with id 15
$this->EE->db->loadEntry('post',15);

Is SQL the only option to access data from PHP?

Turns out the secret lies within the Code Ingiter docs: codeigniter.com/user_guide/database/active_record.html#select — Matt
– Matt, Commented Jun 6, 2012 at 21:36

kant312 · Accepted Answer · 2012-06-07 13:19:38Z

2

You can use the following library, created by objectivehtml:
https://github.com/objectivehtml/Channel-Data

Of course, the best would be to have an API directly available in the EE core, but the existing one (Api_channel_entries) seems to only allow the creation or update of entries.

answered Jun 7, 2012 at 13:19

kant312

1,4141 gold badge20 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

Does Expression Engine have a database abstraction layer or API?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related