Duplicating a MySQL table
An SQL statement that allows one table to easily be duplicated in MySQL. Also describes table duplication in PHPMyAdmin
An SQL statement that allows one table to easily be duplicated in MySQL. Also describes table duplication in PHPMyAdmin
Some handy PHP code to get the longitude and latitude values from Google Maps API, based on the town, city or country location.
A PHP function that will highlight all matched keywords in a text string, whilst maintaining correct capitalisation. Examples given and code explained
A tutorial demonstrating how to enable mod_rewrite which will allow a website running on a WAMP stack to use a local .htaccess file for URL rewriting.
Part 2 of the custom twitter feed tutorial with authentication. Caching the twitter feed to a local file can speed up loading of tweets and negate Twitters rate limiting.
A tutorial for setting up a scheduled task using Plesk 11 on Linux. A couple of steps are involved for the scheduled script; ensuring Access to the server over SSH is specified and using wget utility to run the PHP script.
A tutorial designed to help anyone who is using or wants to create a custom Twitter feed that needs to authenticate basic read-only access for any public user timeline with Twitter OAuth, API V1.1.
Indexing database fields can do wonders to speed up complex PHP queries. This post goes shows how easy it is to know where to use indexes and how, using MySQL, PHP and PHPMyAdmin.
A useful Twitter style PHP time interval function to calculate the difference in seconds, minutes, hours or days between two different dates and times. The function can be used to display seconds, minutes or hours only, or display the most relevant time measurement unit automatically.
A useful PHP function that gets the first paragraph from a regular HTML string, with option to remove the paragraph tags.