Categories
MySQL

Filter Rows Using WHERE Statement

In SELECT statement you can filter with condition to get actual result. Using WHERE clause you will get the data from the table that you exactly need. Here is sample sql for Filter Rows: SELECT name, address FROM users WHERE state = ‘AL’;

Categories
Css Css3

Use reset.css

Reset.CSS is used to normalize browser’s default styles that resets the styling of all HTML elements to a consistent baseline. Every browser has its own default ‘user agent’ stylesheet which use unstyled websites appear more legible. For example default links color is blue and visited links are purple color. – Some reset stylesheets is harmful […]

Categories
Html

HTML Entities

In many different language HTML language is used. So it contains different types of symbols or entities which are not english alphabet. These entities starts with ampersand character and finish with semicolor character. For e.g. &quot; Here is a list of entities examples: &quot; “ &apos; ‘ &amp; & &lt; < &gt; > &pound; £ […]

Categories
Css3

A Little Known CSS Facts

As you have been writing css for several years day by day you are getting new things that you have never used previously. Each and every well trained front-end developer feature-tests before using any features which a browser may not have. This feature testing has always done with scripting, and most of the people use […]

Categories
MySQL

MySQL UNION Operator

Using MySQL UNION Operator you can combine two or more result set from a multiple table into a single result set. UNION operator eliminates duplicate rows from the result set even you forgot to use DISTINCT operator. UNION ALL allows duplicate rows remain in the result. In the corresponding SELECT statements the number of columns […]

Categories
Html

Element Structure of HTML

HTML documents consists of multiple element structure which includes start tag, attribute, body element, end tag etc. Element Structure: The main tag of HTML is <html> and </html> which is start tag and end tag.The content element is written between two tags i.e. body tag.For example, <p>Hello there!</p> Few HTML elements have no body i.e. […]

Categories
jQuery

Steps to take when jQuery is not working

Sometimes it may happen that you used jQuery but it not working and you are in a deep trouble that makes you puzzle at a moment. So what to do with the jquery steps? Here are few simple things that are primary jquery steps to check for sure. JavaScript disabled/not supported by browser: Make sure […]

Categories
MySQL

MySQL INDEX

For improving the speed of operation in a table we use MySQL INDEX. We can create more than one field as a index field in a table. This is basically use for searching process so that it can lookup records very fast. As it fetches record very fast from the database, during insert and update […]

Categories
MySQL

Database Manage in MySQL

Database Manage in MySQL is a first priority to maintain a database. Here you will learn how you can manage database i.e. create a new database in MySQL, remove existing database etc. A database is nothing but a container of data that stores any kind of data. Here is how database manage: Creating DatabaseCREATE DATABASE […]

Categories
AngularJS

AngularJS Controller

To control the flow of data AngularJS mainly relies on controllers. It is defined using ng-controller directive. Controller contain attributes, properties and functions. Example of Controller: <html> <head> <title>AngularJS Controllers</title> <script src=”http://ajax.googleapis.com/ajax/libs/angularjs/1.3.14/angular.min.js”></script> </head> <body> <h2>AngularJS Controllers</h2> <div ng-app=”ngApp” ng-controller=”nameController”> First name: <input type=”text” ng-model=”name.firstName”><br><br> Last name: <input type=”text” ng-model=”name.lastName”><br> <br> Full name: {{name.fullName()}} </div> <script> […]