Flickerbook

A quick example of how I filled a newly created column in database table, using already existing data and PHP to calculate and insert new values into new column.

chartJS / Data Analytics / Flickerbook / HTML5 / javacsript / jQuery / PHP / SQL / Web development

Still Working On Flickerbook

For the last two months was continuing work on Flickerbook. Have done a lot of changes! Wont go trough all the code and queries I have written, but in this post I showcase new tables and charts I have created for my work related data 😉

Bootstrap / CSS / Flickerbook / HTML5 / javacsript / Web development

Animating Height Of Result Tables And Charts For Flickerbook’s Totals Calculator

In this post I explain how I animated table and chart container’s height, once a new set of data gets loaded.

Flickerbook / PHP / SQL / Web development

Still Working On Flickerbooks Totals Calculator

I used SQL temp tables and UNION ALL for the first time. With the help of SQL temp tables I was able to use a GROUP BY statement on payments, that are stored in multiple columns, but have identical names.

Bootstrap / CSS / Flickerbook / HTML5 / javacsript / PHP / SQL

More work on Flickerbook’s total’s calculator

Have done some more work on Flickerbooks totals calculator. Used Left and INNER joins to retrieve data from 3 different tables. Also wrote a new function that creates html elements for table and charts and helps me avoid repetitive HTML code.

Bootstrap / chartJS / CSS / Flickerbook / HTML5 / javacsript / PHP / SQL / Web development

Improving Flickerbooks Totals Calculator

I have added 9 new tables and charts to totals calculator, that are listed below: Below is an example of earnings by employer table and pie chart: HTML […]