Categories
Google Google Maps MySql PHP phpMyAdmin Programming Languages

How to store Longitude/Latitude, from Google Maps in MySql?

If you are confused about the field type of longitude/latitude in the database tables and you are thinking about decimal or float then use the best way defined below.

In MySQL or SQL Server, we can save it as FLOAT( 10, 6 ) NOT NULL

This is the recommendation from google itself: https://developers.google.com/maps/articles/phpsqlajax

CREATE TABLE `markers` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 60 ) NOT NULL ,
`address` VARCHAR( 80 ) NOT NULL ,
`lat` FLOAT( 10, 6 ) NOT NULL ,
`lng` FLOAT( 10, 6 ) NOT NULL ,
`type` VARCHAR( 30 ) NOT NULL
) ENGINE = MYISAM ;

If you are using phpmyadmin then you can save the latitude and longitude shown below.

Categories
Git Linux Server PHP

Basic Git commands and use of these commands

Once you have installed git on your local computer then you have to go to the folder where git is installed.
To go to the folder you can write the following
pwd
cd c:/xampp/htdocs/
git branch

If you are using Git Public Repository then you must be aware about the following basic commands of Git.
Here is a small list of basic Git commands.

git push origin :BN – remove/delete branch from git server/repository

git stash – if there are conflicts and you want to avoid those conflicts

(git add filename) in which u resolved conflict then (git commit -a -m “resolved conflict while making design changes by nilesh”) then git push origin Dev and see your changes

git merge commit_id (to commit the changes in the branch that you are in now)

git reset – -hard (Reset current HEAD to the specified state)

git reset – -hard origin/master (if you are in master branch and git pull showing some conflicts then you can use this command to reset the master)

git branch -D BN – to delete a branch (you must be in other branch(i.e master or IndexFlowVaseem) to delete this branch)

git fetch origin BN:BN – to pull branch data from git

pwd – to see current working directory

git branch MyNewBranch – to create a new branch

git checkout master – to work in master branch or to switch master branch

git pull origin branchname – to get the github.com data on your local computer or git pull origin Dev

git pull origin Dev – a new branch named as Dev will be created with the code from git

git status – to see the changes in your branch and in github.com branch

git commit filepath_name1 filepath_name2 -m “your comment” – to commit the changes you have made

git push origin MyBranch – to upload your data to git branch

git add filename1 filename2 – to add new files in git

git log – to see the commit in the current branch

rm filename1 filename2 – to delete files

The most commonly used git commands are:
add–Add file contents to the index
bisect–Find by binary search the change that introduced a bug
branch–List, create, or delete branches
checkout–Checkout a branch or paths to the working tree
clone–Clone a repository into a new directory
commit–Record changes to the repository
diff–Show changes between commits, commit and working tree, etc
grep–Print lines matching a pattern
init–Create an empty git repository or reinitialize an existing one
log–Show commit logs
merge–Join two or more development histories together
mv–Move or rename a file, a directory, or a symlink
pull–Fetch from and merge with another repository or a local branch
push–Update remote refs along with associated objects
rebase–Forward-port local commits to the updated upstream head
rm–Remove files from the working tree and from the index
show–Show various types of objects
tag–Create, list, delete or verify a tag object signed with GPG

Categories
Git Programming Languages

How to get Git Commit Id

If you are a programmer or developer then you must heard about the Git.
Git is a free & open source, distributed version control system designed to handle everything from small to very large projects with speed and efficiency.

You must If you are working with Git and you want to make changes in the code. Then after making those changes you will need a commit id to make those changes Live.

Please follow the following procedure to get a Git commit id.

cd /c/xampp/xampp/htdocs/lazy-load-release/
git checkout master    (to go to master branch)
git pull origin master (this will copy all the data from git to your computer)
git branch NewBranch (this will create a new branch with data of master branch)
git checkout NewBranch (To switch to your branch and then Put your files or work in lazy-load-release(name of folder may be differ) folder)
git status (you will see the list fo files that just been changed)
git commit filename1 filename1 -m “author_commit”
git push origin NewBranch (if you are in the same branch NewBranch) or git push origin NewBranch:NewBranch (if you are not in the same branch)
git log (copy the commit id)

Categories
Bill Gates Blogging Carlos Slim Explore the Knowledge Mark Zuckerberg News Success Successful People Warren Buffett

Mark Zuckerberg is Now World’s Richest

Zuckerberg is Now World’s Richest and Top 5 Richest People in the World

“Mark Zuckerberg is already a rich man. The most recent tally of the world’s wealthiest people by Forbes magazine put the Facebook founder’s net worth at $13.5 billion in 2011, ranking him 52nd in the world. Now Mr. Zuckerberg is set to become considerably richer. His 28.4 percent stake in Facebook could see his fortune rise to as much as $28.4 billion, assuming that Facebook’s recently announced share offering is valued at $199 billion. That would place him ninth in the last year’s rankings. But what may be cost remarkable is Zuckerberg’s youth. At 27, he is the youngest of the plutocrats by a considerable margin. In the top 100, only Larry page and Sergey Brin, the co-founders of Google, are also under 40. Indeed, adjusted for years of age, Mr. Zuckerberg will be the richest man in the world,” as stated by ‘The Economist Online’.

The top 5 people who made their name in this list are as follows:

1. Mark Zuckerberg: Mark Elliot Zuckerberg is an American Computer Programmer and Internet Entrepreneur who has co-created the social networking site, Facebook. He co-founded Facebook in 2004 along with his Harvard classmates Dustin Moskovitz, Eduardo Saverin, and Chris Hughes. He is also the Chief Executive of the same. After the success of Facebook, he dropped out from Harvard University.
He is tagged as the ‘Person of the Year’ by Time’s Magazine in 2010. Forbes has listed him as the ninth powerful people in the world, and ranked him as 52nd Forbes Billionaires. His personal wealth is $17.5 billion as estimated in 2011. With this wealth in the age of 27, he is the world’s youngest billionaires.

2. Carlos Slim: Slim is a Mexican businessman and philanthropist, who is the Chairman and CEO of Telmex and American Movil. He studied Engineering from National Autonomous University of Mexico, where he was simultaneously teaching Algebra and Linear Programming. He learnt the basic business strategies from his father. At the age of 12 he bought shares in a Mexican bank. He started his business through real estate, construction and mining business. He has been the Vice President of the Mexican Stock Exchange and President of the Mexican Association of Brokerage Houses.

3. Bill Gates: William Henry Bill Gates is an American Business tycoon. He is the former CEO of Microsoft and presently is the Non Executive Chairman of the same company. He founded the Microsoft Software Company with Paul Allen. He has a consistent ranking among the world’s wealthiest people. He was the wealthiest in the world overall from 1995 to 2009. Gates is the best-known entrepreneurs of the personal computer revolution though he has been criticized for his business procedures, which have been considered as anti-competitive.

4. Bernard Arnault: Bernard Arnault is a French Businessman, who is the world’s 4th and Europe’s richest person with a net wealth of $41 billion. Forbes has also tagged him as ‘the Fashion Person of 2011’. He did his high school from the Maxence Van Der Meersch High School in Roubaix and graduated in Engineering from Ecole Polutechnique. He joined his father’s company after graduating. He modified his father’s business by convincing him to liquidate the construction division of the company by 40 million French Francs. He changed the company’s focus to real estate. BERBARD Arnault was awarded by the French Legion of Honour.

5. Warren Buffett: The American business tycoon, investor and philanthropist, Warren Edward Buffet is widely regarded as one of the most successful investors in the world. He is often named as “legendry investor, Warren Buffet”. He is primarily a shareholder but also a Chairman and CEO of Berkshire Hathaway. He made his name in the list of World’s wealthiest people consistently. In 2011, he was named as the third wealthiest person in the world.

Categories
My Best Friends Wishes for All

A Prayer for all in this New Year 2012

MAY THE NEW YEAR bring an end to the heart-rending scenes of the people wailing over their loved ones, who fall prey to the bullets of the power-hungry devilish forces.

MAY THE NEW YEAR stop the production of those lethal bullets and shells which pierce the bodies of the innocent and helpless people, and bring rattling down the magnificent structures.

MAY THE NEW YEAR infuse the boundless love for humanity in the hearts of those, who under the wrong belief of righteousness, enjoy tearing apart their own selves and other fellow beings in every part of the world.

MAY THE NEW YEAR once again revive the man’s unshakable faith in the humanity, and see his deep-rooted malice, hatred, rancor and intolerance being replaced by an overflowing benevolence, empathy, love and tolerance.

MAY THE NEW YEAR be blessed with the dawn of an era wherein ‘humanitarianism’ might emerge as the supreme religion of the mankind.

Categories
Entertainment Hindi Music Lyrics Hindi Songs Songs Things i like

Jaana suno hum tum pe marte hain – Khamoshi Song Lyrics

Jaana suno hum tum pe marte hain
Tumse mohabbat karte hain
Chaahat meri haseen koi gunaah hai nahin
Ye jo mohabbat hai
Yehi to ibaadat hai
To phir aao pyaar mein jalayein dil
Jalke bujh na paayein dil
Hai apni manzil yahin pe
Aa ab kahin na ja
Tum kahin bhi jaao yahin pe hai aana
Ki dil ka dil hai thikaana

Jaana suno hum tum pe marte hain
Tumse mohabbat karte hain

Aao kuchh asie milein hum tumse
Ki aaj khuda bhi hasn pade humpe
Milein hum milein hum
Tumse tumse
Ki Khuda khuda
Bhi hans de hans de
To phir aao pyaar mein jalayein dil
Jalke bujh na paayein dil
Hai apni manzil yahin pe
Aa ab kahin na ja
Tum kahin bhi jaao yahin pe hai aana
Ki dil ka dil hai thikaana

Jaana suno hum tum pe marte hain
Tumse mohabbat karte hain

Ek duje mein hum yoon kho jayein
Main hoon ki tum khud dhoondh na payein
Do badan do badan
Yoon mile yoon mile
Ki pata ki pata
Na chale na chale
To phir aao pyaar mein jalayein dil
Jalke bujh na paayein dil
Jalke bujh na paayein dil
Pyaar mein jalayein dil
Jalke bujh na paayein dil

Jaana suno hum tum pe marte hain
Tumse mohabbat karte hain