Using one DB query per node in a tree is expensive, and if your tree is large, will horribly slow the site. The answer is to take a little more time on inserts and reap the efficiency rewards in selects. I’ve been using this technique for a while but I just mislaid my “rebuild tree” [...]
Entries Tagged as 'php'
Paste-in Keyword Density Calculator
August 11th, 2009 13 Comments
I just knocked this keyword density calculator together for my own use - there are plenty online that take a URL but I wanted one to automatically show the keyword density for offline documents - in other words I wanted to paste in the entire document, not just the URL.
Here’s the keyword density checker source [...]
Tags: google · keyword density · php · seo
Simple PHP Article Spinner
April 27th, 2009 32 Comments
I was doing some SEO for an excellent site on Friday. Their on-page was excellent, and they had some desirable backlinks. One problem they did have though was duplicate content on their location-specific “doorway” pages - pages designed to rank for “Blue Widgets Ely”, “Blue Widgets Cambridge” etc
I proposed they at least “spun” the body [...]
Tags: article spinning · google · php · seo · unique content
Want people to Tweet for you virally? Don’t ask for their password.
March 29th, 2009 1 Comment
More and more companies are catching on to the massive exposure that its possible to get through Twitter.
Some are using “bribes” to get people talking about their products and services.
Usually they use software like Viral Tweets to accomplish this.
Fine enough, but I don’t want to be handing over my Twitter password to all and sundry. [...]
Tags: bfm · butterfly marketing · mike filsaime · pdf · php · sales letter · twitter · viral marketing
How to Install PHP / MySQL and Apache on Windows - WAMP
March 29th, 2009 1 Comment
Just did a new video on downloading and installing WAMP
http://vids.myspace.com/index.cfm?fuseaction=vids.individual&videoid=53965013
For some reason the “voice” audio codec I used only works on MySpace. The other video sites are silent.
WAMPserver is a hugely powerful and very easy-to-use package that allows you to run a complete server on your local computer, running the Apache webserver, MySQL [...]
How To Scale Your Web Technology For Product Launch - Lessons Learned From The Butterfly Marketing 2.0 Launch
March 25th, 2009 4 Comments
When the order link for the Butterfly Marketing 2.0 launch was emailed to Mike Filsaime’s “Early Bird” list yesterday, the BFM servers crashed pretty spectacularly. Ustream chatrooms were packed with unhappy punters jabbing the refresh button like woodpeckers - fearful they might miss the opportunity to be one of the first 5000 to grab what was undeniably [...]
Tags: bfm · butterfly marketing · mike filsaime · mysql · php
Quality PHP Web Development Consultancy
January 6th, 2009 1 Comment
New Year = new direction…
After many years of almost seamless employment, I’m now available for freelance / consultancy work again.
I offer nearly 10 years professional PHP / MySQL development experience and, crucially, the ability to speak about highly technical matters to highly non-technical people - in a language they understand.
My commercial awareness sets me apart from the vast [...]
Tags: php · php freelancing · php web development · web consultancy
