Categories
KnockoutJS

Dependency Tracking – KnockoutJS

Using a single object called dependency tracker i.e. ko.dependencyDetection you can determine when the value get updated. When you declare a computed observable, KO immediately gets its initial value and updated computed observable. Lets see an example for Dependency Tracking: <!DOCTYPE html> <html> <head> <title>Dependency Tracking – KnockoutJS</title> <script src=”http://ajax.aspnetcdn.com/ajax/knockout/knockout-3.1.0.js” type=”text/javascript”></script> </head> <body> <div> <form […]

Categories
MySQL

Compare two tables in MySQL

When migrate data you need to compare two tables and identify the unmatched results records. Suppose you have two tables table1 and table2 with same columns and values. If any one table has any extra row then using below query you can get the unmatched results. Compare two tables: SELECT id, name FROM ( SELECT […]

Categories
Html5

HTML5 – Tips & Tricks

HTML5 has a lot of new tools to build website for better user experience and it is strong and powerful version of HTML. For Mobile phone applications it is used to a very great extent. Here are some tips and tricks for HTML5 HTML <!DOCTYPE> Declaration:The <!DOCTYPE> declaration is the first tag in your HTML […]

Categories
MySQL

MySQL ORDER BY Clause

Using MySQL ORDER BY Clause you can sort table columns by ascending or descending. Suppose we have a table ‘tbl’ with column ‘name’ and a row like below values: 1 1B 10 2 10C 2A 10Z So, when you sort by name: SELECT name FROM tbl ORDER BY name; So, when you sort by that […]

Categories
Business Feature Story

Things You Should Know Before Starting Your First Brand Identity Project

Is it accurate to say that you are in all-out startup mode? Perhaps a little overpowered by all that you have to do to before your brand welcomes the world? Is “business branding” one thing on your agenda that you aren’t sure how to handle? Distinctive brand identity captivates, resonates, and defines, forging lasting connections […]

Categories
Html5

Tips for fast loading HTML5 videos

HTML5 videos is becoming more popular with day by day. So for displaying the video in website it should be well-designed and load quickly. The complexity of the HTML5 video arises not from the syntax, but from the browser support and encoding video also. To build a successful HTML5 site with a video display, you’ll […]

Categories
MySQL

MySQL Event

In MySQL you can add an event to a database that runs in a interval to automate database tasks. You can wait for intervals and check the table to see the changes. By default, the event scheduler thread is not enabled in the database. You need to enable this: SET GLOBAL event_scheduler = ON; Or […]

Categories
MySQL

PROCEDURE ANALYSE()

If you want to analyze the columns structures of a MySQL table and want to view the actual data in your table with certain suggestion then you can get help from PROCEDURE ANALYSE(). For example, if any data present in your table and plays a big role in any decision making then this is very […]

Categories
KnockoutJS

KnockoutJS – Declarative Bindings

To connect data to UI declarative bindings are used. As bindings and Observables both are different, using normal javascript object you can bind view. Declarative Bindings consists of two values i.e. name and value: Full name: <input data-bind=”value: fullName, valueUpdate: ‘afterkeydown’” /> Here when each key is pressed value will be updated.

Categories
Css3 Html5

CSS3 required styles

Using HTML5 required style you can validate your form and show error. But sometimes you need to give a style like keep the color red for error or green on success.  Here’s how to use CSS3 required. Here is a sample example for required css: <!DOCTYPE html> <html> <head> <title>CSS3 styles</title> <style type=”text/css”> input[type=”checkbox”]:required:invalid + […]