Tips and Tricks

[How-To Guide] Optimize WordPress Database Using PHPMyAdmin

Already I had provided you a step-by-step guide on repairing and optimizing your WordPress driven website without using any plugin. This article focus on optimizing WordPress Database by using PHPMyAdmin.

PHPMyAdmin, free software tool written in PHP and made to handle administration MYSQL over world-wide web.

Step1: Login to your WordPress Database using PHPMyAdmin

Step2: Select the right database, if there is only one database then it would be chosen by default.

Step3: Now click on “check tables having overhead” option and select the proper table as shown below:

Step4: From drop down menu (as indicated above in screen-shot), select the menu item which says “Optimize table”. This will optimize the tables which is shown below:

PHPMyAdmin is the easiest way to optimize the overheads of your database without adding plugin load to your WordPress site.

Note: Before applying this tutorial back-up your database and never click on options like Drop, Empty because they will ruin your database and creates a problem so be careful.

Finally in the end do let us know in the comments section, if you faced any problem?

[How-To Guide] Repair And Optimize WordPress Database

As a webmaster, it’s a nice thing to optimize blog’s database because optimizing a database improve the loading time of blog which indirectly improve’s the performance of database. Already many of them using WordPress plugins to optimize database but in this article I offer you a step-by-step guide to optimize database without using a WordPress plugin because already WordPress built-in Repair and Optimize functionality is available at the admin back-end.

Well you can check out this functionality by visiting

http://www.educationguide4u.com/wp-admin/maint/repair.php

(replace http://www.educationguide4u.com/ with your real blog/site url).

Step1: Login to your wp-admin section by visiting http://www.educationguide4u.com/wp-login.php

Step2: Now simply type http://www.educationguide4u.com/wp-admin/maint/repair.php in a new tab of your browser. After typing this URL and hitting enter button, it ask you to add a piece of code to WordPress wp-config.php file as shown below:

Step3: Add this code to WordPress wp-config.php file

define(‘WP_ALLOW_REPAIR’,true);

Step4: After adding this code just simply reload/refresh page and it will look like this:

Step5: Now you can see a page with two options (screen-shot of step4) first one is “Repair Database” and second one is “Repair and Optimize Database”. Click on any of the option.

Step5.1: If you click on “Repair Database” option, WordPress will automatically look for some common database problems and repair them automatically by executing SQL queries in WordPress database tables.

Step5.2: If you click on “Repair and Optimize Database” option, WordPress also attempt to optimize the database. this improves the performance in some situations.

Caution:

Repairing and Optimizing database option can take long time and database can be locked while optimizing.

Hope this will improve your WordPress blog’s performance and let us know in the comments section if you face any problems while optimizing and repairing your WordPress Database.

Note:

Please backup your WordPress Database before making any action on database.

[How-to Guide] Authors Profile Box At The End of The Post In Thesis Theme

As a thesis user I know the importance of having author’s profile box at the end of the post and it becomes much more of importance when you have guest posting on your blog or you have multi author blog. The author’s profile box will help the visitors in recognizing the author of the post. The author’s profile box will take the details from the admin panel of the user profile. So, I have come out with a tutorial that will help you out in adding the author’s profile box at the end of the post.

In this tutorial you will learn how you can add author’s profile box at the end of the post like this as shown in the screenshot:

Just follow these certain steps and you will be able to add author profile box at the end of post.

Log-in to WordPress Admin Panel

2. Go to user panel and fill up your bio and whatever you like to display at the end of the post.

3. Now log-in into cpanel and use FTP, just simply copy this code and paste this code in custom_function.php file.

function post_footer_author() {
if (is_single())
{ ?>
<div>
<?php echo get_avatar( get_the_author_id() , 100 ); ?>
<h4>Article by <a href=”<?php the_author_url(); ?>”>
<?php the_author_firstname(); ?> <?php the_author_lastname(); ?></a></h4>
<p><?php the_author_description(); ?></p>
<p><?php the_author_firstname(); ?> has written <span><?php the_author_posts(); ?></span> awesome articles.</p>
<p>If you like this post you can follow WebGuide4U on <a href=”http://www.twitter.com/webguide4u”>Twitter</a></p>
<p>Subscribe to WebGuide4U feed via <a href=”http://www.webguide4u.com/feed”><b>RSS</b></a> or <a href=”http://feedburner.google.com/fb/a/mailverify?uri=Webguide4u&loc=en_US”><b>EMAIL</b></a> to receive instant updates.</p>
</div>
<?php }
}
add_action(‘thesis_hook_after_post_box’, ‘post_footer_author’);

4. Now simply add this code in custom.css file like you have done for custom_function.php

.postauthor {background: #F5F5F5;
 border-top: 1px solid #e1e1e0;
 border-bottom: 1px solid #e1e1e0;
overflow: hidden; padding: 1.5em;
}
.postauthor img {border: 1px solid #e2dede;
float: left;
 margin-right: 1.5em;}
.postauthor h4 {color: #666;
font-size: 2em; margin-bottom: 5px;}
.postauthor p {color: #515151; font-size: 13px;
margin-bottom: 12px;}.postauthor p.hlight {font-size: 11px;
text-transform: uppercase;}.postauthor p.hlight span {color: #CB3131;
font-size: 1.5em; font-style: italic;
font-weight: bold; letter-spacing: 0.8px;}
.custom .postauthor p {
fontsize:15px;}
.custom .postauthor p.hlight{
fontsize:13px;
fontweight:bold }

By adding both the codes you can simply add the authors profile box at the end of the post. If you faced any difficulty in this then let me know through comments section.

[How-to Guide] Add New WordPress Themes In WordPress 3.0

Already in the previous tutorial I had provided you the step by step guide on installing the wordpress on Hostgator and now in this tutorial I will guide on installing WordPress theme. You might be amazed by listening this but wordpress 3.0 has come out with different layout now it’s not a single click installation of theme.

In earlier versions of WordPress, you can easily add new themes by login into your wp-admin panel. After login to your admin panel go to Appearance> Add New Themes like this shown in screenshot:

And after clicking on this you will easily add new themes in your wp-admin panel and will change it when you want to change the layout of your blog.

But in WordPress 3.0 you won’t add new themes like this. Why? When you log-in into your wp-admin panel you will not able to see the Add New Themes Option directly as you can see in the older versions of WordPress. Now the question arises, how you add new themes in your WordPress and how you will change the layout of your blog? Need not worry; this article will come as a rescue for you to help out in adding new themes in WordPress 3.0. As already, I had covered some of the tutorials and how-to guides on WordPress 3.0. Some of them are being listed below to help you out WordPress 3.0:

How-to Upgrade WordPress to WordPress 3.0

URL Shortener Feature Under Your Domain Name

Multi-Site Option in WordPress 3.0

Integrating WordPress MU in WordPress 3.0

Adding Multiple Blogs in WordPress 3.0

So without wasting any time, I will guide you how you can add New Themes in WordPress 3.0

Go to Appearance, click on Themes. After clicking on themes, on the top of page you will two navigation menus like this:

Now click on Install themes, you will see a page like as shown in screenshot:

Now you can easily add the new theme and change the layout of your blog.

This tutorial will help you out in adding new themes, even though if you feel any difficulty in adding new themes then let me through comments section or use our contact form.

In the meanwhile do let us know your thoughts on WordPress 3.0

[How-to Guide] Add Facebook Like Button to Your Blog

Facebook and Twitter are going head to head in their attempts for web domination. Now facebook has released their “Like” button. The Facebook like button extends their like feature to other sites on the web. If the users are logged into their facebook account, then they can “like” or “recommend” a web page to all of their facebook friends as they are reading it from the site. In this article i will show you that how you can add facebook like button without installing any WordPress plugin. All you need to do is to insert this simple code in your WordPress blog:

Code:

<iframe src=”http://www.facebook.com/plugins/like.php?href=<?php echo urlencode(get_permalink($post->ID)); ?>&layout=standard&show_faces=false&width=450&action=like&colorscheme=light” scrolling=”no” frameborder=”0″ allowTransparency=”true” style=”border:none; overflow:hidden; width:450px; height:60px;”></iframe>

There are other parameters and options for this plugin.

If you want to show the friend icons under the button, then you should use the parameter:

show_face=true

If you want to display the simple button with only the count and nothing else, then you want to use the parameter:

layout=button_count

If you want a darker color scheme for your button, then you need to use the parameter:

colorscheme=dark

If you want to change the text from Like to Recommend, then use the parameter:

action=recommend

You can customize the width of the iFrame as you like.

This tutorial will help you to put facebook like button without any help of plugin and will save you from installing a one more plugin in your WordPress blog. In the end, if you like this tutorial then you like WebGuide4U on Facebook.