Zend DB Query Dump

June 25th, 2013

If you ever need to see the SQL that Zend DB has created, so that you can run it manually or any other reason, here’s how to do it.

// Turn on the profiler
$db->getProfiler()->setEnabled(true);

// Run your query
$db->update('someTable', array(
    'thisField' => 0.12551,
    'anotherField' => 'xxxxxxxxxxxx'
), 'whatId = ' . $cdsDB->quote('james'));

// Output the last query
echo "\n" . $db->getProfiler()->getLastQueryProfile()->getQuery() . "\n";

// And the parameters for it
print_r($db->getProfiler()->getLastQueryProfile()->getQueryParams());

// Then turn the profiler off, unless you want to do more
$db->getProfiler()->setEnabled(false);

/*
    And the output is

    UPDATE `someTable` SET `thisField` = ?, `anotherField` = ? WHERE (whatId = 186459)
    Array
    (
        [1] => 0.12551
        [2] => xxxxxxxxxxxx
    )
*/

Strip Whitespace Out Of A File

June 6th, 2013

sed is a wonderful tool. Just used this command today to remove most of the whitespace from a file.

sed 's/ //g' test.txt > test2.txt

WordPress - Entries (RSS) and Comments (RSS) - © 2011 Ben Dauphinee