<?xml version="1.0" encoding="UTF-8"?><rss version="0.92">
<channel>
	<title>Archétype Informatique: the back burner</title>
	<link>http://www.archetype-it.com/thebackburner</link>
	<description>Occasional articles about our “back burner” web projects, and handy technical tips</description>
	<lastBuildDate>Tue, 13 Dec 2011 15:21:25 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	<!-- generator="WordPress/3.2.1" -->

	<item>
		<title>Automatically updating a WordPress blogroll</title>
		<description><![CDATA[Years ago, I signed up to a social bookmarking system called Spurl. I&#8217;m really not interested in social bookmarking, but it had a handy feature: by inserting a bit of Javascript in a web page, you could pull all or &#8230; <a href="http://www.archetype-it.com/thebackburner/2011/11/26/automatically-updating-a-wordpress-blogroll/">Continue reading <span class="meta-nav">&#8594;</span></a>]]></description>
		<link>http://www.archetype-it.com/thebackburner/2011/11/26/automatically-updating-a-wordpress-blogroll/</link>
			</item>
	<item>
		<title>Book review: PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide, 4th Edition by Larry Ullman</title>
		<description><![CDATA[I bought PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (4th Edition) to use as a set book for an online intermediate PHP class that I teach. I previously used Web Database Applications with PHP &#38; MySQL by &#8230; <a href="http://www.archetype-it.com/thebackburner/2011/09/30/book-review-php-and-mysql-for-dynamic-web-sites-visual-quickpro-guide-4th-edition-by-larry-ullman/">Continue reading <span class="meta-nav">&#8594;</span></a>]]></description>
		<link>http://www.archetype-it.com/thebackburner/2011/09/30/book-review-php-and-mysql-for-dynamic-web-sites-visual-quickpro-guide-4th-edition-by-larry-ullman/</link>
			</item>
	<item>
		<title>Accessing virtual hosts across a LAN</title>
		<description><![CDATA[Like many web developers, I have a local Apache/MySQL/PHP setup for developing sites. To ensure maximum compatibility with live servers, I set up a virtual host for each site. That way I know all paths will work. For example, on &#8230; <a href="http://www.archetype-it.com/thebackburner/2011/09/05/accessing-virtual-hosts-across-a-lan/">Continue reading <span class="meta-nav">&#8594;</span></a>]]></description>
		<link>http://www.archetype-it.com/thebackburner/2011/09/05/accessing-virtual-hosts-across-a-lan/</link>
			</item>
	<item>
		<title>More nifty SQL: insert if not exists</title>
		<description><![CDATA[Quite often you want to insert a record into a table, but only if it doesn&#8217;t already exist. OK, you could first do a SELECT query to check for existence, and then do the insert, but it&#8217;s clumsy and raises &#8230; <a href="http://www.archetype-it.com/thebackburner/2011/06/21/more-nifty-sql-insert-if-not-exists/">Continue reading <span class="meta-nav">&#8594;</span></a>]]></description>
		<link>http://www.archetype-it.com/thebackburner/2011/06/21/more-nifty-sql-insert-if-not-exists/</link>
			</item>
	<item>
		<title>ADODB database abstraction library for PHP</title>
		<description><![CDATA[I&#8217;ve been using this library for years to make my database interface code database-independent, but I am still discovering new useful functions. Case in point: today I was using the handy rs2csv function, which outputs a recordset to a CSV &#8230; <a href="http://www.archetype-it.com/thebackburner/2010/03/30/adodb-database-abstraction-library-for-php/">Continue reading <span class="meta-nav">&#8594;</span></a>]]></description>
		<link>http://www.archetype-it.com/thebackburner/2010/03/30/adodb-database-abstraction-library-for-php/</link>
			</item>
	<item>
		<title>Preventing hotlinking of images</title>
		<description><![CDATA[Using an .htaccess file to prevent people stealing bandwidth by linking directly to your images from another website is a popular and well-known technique. I needed to do this, but decided to take it a step further with a little &#8230; <a href="http://www.archetype-it.com/thebackburner/2009/09/29/preventing-hotlinking-of-images/">Continue reading <span class="meta-nav">&#8594;</span></a>]]></description>
		<link>http://www.archetype-it.com/thebackburner/2009/09/29/preventing-hotlinking-of-images/</link>
			</item>
	<item>
		<title>Who knew Javascript could be fun?</title>
		<description><![CDATA[It gave me migraines till I discovered jQuery. Now I can validate a form with some simple CSS and a couple of lines of jQuery code. And today I had a rather odd requirement to toggle the colour of cells &#8230; <a href="http://www.archetype-it.com/thebackburner/2009/02/02/who-knew-javascript-could-be-fun/">Continue reading <span class="meta-nav">&#8594;</span></a>]]></description>
		<link>http://www.archetype-it.com/thebackburner/2009/02/02/who-knew-javascript-could-be-fun/</link>
			</item>
	<item>
		<title>PHP: is it a leap year?</title>
		<description><![CDATA[I&#8217;ve written about date manipulation in PHP before. There are some truly horrible hacks out there. Today I needed to detect whether a given year was a leap year, in order to write future-proof code for a calendar. PHP has &#8230; <a href="http://www.archetype-it.com/thebackburner/2009/01/29/php-is-it-a-leap-year/">Continue reading <span class="meta-nav">&#8594;</span></a>]]></description>
		<link>http://www.archetype-it.com/thebackburner/2009/01/29/php-is-it-a-leap-year/</link>
			</item>
	<item>
		<title>Amarok and network shares on the eee PC</title>
		<description><![CDATA[The eee now spends most of its time being used as a convenient way to play music through the stereo. This means it needs to mount the shared directory on the server downstairs that contains all the music. This caused &#8230; <a href="http://www.archetype-it.com/thebackburner/2008/05/25/amarok-and-network-shares-on-the-eee-pc/">Continue reading <span class="meta-nav">&#8594;</span></a>]]></description>
		<link>http://www.archetype-it.com/thebackburner/2008/05/25/amarok-and-network-shares-on-the-eee-pc/</link>
			</item>
	<item>
		<title>SQL query to find duplicate rows</title>
		<description><![CDATA[This is one of those things I can never remember how to do when I need to do it. I don&#8217;t know why, it&#8217;s really quite simple: SELECT emailaddress, firstname, lastname, COUNT(emailaddress) FROM customers GROUP BY emailaddress HAVING COUNT(emailaddress) &#62; &#8230; <a href="http://www.archetype-it.com/thebackburner/2008/04/15/sql-query-to-find-duplicate-rows/">Continue reading <span class="meta-nav">&#8594;</span></a>]]></description>
		<link>http://www.archetype-it.com/thebackburner/2008/04/15/sql-query-to-find-duplicate-rows/</link>
			</item>
</channel>
</rss>

