Skip to content

Instantly share code, notes, and snippets.

View hughstimson's full-sized avatar

Hugh Stimson hughstimson

View GitHub Profile

Keybase proof

I hereby claim:

  • I am hughstimson on github.
  • I am hughstimson (https://keybase.io/hughstimson) on keybase.
  • I have a public key whose fingerprint is 29D2 18BE 927D C52A ECDF 33D4 F08C C806 15ED E858

To claim this, I am signing this object:

<?php
header('Content-type: text/plain');
$username = "[user]";
$password = "[password]";
$hostname = "localhost";
$database = "[database]";
// Opens a connection to a mySQL server
$connection=mysql_connect ($hostname, $username, $password);
<?php
/**
* PostGIS to GeoJSON
* Query a PostGIS table or view and return the results in GeoJSON format, suitable for use in OpenLayers, Leaflet, etc.
*
* @param string $geotable The PostGIS layer name *REQUIRED*
* @param string $geomfield The PostGIS geometry field *REQUIRED*
* @param string $srid The SRID of the returned GeoJSON *OPTIONAL (If omitted, EPSG: 4326 will be used)*
* @param string $fields Fields to be returned *OPTIONAL (If omitted, all fields will be returned)* NOTE- Uppercase field names should be wrapped in double quotes
* @param string $parameters SQL WHERE clause parameters *OPTIONAL*
@hughstimson
hughstimson / GemLoadError.md
Last active December 20, 2015 07:19
StackTrace and Gemfile related to Gem::LoadError

I installed Ruby using the RubyInstaller and DevKit on Windows 8. I'm using PostgreSQL 9.2 64bit.

The error:

Gem::LoadError
Specified 'postgresql' for database adapter, but the gem is not loaded. Add `gem 'pg'` to your Gemfile.

Gemfile: