Wolfgang Moritz

Call me Wolf

Moving From Shared Hosting to a VPS

It was time to get off shared hosting. I had been using the same shared hosting service for many years, and for the most part it worked just fine. The service was easy and fast - enough - and the hosting cPanel had lots of nifty widgets. But I was also stuck with whatever software versions the…


Lightweight PHP MySQL Session Handler

Note: Version 1.2 was released as of June 21, 2016. Managing session state across a stateless protocol like HTTP has its challenges. PHP has a native session handler, and is easy to use, but I wanted something that persisted to the (MySQL) database. CodeIgniter has a great session class that uses a…


Slim 3 Custom Not Found Handler and Template

I have been using the Slim micro-framework (version 2) for small web projects for some time now. Now that Slim version 3 is out, I thought I would give it a try on a new project. Slim 3 is new, like shiny new, and I found it is also very different from version 2. It's more like learning a new…


Dynamic Sitemap with Codeigniter 1 Comment

Sitemaps are a great tool to help your site’s SEO. A Sitemap is just a list of URL’s for your site that search engines may consider when indexing your website. Without a Sitemap search engines have to organically discover pages in your site by following links. With a Sitemap you get an…


An All SQL Option to Densifying Dates

In a previous post I had discussed how to densify a sales report by filling in missing date rows. I accomplished that by referencing an existing table of calendar dates to which I outer joined my sales data. For those who don’t have a handy dates table (as I do in our E-Business Suite), I…