Jquery Basics

Saturday, September 5th, 2020 Jquery,

The minimium required Jquery setup should be inlcuded in the head of the HTML document and includes a link to the Jquery Library hosted on […]

Adding a Countdown Timer to Google Search Ads (Formerly Adwords)

Sunday, April 14th, 2019 Adwords,

I just found out about this really cool feature available in Google Ads which allows you to add a countdown timer to appear in your […]

Count Distinct or Grouped Database Records in SQL

Sunday, April 7th, 2019 MySQL,

Say you have a SQL database table which has some type of repeating items, like suburbs in a table of contacts, or categories in a […]

Adding Batch / Multiple SQL Insert Queries with PHP’s mysqli_multi_query()

Saturday, February 16th, 2019 MySQL, PHP,

I had a project which required to insert a batch of mySQL database rows in one go with PHP. I firstly wrote the script to simply […]

Retrieve Acquisition Overview & Top Channels Data Using Google Analytics Reporting API & PHP

Saturday, November 17th, 2018 Google Analytics Reporting API,

In this post I’ll show you some code that will extract data from the Google Analytics Reporting API which is included on the Acquisition Overview […]

Using Google Analytics Reporting API & PHP to Retrieve Metrics Like Sessions, Hits, Bounce Rate, Goals

Saturday, October 6th, 2018 Google Analytics Reporting API, PHP API Integrations,

In this example we will use the Google Analytics Reporting API and PHP to extract some basic website performance metrics such as total sessions, hits, […]

Adding Subscribers to a Campaign Monitor List Using The API and PHP Basic Example

Sunday, September 16th, 2018 Campaign Monitor, PHP API Integrations,

So you want to add subscribers to a Campaign Monitor list from your custom PHP script. Good news is there is a great PHP class […]

The Best Apps For Aussies Travelling in Europe

Monday, June 11th, 2018 Travel,

I recently returned from a great trip through Ireland, England and France. All previous times I have travelled to Europe it has always been planned […]

A Short & Free PHP Script To Return A Currency Conversion Rate

Saturday, June 9th, 2018 PHP, PHP API Integrations,

I was looking for a free / public API in which I could query a currency conversion rate just once per day, so no need […]

Paypal Client Side Express Checkout Popup PHP Cart Example Code

Saturday, April 28th, 2018 Paypal API, PHP,

I recently needed to setup the Paypal express checkout (which is a lightbox style pop-up that can be integrated into any web page) on a […]

Adwords Video Ads Certification – Exam Notes 2018

Tuesday, April 10th, 2018 Adwords,

Ah the Video Ads (AKA Youtube Video Ads) Exam for Adwords Certification. Going through the requirements for this one was very interesting and I was […]

Adwords Shopping Ads Certification – Exam Notes 2018

Friday, March 30th, 2018 Adwords,

Another Adwords Certification exam done and dusted, this time it was the Adwords Shopping Ads. Like last time, here are my study notes which I […]

Adwords Display Advertising Certification Exam Notes 2018

Saturday, March 24th, 2018 Adwords,

I recently took, and passed, the Google Adwords Display Advertising certification exam. I though I would publish all my quick study notes as reference point. […]

Boosting Ad Click Through Rate (CTR) Using Dynamic Keyword Insertion In Adwords

Saturday, March 17th, 2018 Adwords,

So a potential customer searching for your product (let’s say you sell ‘Digital Cameras’ for this example) will be much more likely to click on your […]

A PHP Function To Generate 1 Random Password, Or 2, Or 2… Million…

Monday, March 12th, 2018 PHP,

Now, I am not sure where I originally found this script, or if it is the most efficient way to generate a password in PHP, but […]

An Easy PHP Function To Run Your Harvest API Calls Through

Saturday, February 24th, 2018 Harvest API (V1),

So, you need to make requests to and from the Harvest API in your PHP website or application. Here is a relatively straight forward PHP […]

A Starting Point .htaccess File For New Websites Explained

Saturday, February 17th, 2018 htaccess,

The .htaccess file is a very powerful tool on your cpanel or apache based hosting and acts as a configuration file for various items. It […]

Quickly Add Email Error Reporting to Your PHP Application or Script

Saturday, February 10th, 2018 PHP,

I recently needed to add some error reporting onto a custom PHP script I had created. I looked at a few options including using a PHP Mailer include […]

6 Awesome mySQL Statements That I Always Forget

Friday, November 17th, 2017 MySQL, PHP,

A collection of some the simplest SQL examples that I always forget. Order by Random Want to return your result in a random order, just […]

How to format or manipulate dates and times with PHP

Saturday, November 11th, 2017 PHP,

PHP has a a great many options for formatting and manipulating dates. I always find myself going back and forth to find the same examples […]

Using PHP to create a CSV download for import into MYOB

Sunday, November 5th, 2017 MYOB API, PHP,

I had the situation a few years back where we were running a custom developed job system (PHP with mySQL) and wanted to import the […]

Using PHP and the Harvest API to return project time for a date range and user

Saturday, September 16th, 2017 Harvest API (V1), PHP,

Here is some PHP functions and code to return a particular users time entries for a date range from the Harvest API. Functions Firstly, there […]

Some Quick HTACCESS Codes to Boost Site Security

Friday, September 1st, 2017 htaccess, PHP,

Here is a quick set of codes that can be easily added to your HTACCESS file to give your website an extra layer of security than […]

Redirect to non-www to www version using the .htaccess file, for both secure and non-secure websites

Wednesday, August 30th, 2017 htaccess,

It’s a Google best practice to only have a single version of your site available to the public and to their index. Every default hosting […]

Using Excel to split a full name into 2 separate columns

Saturday, August 26th, 2017 Excel Hacks for Designers,

So, say you have a contact list of 2000 odd full names (first and last name together) provided to you in an Excel file and […]

An example of coverting old-school PHP mysql to more secure mysqli

Saturday, March 25th, 2017 MySQL, PHP,

A very common way hackers can break into your website database is via targeting outdated PHP code and unsecured get variables, especially when the code retrieves […]