IFNULL - MySQL

IFNULL(`field1`, `field2`)

That returns field1 if it’s not null. However, it will return field2 if it is null.

Notes On JOIN - MySQL

• If your INNER join is returning too few values and duplicates, you’re probably using the wrong kind of join. Try a LEFT join.
• INNER JOIN is the same as JOIN
• http://i.stack.imgur.com/GbJ7N.png (diagram explaining joins)
• LEFT JOIN is used - this will return ALL rows from Table1, regardless of whether or not there is a matching row in Table2.

Indexes Help... A Lot

I just brought 4 queries from 15 seconds to less than 1 second by adding indexes to the columns in the ON() portion on the join.

Indexes help… A lot.

Yii-Booster Incorrect Width

Set public $responsiveCss = false; to public $responsiveCss = true;

group_concat - MySQL

http://mahmudahsan.wordpress.com/2008/08/27/mysql-the-group_concat-function/

This seems like it will be super useful.

If you’re using “group by” and you still want to get data out of the grouped rows, then you can use this to combine multiple rows into a single row.

Looping Through Associative Array - PHP

http://stackoverflow.com/questions/1951690/php-how-to-loop-through-a-associative-array-and-get-the-key-name

This was totally not very intuitive. I was expecting something like this:

foreach($array as $sub) {
    echo(key($sub));
}

Instead, it’s this:

foreach ($decodedOutput as $key => $value) {
    echo $key;
}

Search Directory For String - Linux

grep -rl "search_for_this_string" /var/www

PHPExcel Convert Excel Serial Date To MM/DD/YY

PHPExcel_Shared_Date::ExcelToPHPObject($value)->format("m/d/y")

Easiest Way To Consume .Net Web Services - Python

The suds library is the easiest way I found to consume .NET SOAP web services from Python, with Python acting as the web service client. I first picked it up from Jan Sipke’s tutorial.

Here’s an example of my simple client:

from suds.client import Client
client = Client("http://xxx.xxx.xxx.xxx/API/Info.asmx?WSDL")
client.service.getInfo("05/12/2013", "05/12/2013")

New Vocabulary Word

CRUD

• Create
• Read
• Update
• Delete

An example of a CRUD application would be something that tracks orders in a database. All 4 actions are going to be necessary to track those orders. CRUD: The basic database operations.