Andrew Ho

24 February 2017

Google data studio

I love the new Google Data studio, it’s like Tableau or QlikView but free and even easier to use. I have created a visualisation of travel time to and from work with departure time as dimension.

20 February 2017

Online documentation – an overview of SAAS solutions

https://www.notion.so – Affordable solution

https://gelato.io – Ideal for API’s but expensive

https://www.mediawiki.org/wiki/MediaWiki – Open source solution, a crime to set up

—

WordPress website with WeDocs

20 February 2017

Readme driven development

Came across this phenomenon during a meetup. Love the idea

http://tom.preston-werner.com/2010/08/23/readme-driven-development.html

13 September 2016

Facebook social login for iOS

-(void)FBloginButtonClicked
{
    
    
    FBSDKLoginManager *login = [[FBSDKLoginManager alloc] init];
    //login.loginBehavior = FBSDKLoginBehaviorSystemAccount; //Zorgde voor problemen
    
    [login
     logInWithReadPermissions: @[@"public_profile", @"email"]
     fromViewController:self
     handler:^(FBSDKLoginManagerLoginResult *result, NSError *error) {
         if (error) {
             NSLog(@"Process error");
         } else if (result.isCancelled) {
             NSLog(@"Cancelled");
         } else {
             NSLog(@"Logged in");
                
             
             NSDictionary *parameters = @{@"fields":@"email,first_name,last_name,picture.width(400).height(400)"};
             
             [[[FBSDKGraphRequest alloc] initWithGraphPath:@"me" parameters:parameters]
              startWithCompletionHandler:^(FBSDKGraphRequestConnection *connection, id result, NSError *error)
              {
                  if([result objectForKey:@"email"] != nil){
                      
                
                      
                  }
                  else {
                      [self.view hideActivityView];
                      UIAlertView *alert = [[UIAlertView alloc] initWithTitle:@"Fout"
                                            // message:error.localizedDescription
                                                                      message:[NSString stringWithFormat:@"Er ging iets mis, probeer het nog eens."]
                                                                     delegate:nil
                                                            cancelButtonTitle:@"OK"
                                                            otherButtonTitles:nil];
                      [alert show];
                      
                  }
                  
                  
                  
                  
              }];
         }
     }];
}

-(void)FBloginButtonClicked

{

FBSDKLoginManager *login = [[FBSDKLoginManager alloc] init];

//login.loginBehavior = FBSDKLoginBehaviorSystemAccount; //Zorgde voor problemen

[login

logInWithReadPermissions: @[@"public_profile", @"email"]

fromViewController:self

handler:^(FBSDKLoginManagerLoginResult *result, NSError *error) {

if (error) {

NSLog(@"Process error");

} else if (result.isCancelled) {

NSLog(@"Cancelled");

} else {

NSLog(@"Logged in");

NSDictionary *parameters = @{@"fields":@"email,first_name,last_name,picture.width(400).height(400)"};

[[[FBSDKGraphRequest alloc] initWithGraphPath:@"me" parameters:parameters]

startWithCompletionHandler:^(FBSDKGraphRequestConnection *connection, id result, NSError *error)

{

if([result objectForKey:@"email"] != nil){

}

else {

[self.view hideActivityView];

UIAlertView *alert = [[UIAlertView alloc] initWithTitle:@"Fout"

// message:error.localizedDescription

message:[NSString stringWithFormat:@"Er ging iets mis, probeer het nog eens."]

delegate:nil

cancelButtonTitle:@"OK"

otherButtonTitles:nil];

[alert show];

}

}];

}

}];

}

6 September 2016

RefreshControl in a UITableViewController

3 August 2016

Simplest way to load json without an external networking framework iOS Objective c

 [[UIApplication sharedApplication] setNetworkActivityIndicatorVisible:YES];
    NSString *urlString = [NSString stringWithFormat:@"https://sbdev.nl/bayer.json"];
    NSURLRequest * request = [NSURLRequest requestWithURL:[NSURL URLWithString:urlString]];
    [NSURLConnection sendAsynchronousRequest:request queue:[NSOperationQueue mainQueue]                          completionHandler:^(NSURLResponse * response, NSData * data, NSError * connectionError)
     {
         if (data)
         {
             id myJSON;
             @try {
                 myJSON = [NSJSONSerialization JSONObjectWithData:data options:NSJSONReadingMutableContainers error:nil];
             }
             @catch (NSException *exception) {
             }
             @finally {
             }
             NSArray * jsonArray = (NSArray *)myJSON;
             
            NSLog(@"NSArray %@",jsonArray);
                          }
         }
     }];

[[UIApplication sharedApplication] setNetworkActivityIndicatorVisible:YES];

NSString *urlString = [NSString stringWithFormat:@"https://sbdev.nl/bayer.json"];

NSURLRequest * request = [NSURLRequest requestWithURL:[NSURL URLWithString:urlString]];

[NSURLConnection sendAsynchronousRequest:request queue:[NSOperationQueue mainQueue] completionHandler:^(NSURLResponse * response, NSData * data, NSError * connectionError)

{

if (data)

{

id myJSON;

@try {

myJSON = [NSJSONSerialization JSONObjectWithData:data options:NSJSONReadingMutableContainers error:nil];

}

@catch (NSException *exception) {

}

@finally {

}

NSArray * jsonArray = (NSArray *)myJSON;

NSLog(@"NSArray %@",jsonArray);

}

}];

3 August 2016

iOS 9+ occasionally screws up scroll insets when working with a UITabbar and a UINavigationcontroller at the same time. I have spent hours figuring out that the solution is just one simple line of code.

self.automaticallyAdjustsScrollViewInsets = NO;

1	self.automaticallyAdjustsScrollViewInsets = NO;

26 July 2016

Encrypt and decrypt strings in PHP the easy way

function dec_enc($action, $string) {
    $output = false;

    $encrypt_method = "AES-256-CBC";
    $secret_key = 'This is my secret key';
    $secret_iv = 'This is my secret iv';

    // hash
    $key = hash('sha256', $secret_key);
    
    // iv - encrypt method AES-256-CBC expects 16 bytes - else you will get a warning
    $iv = substr(hash('sha256', $secret_iv), 0, 16);

    if( $action == 'encrypt' ) {
        $output = openssl_encrypt($string, $encrypt_method, $key, 0, $iv);
        $output = base64_encode($output);
    }
    else if( $action == 'decrypt' ){
        $output = openssl_decrypt(base64_decode($string), $encrypt_method, $key, 0, $iv);
    }

    return $output;
}

function dec_enc($action, $string) {

$output = false;

$encrypt_method = "AES-256-CBC";

$secret_key = 'This is my secret key';

$secret_iv = 'This is my secret iv';

// hash

$key = hash('sha256', $secret_key);

// iv - encrypt method AES-256-CBC expects 16 bytes - else you will get a warning

$iv = substr(hash('sha256', $secret_iv), 0, 16);

if( $action == 'encrypt' ) {

$output = openssl_encrypt($string, $encrypt_method, $key, 0, $iv);

$output = base64_encode($output);

}

else if( $action == 'decrypt' ){

$output = openssl_decrypt(base64_decode($string), $encrypt_method, $key, 0, $iv);

}

return $output;

}

22 June 2016

Curl cheatsheet

18 May 2016

Nice HTML5 video player

https://plyr.io/#video

17 May 2016

Get the brightness of a color in php

With this function it is possible to decide the font color based on a variable background colour.

function get_brightness($hex) {
    // returns brightness value from 0 to 255
    // strip off any leading #
$hex = str_replace('#', '', $hex);

$c_r = hexdec(substr($hex, 0, 2));
$c_g = hexdec(substr($hex, 2, 2));
$c_b = hexdec(substr($hex, 4, 2));

return (($c_r * 299) + ($c_g * 587) + ($c_b * 114)) / 1000;
}

function get_brightness($hex) {

// returns brightness value from 0 to 255

// strip off any leading #

$hex = str_replace('#', '', $hex);

$c_r = hexdec(substr($hex, 0, 2));

$c_g = hexdec(substr($hex, 2, 2));

$c_b = hexdec(substr($hex, 4, 2));

return (($c_r * 299) + ($c_g * 587) + ($c_b * 114)) / 1000;

}

10 May 2016

Swift Programming cheat sheet

12 April 2016

Redirect WP-Login to a frontend login

add_action( 'login_init', 'wpse149411_login_redirect' );

function wpse149411_login_redirect() {
    wp_redirect( site_url( '/login/' ) );
    exit;
}

add_action( 'login_init', 'wpse149411_login_redirect' );

function wpse149411_login_redirect() {

wp_redirect( site_url( '/login/' ) );

exit;

}

7 April 2016

WordPress: Add uploaded image to the media library

if (!empty($_FILES['imgageproduct']['tmp_name'])) {
                $uploaddir = wp_upload_dir();
                $length = 8;
                $randomstring = 'img'.substr(str_shuffle("0123456789abcdefghijklmnopqrstuvwxyz"), 0, $length);
                $temp = explode(".",$_FILES["imgageproduct"]["name"]);
                $newfilename = $randomstring . '.' .end($temp);
                $uploadfile = $uploaddir['path'] . '/' .$newfilename;
                move_uploaded_file( $_FILES['imgageproduct']['tmp_name'], $uploadfile);
                // Check the type of file. We'll use this as the 'post_mime_type'.
                $filetype = wp_check_filetype( basename( $uploadfile ), null );
                // Get the path to the upload directory.
                $wp_upload_dir = wp_upload_dir();
                $filename = $uploadfile;
                // Prepare an array of post data for the attachment.
                $attachment = array(
                    'guid'           => $wp_upload_dir['url'] . '/' . basename( $filename ),
                    'post_mime_type' => $filetype['type'],
                    'post_title'     => preg_replace( '/\.[^.]+$/', '', basename( $filename ) ),
                    'post_content'   => '',
                    'post_status'    => 'inherit'
                );
                // Insert the attachment.
                $attach_id = wp_insert_attachment( $attachment, $filename, $parent_post_id );

                // Make sure that this file is included, as wp_generate_attachment_metadata() depends on it.
                require_once( ABSPATH . 'wp-admin/includes/image.php' );

                // Generate the metadata for the attachment, and update the database record.
                $attach_data = wp_generate_attachment_metadata( $attach_id, $filename );
                wp_update_attachment_metadata( $attach_id, $attach_data );

            }

if (!empty($_FILES['imgageproduct']['tmp_name'])) {

$uploaddir = wp_upload_dir();

$length = 8;

$randomstring = 'img'.substr(str_shuffle("0123456789abcdefghijklmnopqrstuvwxyz"), 0, $length);

$temp = explode(".",$_FILES["imgageproduct"]["name"]);

$newfilename = $randomstring . '.' .end($temp);

$uploadfile = $uploaddir['path'] . '/' .$newfilename;

move_uploaded_file( $_FILES['imgageproduct']['tmp_name'], $uploadfile);

// Check the type of file. We'll use this as the 'post_mime_type'.

$filetype = wp_check_filetype( basename( $uploadfile ), null );

// Get the path to the upload directory.

$wp_upload_dir = wp_upload_dir();

$filename = $uploadfile;

// Prepare an array of post data for the attachment.

$attachment = array(

'guid' => $wp_upload_dir['url'] . '/' . basename( $filename ),

'post_mime_type' => $filetype['type'],

'post_title' => preg_replace( '/\.[^.]+$/', '', basename( $filename ) ),

'post_content' => '',

'post_status' => 'inherit'

);

// Insert the attachment.

$attach_id = wp_insert_attachment( $attachment, $filename, $parent_post_id );

// Make sure that this file is included, as wp_generate_attachment_metadata() depends on it.

require_once( ABSPATH . 'wp-admin/includes/image.php' );

// Generate the metadata for the attachment, and update the database record.

$attach_data = wp_generate_attachment_metadata( $attach_id, $filename );

wp_update_attachment_metadata( $attach_id, $attach_data );

}

31 March 2016

Woocommerce change price in cart

add_action( 'woocommerce_before_calculate_totals', 'add_custom_price' );

function add_custom_price( $cart_object ) {
    $custom_price = 10; // This will be your custome price  
    foreach ( $cart_object->cart_contents as $key => $value ) {
        $value['data']->price = $custom_price;
    }
}

add_action( 'woocommerce_before_calculate_totals', 'add_custom_price' );

function add_custom_price( $cart_object ) {

$custom_price = 10; // This will be your custome price

foreach ( $cart_object->cart_contents as $key => $value ) {

$value['data']->price = $custom_price;

}

15 March 2016

Instagram social API

 public function insta()
  {
    extract($json_api->query->get(array('userid')));
	
	inserttoDB('insta');
	
    //  $URL = 'https://api.instagram.com/v1/tags/'. $tag .'/media/recent?access_token='. esc_attr( get_option('instatoken') ) .'&count=15';
	  $URL = 'https://api.instagram.com/v1/users/'. $userid .'/media/recent/?access_token='. esc_attr( get_option('instatoken') )  .'&count=15';
	 
	// Get cURL resource
	$curl = curl_init();
	// Set some options - we are passing in a useragent too here
	curl_setopt_array($curl, array(
	    CURLOPT_RETURNTRANSFER => 1,
	    CURLOPT_URL => $URL,
	    CURLOPT_USERAGENT => 'Codular Sample cURL Request'
	));
	// Send the request & save response to $resp
	$resp = curl_exec($curl);
	// Close request to clear up some resources
	curl_close($curl);
	
	
	$response = json_decode($resp);
	$data = $response->data;
	
  	 return array(
  				"status" => 'ok',
				"messages" => $data	
			);
	
  }
  
   public function instatag()
  {
    extract($json_api->query->get(array('tag')));
	
	inserttoDB('instatag');
	
     $URL = 'https://api.instagram.com/v1/tags/'. $tag .'/media/recent?access_token='. esc_attr( get_option('instatoken') ) .'&count=15';
	// $URL = 'https://api.instagram.com/v1/users/'. $userid .'/media/recent/?access_token='. esc_attr( get_option('instatoken') )  .'&count=15';
	 
	// Get cURL resource
	$curl = curl_init();
	// Set some options - we are passing in a useragent too here
	curl_setopt_array($curl, array(
	    CURLOPT_RETURNTRANSFER => 1,
	    CURLOPT_URL => $URL,
	    CURLOPT_USERAGENT => 'Codular Sample cURL Request'
	));
	// Send the request & save response to $resp
	$resp = curl_exec($curl);
	// Close request to clear up some resources
	curl_close($curl);
	
	
	$response = json_decode($resp);
	$data = $response->data;
	
  	 return array(
  				"status" => 'ok',
				"messages" => $data	
			);
	
  }
   public function instalocation()
  {
    extract($json_api->query->get(array('locationid')));
	
	inserttoDB('instatag');
	
     $URL = 'https://api.instagram.com/v1/locations/'. $locationid .'/media/recent?access_token='. esc_attr( get_option('instatoken') ) .'&count=15';
	// $URL = 'https://api.instagram.com/v1/users/'. $userid .'/media/recent/?access_token='. esc_attr( get_option('instatoken') )  .'&count=15';
	 
	// Get cURL resource
	$curl = curl_init();
	// Set some options - we are passing in a useragent too here
	curl_setopt_array($curl, array(
	    CURLOPT_RETURNTRANSFER => 1,
	    CURLOPT_URL => $URL,
	    CURLOPT_USERAGENT => 'Codular Sample cURL Request'
	));
	// Send the request & save response to $resp
	$resp = curl_exec($curl);
	// Close request to clear up some resources
	curl_close($curl);
	
	
	$response = json_decode($resp);
	$data = $response->data;
	
  	 return array(
  				"status" => 'ok',
				"messages" => $data	
			);
	
  }

public function insta()

{

extract($json_api->query->get(array('userid')));

inserttoDB('insta');

// $URL = 'https://api.instagram.com/v1/tags/'. $tag .'/media/recent?access_token='. esc_attr( get_option('instatoken') ) .'&count=15';

$URL = 'https://api.instagram.com/v1/users/'. $userid .'/media/recent/?access_token='. esc_attr( get_option('instatoken') ) .'&count=15';

// Get cURL resource

$curl = curl_init();

// Set some options - we are passing in a useragent too here

curl_setopt_array($curl, array(

CURLOPT_RETURNTRANSFER => 1,

CURLOPT_URL => $URL,

CURLOPT_USERAGENT => 'Codular Sample cURL Request'

));

// Send the request & save response to $resp

$resp = curl_exec($curl);

// Close request to clear up some resources

curl_close($curl);

$response = json_decode($resp);

$data = $response->data;

return array(

"status" => 'ok',

"messages" => $data

);

}

public function instatag()

{

extract($json_api->query->get(array('tag')));

inserttoDB('instatag');

$URL = 'https://api.instagram.com/v1/tags/'. $tag .'/media/recent?access_token='. esc_attr( get_option('instatoken') ) .'&count=15';

// $URL = 'https://api.instagram.com/v1/users/'. $userid .'/media/recent/?access_token='. esc_attr( get_option('instatoken') ) .'&count=15';

// Get cURL resource

$curl = curl_init();

// Set some options - we are passing in a useragent too here

curl_setopt_array($curl, array(

CURLOPT_RETURNTRANSFER => 1,

CURLOPT_URL => $URL,

CURLOPT_USERAGENT => 'Codular Sample cURL Request'

));

// Send the request & save response to $resp

$resp = curl_exec($curl);

// Close request to clear up some resources

curl_close($curl);

$response = json_decode($resp);

$data = $response->data;

return array(

"status" => 'ok',

"messages" => $data

);

}

public function instalocation()

{

extract($json_api->query->get(array('locationid')));

inserttoDB('instatag');

$URL = 'https://api.instagram.com/v1/locations/'. $locationid .'/media/recent?access_token='. esc_attr( get_option('instatoken') ) .'&count=15';

// $URL = 'https://api.instagram.com/v1/users/'. $userid .'/media/recent/?access_token='. esc_attr( get_option('instatoken') ) .'&count=15';

// Get cURL resource

$curl = curl_init();

// Set some options - we are passing in a useragent too here

curl_setopt_array($curl, array(

CURLOPT_RETURNTRANSFER => 1,

CURLOPT_URL => $URL,

CURLOPT_USERAGENT => 'Codular Sample cURL Request'

));

// Send the request & save response to $resp

$resp = curl_exec($curl);

// Close request to clear up some resources

curl_close($curl);

$response = json_decode($resp);

$data = $response->data;

return array(

"status" => 'ok',

"messages" => $data

);

}