All posts by Amit Sonkhiya


Entrepreneur, multiple programming skills and technology lover.

MySQL update if value is greater than current value

While working with MySQL database there might be situation when you wish to update certain column only if the value being updated is greater than existing value or current value stored in that column. MySQL GREATEST and LEAST functions are quite handy in such situations. Let’s see how can we use first function to update a column if value is greater than current value.

Continue Reading ››

Facebook app is still in development mode & don’t have access

When you setup App on Facebook and try to make login with Facebook available in your script, everything seems fine but when someone attempt to login with a Facebook account he/she gets either of these errors from Facebook:

App Not Setup: This app is still in development mode, and you don’t have access to it. Switch to a registered test user or ask an app admin for permissions.

The developers of this app have not set up this app properly for Facebook Login.

app is still in development mode

Continue Reading ››

2 ways to center a column in Twitter Bootstrap 3

Here are 2 ways which you can use whenever you need to center a column div within `.container` in Twitter Bootstrap 3 as well as to keep empty space outside the `div` to be evenly distributed. First approach uses offset feature available in Bootstrap while it has a limitation and second approach is using `center-block` class with setting `float: none` in Twitter Bootstrap.

Continue Reading ››

Find object by value in array of objects

In PHP we either create objects and their array, or database returns array of objects as result-set of some query. There we might need to find an object which have a particular property-value pair. There is no direct function available in PHP to perform the same so I’m explaining here how can we find object by value in array of objects by using a foreach loop.

Continue Reading ››

Fancybox ajax content & navigation issue in group & popup

While working with fancybox, you might have noticed that any button or link or input inside fancybox popup just behaves like previous/next item slider, making that coming item to appear in popup rather of doing it’s assigned code on click. All the reason is the width specified for `fancybox-nav` class with higher `z-index` for it.

Continue Reading ››