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)”