Lorna Mitchell: Introduction to Zend_Db
Recently, Lorna Mitchell has ben working with Zend Framework and Zend_Db_* to get a project up and running. She ran into some early problems figuring out how things are supposed to be put together. Once she did figure it out, she posted it to her blog for all to share in a post titled “Introduction to Zend_Db”:http://www.lornajane.net/posts/2008/Introduction-to-Zend_Db
bq. I recently worked on a project which was based on Zend Framework – I haven’t worked with it before and I was temporarily confused by the existing implementation of some of the database-level stuff. After much reading and untangling of code, I’m now pretty clear how this should look, so here’s my overview. I’m not going to go into setting up a whole application, but this is a quick primer on how data models go together.
If you are just starting to work with Zend Framework, it’s a good post to read over.
2 comments to “Lorna Mitchell: Introduction to Zend_Db”
March 13th, 2010 at 11:58 am
SELECT * FROM emp WHERE ename=’smith’ AND id=520
please tell me how to implement this qury in zend frame work
March 13th, 2010 at 3:24 pm
Hello All Zend Developers and contributors,
I want to ask that in zend framework Model class which is derived from Zend_Db_Table_Abstract how can we use ‘SQL JOINS’.
I have a requirement that i want to populate data which will come from two tables. Now i read the manual of zend_db there it was mention that because of some integrity issue the zend_db_table_abstract class can’t return the values of the y table. Means that if Zend_Db_Table_Abstract points to ‘x’ then it can’t retrive colums of ‘y’ table. Now if that is the case then how can we perform join and how can we use nested queries like:
Select u.id, u.name, atl.name, atl.desc FROM users u, articles atl Where u.id IN (SELECT z.uid FROM article_author WHERE u.id=123);
I posted a similar question at zend framework manual and didn’t get any reply. Please do reply because i need help asap.
Thanks in advance.