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
MySQL

Replace NULL values

You can show the null values which represent the concept of missing or inapplicable information, with other values for better data representation. Suppose we have a table as below: Name Country John India Jane Australia Tim [NULL] So if you query from the database the null result will show the blank result. You can replace […]

Categories
Feature Story Technology

What Is Construction Defect Management Software and Why Do You Need It?

Construction projects can be complicated, with many moving parts, teams, and deadlines to manage. Making sure the finished product is high-quality is essential. But finding and fixing problems during construction, especially in large projects, isn’t easy. That’s where Construction Defect Management Software comes in. It helps teams find and fix problems. What Is Construction Defect […]

Categories
KnockoutJS

Components of KnockoutJS

Components are way of organizing the UI code for structure wise and promote code re-usability for a large application. Components can be registered using the ko.components.register() API. ko.components.register(‘componentname’, { viewModel: {…}, template: {….) }); <!DOCTYPE html> <head> <title>Components of KnockoutJS</title> <script src=”https://cdnjs.cloudflare.com/ajax/libs/knockout/3.2.0/knockout-min.js”></script> </head> <body> <h4>Example 1: without parameters</h4> <div data-bind=’component: “example-editor”‘></div> <h4>Example 2: passing parameters</h4> […]

Categories
Feature Story Web Design & Development

Top 5 Tips to Choose Best Web Application Development Company

Since 59% of the global population is looking for products and services online, it is imperative that your company has a strong online presence to stand ahead of competitors. Customized web applications offer greater security, scalability, and features that are basically designed to meet the demands of individual businesses. Custom creation, as opposed to off-the-shelf […]

Categories
MySQL

MySQL copy table

It is very useful to copy table data from a old existing table to a new table when you need to back up data and replicating the production data for testing. To copy data from one table to another table, you can use CREATE TABLE and SELECT statements as follows. Simple example of copy table: […]

Categories
AngularJS

AngularJS Scopes

AngularJS scopes is a special object which joins controller with views. $scope object access model data in controller as it is the first argument to controller. $scope is specifically for controller so it can inherit its parent controller also. Basically, scope is an object which refers to the application model i.e. an execution context for […]

Categories
MySQL

Create Trigger in MySQL

Using CREATE TRIGGER statement you can create a trigger. You have to put the trigger name after the trigger statement. Let’s see an example of Create Trigger: For example we have two tables i.e. users and userhistory. users:userIDfirstNamelastName userhistory:userIDlast_update Read Also: INSERT … ON DUPLICATE KEY UPDATE Now we will create a trigger before update […]

Categories
KnockoutJS

KnockoutJS – Observables

3 concepts in which KnockoutJS is build upon is:– Through observables dom elements and ViewModel exchange information– Bindings between UI and ViewModel– Templating web applications To make it observable declare as:this.property = ko.observable(‘value’); Let’s try below Observables example: <!DOCTYPE html> <head> <title>KnockoutJS – Observables</title> <script type=”text/javascript” src=”http://ajax.aspnetcdn.com/ajax/knockout/knockout-3.1.0.js”></script> </head> <body> <!– This is input box, used […]