Posted in CSS

CSS : Differentiate Styles between IE and Other Browser

There are times when we need to write browser specific CSS. But, without any JavaScript code, just like media queries are used to write responsive CSS, we can use plain CSS to differentiate styles across IE and other browsers.

We may need this IE and other browser differentiating styles in order to make our application compatible with old un-upgraded IE engine, but still want to give the good layer of coating to support new browsers with fancy styles which almost are broken in Internet Explorer.

Continue reading “CSS : Differentiate Styles between IE and Other Browser”
Posted in Code Snippets, Developer

FullCalendar : Hide dates of previous and next month

FullCalendar by default displays the dates of past and next month. This shows 6 rows on the view. Sometimes, when the complete last week (6th row) will be next month’s dates would have lesser desire for the users. Example: April 2019

Continue reading “FullCalendar : Hide dates of previous and next month”
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:

1 AND 2 AND 3 AND

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”