Posted in Code Snippets, PHP

Puzzle: A Simple Solution for Fizz Buzz Test

There are multiple approaches to solve the Fizz Buzz Test:

Write a program that prints the numbers from 1 to 100. But for multiples of three print “Fizz” instead of the number and for the multiples of five print “Buzz”. For numbers which are multiples of both three and five print “FizzBuzz”

Click to see a simple solution
Posted in SQL

Chained data using single SQL Query (Fixed Length)

In e-commerce sites and in other applications, database sometimes will be designed in such a way that single table has child records in a chained fashion. Like, while defining a Product Type, Category and Sub-Category. A Sub-Category points to a Category in a same table and Category points to a Product Type in a same table. This Chained table has a format of Grand Parent, Parent and Child in same table as:

id parent_id name
1 0 John
2 1 Jacob
3 2 James
4 0 Jessie
5 4 Jemimah
6 5 Julia

Continue reading “Chained data using single SQL Query (Fixed Length)”

Posted in Code Snippets, Javascript

Workaround for failed loading of images

Images that depend on server-side loading fails sometimes due to multiple reasons, like image is not present, location might be wrong, browser fails to load or process the image. All these returns 404 as HTTP status. This breaks the image placeholder too. Using JQuery, the broken image can be replaced with the error placeholder image with this simple JQuery snippet:

Continue reading “Workaround for failed loading of images”

Posted in Code Snippets, PHP

PHP: Implode or Trim – Concatenating strings in a loop

There are bunch of questions circulating in Stack Overflow like this. People when trying to concatenate some strings with another string or a character, they simply concatenate with . inside the loop like this:

$values = [1, 2, 3];
$string = '';
foreach ($values as $value) {
   $string .= $value . " AND ";
echo $string;

This leaves string like this:


Then they come up with a question as how to remove the last AND.

Continue reading “PHP: Implode or Trim – Concatenating strings in a loop”