Highlight: TV-integrated drag & drop KANBAN board

Description An integrated drag & drop KANBAN board for table views which changes status and modified by/on columns of records just by dropping into a different slot. Showcase Example Table calculations contains a column named state_id which is a lookup, referencing states-table. There are four different states in states-table. Every state has been rendered as slot and therefore is available as drop-target. Additional states can be added, of course. When dropping an item into a different slot, there is an AJAX call from client (browser) to server. The serverside PHP script validates the passed data and checks for edit-permission on …

Formatting numbers in SQL, PHP, JS

As a web developer, some tasks keep coming up. And every time you look for the solution in the online documentation. This includes converting numbers into different formats. On this page we summarize the elementary number conversions for SQL, PHP and Javascript How to read this page If your have an INPUT like “1234.999” and you’d like to convert in into an OUTPUT like “1.235,00” using language SQL or PHP or Javascript your can use the code shown here as a starting point. Standard number conversion Input 1234.999 MySQL/MariaDB PHP Javascript Output 1,234.999 Attention: Rounding Input 1234.999 MySQL/MariaDB PHP Javascript …