Press "Enter" to skip to content

Posts published in “Uncategorized”

How to update wordpress database after switching domain

WPExpert 0

Please keep backup before doing any update in database.

So this is very import to know, how to update database after moving wordpress website from one domain to another. For example

Suppose that in you are working on local server and after completion of project, you have uploaded all files on your live server along with local server database. Then here you need to run some query to update old url with new url.

Old url = http://www.oldsiteurl.com

New ulr = http://www.newsiteurl.com

Now here is some query to update old url with new url

Change Siteurl & Homeurl

If you transfer your WordPress site from the localhost to your server, your site will not load online, because the absolute path URL is still pointing to your localhost server. You will need to change the site URL and the home URL.

UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldsiteurl.com', 'http://www.newsiteurl.com') WHERE option_name = 'home' OR option_name = 'siteurl';

Change GUID

After you have migrated your website from the localhost to your server or from old domain to a new domain, then you will need to fix the URLs for the GUID field in wp_posts table. This is crucial because GUID is used to translate your post or page slug to the correct article absolute path if it is entered wrongly.

UPDATE wp_posts SET guid = REPLACE (guid, 'http://www.oldsiteurl.com', 'http://www.newsiteurl.com');

Change URL in Content

WordPress uses absolute path in the URL link instead of a relative path in the URL link when saving them into the database. Therefore you will need to change all old URLs to the new domain url.

UPDATE wp_posts SET post_content = REPLACE (post_content, 'http://www.oldsiteurl.com', 'http://www.newsiteurl.com');

Change Image Path Only

If you decide to use Amazon CloudFront as your Content Delivery Network (CDN) to offload the delivery of images from your server. After your have created your CNAME record, you can use the query below to change all the image paths in WordPress to load all your images from Amazon CloudFront.

wp_posts SET post_content = REPLACE (post_content, 'src="http://www.oldsiteurl.com', 'src="http://yourcdn.newsiteurl.com');

You will also need to update the GUID for Image Attachment with the following query:

UPDATE wp_posts SET guid = REPLACE (guid, 'http://www.oldsiteurl.com', 'http://yourcdn.newsiteurl.com') WHERE post_type = 'attachment';

Update Post Meta

Okay so here is updating post meta works almost the same way as updating the URL in post content. If you have stored extra URL data for each post, then you can use the follow query to change all of them.

UPDATE wp_postmeta SET meta_value = REPLACE (meta_value, 'http://www.oldsiteurl.com','http://www.newsiteurl.com');

 

Why wordpress for your website or blog ?

WPExpert 2

Wordpress is a popular CMS and blogging system. Its based on PHP and MySQL. Wordpress is most trusted CMS (Content Management System). This is very easy to understand how its dashboard works and how user create attractive blog. Every individual who wants to design a new and innovative website, WordPress web development is an ideal choice. If you want to build a website that helps your business, it is a good idea to hire WordPress developers.

Hiring a WordPress developer is a profitable option to get your website developed at affordable rates because they use unique CMS tools and employ interactive WordPress theme development methodologies. With the help of professional developers, you can add a high level of functionality, usability, and interactivity to your developed WordPress Website.

With an attractive design and using custom themes, WordPress enables you to change graphics, widgets, logos, banners, fonts, and a lot more.

Advantage of Wordpress CMS

Reduced Development Cost

You don’t need to hire web developer for even small modifications. With this CMS you don’t have to pay your web developer or designer for changing a few web pages and text. You can do yourself. This is great way to save money.

Managing time is easy:

You can schedule some posts to publish on your site for whatever day and time you want. This will save your time also

Easy to Use

This is very easy to use. You can make any modifications or add/edit/delete any content to your site from anywhere.

Social media friendly

WordPress is social media friendly platform in which you can automatically integrate your websites with social media like Google+, Twitter, LinkedIn and more.

SEO friendly URL

Wordpress generate SEO friendly URL. They also have some others feature like adding plugins which help you to promote your blog.

Easy to Understand

Wordpress dashboard is very easy to understand. You don’t need to hire trainer for dashboard.

 

Interested to Start a Website With Wordpress 

How to enable bootstrap tooltip for dynamic added elements

WPExpert 0

Some time we face a problem to show tooltip for dynamic added element using jquery. Tooltip not works as normal work for others element. To remove that type of issue we need to add following code to fix that issue.

Jquery :
$('body').tooltip({

    selector: '.removeRowId'

});
HTML
<div class="input-group-btn removeRowId" data-toggle="tooltip" data-placement="left" title="Remove row" data-trigger="hover">

<button class="btn btn-danger form-control" type="button" onclick="remove_education_fields('+ room +');"> 

<span class="glyphicon glyphicon-minus" aria-hidden="true"></span> 

</button>

</div>