google maps from address with jquery

One of my client need this feature of google maps from address so he must be able to enter the address in its admin panel and he want to show it as google map on front end.So i made this option for him and new post for my blog.you can use this code with any language like php c# java etc or any framework.googlemap by address

Google maps from address with jquery and map api

The idea behind google map from address is simple.It is based on reverse geocoding google map.I am using google map v3 api.

Lets get right to the topic

we will use google map api
https://maps.googleapis.com/maps/api/js?sensor=false
and jquery
https://ajax.googleapis.com/ajax/libs/jquery/1.8.1/jquery.min.js

To get map from google you need location’s longitude latitude
you can get location geocode from google map Geocoder function.

How google maps from address works

google map latitude longitude

Stage 1 : Your Address goes to geocoder.
address includes address, city/town , State, postalcode and country.
Function : google.maps.Geocoder();

Stage 2 : Geocoder fetch your address’s latitude and longitude.

Stage 3: These latitude and longitude value passed to the google map function.
Function : google.maps.Map();

Stage 4: The google map then represent these latitude and longitude value in map.
you can design your info window of address here by
Function : google.maps.InfoWindow()

Also you can set the title of your location by marker function.
Function : google.maps.Marker()

Feature of google maps from address widget

  • You can select from all the four view of google map.
    ROADMAP displays the normal, default 2D tiles of Google Maps.
    SATELLITE displays photographic tiles.
    HYBRID displays a mix of photographic tiles and a tile layer for prominent features.
    TERRAIN displays physical relief tiles for displaying elevation and water features.
  • You can set the zoom level of the map.
  • You can get longitude latitude from google maps address(can find geocode).
  • Find location by latitude longitude google map.

Download section

Live DemoDownload Source

Reset drupal 7 admin password

One of my developer left the drupal project in middle, he didn’t told me the drupal admin password.After long search i get the code to reset drupal 7 admin password.This trick will works if you have access to ftp and database of your server.

well in previous version of drupal you can easy reset the password using md5 hash but in drupal 7 it use salted sha512 hash, so to get salted sha512 hash of your password you need to follow some steps

Steps To Reset Drupal 7 admin password

  1. Create a reset.php with your text editor or developer ide.Place the content write below in it.
    <?php define('DRUPAL_ROOT', getcwd());
     require_once DRUPAL_ROOT . '/includes/bootstrap.inc';
     drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);
     require_once 'includes/password.inc';
     echo user_hash_password('my_new_password');
    die();
    menu_execute_active_handler(); ?>

    Replace the “my_new_password” with the password you want to set.

  2. Upload this file in root of your drupal project.
  3. Access this file from browser.You will get the hash of your password.
    Copy the password hash.
  4. Open phpmyadmin. Goto your drupal database.

    if you don’t know what database your drupal is using then open configuration file at sites/default /settings.php
    and find database name in $databases variable.

    After that either execute the following query[sql]UPDATE users SET pass = md5(‘password hash’) WHERE uid = 1;[/sql]or proceed further.

  5. Click on the users table.
    edit the admin row.

  6. Paste the password hash in pass field.

Now Login With Your New Password

4 ways to import large file in phpmyadmin

In phpmyadmin either by wamp , lamp , mamp or cpanel is always a time consuming and tedious, in this post i will share 4 ways to import large file in phpmyadmin or in mysql
you may get the following errors while uploading large file in phpmyadmin

Fatal error: Maximum execution time of 30 seconds exceeded

Fatal error: Allowed memory size of —– bytes exhausted

let us resolve this issue and duscuss the ways to import large files in mysql with cpanel, wamp and lamp.

4 ways to import large file in phpmyadmin with

  1. By editing php.ini
  2. Using php script BigDump
  3. Use of Command Line SSH to upload sql
  4. Using split and compress Method

1. Use of php.ini to large database import

This method will work on wamp, xamp , manp and lamp

  • find your php.ini file
  • goto the line upload_max_filesize
  • set its value to 500M (for 500 mb)
  • Now got the line post_max_size
  • Set its value to 500M
  • Now goto the line max_execution_time
  • Set its value to 300 or 500

to import large sql in cpanel , if your server allow to edit the php.ini you can do the above method

2. Using BigDump php script

In this method you have to upload the dump sql file in server via ftp (like filezila).

  • Create a directory db_upload in your webserver
  • Upload you large dump via filezilla
  • Upload bigdump.php  via filezilla to the db_upload  directory
  • Run the bigdump.php from your browser via URL like http://www.mydomain.com/db_upload/bigdump.php
  • Wait for the script execution, do not close the browser .
  • If Timeout errors occur, adjust the $linepersession setting in this file.

More info and Download Available at here

3. Using Command Line to import database in cpanel

you can use putty for remote ssh access, after login type the following command to import the files directly into the mysql

mysql -u {DB-USER-NAME} -h {MySQL-SERVER-HOST-NAME} -p {DB-NAME} < {db.file.sql path}

remember in this case your file should be inside the server, you can upload it via filezilla

 

4. Using SQL Dump Splitter

If your max upload size is larger then your sql dump then how to Import large file in phpmyadmin ?
The answer is easy “spilt the dump file”

But in this large file how can you split and from where to split.

Well solution of problem is simple  Dump Splitter , this tool that split your sql dump files into sub files.

All you need to do is to import the file to this application, process it and then follow the instruction created by this application .

import large file phpmyadmin

This application divides your files into no. Of chunks you want.

Also this application generate an instruction file that will tell you which file you need to import first.

i.e. the file with table structure must be imported first.

Suppose the size of your sql dump file is 80MB and your server allow you to upload only 20MB at a time then.

Steps to Use SQL Dump Splitter

  1. Run sql dump splitter .
  2. Browse and select your file .
  3. Set the max upload size in this case select 19MB.
  4. Select your destination directory and execute.

After that file generate the 6 files in your destination directory 5 with max upload size i.e. 19MB.

And one help file this Readme file,
Read me file tell you out of these 5 files which one must be uploaded first.
(which one is table structure file.)

Extra tip : You can set size of chunk 40 mb and then compress the output files with zip archive

So this is simple trick to Import large file in phpmyadmin if your max upload size less then file.

Download

Tooltip For Dropdown

What Is Tool Tip

The tooltip or infotip or a hint is a common graphical user interface element. It is used in conjunction with a cursor, usually a pointer. The user hovers the pointer over an item, without clicking it, and a tooltip may appear—a small “hover box” with information about the item being hovered over. Tooltips don’t appear on mobile operating system, since there is no cursor.jQuery Tooltip For Dropdown display hit for each option you selected. Continue reading “Tooltip For Dropdown”