IFNULL - MySQL
IFNULL(`field1`, `field2`)That returns field1 if it's not null. However, it will return field2 if it is null.
That returns field1 if it's not null. However, it will return field2 if it is null.
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-nameThis 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/wwwPHPExcel 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
http://www.jansipke.nl/python-soap-client-with-suds/That article was very helpful for learning to use Python's SUDS library for consuming soap web services.
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")
"05/12/2013" and "05/12/2013" are both parameters
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.