How To Delete Spam Comments?

You all must know by comment spam is not it? one problem is quite annoying for the blog owner is the comment spam that comes every day, to the owner of wordpress-based blog comment spam can be minimized by installing the Akismet plugin but still could not prevent comment spam to stop by to our blog.

Sometimes maybe so busy these spam comments deleted and eventually forget to continue to accumulate up to hundreds or even thousands of spam comments which eventually meet in the database space hosting overwhelmed us and make our own to delete them manually. What if there are 9000 comment spam? How much time do we need to remove them manually?

But do not be afraid because you can delete all comment spam is really quick and easy, here's how:

1. login to cpanel / hosting you and go into phpMyAdmin

2. Then click the SQL

3. Paste the following code in the box SQL:

DELETE from wp_comments WHERE comment_approved = '0 ';

Technical Explanation: In the table there are fields named wp_comments comment_approved, which has two values ie 1 and 0, where 1 is for comments that have been approved, while 0 is not yet approve.


So before deleting comment spam in this way, make sure first that you already had approved the comment is not spam. Because not all the comments that have not approve it is spam.

Note: This tip is for friends who use wordpress with hosting his own and with a database of "restricted". Do not do these tips if you do not understand

Read More …

000webhost, one of the free hosting with a good quality

Free Hosting discusses seems to have no end, whose name is free there must be a weakness and also its advantages.
Definite advantages in terms of the Free, even the Space can be larger than the paid versions.
But until now I have yet to find a quality hosting paid hosting as well, for instance from the control panel. most use the vista panel hosting or custom panels, while the majority of paid hosting nowadays is using Cpanel.
already more than four years I have hunted this free hosting from a search engine, but only one hosting that seems pretty good, namely 000webhost.com.

Although for the time we abolished auto-installer can still make it manually, such as Wordpress, osCommerce and others,
but for the size of free hosting with 1500 mb space and 10 GB monthly bandwidth is more than enough for normal usage.
one of the other advantages of this are hosting their own servers so that they have no dependence on other companies, as with several other hosting companies who do not have their own server.
in addition to a feature version of the free version as well as domain addon domain where we can add us as they pleased, 5 webmail account, as well as five subdomains.

while the hosting control panel uses a custom panel for the free version and a paid version for the latest cpanel.
Hosting standard features such as MySQL, PHP, and other standard features also exist here
If you feel that not enough with all that you can also upgrade to a premium account with unlimited space and bandwidth.
Another disadvantage is if your website visitors is less than 10 visitors per month then the account will be deleted or disabled temporarily.
For server uptime level I think is good enough for hosting the size compared to other free hosting.
But on the other hand I've read in some blogs that wrote that is a SCAM Affiliate 000webhost, ie they will never pay you, so take advantage of hosting free version only, while its Affiliates do not need you to follow.
This hosting is perfect for beginners or small business or can also be used for hosting your helpers from the main hosting.
For more details, please visit his website www.000webhost.com. good luck

Read More …

How to choose a good free web hosting ?

In this world are so many companies are moving the field of web hosting services and many of them are good for is selected as the web host your web site. But how can I choose the best among all of us who have? Here I try to explain to you a little about how to choose a good web host.
In fact there are 2 options before you decide to use the web hosting free web hosting and a commercial web host .

If you choose the free, should consider the following things:

1. Advertising (Advertising), Most free web hosts that contain ads that are not relevant to your website. There is a display Banner on your site or to the way we display a new window that pop up on every new page on your website. And many more things the way they promote on your site.
So any way for them to campaign on your site, you should select the free web host that is not possible the main view of your site.
2. Capacity, capacity that is provided for your website is very important to do. if at any time you want to enlarge the capacity of your website, you should check whether the web host provide this extra capacity to your website.
3. FTP Access, FTP Access fact is a matter that absolutely must be owned by web hosts, but there are some free hosting providers that only allow you to design web pages using your online buildernya. should you choose free web host that provides FTP access in order to facilitate your performance.



4. Limits the type of file, you should see what type of file that can be uploaded and if there are limitations in the size of each file in the upload. because there are some free web host that limits the size of the file which you upload.
5. Reliability and speed access, this is very important to note. A web site that has a low-speed access will be increasingly left behind by visitors. if you choose free web host, look who has the better speed access. to test a host that has access to a good speed, you try to call your web site for some time, when the busy day hours. if its slow loading or not.
6. Access CGI-BIN / PHP, CGI-access facilities bin used in the web hosting facilities to support the facility on your website such as web counters, search engines, forms, polls, mailing lists and so forth. You should also examine whether the web host’s support script like PHP or not. If YES then free web host is eligible to choose from.
7. Amount of Bandwidth, have some free web host that implements a limitation of the amount of trffic web site you used per day or by month. This means that if your web page by the user during the visit several times per day or per month that exceed their limits, then the web host will disable your web site or be charged for it. should select the restrictions that provide the most good traffic.

So, hopefully from the above explanation will help you to decide your choice in the case of using free web hosting.

Read More …