16 Feb 2019

Excel – insert current date – [ ctrl+; ] not working

20:14 | excel, tricky | 54 views

Goal: sometimes the current date insert not working. Find a way to solve this I don’t know why and how but sometimes the ctrl + ; stopping to work. I tried to find solution. Many of forums suggest to reinstall the whole office package… Nope… or delete the normal.dot template… nope… or just start the […]


1 Feb 2019

javascript – Convert NodeList to Array

0:57 | javascript | 71 views

Goal: work with nodeList as an array The nodeList is great but sometime we need to convert it to an array for the easy processing. old method old method – short form ES6 way – shorter form ES6 way – the shortest form enjoy… One more thing is a little bit strange. Check the speed […]


12 Jan 2019

mysql date range creation

11:36 | database, mysql | 67 views

Goal: create a date range Simple question to create a date range from a start date to an end date. 1. date dimension table – previously created range Simple, let’s create a date dimension table filled up with the days from a specified day to the future(?). This is a very dangerous if we forget […]


13 Dec 2018

WordPress add functions – safe method

16:40 | tricky, wordpress | 89 views

Goal: add own functions to the wordpress site Forget the functions.php! Frankly this is working only until the next update :(. My way is to create a totally separated file with the added functions: 1. Let’s create a new file functions_added.php Never put php close tag ?> to the end of the file! 2. Put […]


5 Jul 2018

Google Pixel Android P – Couldn’t download

11:17 | android, pixel, tricky | 126 views

Goal: avoid the system update issue – android 9 I have enrolled to try the new android system before the final release. Everything was fine until a disturbing issue. I tried to refresh the system and the following happened. How we can avoid this? if you can see on the top right corner I used […]


18 Apr 2018

use regions in MVS2015 for php files

13:12 | javascript, mvs, php | 213 views

Goal: I want fold-able code for php like I have to js files The texteditor-like editors are great but without regions your life would be difficult. The Microsoft Visual Studio platform provides a very nice feature to use regions. The simpliest way is the following form – you can use it for javascript The php […]


21 Dec 2017

PHP xDebug – xampp – php 7 – chrome

2:40 | php, xampp | 370 views

Goal: not a question, how we can know what is under the hood The PHP debugging is not a trivial case. Could be with the xDebug extension. Follow these steps: A. Xdebug core environment notice: according to the internet you need to disable the output buffering output_buffering = Off for me working with the following […]


16 Dec 2017

PDO bind value list for IN statement

4:14 | mysql, tricky | 400 views

Goal: pass value list to IN statement The PDO variable binding is easy until you want to use an IN statement like with PDO after the binding this statement is not working because in the background the select statement will be like this: Luckily the mysql knows the following tricky form and the bindable form […]


28 Oct 2017

identify the type of an object

12:54 | javascript, web trick | 251 views

Goal: simple way to check the type of a page object I have found many answers about this question but the useless is much more than the valuable. There is a simple way to identify objects on the page. For example I have a click listener and I want to know the type of the […]


27 Oct 2017

swap two numbers

12:49 | javascript, tricky | 238 views

Goal: to enjoy he beauty of out of box thinking Everyday task to swap two numbers. Nothing easier like this, but do it in one line. The trickiest solution I have ever seen: ok, swap them this is it, simple beautiful


#sidebar a { color:#fff; } #sidebar ul ul li { color: #DEF585; } #sidebar h2 { color: #fff; } #sidebar ul p, #sidebar ul select { color: #BEDDBE; } #backfly { background: url(images/golfBallWallPaper.jpg) left bottom fixed repeat-x #65a51d; }