jQuery Location Autocomplete with Google Maps Places

This is a simple jQuery plugin that enables you to pick a place/address/location from a dropdown suggestion box and display the place on the Google Maps, based on Google Maps API's places library.

HTML+Javascript Code

  
    

    

    

    
    
    
    

    

    

    

    

  

  

    

      

        

jquery-placepicker

A simple placepicker component for the google-maps api.
        



    


      

Basic usage

        

          

            
          



Set value by location coordinates

        

          

            
          



Use hidden inputs for submitting location coordinates

         

           

             


               

               
               

             

           



Integrating a map view

         

           

             

               
             

               




           



Advanced usage

Custom map CSS class and JavaScript callback

         

           

             

               
             

               




           

If you want this plugin. Download from here.
Download


OR

Another Google map Api code is there. you can use it also.

HTML+Javascript Code

  
    
    
    
    
    

    
  
  
    
    

      
      All

    

What is difference between MYISAM and InnoDB?

I am writing this article to understand the difference between MYISAM and INNODB.

MYISAM:
1. MYISAM supports Table-level Locking
2. MyISAM designed for need of speed
3. MyISAM does not support foreign keys hence we call MySQL with MYISAM is DBMS
4. MyISAM stores its tables, data and indexes in diskspace using separate three different files. (tablename.FRM, tablename.MYD, tablename.MYI)
5. MYISAM not supports transaction. You cannot commit and rollback with MYISAM. Once you issue a command it’s done.

INNODB:
1. InnoDB supports Row-level Locking
2. InnoDB designed for maximum performance when processing high volume of data
3. InnoDB support foreign keys hence we call MySQL with InnoDB is RDBMS
4. InnoDB stores its tables and indexes in a tablespace
5. InnoDB supports transaction. You can commit and rollback with InnoDB