Wolfgang Moritz

Call me Wolf

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…


Apex HTML Report Layout Options 7 Comments

The Classic and Interactive report regions in Oracle’s Application Express have plenty of options to format the data to suit your taste – if you stick with a basic tabular layout. In most cases, that’s perfect, after all SQL is meant to dish up structured data. But, sometimes the tabular…