Categories
Json

Syntax of JSON

Basically Syntax of JSON is the subset of the JavaScript syntax. It has following notation: Data is represented in name/value pairs. The name/value pairs are separated by , (comma). Curly braces hold objects. Square brackets hold arrays. Below is a example of Syntax of JSON: {“students”:[ {“Name”:”Tim”, “Age”:”25″}, {“Name”:”John”, “Age”:”30″}, {“Name”:”Jane”, “Age”:”45″} ]} So,students[0].Name + […]

Categories
Css

7 CSS tricks for website

It is very essential to remember when using CSS to website that you need to maintain some types of tricks which is very helpful. CSS tricks: 1) Don’t fix the font size:You do not know in what resolution people are using your website so let auto fix the font size depends on ratio. Avoid p […]

Categories
Css

3 ways to add CSS to your web sites

Website can not be completed without any style. So you apply CSS. When a browser reads a CSS style sheet, this formats the HTML document according to the information in the CSS style sheet. With 3 basic ways you can add CSS in your web pages:- 1) Link your webpage with an external file: <link […]

Categories
Creative blog

Create a free Blog on WordPress.com

WordPress blog is nothing but converting your hobby into business. So by business or profession share your thoughts on a subject you love. Blogging is free and you can create blog on blogger or WordPress. Let’s see how to start a WordPress Blog: Go to http://wordpress.com Fill up the online form. In the blog address […]

Categories
Php

array_map: stop writing foreach() cycles

Php 5.3 has a solution for ignoring for(), foreach() cycles that will reduce the average number of iteration structures you need to write i.e. array_map. This function in PHP sends each value of an array to a user defined function, and then returns an array with new values that is given by the user defined […]

Categories
MySQL

MySQL LIKE Operator

Using MySQL LIKE operator you can search based on patterns. It is used in the WHERE clause in SELECT statement. This basically use two characters for using the MySQL LIKE operator: ‘%’ – allows you to match zero or more characters‘_’ – allows you to match any single character For searching the first character starts […]

Categories
MySQL

MySQL DELETE Statement

Using MySQL delete state you can delete table data. With a single delete statement you can delete one or more tables data at a time. Example of MySQL DELETE: DELETE FROM users WHERE status = 0; For multiple table: DELETE users, orders FROM users, orders WHERE users.user_id = orders.user_id AND users.status = 0; TRUNCATE TABLE […]

Categories
AngularJS

AngularJS Tables

In AngularJS Tables we can show repeatable data. Using ng-repeat directive we can draw table easily. See the below example how to use ng-repeat in table. Table data is normally repeatable by default and ng-repeat directive can be used perfectly to create table easily. Example of AngularJS Tables: <table> <tr> <th>Name</th> <th>Age</th> </tr> <tr ng-repeat=”x […]

Categories
MySQL

Mysql Query tips & tricks

Few Mysql queries that will help you develop websites and resolve complex codes. Here are few Mysql Query tips: Finding 2nd highest salary in employee table SELECT MAX(`salary`) from tbl where `salary` < (select MAX(`salary`) from tbl); Mysql order by FIELD SELECT * FROM tbl ORDER BY FIELD(first_name,’John’) desc, FIELD(last_name,’Doe′) ASC; Show category-parent category SELECT […]

Categories
MySQL

Subquery in MySQL

Subquery in MySQL means Query inside another query on SELECT, INSERT, UPDATE or DELETE. A subquery must be enclosed with parentheses and can be used anywhere in an expression. The main advantages of subqueries is that it allow queries that are structured so that, it is possible to isolate each part of the statement and […]