How2Labs

Tuesday, February 12, 2013

0 Facebook Developers Live

Today Facebook Announced Its New Section for developers Called Facebook Developers Live.it will be going live from feb. 20th. To join developers Live visit here

what it Provides For Developer ?

It provides all the resources for developing and growing your Facebook Application. Specially the most needed section of Facebook developer "Video Tutorials"

0 Are you Ready For New Ubuntu Phone ??

getting started Mobile Phone open source tech tutorial ubuntu

Recently Ubuntu Announced that its Phone will be available in market in last quarter of 2013.So Are you ready for getting hands on New Phone Experience .

At the Press Release in London Mark Shuttleworth said that

Calling the product launch a “significant next step in our history”, he also gave demo of the device

Ubuntu Phone Preview

But What's Special about Ubuntu ?

Ubuntu Provides some Features that makes your Phone Experience amazing

Access Everything by just 1 finger swipe
Full utilization of Mobile Screen
Everything on screen but Nothing shown until you Swipe
Super fast Switching Between Apps

Main features of Ubuntu Phone

Edge magic: thumb gestures from all four edges of the screen that enable users to find content and switch between apps faster than they can on other phones.
Focus on content, not the controls: immerses the user in their content. Controls only appear when they want them.
Integrated search: Search for anything that’s saved on the phone, any content from online providers like Amazon and even menu functions within applications.
HTML5 apps, web apps and native apps are equal citizens – they all get their own icons and access to system services, so the user need never know the difference.
Personalised welcome screen: a visualisation of an individual’s social interactions (infographics on calls, SMS, Twitter) – ever changing, totally personal.

Special Feature Images

Ubuntu Animated home screen With Notification

What's For Developer ?

Useful links

Get Started
resources
Publish Apps

0 Brackets : An Open Source Text Editor from Adobe

Brackets open source software tech web project website

Finally Adobe made something Open Source. Brackets is the opensource text editor specially designed for the Web developer. there are some amazing features like inline editing,live edit (preview is shown in chrome) that most of the web developer gonna love. One more thing is liked about this is that it built by using java script, html 5,CSS , So as they say

For the WEB by the WEB

Where To get it ?

you can get it here. current release it Sprint 19.

Basic features how to use ?

For inline text editing just put your mouse on the html tag like body,div,h1 etc and press CTRL+E

Live Preview

To Use the Bracket live Preview feature click on the icon in top right , just as icon highlighted in below image.

Bracket Video Demo

Bracket extensions

Bracket mainly focus on the web development and there are so many extension available to increase your productivity and performance . these extensions are categorized under different categories but there is no GUI for installing the extensions however you can manually download and copy the extension and copy them to extension directory and then browse it using menu bar.

Code/Text Editing

Select Parent: Quick way to select the block enclosing the selection
Web Fonts: Simple interface for adding/deleting/swapping Google Web Fonts in a CSS file
Kill Ring: Adds an Emacs-style kill ring to the editor.
Spell Checker: integrates the spell checker web service After The Deadline - now in beta - Supports English, German, French, Spanish and Portuguese. Note: Now compatible with brackets build >== build 0.18.x /Sprint 18

Snippets & Shorthand

Emmet/Zen Coding: Adds Emmet (Zen Coding) support to Brackets (download here).
Snippets: Assign trigger keys to insert snippets. Configurable with JSON
Prefixr: Generate browser specific CSS prefixes using the prefixr service.
Quick Markup: fast HTML markup generation as you type.
HTML Templates: Pastes in barebones HTML code for different doctypes.
Auto-match pairs: auto-complete Paranthesis, Brackets, Braces, Double and Single Quotes...

Code/Text Formatting

String Convert: Provides shortcuts for modifying and encoding strings within the editor.
Show Whitespace: Visualizes spaces and tabs
TabToSpace: Converts indentation to tabs or spaces
Align Assignments: Aligns assignment operators (equal signs)
Auto Formatter: Auto formatter for XML/HTML, CSS, JavaScript files.
Auto Indent: Indent automatically for whole file.
Beautify: Beautify HTML, CSS, and Javascript (uses js-beautify)
Remove Trailing Spaces: Removes unnecessary whitespace when saving files.
Whitespace Normalizer: Trims trailing whitespaces, transforms tabs to spaces and adds newline at the last line when saving files.

Code Generation

App Cache Buddy: Generate and validate application cache manifests.
Annotate: Generates JSDoc annotations for your functions

Language Support

JavaScript Code Hints: Code hinting (aka autocompletion) for JavaScript files in Brackets.
PHP: adds PHP function definition support to QuickOpen search

General Functionality

Extension Manager: Install, Remove, and upgrade your extensions from the cloud from inside Brackets (requires node).
Extension Toolkit An extension to make building Brackets extensions easier.
Related Files: Discovers and allows you to open related files in your project.
File Navigation Shortcuts: shortcuts for switching to next/previous editor (non-MRU order), and a version of Quick Open scoped to only open files.
Open File from URL: Opens any href and rel atribute urls in editor on ALT+0 shortcut. Currently works only with existing files.
Brackets Commands Guide: Search and execute commands by typing part of their name, similar to Quicksilver (or Sublime's Ctrl+Shift+P or Eclipse's Ctrl+3).
Open Containing Folder: Opens folder containing current file or a file/folder in Sidebar. Added keyboard shortcut CTRL+ALT+O for opening folder containing document opened in editor.
Bookmarks: Navigate within a document using bookmarks.
TestQuickly: simple extension to run unit tests with a keystroke (handy for Brackets core and extension developers)
PageSuck: prompts for a URL and pulls that page's HTML directly into the editor as a new file

Live Development

Debugger: Brackets Debugger for the Live Development browser.
Everyscrub: Everything's a scrubber! Cmd/Ctrl + drag on any number or hex color to scrub its value and update the browser in real time.
Reload in Browser: Adds a toolbar button and shortcut to reload the page in the browser
V8/Node Live Development: Updates scripts running in Node.js as you type

Visual Editing

Edge Web Fonts: Browse free fonts from the Edge Web Fonts collection, with thumbnails. Activated via CSS code hints for font-family.
Hover Preview: Displays a preview when hovering over a color value, gradient, or image filename.
CSS Exclusion Shape Viewer: Quick Edit on an exclusion shape definition in CSS displays the shape.
SVG Preview: Live preview SVG files in an inline panel while you edit them.
Markdown Preview: Live preview of Markdown files, updated as the document is edited.

External Tools

BracketLESS: Compiles LESS files to CSS on save
GitHub: Implements the GitHub API, including oAuth. Currently functionality limited to Gists.
ToGist: Create an anonymous gist from the current selection.
PhoneGap Extension for Brackets: Manage PhoneGap Build projects from Brackets.
(See also Prefixr above).

Documentation

CanIUse: An inline viewer of CanIUse.com support data.
Display Shortcuts: Display Shortcuts defined to Brackets.

Linting & Warnings

CSSLint: CSSLint your documents.
JSHint: Performs a JSHint report.
W3CValidator: Run the W3C Validator on your HTML.
(See also App Cache Buddy above).

Deprecated Extensions

Color Editor: Quick Edit on a hex/rgb/hsl color opens an inline color picker, plus a listing of all colors used in the file. (Merged into Brackets as of Sprint 17).
Color Picker: Quick Edit on a hex color opens an inline color picker. (A color picker is built into Brackets as of Sprint 17).
Editor Shortcuts: Keyboard shortcut to delete line. (This command is built into Brackets as of Sprint 15).
MDNLookup: Includes a way of creating an extensions toolbar and adding buttons to the toolbar with callbacks. Requires a slight change to the core. (Does not work in current versions of Brackets).

0 Getting Started With Firefox OS

firefox app tutorial firefox application Firefox OS firefox os tutorial

In this Tutorial We are going to see the How we can start the Development with FireFox OS and then we Build a Sample Application.

Firfox O.S. completely focus on the Web Applications,so you need not to learn anything new if you are a Web geek .

PreRequsite :

Firfox O.S. completely focus on the Web Applications,so you need not to learn anything new if you are a Web geek .
if you are familar with the following term you can jump start .otherwise you can just follow the steps and when you feel free try to learn something about these terms.

HTML 5
Java script
CSS
Git and Github
simulator : for Testing Apps

Lets Start by setting upp the environment for our Tutorial.

if you are familer with Git and git hub you can skip these step , otherwise go to the Git and Github download Git and create a free account at Github . After this just follow the instruction for Setup - Git
There are few Templates already available for developemnt so we are going to start with a basic template. you can get it from Mozila-app-stub or you can clone it directly to your system using the following command (in command myweatherapp is the app name you can give it any name).
$ git clone git@github.com:mozilla/mortar-app-stub.git myweatherapp
Download and Install Node.js. After the installation just open command prompt(windows)or shell(gitor any other terminal) and type following command
npm install -g volo
.This will install volo utility, which is required to complete this Tutorial.
Download Bootstrap . we can do this by using volo add command . the command is shown below .
volo add bootstrap
it download the bootstrap from git and add it to your project make sure you run this command from project directory as shown in image . for dependency and global name just hit enter.
Download and add Underscore.js its the Javascript libarary. you can do it using volo command just like we did in above step
volo add underscore
download modernizr.js and copy it into js/lib folder
Download Bootstrap zip extract it and copy css/bootstrap.css into to our www/css directory
Download and Install the Firefox simulator

Lets Begin to Code

you can find the source files under myweatherapp/www directory.

Edit Index.html

open the Index.html in any text Editor and copy paste the following script



<html>
  <head>
    <meta charset="utf-8">

    <title>My Weather App</title>
    <meta name="description" content="">

    <!-- Mobile viewport optimized: h5bp.com/viewport -->
    <meta name="viewport" content="width=device-width">

    <!-- Place favicon.ico and apple-touch-icon.png in the root directory: mathiasbynens.be/notes/touch-icons -->



    <!-- Do not add any other CSS here, instead @import it in app.css.
It will be inlined when building. That way it will
automatically be minified. -->
    <link rel="stylesheet" href="css/app.css">

    <!-- All JavaScript at the bottom, except this Modernizr build.
Modernizr enables HTML5 elements & feature detects for optimal performance.
Create your own custom Modernizr build: www.modernizr.com/download/ -->
    <script src="js/lib/modernizr-2.5.3.min.js"></script>
  </head>
  <body>

        <div class="content">
      <ul class="nav nav-tabs">
        <li class="active"><a href="#forecast">Forecast</a></li>
        <li><a href="#settings">Settings</a></li>
      </ul>

      <div class="tab-content">
        <div class="tab-pane active" id="forecast">
          <h1>What's the Forecast?</h1>
          <h2 class="name"></h2>

          <section class="day1">
            <h3>Today:</h3>
            <p class="low">Low: <span></span></p>
            <p class="high">High: <span></span></p>
          </section>

          <section class="day2">
            <h3>Tomorrow:</h3>
            <p class="low">Low: <span></span></p>
            <p class="high">High: <span></span></p>
          </section>
        </div>
        <div class="tab-pane" id="settings">
          City, zip code, or place: <input type="text" name="place" />
          <div>
            <button class="btn save">Save</button>
          </div>
        </div>
      </div>
    </div>






    <!-- JavaScript at the bottom for fast page loading: http://developer.yahoo.com/performance/rules.html#js_bottom -->

    <!-- Using require.js, a module system for javascript, include the
js files. This loads "main.js", which in turn can load other
files, all handled by require.js:
http://requirejs.org/docs/api.html#jsfiles -->
    <script type="text/javascript"
            data-main="js/app.js"
            src="js/lib/require.js"></script>

  </body>
</html>

Edit js/app.js

To add any javascript libarary to our code we Define the require.js using the folloing statement

define(function(require) { }

and put our code insde it. to use any javascript libaray we use the require function function. if you remeber we downloded the underscore.js in setup steps now we add the library by following command


var _ = require('underscore');

//simillary we add the bootsrap-tab libaray
require('bootstrap/js/bootstrap-tab');

Now we open the app.js and replace the code with the following code.

require.config({
    baseUrl: 'js/lib',
    paths: {'jquery':
            ['//ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min',
             'jquery']},

});


// When you write javascript in separate files, list them as
// dependencies along with jquery
define("app", function(require) {

    var $ = require('jquery');
	


var _ = require('underscore');
require('bootstrap/js/bootstrap-tab');

    function fetchForecast(woeid) {
        var query = escape('select item from weather.forecast where woeid="' + woeid + '"');
        var url = ("http://query.yahooapis.com/v1/public/yql?q=" +
                   query +
                   "&format=json&callback=?");

        $.getJSON(url, function(data) {
            var item = data.query.results.channel.item;
            var forecast = item.forecast;

            $('h2.name').text(item.title);

            for(var i=0; i<forecast.length; i++) {
                var el = $('.day' + (i+1));

                el.find('.high span').text(forecast[i].high);
                el.find('.low span').text(forecast[i].low);
            }

            $('.nav-tabs a:first').tab('show');
        });
    }

    fetchForecast(localStorage.placeWoeid || '2480894');

    $('.nav-tabs a').click(function(e) {
		
        $(this).tab('show');
    });

    $('#settings button.save').click(function(e) {
       
        var place = $('#settings input[name=place]').val();
        var query = "places.q('" + escape(place) + "')";
        var url = ('http://where.yahooapis.com/v1/' + query +
                   "?appid=Zz.TvXLV34Go6RzyHMnH6scOSn_DdLYdyuJVbd6l2MLvuTAAEFIylCIj7Koo_pth7BHeGmNV5m0zdAkAY_CspQ9eKlJRlmM-&format=json&callback=?");
        
        $.getJSON(url, function(data) {
            if(data.count !== 0) {
                var p = data.places.place[0];
               localStorage.placeWoeid = p.woeid;
                fetchForecast(p.woeid);
            }
        });
    });



});

Now we add some CSS to our code .so open css/app.css folder and replace the code with following



/* Tip: Use "@import" to add styles instead of adding 's in your
   HTML, and volo will inline it when building for production */

/* Styles for the installation button */
@import "install-button.css";

/* Your styles here */

@import "bootstrap.css";
/* @import "bootstrap-responsive.css"; */

body {
    background-color: #d3dde5;
}

.day1 {
    margin-top: 1em;
}

#forecast p {
    margin: 1em;
}

.nav-tabs {
    margin: 0;
}

.content {
    padding-top: 1em;

    background: #ffffff; /* Old browsers */
    background: -moz-linear-gradient(top, #ffffff 0%, #d3dde5 100%); /* FF3.6+ */
    background: -webkit-gradient(linear, left top, left bottom, color-stop(0%,#ffffff), color-stop(100%,#d3dde5)); /* Chrome,Safari4+ */
    background: -webkit-linear-gradient(top, #ffffff 0%,#d3dde5 100%); /* Chrome10+,Safari5.1+ */
    background: -o-linear-gradient(top, #ffffff 0%,#d3dde5 100%); /* Opera 11.10+ */
    background: -ms-linear-gradient(top, #ffffff 0%,#d3dde5 100%); /* IE10+ */
    background: linear-gradient(to bottom, #ffffff 0%,#d3dde5 100%); /* W3C */
    filter: progid:DXImageTransform.Microsoft.gradient( startColorstr='#ffffff', endColorstr='#d3dde5',GradientType=0 ); /* IE6-9 */
}

.content h1 {
    margin: .25em 0;
}

section p, #settings {
    font-size: 1.25em;
}

.tab-content {
    padding: 1em;
}

Debug, Build and Deploy

Debug:

to dubeg our app we launch server through volo command . as shown below

volo serve

once you see in terminal starting web server at http://localhost:8008. you can open browser like chrome or mozlia (updated version) or you can launch the simulator by going through Menu in Mozila as shown below

it will launch the firefox simulator with dashboard. in the Dashboard ,at field next to Add directory type

http://localhost:8008/

and click Add URL . it will launch simulator and add your application to it as show in picture . just swipe screen untill you see your app.

Now you can open and Test your App. if it works well you can move to next step oterwise just check your code and steps again, to stop server press Ctrl+C

Time to Build The App

To build the Application use the volo command as show below

volo build

it will build the app abd place it intowww-built directory

Once the build get successfull now we can Run the our built app using the following command

$ volo serve base=www-built

now see the simultor app again . hope you successfully built the App . final output of App will be shown here.

Lets Deploy :)

Now we are done with built and we tested it so now we can deploy our app to Github its free so if you don't have account get one for you and follow the command given below

volo ghdeploy

it will ask you to give name for repo you can hit enter if you want repo with same name as project or you can give name. if repo doesn't exist already it ask is this repo private just type n and hit enter . Now it will upload files on git so just wait untill it asks your password for authentication .

Download Source Code

0 Download IBM DB2 10.1

download db2 ibm db2 software for tgmc

Today a guy ask me where i can download IBM DB2 ? its free or not ? So i thought that the same question must be coming to diff. students too who are working on TGMC or some other projects. So here is Answer for both question.

IBM DB2 comes in two versions

1. commercial version
2. Express-C where C stands for community edition its for developers and students and as IBM says

Free to develop, free to deploy, free to distribute

So you can download it free from the link given below .

http://www-01.ibm.com/software/data/db2/express-c/about.html

you just need to login with your IBM account . if you don't have one just relax you can create it ,it's free .

feel free to ask if you have any doubt subscribe for updates .

0 Interesting Facebook Graph Search terms

facebook facebook graph how to tech

Facebook Recently Launched its New Graph Search by which you can search things in simple English or your language and then you can filter them to on different parameters .

This search can be utilized in different ways depending on your Interests .

E.g.

Search For Singles in your Locality : just type following search term:
Single females who live in " locality" ( like.. Single females who live in New Delhi, India )
gives result :

Then you can apply different filter on them.

BASIC INFO
Gender
Age Range
Relationship
Languages
Religious Views
Political Views
WORK AND EDUCATION
Employer
Position
Employer Location
Time Period
School
Class Year
Concentration
Degree

LIKES AND INTERESTS
Likes
Following
Admins of
Members of
Apps They Use
PHOTOS AND VIDEOS
Tagged in
Commented on
Interacted with
Created
LIVING
Birth Year
Current City
Live Near
Hometown
Visited
RELATIONSHIPS & FAMILY
Friendship
Relationship with
Married to
Engaged to
Partners with
Relatives of
Parents of
Stepparents of
Siblings of
Children of
Cousins of

Other Useful terms you wanna try :
People who work at IBM in Chennai, Tamil Nadu
Photos of Sachin Tendulkar

And My Favouraite one :
Current cities of my friends

How to get it ?

https://www.facebook.com/about/graphsearch

0 Mozila's Reveals its Mobile with Firefox OS

developer preview phon Firefox OS firefox os tutorial Mozila

A New Era of Open Source Mobile Development is gonna starts now with the Launch of Mozila's FireFox OS. Google gets competitor. Mozila always famous for its open source development Reveals its New Mobile with its own New O.S. Have look because You gonna love it .

Phone Specifications

The Keon model
CPU Qualcomm Snapdragon S1 1Ghz
UMTS 2100/1900/900 (3G HSPA)
GSM 850/900/1800/1900 (2G EDGE)
Screen 3.5″ HVGA Multitouch
3 MP Camera
4GB ROM, 512 MB RAM
MicroSD, Wifi N, Light and proxmity Sensor, G-Sensor, GPS, MicroUSB
1580 mAh battery
Over the air updates
Unlocked, add your own SIM card

The Peak model

CPU Qualcomm Snapdragon S4 1.2Ghz x2.
UMTS 2100/1900/900 (3G HSPA).
GSM 850/900/1800/1900 (2G EDGE).
Screen 4.3″ qHD IPS Multitouch.
Camera 8 MP (back) + 2 MP (front).
4 GB (ROM) and 512 (RAM).
MicroSD, Wifi N, Light and proxmity Sensor, G-Sensor, GPS, MicroUSB, Flash (camera).
Battery 1800 mAh.

Opportunity For Developers :

Mozilla gives a Completely New market for App developer where the can publish there app. The Best Thing Supports HTML 5 Good For web developer Now they can also jump in Mobile Development

Useful Links For Developers :

Introduction to Firefox OS http://www.mozilla.org/en-US/firefoxos/
Content Repo: Resources for hacking on Open Web Apps http://fwenzel.github.com/hackday-resources/StartHere.html
Firefox Marketplace Developer Hub https://marketplace.firefox.com/developers/
Firefox OS Simulator - Add-ons for Firefox https://addons.mozilla.org/en-US/firefox/addon/firefox-os-simulator/
Firefox OS - Mozilla href="https://developer.mozilla.org/en-US/docs/Mozilla/Firefox_OS
Firefox Apps Docs https://developer.mozilla.org/en-US/docs/Apps

1 How to make SanDisk USB Bootable windows 7

how to SanDisk tech windows

Few days back i needed to format my Laptop , but i didn't had windows disk so i decided to go for USB Boot . i tried so many times by formatting disk into NTFS and copying all windows 7 files in USB drive but nothing worked . finally i searched all over net and found a solution which worked for me . so here it is .

Step 1 : backup all your USB data because its gonna format this.
Step 2: goto run type cmd and run command prompt as administrator.
Step 3: Now type all the commands as it is shown .
Step 4: type diskpart and hit enter
Step 5: type list disk . it shows the list of disks. make sure you able identify your USB drive (see the size and free space).
Step 6: type select disk # (where # represents your disk number , for me its 1)

from step 4 to 6

Step 7: type clean (Clean : removes any existing partitions from the USB disk, including any hidden sectors)
Step 8:type Create Partition Primary (it Creates a new primary partition with default parameters)
Step 9:type Select Partition 1 (Focus on the newly created partition).
Step10: type Active (Sets the in-focus partition to active, informing the disk firmware that this is a valid system partition)
Step11:Format FS=NTFS (Formats the partition with the NTFS file system. This may take several minutes to complete, depending on the size of your USB key.)
Step12:Assign (Gives the USB drive a Windows volume and next available drive letter, which you should write down. In our case, drive “J” was assigned.)
Step13:Exit (Quits the DiskPart tool)
Step 14 :Now go into the directory where you copied all your windows 7 files ( in command prompt ). open boot directory(cd boot) . and type the command as

Bootsect.exe /nt60 J: (where ‘L’ is the drive letter assigned to your USB key from the previous step)
Bootsect infuses boot manager compatible code into your USB key to make it a bootable device.

Now copy all windows 7 files to USB drive , no need to use command prompt you can do it using copy paste option. Have fun installing windows.

0 Slice of SQL

database sql tutorial

Wanna learn sql ? in a different way . lets try this.
Once there was a quy who went shop and said “ give me few chocolates “. Shopkeeper sais do you have basket he said no .shopkeeper said go and bring the basket . he just created a basket . in database our basket is the TABLE and we can create it by using this following statement.

SQL> create table basket(name varchar2(20),price number(4),quantity number(2));
(Output:>)Table created.

In above query > basket is the name of table .
name is the column of type character of length 20 .
price is the column of type number of size 4
quantity is the column of size 4.
After getting the basket he again went to shop and said give me 5 dairymilk,4 5star and 3 perk in this basket . we can do this in database by “insert command”

SQL> insert into basket(name,price,quantity) values('dairy milk',20,5);
1 row created.

We can even do this in a simple way .

SQL> insert into basket values('5star',10,5);

1 row created. (note: to use this all values need to be entered )
Now he just wants to crosscheck the basket so he checked the chocolates in basket similarly we can do this by using the “SELECT command”

SQL> select * from basket ;
NAME                      PRICE   QUANTITY
-------------------- ---------- ----------
dairy milk                   20          5
5star                        10          5
perk                         15          3

where * indicates all the column
Now when he was going to meet his girlfriend ,he met with his friend and he took some chocolates from his basket. Now he just wants to confirm the number of 5star chocolates availbe so he counts the 5star chocolate. We can also do this in database using following command.
SQL> select name,quantity from basket where name='5star';
NAME                   QUANTITY
-------------------- ----------
5star                         5

Finally he meets with his girlfriend and gave basket to her. After going home the girl checks the basket and counts the number of types chocolate given by the guy. In database we use “Aggregate functions” for this .

SQL> select count(name) from basket;
COUNT(NAME)
-----------
3

From this tutorial what we learned is

Creating a table : create command.

CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
column_name3 data_type,
....
)

Inserting values in table : insert command

INSERT INTO table_name
VALUES (value1, value2, value3,...)
INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)

Selecting or viewing the rows : select command

SELECT column_name(s)
FROM table_name
Or
SELECT *
FROM table_name

Selecting specific rows on conditions : where clause

SELECT column_name(s)
FROM table_name
WHERE column_name operator value
Operator and their meanings

Operator	Description
=	Equal
<>	Not equal
>	Greater than
<	Less than
>=	Greater than or equal
<=	Less than or equal
BETWEEN	Between an inclusive range
LIKE	Search for a pattern
IN	To specify multiple possible values for a column

Counting the number of rows: Aggregate function- count

Useful aggregate functions:

AVG() - Returns the average value
COUNT() - Returns the number of rows
FIRST() - Returns the first value
LAST() - Returns the last value
MAX() - Returns the largest value
MIN() - Returns the smallest value
SUM() - Returns the sum

0 Remote control the Browser Window

Ajax framote sharing tech

FRAMOTE

Someone said that Big surprises comes in small packages . Today i feel this line perfect for that framote . This is an awesome example of Ajax and iframe shown by Jaime Caballero .

What it is ? and how it works ?

framote enables you to control the remote browser and show the links which you want. You just need to give a starting URL(link) and it will provide you two different URL's (i). to share on remote devices (ii) to control those remote devices .

Where you can use this ?

This will be specially useful for the web Developers by using this they can test their applications on different browsers and multiple devices without opening the whole web on each of them one by one. yippee its free.

How to Use Framote Step by step

Step 1: go to framote and give a URL i say "http://www.how2labs.info/" and click create.

Step 2: share the Framote URL and open Control URL in a new window to control the Framote URL

framote in action

Step 3: in Control URL provide the new URL you want to share and click change. the remote url will automatically get refreshed

change remote url framote

Pages

Tuesday, February 12, 2013

what it Provides For Developer ?

Growing Mobile Apps with Facebook SDKs

How to Build & Measure Mobile App Install Ads

Facebook Mobile Developer Day: Keynote

Your First Open Graph App

What is Open Graph?

Open Graph Pro Tips

Open Graph Tagging Users, Messages, and Posts

Open Graph Object and Action References

Open Graph Deep Linking for iOS

Publishing Open Graph Actions from iOS

Publishing Open Graph Actions Using the JavaScript SDK

Using the Facebook SDK for Android

Introduction to Mobile App Install Ads

Using the Facebook SDK for iOS

Facebook Mobile Developer Day: Best Practices App Panel

Facebook Mobile Developer Day: Growing Your Mobile Game

Facebook Mobile Developer Day: Q&A Wrap Up

Facebook Mobile Developer Day: Getting Started with iOS SDK

Facebook Mobile Developer Day: Getting Started with Android SDK

Facebook Mobile Developer Day: Advanced iOS SDK

Facebook Mobile Developer Day: Advanced Android SDK

Facebook Mobile Developer Day: Engaging Social Apps

Facebook Mobile Developer Day: Driving Mobile Installs

Facebook Mobile Developer Day: Morning Q&A

Facebook on PBS's America Revealed

Growing Games with Facebook

Facebook for iOS and Android Developers

Getting Started with the Facebook Platform

Introduction to the Facebook Platform

Wednesday, February 6, 2013

But What's Special about Ubuntu ?

Main features of Ubuntu Phone

Special Feature Images

What's For Developer ?

Useful links

Saturday, February 2, 2013

Where To get it ?

Basic features how to use ?

For inline text editing just put your mouse on the html tag like body,div,h1 etc and press CTRL+E

Live Preview

Bracket Video Demo

Bracket extensions

Wednesday, January 30, 2013

PreRequsite :

Lets Start by setting upp the environment for our Tutorial.

Lets Begin to Code

Edit Index.html

Edit js/app.js

Debug, Build and Deploy

Debug:

Time to Build The App

Lets Deploy :)

Sunday, January 27, 2013

Saturday, January 26, 2013

Wednesday, January 23, 2013

Phone Specifications

Opportunity For Developers :

Sunday, January 13, 2013

Sunday, December 30, 2012

Saturday, December 29, 2012

What it is ? and how it works ?

Where you can use this ?

How to Use Framote Step by step

Step 1: go to framote and give a URL i say "http://www.how2labs.info/" and click create.

Step 2: share the Framote URL and open Control URL in a new window to control the Framote URL

Step 3: in Control URL provide the new URL you want to share and click change. the remote url will automatically get refreshed

Step 4: Don't forget to subscribe for new update :)

For Beginners

About

Get Free Email Upadtes

Popular posts

Archive

Categories

Labels