HTML5 Input Types for Mobile web application.

Are you working with mobile web applications, then you must adapt new HTML5 components. Here I explains you how to implement new HTML5 input types while creating forms in mobile web projects. Take a look at these screen shots of the new input types in browsers that support in iPhone. and iPad.

type='text'

Usual input type text that display a alphabetical keyboard

<input type="text" name="username" placeholder="Username"/>

type='url'

iOS shows .com and /, removing the space key

<input type="url" name="url" placeholder="Website URL"/>

type='email'

iOS display an @ sign on the keypad

<input type="email" name="email" placeholder="Email"/>

type='tel'

Smartphone display a numeric keyboard

<input type="tel" name="tel" placeholder="Telephone"/>

type='date'

Smartphone display a numeric keyboard

<input type="date" name="date" placeholder="Date"/>

type='number'

iOS display a numeric keyboard with special characters

<input type="number" name="number" placeholder="Numbers"/>

How to Connect to XAMPP/MySQL using Windows CMD [Command Prompt]

On our previous post, we have discussed about how to install LAMP Environment on your Windows PC easily using XAMPP. If you are a MySQL coder, or wish to learn it, then probably you have came to know about the MySQL terminal [or simply a command prompt in Windows]. Basically it is the best MySQL tool for any newbie user. You have type all your SQL Queries here manually and this way you can actually learn faster.

But opening the MySQL prompt can be a little tricky in Windows PC. As just typing “mysql” in command prompt does not work… So here is a complete guide to easily open MySQL terminal from Windows Command Prompt.

#1: Install XAMPP and locate installation Directory:

First you need to install XAMPP on your Windows PC. You can install MySQL alone if you want, but I shall recommend XAMPP for a better and easier usage. Simply follow the previous post to install it. AlsoNote down the installation directory.

The default installation directory is “C:\XAMPP\”. It may vary for your customized installation. So assuming this, try to locate this folder:

“C:\xampp\mysql\bin\” or “~Installation Folder~\xampp\mysql\bin”

where ~installation Folder~ is obviously the folder where you have selected to install XAMPP.

You should be able to find a file named, mysql.exe . This is the main MySQL Terminal.If you simply open it by double clicking then although a MySQL Terminal will be launched, but you won’t actually be able to modify your database, as in this way MySQL terminal does not get connected to the DB server host!

Just follow the instruction below to open the terminal properly…

#2: Open MySQL terminal from Windows Command Prompt(cmd):

• Go to Start Menu > All Programs > Accessories > Command Prompt;
• This will pop up the Windows CMD.
• Now type in the following command and hit enter:
  CD C:\xampp\mysql\bin
  

• Note that if you have any other installation directory, then you need to replace C:\XAMPP accordingly. Rest the Folder structure …\mysql\bin\ remains the same.
• Now type the following command on the cmd prompt:
  mysql.exe –h localhost –u root -p
• MySQL will start and will prompt you for a password. Leave it blank and hit enter.This should bring you the MySQL terminal.

Now write and run the SQL Query languages and do whatever you wish to. Below is a process to add shortcut to the MySQL terminal.

#3: Adding shortcut using environment variables:

We will now add a environment variable to windows so that we can open the mysql.exe terminal window anywhere from command prompt without changing the working directory. Just follow the steps below:

• On Windows 7 / Vista:Go to Control Panel > System > Advanced System Settings > Advance Tab > Environment Variable;
• On Windows XP: Go to Control Panel > System > Advanced Tab > Environment Variable;
• Now under “User Variables for ~UserName~” Click on “New” button.
• Under “Variable Name” type: mysql
• Under “Variable Value” type: C:\xampp\mysql\bin\mysql.exe
• Obviously you need to change the location of …/xampp if you have any other installation directory.
• Now Save everythingand close the window.

You are done with creating the shortcuts… To launch MySQL all you need to is:

• Open up Command Prompt;
• Type:
  %mysql% –h localhost –u root -p
  and hit enter (As shown on the first image). Give blank password as before and you are set to go…

Create jQuery Form with Progress bar and Input Limiter

Simple jQuery progress bar on form to show characters length with input limiter functionality. Demo available with downloads.

Click Here For Demo

Read more

MongoDB PHP Tutorial

Now time to work with MongoDB NoSQL database management systems, it stores data into structured JSON like documents with dynamic schemas and improves application performance. This tutorial helps you how to create a simple login page using PHP and MongoDB. Try this download script and implement scalable application.

Installation

Windows
http://docs.mongodb.org/manual/tutorial/install-mongodb-on-windows/

You can download PHP mongo drive/extension dll file from following URLhttps://github.com/mongodb/mongo-php-driver/downloads. Copy php_mongo.dllfile into your PHP extension directory

Linux & Mac
http://docs.mongodb.org/manual/tutorial/install-mongodb-on-ubuntu/

http://docs.mongodb.org/manual/tutorial/install-mongodb-on-ubuntu/

Click for Read more 

Login with Google Account Open Authentication (OAuth)

We are going to cover all the Open Authentication (oAuth) login system for Twitter, LinkedIn, Facebook and now I am writing tutorial about Google Open Authentication login.

in this tutorial i will explain how to implement Google oAuth for your web project, this script is very quick and sure it helps you to increase your web project registrations.

You can Read More Here and See Demo

Download 

Bing Instant Search with Jquery and Ajax

Some days back I had posted a popular article 'Youtube instant search with Jquery and Ajax'. I received a lot of request from my readers that asked to me how to instant web search results so I had coded Bing instant search with real time search results. Just few lines of code, reading Bing search JSON API file with Jquery. 

First you have to create an application ID from Bing Developer Center.
See Demo
Here Download
Read More 

Tool Tip Jquery Plugin

clueTip Plugin Example

Below are quite a few examples of how you can add a clueTip to your page, using a wide range of options. Keep in mind that there is nothing magical about the HTML markup. You can use any jQuery selector you want to attach your clueTips. For example, if you want to attach clueTips to all links with a class of "peanuts," you would simply write in your jQuery code:$('a.peanuts').cluetip();.

Default Style

1. basic tip from title: This example pulls the clueTip's contents from the invoking element's title attribute via the "splitTitle" option.
   View the HTML
   View the jQuery
2. basic ajax, with no title attribute: This one requires no options.
   no bleed-thruin IE6when using bgiframe plugin
   View the HTML
   View the jQuery
3. custom width and hidden title bar: This tip has a custom width of 200px. The clueTip title bar (heading) is hidden. Try me!
   View the HTML
   View the jQuery
4. sticky, with arrows:This sticky clueTip has its "close" text in the title bar. It won't close until you close it, or until you hover over another clue-tipped link. It also displays an arrow on one of its sides, pointing to the invoking element. sticky clueTip with arrows
   View the HTML
   View the jQuery
   
   
   Click For DEMO
   
   

Build a Simple Yahoo! Answers API Webapp with PHP

Build a Simple Yahoo! Answers API Webapp with PHP

advertise here

The open Yahoo! API is a great resource to work with. There is plenty of documentation for web developers, along with live demos and examples. What makes the application so interesting is how Yahoo! manages so many different online services. Along with their search engine there is also Yahoo! news, maps, weather, and so much more.

For this tutorial I’d like to focus on the Yahoo! Answers API. We will be creating a simple webapp that pulls all recently answered questions from a select few categories. The API delivers results via XML or JSON, so we have the option to build with any backend programming language. Although for this guide I’ll stick to PHP since it’s the most commonly understood backend language.

Live Demo – Download Source Code
Learn More