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 […]
16 Dec 2017
PDO bind value list for IN statement
4:14 |
mysql, tricky |
457 views
28 Oct 2017
identify the type of an object
12:54 |
javascript, web trick |
303 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 […]
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 |
284 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
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
22 Oct 2017
get function name in strict mode
13:25 |
javascript, tricky |
248 views
Goal: show the name of the called function in strict mode If I want to see the function name I can put it like this but I like the globalized solutions and don’t forget the strict mode, where the possibilities are restricted. There is nothing else to do just throw an exception and read from […]
Goal: show the name of the called function in strict mode If I want to see the function name I can put it like this but I like the globalized solutions and don’t forget the strict mode, where the possibilities are restricted. There is nothing else to do just throw an exception and read from […]
13 Oct 2017
disable title/tooltip with css
19:04 |
css, tricky |
265 views
Goal: find simple way to hide the tooltip The problem is very simple and there are many ways to solve. I have a button or link or just a simple div with a tooltip on it. I want to create a disabled state for this control. the object like this and the style for the […]
Goal: find simple way to hide the tooltip The problem is very simple and there are many ways to solve. I have a button or link or just a simple div with a tooltip on it. I want to create a disabled state for this control. the object like this and the style for the […]
12 Oct 2017
Table column names comma delimited list
21:12 |
mysql |
280 views
Goal: quick method to get the column names comma delimited list Simple mysql or mariadb database. How to get a detailed select command if I don’t have a good sql gui tool. So, here is an easy way: where TABLE_SCHEMA is your schema, and TABLE_NAME is the table in the question. The result will be […]
Goal: quick method to get the column names comma delimited list Simple mysql or mariadb database. How to get a detailed select command if I don’t have a good sql gui tool. So, here is an easy way: where TABLE_SCHEMA is your schema, and TABLE_NAME is the table in the question. The result will be […]
15 Sep 2017
contenteditable – select all on double click
15:35 |
javascript, jquery |
293 views
Goal: don’t be fool, do it easy A have a DIV with contenteditable=”true” attribute. Like a textbox but not really. I want to select all the content with a double click on it. With jQuery like this: … so do you know better than this solution? … I have read many scientific solution for this […]
Goal: don’t be fool, do it easy A have a DIV with contenteditable=”true” attribute. Like a textbox but not really. I want to select all the content with a double click on it. With jQuery like this: … so do you know better than this solution? … I have read many scientific solution for this […]
27 Aug 2017
extend an array – js way
8:05 |
javascript |
246 views
Goal: find the cleanest way to extend an array Everyday happening to extend an array in javascript. There are many ways to do but here is the simplest one 🙂 No more code, no more pain in the neck just an extended array. What we need more for today?
Goal: find the cleanest way to extend an array Everyday happening to extend an array in javascript. There are many ways to do but here is the simplest one 🙂 No more code, no more pain in the neck just an extended array. What we need more for today?
6 Jun 2017
mysql comma delimited result
2:32 |
mysql |
230 views
Goal: select a quick comma delimited value for a column The method is easy. In this example the result is a long string contains comma delimited list of the language names. the result something like this: But the working buffer size is a weak point in this story. The correct way something like this: So […]
Goal: select a quick comma delimited value for a column The method is easy. In this example the result is a long string contains comma delimited list of the language names. the result something like this: But the working buffer size is a weak point in this story. The correct way something like this: So […]
7 Apr 2017
use the camera
14:15 |
html5, web trick |
248 views
Goal: simple way to use the camera I’ve read some articles about this, but there was no a simple one. So, here is: check it: here Two thing to know. 1. the browser will say insecure connection. Just say do it anymore 2. Take a Photo will take a photo after 3 sec
Goal: simple way to use the camera I’ve read some articles about this, but there was no a simple one. So, here is: check it: here Two thing to know. 1. the browser will say insecure connection. Just say do it anymore 2. Take a Photo will take a photo after 3 sec
