Categories
Json

JSON with Ajax

Ajax is Asynchronous JavaScript and XML for for asynchronous web applications. Using ajax data from a server asynchronously retrieved and display without reloading the page. So JSON with Ajax is no exception. JSON stands for JavaScript Object Notation. So, in simple terms JSON is a way of formatting the data. For, e.g., transmitting it over […]

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
Json

What is JSON?

JSON or JavaScript Object Notation is nothing but a text-based human-readable data storing and interchange. Douglas Crockford originally specified the this format.The media for this is application/json and the extension is .json.This is an easier-to-use alternative of XML. The below example shown an student object with an array of 3 records: {“students”:[ {“Name”:”Tim”, “Age”:”25″}, {“Name”:”John”, […]

Categories
MySQL

MySQL Transaction

Using MySQL you can COMMIT a statement and ROLLBACK to manage transaction. While adding a data into two or more tables where one primary key for one table is the foreign key of another table it may happen sometimes that after adding data into first table MySQL failed to add data into second table due […]

Categories
Monetize

No Investment for Any Online Jobs

For making money, online jobs are becoming very popular and easy to maintain around the world. Million of users are using online jobs for making extra income for part time from home. Online Jobs are becoming very popular in India & all over the world for earning Money online from home without any investment. Now […]

Categories
MySQL

MySQL INSERT statement

To insert data into tables you can use MySQL INSERT statement. Simple syntax of MySQL INSERT: INSERT INTO table(column1,column2..) VALUES (value1,value2,..), (value1,value2,..); You can also insert from another table also i.e. clone: INSERT INTO tbl_1 SELECT * FROM tbl_2;

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 SELECT Statement

Using MySQL SELECT statement you can fetch combination of columns and rows from tables or views, known as a result set. This is the one of the most commonly used queries in MySQL to get data from the MySQL database. You can add or use one or more tables i.e. separated by comma for including various […]

Categories
MySQL

MySQL BETWEEN & Alias

To specify a range of test you can use BETWEEN operator. Example of BETWEEN: SELECT * FROM users WHERE age BETWEEN 18 AND 55; Here below 18 and above 55 aged user will be eliminated. For your own understand you can give an alias name to a column while getting the data from a table. […]