How to select the last 2 days on a timestamp field in PostgreSQL
For one of my projects I wanted to make sure users can request changes to their account (email, username, ..), which they would have to verify via email. In order to make sure these emails have a predefined lifetime, I would want to either clean up the change table or use a SQL query to select only recent change requests. I have chosen for the last solutions since it saves me some time in setting up cron jobs or triggers. Within PostgreSQL you can make use of the interval function which will...
Read MoreHow to extract email addresses in PHP (code snippet)
Since I once wanted to harvest some email addresses to contact people on a specific subject, I have created this small PHP script that would extract any email addresses from the text that you put in. <?php function extract_emails_from($string){ preg_match_all("/[\._a-zA-Z0-9-]+@[\._a-zA-Z0-9-]+/i", $string, $matches); return $matches[0]; } if(isset($_POST['emails'])) { $emails = extract_emails_from($_POST['emails']); print(implode("<br/>",...
Read MoreGoogle Webmaster Tools +1 tracking
As from yesterday, Google Webmaster Tools gives you a lot of insights into the performance of your +1 buttons. The Search Impact report gives you an idea of how +1‘s affect your organic search traffic. You can find out if your clickthrough rate changes when personalized recommendations help your content stand out. Do this by comparing clicks and impressions on search results with and without +1 annotations. We’ll only show statistics on clickthrough rate changes when you have enough...
Read MoreGoogle is testing drastic changes to search results
I just noticed that Google is testing some drastic changes to search results.
Read MoreHow to setup Feedburner on WordPress
I started blogging a few months ago and realized I have not really taken attention to my blogs feed readers. Google Webmaster Central tells me I have 3 (known) readers right now. HeeeeuJ! Since this is not a very accurate number, I would like to track usage of my feeds. Therefore I am going to setup feedburner for WordPress. Burn your feed Step 1 . Login to feedburner.google.com You will have to use your Google Account to login to Feedburner. After logging in, you need to enter a feed name or...
Read MorePHP class for the Raven Tools API
Even though many of you might really love the Raven Tools interface, I personally have experienced that it is a bit slow (Europe) and not as flexible as I would like it to be. Therefore I have created a simple and lightweight PHP class that is able to fetch most of the SEO stuff I am interested in. The API does not support that many features of Raven Tools (as far as I know; at this moment). I have picked json, but if you want to, you can extend the function request() to also support the XML...
Read More5 Secret tips to increase your organic search CTR!
I am imagining that you have put quite some effort into technical optimizations, content creation, and link building. After putting in all this effort, you are now ranking amongst the top dogs for some really competitive keywords. You are at full speed and are having a hard time to make any further improvements. What to do next? Are you squeezing the final bit out of your top 3 rankings? How should your search result look like? If I would be optimizing for “loan” within the United...
Read MoreCommon SEO rewrite rules for Apache using htaccess
There are many ways and reason why you would want to use some SEO rewrite rules for Apache. Rewrite rules can help you to set-up a nice reading url structure, or 301 redirect any old url’s you have so that search engines and users won’t get lost. I have summarized a bunch of them since they are/should be a common practice for anyone building websites with Apache. I am well know with Apache and rewrite rules, though I caught myself several times looking up common solutions on the...
Read MoreHow to best use multiple domains for 1 website using DirectAdmin
I came across the situation where I have both the singular and plural domainname. I have looked up how to best tie them together to 1 website forcing any other than the original domainname to 301 redirect using DirectAdmin. It is best (read: easiest) to use: Domain pointers to add any domain to the main website A htaccess file to auto redirect any domain which is not the default/main domainname. Please do update the below content for within your htaccess file with your own domainname ...
Read MoreHow to change your Outlook 2010 signature
I had to change my Outlook signature several times this year, and I always had to search how to since we swapped Outlook versions. I’ve gathered some screenshots to remind me about how to change my signatures in Outlook...
Read More
Recent comments