Time to relearn a new skill: Spark

I took a Spark class maybe earlier this year but can’t say I really remember any of it.  Figured I’ll just start at the beginning with an Intro to Spark class on edx.org.



These days just developing an excel like webpage using handsontable.  Not very interesting at all.

Posted in Coding, Web | Leave a comment

Clash Royale Card Calculator

I play Clash Royale and decided to make a card calculator to calculate what level troops I would have with all my cards and how much gold it would cost.  I don’t upgrade all of the troops because who has enough gold for that?

I’m debating whether I want to make a mobile app for this.  On my github page I have the project hosted there too.

Here it is:



Posted in App Idea | Leave a comment

TCPDF: Open Source PHP Class for generating PDF documents.

Been using TCPDF the last couple of days and have to say it is real easy to use.  The examples are really easy to follow and then customize to one’s own needs.

Really easy to format the PDF using the table type format of using the function Cell() and MultiCell().  Only tricky thing about MultiCell is if the cell’s content is multiple lines.  You have save the output of MultiCell() (returns number of rows used) and then add that many lines after (ln(output)).  If you don’t do it you will have cells on top of the multicell.

$numRows = $this->MultiCell()

Haven’t gotten around to using the barcode but that’s probably what I’ll be looking at in the future.

Posted in Coding, Web | Tagged | Leave a comment

ADOdb library

Came across this today. Well saw someone use this library. seems pretty neat to check out more later.  Been writing my own SQL code for PHP scripts. Think this library can make this easier and generate part of it I believe



Posted in Coding | Tagged , | Leave a comment

Google Geocoding API Example in PHP

I had to quickly create a script to set the latitude and longitude value in a DB knowing the address.

I googled and found this codeofaninga.com site that explained the basics of how to use the Google Geocoding API.

I decided to expand on his example and create a script that shows one how to get the individual address components and save them in an associative array.  Saving them in an associative array makes it a bit cleaner.  I guess a better way can be to save it in a class and use get functions for the cleanest solution.  I’ll leave that to the next person.  Here is my example on my github page.


$addr = "1600 Pennsylvania Avenue, 20500";

$result = geocode($addr);


echo "The full address is: ".  $result['formatted_address'] 
." with latitude: ".$result['lat'] ." and longitude: ".$result['lon']." \n";

// function to geocode address, it will return false if unable to geocode address
function geocode($address){
    // url encode the address
    $address = urlencode($address);
    // google map geocode api url
    $url = "http://maps.google.com/maps/api/geocode/json?sensor=false&address={$address}";
    // get the json response
    $resp_json = file_get_contents($url);
    // decode the json
    $resp = json_decode($resp_json, true);
    // response status will be 'OK', if able to geocode given address 
        // get the important data
		$street_number = NULL;
		$street_name = NULL;
		$city_name = NULL;
		$county_name = NULL;
		$state_name = NULL;
		$state_abbr = NULL;
		$country_name = NULL;
		$country_abbr = NULL;
        $lati = $resp['results'][0]['geometry']['location']['lat'];
        $longi = $resp['results'][0]['geometry']['location']['lng'];
        $formatted_address = $resp['results'][0]['formatted_address'];
		$address_components = $resp['results'][0]['address_components'];
		foreach ($address_components as $component) {
			$type = $component['types'][0];
			if ($type == 'street_number')
				$street_number = $component['short_name'];
			else if ($type == 'route')
				$street_name = $component['short_name'];
			else if ($type == 'locality')
				$city_name = $component['short_name'];
			else if ($type == 'administrative_area_level_2')
				$county_name = $component['short_name'];
			else if ($type == 'administrative_area_level_1') {
				$state_name = $component['long_name'];
				$state_abbr = $component['short_name'];
			else if ($type == 'country') {
				$country_name = $component['long_name'];
				$country_abbr = $component['short_name'];
			else if ($type == 'postal_code')
				$postal_code = $component['short_name'];
        // verify if data is complete
        if($lati && $longi && $formatted_address){
            // put the data in the array
            $data_arr = array();   

			$data_arr['street_number'] = $street_number;
			$data_arr['street_name'] = $street_name;
			$data_arr['city_name'] = $city_name;
			$data_arr['county_name'] = $county_name;
			$data_arr['state_name'] = $state_name;
			$data_arr['state_abbr'] = $state_abbr;
			$data_arr['country_name'] = $country_name;
			$data_arr['country_abbr'] = $country_abbr;
			$data_arr['lat'] = $lati;
			$data_arr['lon'] = $longi; 
			$data_arr['formatted_address'] = $formatted_address;
            return $data_arr;
            return false;
        return false;







Posted in Uncategorized | Leave a comment

iOS: Alamofire and SwiftyJSON

Alamofire is great to use to create an iOS app to web service.

SwiftyJSON makes parsing JSON much simpler too.

Liked this example for Alamofire



Posted in iOS | Tagged | Leave a comment

iOS Swift Tutorial

Working on iOS app these days.  Updated an old iOS app that had to old Search Bar to the new iOS 8 version of Search Bar. Objective C

Now doing POC for a new iOS app in Swift.

Not a fan of Objective C and Swift. Though Swift seems to be more like other typical programming languages.

I like this iOS Swift tutorial


Posted in iOS | Tagged , , | Leave a comment

Deleting messages in mailq

Had all these messages stuck in the mailq and couldn’t figure out how to delete the queued messages.  Turns out they were in these locations:




Ubuntu Postfix

Posted in Linux | Tagged , , , | Leave a comment

Skills wanted

Here is the technology stack I came up with:

Bootstrap Framework
Oracle (PL/SQL)
Ruby on Rails




Posted in Coding | Leave a comment

Amazon MWS feed

Found that information about Amazon’s MWS is pretty hard to find and pretty scattered.  Took me awhile to even find a link to ORDER_ACKNOWLEDGEMENT, ORDER_FULFILLMENT sample that Amazon provides.


If you are fulfilling multiple orders in one XML you want to repeat everything in the <Message>

<?xml version="1.0" encoding="iso-8859-1"?>
<AmazonEnvelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="amzn-envelope.xsd">


Link to solution

Posted in Uncategorized | Tagged , , , , | Leave a comment