OK, so now I’ve got jobs being listed… and mapped. And a bonus from LinkedIn, an easy-to-install, no login required widget. The user will have to be logged in on LinkedIn to use it, but it will show any connections to companies that come up in the job search. Now if only Zillow would let me show more than one address’ listing at a time…

Next up: adding in the address “not really a search” box.

Relocator

Fun and troublesome!
Mashup in progress

Issues:

1. Installing PEAR on shared GoDaddy server, thanks to Abby and Win’s Blog
2. Getting Zillow data (easy!)
3. Altering GoogleMapAPI.class.php (from phpinsider.com)
   1. Moving from PEAR DB to MDB2 (what I used for reference because DB is deprecated in the latest version of PEAR)
   2. changed function getCache:
      function getCache($address) {
if(!isset($this->dsn)) return false;
$_ret = array();
// PEAR MDB2
require_once("MDB2.php");
$_db =& MDB2::connect($this->dsn);
if (PEAR::isError($_db)) {
die($_db->getMessage() . ', ' . $_db->getDebugInfo());
}
if (PEAR::isError($_db)) {
die($_db->getMessage(). ', ' . $_db->getDebugInfo());
}
$_res =& $_db->query("SELECT lon,lat FROM {$this->_db_cache_table} where address = '$address'");
if (PEAR::isError($_res)) {
die($_res->getMessage(). ', ' . $_res->getDebugInfo());
}
if($_row = $_res->fetchRow()) {
$_ret['lon'] = $_row[0];
$_ret['lat'] = $_row[1];
}
$_db->free();
return !empty($_ret) ? $_ret : false;
}
   3. changed function putCache:
      function putCache($address, $lon, $lat) {
if(!isset($this->dsn) || (strlen($address) == 0 || strlen($lon) == 0 || strlen($lat) == 0))
return false;
// PEAR MDB2
require_once("MDB2.php");
$_db =& MDB2::connect($this->dsn);
if (PEAR::isError($_db)) {
die($_db->getMessage() . ', ' . $_db->getDebugInfo());
}
$_res =& $_db->query("insert into ".$this->_db_cache_table." values ('$address', $lon, $lat)");
if (PEAR::isError($_res)) {
die($_res->getMessage());
}
$_db->free();
return true;
}
   4. GoogleMap API (easy once I figured it liked addresses better than the lat/long Zillow was returning…)

Stay tuned for more developments…

To do:

1. fix line-height of superscripted registration mark
2. integrate multiple listings
3. integrate search
4. integrate 2 other (maybe 3?) API’s to be named later

Check out Whitney’s blog/podcast haven, DirtyLeaves.com— the link is to his blog, but there are some even more awesome podcasts including 2009 BEST OF THE FIRST ½ (PART 1 • PART 2). The man knows how to lay down the grooves, I tell ya.

This is the logo I developed for CyberhuntLIVE, an online game website launching soon. What do you think?