SQL Code For Changing WordPress URL

Code to use for replacing urls in wordpress database:

UPDATE wp_posts SET guid = replace(guid, 'http://olddomain.com','http://newdomain.com');
UPDATE wp_posts SET post_content = replace(post_content, 'http://olddomain.com', 'http://newdomain.com');
UPDATE wp_links SET link_url = replace(link_url, 'http://olddomain.com', 'http://newdomain.com');
UPDATE wp_links SET link_image = replace(link_image, 'http://olddomain.com', 'http://newdomain.com');
UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://olddomain.com', 'http://newdomain.com');
UPDATE wp_usermeta SET meta_value = replace(meta_value, 'http://olddomain.com', 'http://newdomain.com');
/*UPDATE wp_options SET option_value = replace(option_value, 'http://olddomain.com', 'http://newdomain.com') WHERE option_name = 'home' OR option_name = 'siteurl' OR option_name = 'widget_text' OR option_name = 'dashboard_widget_options';*/
UPDATE wp_options SET option_value = replace(option_value, 'http://olddomain.com', 'http://newdomain.com');

Add a Driving Directions Form to a Website

This code adds a small field to enter an address, plus a “Get Directions” button. The results are shown as Google Maps directions.

Be sure to edit your destination address in the code.

<form action="http://maps.google.com/maps" method="get" target="_blank">
   <label for="saddr">Enter your location</label>
   <input type="text" name="saddr" />
   <input type="hidden" name="daddr" value="101 Main St, Tampa, FL 33615" />
   <input type="submit" value="Get directions" />

Remove Location Bubble from Embedded Google Maps

When embedding a Google Map into a website, you get that annoying location bubble. Sometimes you want it there. Sometimes you don’t. To get rid of it, add the following to the end of the src url.

Just after: