Debugging queries with symfony, doctrine and sprintf

Sometimes it is useful to see what parameters were passed to a query, using getSqlQuery we get the query with question marks and its annoying to then grab the query and play around with it... below is a quick fix for this problem, this purely a technique to save development time and you shouldn't leave var_dumps in your production code :)

var_dump(array(
 'sql_query' => sprintf(
  str_replace('?', '%s', $q->getSqlQuery()), 
      $parameter1, $parameter2, $parameter3
 )
));

Filtering JavaScript Arrays

Below is an example of how you can filter a JavaScript array using jQuery

var foo = new Array(5);
foo[0] = "zero";
foo[1] = "one";
foo[2] = "two";
foo[3] = "three";
foo[4] = "four";

alert(foo);

fooSelected = jQuery.grep(foo, function(value) {
        return value != "three";
} );

alert(fooSelected);

No more print_r's or var_dumps to the web browser

Here is a neat way to dump objects to the log file instead of the browser, just add the following function to your actions class

class yourActions extends sfActions

/**
other code...
**/

/**
 * Just a neater way of dumping objects to the log file instead of the browser
 * 
 * @param $foobar
 * @param $priority
 * @author Richard Udovich 
 * @return void
 * @see self::logMessage()
 */
public function logFoobar($foobar, $priority = 'info') {
 if (in_array('Doctrine_Record', class_parents($foobar))) {
  $table_name = $foobar->getTable()->getClassnameToReturn();
  $this->logMessage('Dumping '.$table_name. "\n".print_r($foobar->toArray(), true).')', 'debug');
 }
}

JS Bin - Collaborative JavaScript Debugging

Great tool allows you to quickly test out and collaborate javascript development, kind of like pastebin for javascript

JS Bin - Collaborative JavaScript Debugging