April 4, 2007

Selecting no fields of a table joined in a Zend_Db_Select

Filed under: PHP — Marcus @ 1:00 pm

I want to be able to use joins to limit the result set I get from a query, but I don’t want to actually select any values from the table I’m joining on, merely use it for making sure what I get back is what I asked for. However it seems there’s no way of saying “don’t select ANY columns from this joined table”.

Code (php)
  1.  
  2. $select->from(‘registereduser’, ‘*’)
  3. ->joinInner(’sessionbooking’, ‘registereduser.id=sessionbooking.userid’,
  4. new Zend_Db_Expr(’sessionbooking.status as status’))
  5. ->joinInner(’sessiontime’, ’sessiontime.id=sessionbooking.sessionid’, )
  6. ->where(’sessiontime.id=?’);
  7.  

So far I’ve resorted to adding something into Zend_Db_Select::_tableCols() to check if the $cols is empty or null and returning if that’s the case. Am I just going about constructing my query incorrectly?

March 28, 2007

PHP5 WSDL Auto-generation

Filed under: PHP, Downloads — Marcus @ 3:39 pm

So it doesn’t get lost, I’m putting up my old WSDL auto-generation code again… It’s now found its way into PRADO 3.1 as a new service type, though having looked around, I can see another generator that seems as good if not better, as it looks like it provides a few more features than what mine does.

PHP5 WSDL Autogen

June 6, 2006

Prado Components

Filed under: PRADO, PHP — Marcus @ 3:21 am

Because I have nothing better to do (…) I whipped something up for storing prado components: Prado Components. Started when I wanted to learn about Nested sets, and eventually became something usable (well, sort of ;)).

Not for production use yet, but hopefully it’ll get some usage over the next few days.

« Previous Page
.

Powered by WordPress