How to integrate Google Places Search API in website?

Get the Google API Key

1. Login to https://console.developers.google.com
2. Get the API Keys.
3. Enable "Google Places API Web Service" from Google Google Map API

HTML Code

<script src="https://maps.googleapis.com/maps/api/js?v=3&amp;libraries=places&amp;key=HERE_YOUR_KEYS"></script>
<div class="search-Form">
<input id="search" name="q" type="text" value="" /> <input id="submit" type="submit" value="go" />
</div>

JavaScript Code

    var lat
    var lon
    function initialize() {
        var input = document.getElementById('search');
        var autocomplete = new google.maps.places.Autocomplete(input);

        google.maps.event.addListener(autocomplete, 'place_changed', function() {
            var place = autocomplete.getPlace();
            lat = place.geometry.location.lat()
            lon = place.geometry.location.lng()
        });

    }

    google.maps.event.addDomListener(window, 'load', initialize);

View Demo

Best Related Posts are Following:

1. How can I check whether Google Maps is fully loaded in GMaps v3.
2. Goole Map - Track your moving Position on google map- html5.
3. Google Maps - Modifying Controls.
4. Google Map Integration Add InfoWindow in Marker.
5. Google Map - Add a marker.
6. Google map integration.

What is Stored Procedure in MySQL?

Question: What is Stored Procedure?
A Stored procedure is program in a regular computing language, stored in database. It have has a name, a parameter list, and SQL statement(s).


Question: What is the purpose of stored procedure?
A stored procedure is used to retrieve data, modify data, and delete data in database table.


Question: What is Syntax for creating stored procedure?

DELIMITER $$
CREATE    
    PROCEDURE `dbName`.`storedProcedureName`()
    BEGIN

    END$$

Question: Create simple stored procedure?

CREATE
    /*[DEFINER = { user | CURRENT_USER }]*/
    PROCEDURE `dbname`.`helloArun`() 
    BEGIN
SELECT id,user_nickname,user_email FROM `cmf_users` WHERE user_email="hello@no-spam.ws";   
    END

Question: How to call stored procedure?

call helloArun();

Question: How to list stored procedure?

SHOW PROCEDURE STATUS;

Question: How to delete stored procedure?

DROP PROCEDURE storedProcedureName

Question: How to delete stored procedure If Exist?

DROP PROCEDURE IF EXISTS storedProcedureName

Question: Create simple stored procedure with argument?

CREATE    
    PROCEDURE `dbname`.`helloArun2`(
  IN email VARCHAR(255)    
    )
    BEGIN
 SELECT id,user_nickname,user_email FROM `cmf_users` WHERE user_email=email;      

    END

Question: How to call stored procedure with parameter?

call helloArun2('arunk@no-spam.ws');

Question: How to list of stored PROCEDURE?

SHOW PROCEDURE STATUS

Question: How to remove stored PROCEDURE?

DROP PROCEDURE storedProcedureName

Question: How to remove stored PROCEDURE if exist?

DROP PROCEDURE IF EXISTS storedProcedureName

Best Related Posts are Following:

1. How to get the sizes of the tables in mysql database?.
2. How to install and Connect to MySQL in NodeJS?.
3. What is Super Key, Candidate keys and Alternate Key?.
4. MySQL Query Optimization Tips and Techniques.
5. How can I make SQL Query case sensitive string comparison on MySQL?.
6. DBMS Interview Questions and Answers for Freshers.
7. MySQL Interview Questions and Answers for Experienced.