New to ZF, question about selects

pkbarbiedoll · #1 (**permalink**) 07-22-2008, 11:18 AM

Hi, I've been programming procedurally for years (maintaining legacy apps) but my company is ready to move forward with oop based apps. I'm interested in ZF since I also use Zend Studio and I think some of the framework is built into Studio.

One of the things that concerns me with any framework is loss of capability over existing code. I join tables with many queries and haven't seen any examples of how to do this in ZF. Also, can I specify the fields I need to select or will all be returned (a la SELECT * FROM)

bennell · #2 (**permalink**) 07-22-2008, 02:32 PM

Check out the section of the manual about building select statements. You can do different kinds of joins, and select individual columns to select

Zend Framework: Documentation

dele454 · #3 (**permalink**) 07-23-2008, 02:02 AM

Quote:

Originally Posted by pkbarbiedoll

Hi, I've been programming procedurally for years (maintaining legacy apps) but my company is ready to move forward with oop based apps. I'm interested in ZF since I also use Zend Studio and I think some of the framework is built into Studio.

One of the things that concerns me with any framework is loss of capability over existing code. I join tables with many queries and haven't seen any examples of how to do this in ZF. Also, can I specify the fields I need to select or will all be returned (a la SELECT * FROM)

To select individual columns you simply specify those columns in your from() function

e.g

Code:

//create instance of your Db_Table class
//$db is your db adapter
...
$select = $db->select()->from(column1,column2)->where(condition);
...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode