##Given Apache 2 and MySQL are already installed.
#Update MacPorts sudo port selfupdate;sudo port -u upgrade outdated
#Install PHP 5.4.* sudo port install php54 php54-apache2handler ##Activate Apache Module cd /opt/local/apache2/modules
/** | |
* Property: mapTypes | |
* The types of map we're switching between | |
*/ | |
mapTypes: (function() { | |
var div = document.createElement('div'); | |
div.innerHTML = '<!--[if lte IE 6]><i></i><![endif]-->'; | |
if (!!div.getElementsByTagName('i').length) { |
#!/usr/bin/env python | |
""" | |
Usage: cat mycsvfile.csv | ./csv2json.py > myjson.json | |
""" | |
import fileinput | |
import json | |
rows = [] | |
headers = [] | |
first_row = True |
var i18n = new Translations("en"); | |
i18n.get('search.prompt'); | |
i18n.setLanguage("cy"); | |
i18n.get('search.prompt'); |
package uk.co.bbc.naturewatch; | |
import android.os.Bundle; | |
import android.view.View; | |
import com.google.android.glass.app.Card; | |
import com.google.android.glass.widget.CardBuilder; | |
import uk.co.bbc.naturewatch.tasks.Task; | |
import uk.co.bbc.naturewatch.tasks.TaskList; | |
import java.util.ArrayList; |
// .. presence checking using switch/case | |
switch ($value) { | |
case 'value1': | |
case 'value2': | |
case 'value3': | |
//.. etc | |
} | |
// .. or isset() for checking keys |
$newArray = $array1 + $array2; //.. unions |
define('LOG_LEVEL_TRACE', 1); | |
define('LOG_LEVEL_DEBUG', 2); | |
define('LOG_LEVEL_INFO', 4); | |
$logSet = LOG_LEVEL_TRACE; | |
$logSet |= LOG_LEVEL_INFO; | |
if ($logSet & LOG_LEVEL_TRACE) { | |
echo 'Trace<br />'; | |
} |
##Given Apache 2 and MySQL are already installed.
#Update MacPorts sudo port selfupdate;sudo port -u upgrade outdated
#Install PHP 5.4.* sudo port install php54 php54-apache2handler ##Activate Apache Module cd /opt/local/apache2/modules
SELECT SETVAL((SELECT pg_get_serial_sequence('<table_name>', '<serial_column>')), 1, false); |
SELECT | |
... | |
ST_X(<column_name>::geometry), | |
ST_Y(<column_name>::geometry), | |
FROM <table_name> |