ReadWriteWeb: Infographic: PHP vs. Python vs. Ruby http://goo.gl/mag/NyklO
Malthusian Prophecies
The blog and posts of web developer Jason Anton
ReadWriteWeb: Infographic: PHP vs. Python vs. Ruby http://goo.gl/mag/NyklO
That is awesome! A lot of really big sites are using drupal. I love discovering more sites using it!
Image via CrunchBase
So Drupal 7 dynamic queries…love them, and hate them.
I just noticed that if you set execute the query, then use the results in a foreach you can’t reuse that result set in another foreach?! So if you’re looking to make a menu for dynamic content on the page (like a JQuery UI tab switcher dealy…that’s what I’m doing) you evidently can’t use the same query to populate both the ul and the content of each div? Lame.
….The more I LOVE! it.
The database abstraction layer is truly fantastic! It already was in Drupal 7 but they’ve definately made it more dynamic in 7. Love it! Check out this example where I’m creating a fairly straightforward, but not simple, query. In this query I’m pulling from one table and joining 2 more with all kinds of conditions and ordering logic. I can add or take away very quick without having to mine through a monster query!
$example_prepare = db_select('example', 'a');
$example_prepare->leftJoin('example_one', 'b', 'a.nid = b.nid');
$example_prepare->leftJoin('example_two', 'c', 'c.nid = a.nid');
$example_prepare->fields('a')
->fields('b', array('title','created'))
->fields('c',array('blahblah'))
->condition('a.created',$dateRange['value'],'>=')
->condition('a.created',$dateRange['value'],'<=')
->orderBy('a.created', 'ASC')
->orderBy('c.blahblah')
->orderBy('b.title');
$example = $example_prepare->execute();
