MySQL5 : MySQL Optimizations - Multiples conditional count

2013-07-11
-
Laurent Bientz
If you have made ​​reporting queries to extract statistics from large tables, you often had to take you into multiple queries to get to be all of your statistics, which can quickly become tedious.
Imagine the following two tables:
news with a...
More

MySQL5 : MySQL Optimizations - Left Join with several "or" conditions

2013-07-09
-
Laurent Bientz
If you have already had to handle large queries with LEFT JOIN cascade that involve multiple conditions "or" in the joints, this article should interest you.
Imagine 3 tables:
news with FK nullable to user + FK nullable to accountuser with FK...
More

Mootools : Dynamic resize of img elements

2013-06-03
-
Kevin Lancien
Here is a small MooTools class that allows you to resize an image based on its container (dynamic size or not) while maintaining the width * height ratio of the image.
Simply assign the following classes to the...
More

Mootools : Loading Canvas : Circles

2013-06-03
-
Kevin Lancien
The canvas tag allows good things. On our website, you can experience this tag on multiple pages, and also as a loading which allows us to make you wait for a resource to load :)

Here is our class JS (MooTools) to generate our loading,...
More

Mootools : Put your own style on input type checkbox

2013-05-31
-
Kevin Lancien
You probably already know that basic html input element of type checkbox is not directly stylisable CSS.
In order to give the style that you want a checkbox input, it must pass through the javascript.
Using much the MooTools JavaScript framework...
More
2 / 5

USER EXPERIENCE

Wandi invites you to discover a new approach to navigating a website...
Are you ready?

Launch the experience