Design Programming & Coding Tutorial

Google Docs spreadsheet script: compare dates, highlight past dates, highlight weekends, and highlight today

ORIGINAL PROBLEM I spent hours tonight struggling with this Google Apps script I wrote to serve as custom functions or advanced macros. I adapted it from this StackOverflow post. The main issue I ran into was comparing dates. Here is my research path, and hopefully, some indicator as to why it took so long: STEPS […]

Design Errors Programming & Coding

Zemanta Puts Unwanted HTML Comments In Pre-Formatted PHP Code (Sourcecode) In WordPress Posts

PROBLEM: I? have recently determined through trial and error and process of elimination that Zemanta is responsible for adding extraneous HTML comments to my pre-formatted (with “pre” tags) PHP code that I have placed between “sourcecode” tags to activate’s built in programming code syntax highlighting. Here is a screenshot (fig 1.) that demonstrates the […]

Design Programming & Coding Tutorial

Building A PHP Database Connection Class From Scratch (using Singleton & ActiveRecord patterns)

Greetings folks. Tonight I’m studying on how to create a PHP Object-Oriented MySQL database connection class.? This will be reusable and able to be implemented in any database driven web application built with PHP & MySQL.? It uses the ActiveRecord and Singleton design patterns. I’m currently following this YouTube tutorial: Using OOP PHP to select, […]