Speed up your site with MaxCDN

MaxCDN Color Transparent 480x1151 Speed up your site with MaxCDN

Google has already announced that web site speed is one of the ranking factors in their ranking algorithm. Therefore all webmasters are trying to improve their web site loading speed as much as possible.

Using a CDN(Content Delivery Network) is one method that you can use to reduce your website loading time. Simply what a CDN does is serving your static files such as images, css files, javascript files etc from a closer place to the visitor. This ensures your static files are served to the visitor as soon as possible.

There are lot of CDN providers on the market now. If you are searching for a reliable CDN for a cheap price then I recommend you MaxCDN (this is not an affiliate link). MaxCDN is a powered by NetDNA which is one of the leading CDN provider. MaxCDN has servers located in many countries.

This video from MaxCDN will give you more information about how CDN works and how MaxCDN helps to Speed up your website.

Setting up a cron job in cpanel

Cron jobs help to run a script on a given interval. You can set a cron job to visit a web page on a given time.  This article explains how to create a cron job easily in cpanel.

First log in to cpanel and click the cron jobs button. In most cpanels this is in the Advanced section at the bottom.

cpanel Setting up a cron job in cpanel

Then you will get the screen where you can set a cron job.

cron job Setting up a cron job in cpanel

In this screen first select the interval you want to run the script. Most of the time your required interval will be on the list of common settings.

Then in the command box enter following code.

wget -q -O - http://www.example.com/ >/dev/null 2>&1

Make sure to replace your url with example.com.  Here the code >/dev/null 2>&1 make sure no email is sent to admin email once a cron job is done successfully. Remove that part from the command if you like to receive email. But be aware that this can end up with filling your inbox with hundreds of emails from cron job.

This method can be used to set up cron jobs for wordpress too. It will be helpful for wordpress plugins which requires a better cron schedule.

How to send email from XAMPP

Default configuration of XAMPP do not allow to send emails through localhost. Here is the configuration for XAMPP to send email using a gmail account.

First you need to upgrade sendmail to the latest version.

  1. go to http://glob.com.au/sendmail/ and download sendmail.zip
  2. backup files in xampp/sendmail/ directory.
  3. delete all files in xampp/sendmail/ directory.
  4. copy the downloaded zip file to xampp/sendmail/ directory and extract the file

Then open the php.ini file (xampp/php/php.ini) and search for [mail function]

Modify the following parameters accordingly.

sendmail_path = "\"C:\xampp\sendmail\sendmail.exe\" -t"
mail.add_x_header = Off

Note: Modify sendmail_path parameter to your sendmail directory if you have installed xampp on an another directory.

Open the sendmail.ini (xampp/sendmail/sendmail.ini) and set following parameters accordingly. Comment all other settings.

smtp_server=smtp.gmail.com
smtp_port=25
error_logfile=error.log
debug_logfile=debug.log
auth_username=****@gmail.com
auth_password=****
force_sender=****@gmail.com

Replace auth_username, auth_password, force_sender parameters with your gmail account details.

Once you have done the modifications you can test the settings using a test php email such as following;

<?php
$subject=”Hi There!!”;
$to=”<receiver_mail_address>”;
$body=”This is a demo email sent using PHP on XAMPP″;
if (mail($to,$subject,$body)){
 echo “Mail sent successfully!”;
}
else{
 echo “Mail not sent!”;
}
?>

Track google adsense check without DHL Tracking Number

2679008523 715ce55bdb Track google adsense check without DHL Tracking Number

Google Adsense is one of the most popular advertising networks on the web. Most of the websites on the web use adsense as their advertisement provider. Secured Express Delivery is one of the payment methods of adsense.

If you use DHL as your Secured Express Delivery provider you can track the check in all it’s way. Normally adsense payment is done on the last week of the month. Even you see as your payment is done google ship your check after about 2-5 days from the payment date.

Once your check is shipped you can track it using the DHL Tracking Number. It takes few days to appear your tracking number in adsense. But you don’t have to wait until that! Here how you can track your check without DHL Tracking Number.

  1. Go to adsense payment details page and copy the Payment Number
  2. Go to http://www.dhl.com/en/express/tracking/shippers_reference.html
  3. Paste the Payment Number in Shipper´s Reference box
  4. Select the payment date as from date.
  5. Select today’s date as to date
  6. Leave the Account Number box empty
  7. Select your country
  8. click track

If this didn’t work try removing the leading zero from the Payment Number.

That’s it! You can find the DHL Tracking Number also from there.

Anyway please keep in mind that this will work only after 2-5 days from the payment date.

Image courtesy: liewcf

Delete wordpress post revisions to reduce the db size

When you edit wordpress posts it automatically creates revision of the post. This is useful if you wanted to rollback to a previous version of the post.

But a problem with this is it creates a record in database each time. This means it increases your database size. This won’t be a much issue for a small site with few posts. But when you have more posts & if you edit posts very often it will affect a lot for your site in the long run. Sometimes this will increase your site loading time & make the site to perform slowly.

Best thing is to delete the revisions often. You can do this by running a simple mysql query. This is the query for it,

DELETE a,b,c
FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_type = 'revision'

This will delete all the revisions as well as the post meta & term relationship records related to them.

If you wish to turn off creating revisions add following code to wp-config.php

define('WP_POST_REVISIONS', false );

Instead turn off revisions if you wish to limit the number of revision created per post, add following code to wp-config.php

define('WP_POST_REVISIONS', 3);

You can modify the number 3 to any number you like. WordPress will keep only that amount of revisions per a post.

If you are not familiar with sql & php there are many plugins that you can use to manage revisions. Here is a better one.

Delete Post Revisions by Donal MacArthur

Feedwordpress – Displaying attached images

rss Feedwordpress   Displaying attached images

Feedwordrpress is a wordpress plugin that syndicates content from RSS feeds to your blog. This is one of the best wordpress plugin if you wish to create an auto blog.

Normally Feedwordpress syndicates images within feeds. But some feeds provide images as attachments of the feed. These images are not shown in the posts created with syndicated posts. But the details of the attachment is saved as a custom field of the post.

Here is a code to display the images attached to the feed. Place this code within The Loop where you want image to be displayed.

<?php $enclosure =  get_post_meta($post->ID , 'enclosure', $single = true); ?>
<?php $image=explode(chr(10),$enclosure); ?>
<?php if(!is_null($image)) : ?>
<img src="<?php echo $image[0]; ?>" alt="<?php the_title_attribute(); ?>" />
<?php endif; ?>

This will display the attached image. You can further customize the display of the image by applying css styles to the image.

note: I have updated the code. If you have used the previous code try using the new code above.

Work from Home – vWorker

xino Work from Home   vWorker

Do you have any Data Entry, Graphic Design, Web development, Software developing or any other computer & Internet skills? If your answer is YES there is a way you can get a good income from your talents.

www.vworker.com(earlier know as rentacoder.com) is a website providing a place for work at home. Buyers all around the world post thousands of new projects in this website daily. You just have to find projects you can do & bid on them. If you win the bid you can finish the project within the project time period & get your payment.

vWorker is a safe place for both buyers & workers. Buyer must transfer cost of the project to vWorker before worker starts the project. When project is successfully completed funds are transferred to the worker. vWorker acts as a third party between the buyer & the worker. So both worker & the buyer is secured.

If you are a talented person you can get a good income . If you are already employed you can make an extra income through vWorker. So just give a try.

Click here for the list of latest projects

Logo vWorker 150x50 Work from Home   vWorker

Oracle 10g XE – Creating scott schema & default tables

ORACLE10G Oracle 10g XE   Creating scott schema & default tables

There is no Oracle default scott schema or default tables like emp,dept,bonus,salgarde in Oracle 10g XE. Here is a easy step by step by guide to create it.

1) Download & install Oracle 10g XE.

2) Go to Start > All Programs > Oracle Database 10g Express Edition > Go To Database Home Page

3) Log in using username: system & your password you entered in installation process

4) Go to Administration > Manage Database Users > Create

5) username: scott Direct Grant System Privileges: CREATE TABLE (You can modify these settings later)

6) Go to Start > All Programs > Oracle Database 10g Express Edition > Run SQL Command Line

7) type connect

8) username: scott password: password you entered in step 5

9) Download this file oracle default tables (1118) (this contents data for the tables)

10) extract the downloaded file

11) type this command in sql command prompt

@(yourfilepathhere)/oracle.sql;

replace yourfilepathhere with the path of the sql file you just extracted. here is an example

@c://downloads/compressed/oracle/oracle.sql;

12) You are done!!! Now you can work with scott schema & all oracle default tables

Free Web Hosting without ads

banner6 Free Web Hosting without ads

There are many Free Web Hosting providers in the web. Among them I found that www.000webhost.com is a website providing a better service. It has many features such as,

  • 1500 MB of Disk Space
  • 100 GB Bandwidth
  • Free Subdomain or Your own domain hosting
  • cPanel Control panel
  • Website Builder
  • Over 500 website templates ready for download
  • Automated Scripts Installer (20 Popular Scripts)
  • Free POP3 Email Box and Webmail access
  • FTP and Web based File Manager
  • PHP, MySQL, Perl, CGI, Ruby.
  • No Ads at all !

This is a great chance for people who are new to web design. If you have designed a website & searching for a cheap place to host your site this will be the ideal place for you. Web hosting is  absolutely FREE. Else you can have a subdomain for FREE. There will be NO ADS at all the time.

www.000webhost.com provides you the cPanel acces. So you can experience  all the advanced controls such as MySql, FTP,  PHP, Perl, CGI, Fantastico & many more.

If you already have a website you can transfer it to www.000webhost.com & make your hosting charges to $0.00. But one drawback is sometimes www.000webhost.com officials check your  site. during that site will show as under maintenance. But this happens very rarely. So you don’t have to care about it much.

Give a try on Free Web Hosting. Signup here