Wolfgang Moritz

Call me Wolf

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…


Windows MySQL Backup to Remote Host

In our home workshop, we have a shared PC workstation running XAMPP to serve up some local PHP applications inside of our home network. These apps are mostly convenience tools, nothing critical, but at the same time the MySQL database holds some data we want to backup – just in case. Backing up…