Last week I was joyfully hacking away at a project, progressing from from one task to another. Then it came time to do a non-trivial SQL query, though at the time I still thought the query would be nothing more than a select with a GROUP BY. I was wrong.

The Problem

What I wanted was to return the most recent log for each task for a particular user.

Here’s my table:

+--------+---------+---------+---------------------+----------+--------------------------------------------------------------------------------------------------------+
| log_id | user_id | task_id | when                | duration | description                                                                                            |
+--------+---------+---------+---------------------+----------+--------------------------------------------------------------------------------------------------------+
|      1 |       1 |       1 | 0000-00-00 00:00:00 |      120 | getting logging working at a very basic level                                                          |
|      2 |       1 |       1 | 2010-06-26 13:52:49 |       20 | polishing off log insertion                                                                            |
|      3 |       1 |       2 | 2010-06-26 15:00:44 |      120 |                                                                                                        |
|      4 |       1 |       3 | 2010-06-27 14:00:40 |      300 | over 30 serves for school lunches                                                                      |
|      6 |       1 |       4 | 2010-06-28 15:00:51 |      150 | YesMen - WordPress theme                                                                               |
|      7 |       1 |       4 | 2010-06-29 16:30:03 |      240 | on the YesMen WordPress theme                                                                          |
|      8 |       1 |       5 | 2010-06-30 17:32:13 |      240 | Checking out the market, looking at competition and discussions involving successful developers   12pm |
|      9 |       1 |       1 | 2010-06-30 07:00:05 |       40 |                                                                                                        |
+--------+---------+---------+---------------------+----------+--------------------------------------------------------------------------------------------------------+

Originally, this was the query that I thought would do it:

SELECT * FROM `logs` WHERE `user_id` = '1' GROUP BY `task_id` ORDER BY `when` DESC;

Which gave me:

+--------+---------+---------+---------------------+----------+--------------------------------------------------------------------------------------------------------+
| log_id | user_id | task_id | when                | duration | description                                                                                            |
+--------+---------+---------+---------------------+----------+--------------------------------------------------------------------------------------------------------+
|      8 |       1 |       5 | 2010-06-30 17:32:13 |      240 | Checking out the market, looking at competition and discussions involving successful developers   12pm |
|      6 |       1 |       4 | 2010-06-28 15:00:51 |      150 | YesMen - WordPress theme                                                                               |
|      4 |       1 |       3 | 2010-06-27 14:00:40 |      300 | over 30 serves for school lunches                                                                      |
|      3 |       1 |       2 | 2010-06-26 15:00:44 |      120 |                                                                                                        |
|      1 |       1 |       1 | 0000-00-00 00:00:00 |      120 | getting logging working at a very basic level                                                          |
+--------+---------+---------+---------------------+----------+--------------------------------------------------------------------------------------------------------+

It looks fine, until you notice task_id 1.

“What?” I thought, “That’s the least recent log for task_id 1!”. Then it struck me, “Oh, ORDER BY is performed after GROUP BY.” (Edit)John Haugeland for bringing up a problem in this post. My expectation of valid results was unfounded because no explicit execution order is defined – it may not always (or ever) produce the correct results. In other words, I shouldn’t have expected it to work. Thanks to commenter

So I thought a bit and said “I know!” and this was my next attempt:

SELECT * FROM `logs` GROUP BY `task_id` HAVING `when` = MAX(`when`);

Which yielded:

+--------+---------+---------+---------------------+----------+--------------------------------------------------------------------------------------------------------+
| log_id | user_id | task_id | when                | duration | description                                                                                            |
+--------+---------+---------+---------------------+----------+--------------------------------------------------------------------------------------------------------+
|      3 |       1 |       2 | 2010-06-26 15:00:44 |      120 |                                                                                                        |
|      4 |       1 |       3 | 2010-06-27 14:00:40 |      300 | over 30 serves for school lunches                                                                      |
|      8 |       1 |       5 | 2010-06-30 17:32:13 |      240 | Checking out the market, looking at competition and discussions involving successful developers   12pm |
+--------+---------+---------+---------------------+----------+--------------------------------------------------------------------------------------------------------+

Though I was hoping that query would do what I wanted, I had a feeling it would do exactly this. It is similar to the last query except it completely removes the logs that aren’t the most recent. This is just as bad. By this point, I had done some searching and even went through my old RMIT Database Concepts Assignments looking for answers. “What now? Will I have to give in and use a subquery? Oh, please no…” As a final resort, I hopped over to #mysql on freenode (I’m SickAnimations).

Somebody linked me to a post about Groupwise Maximum queries on David North’s blog, which was about exactly the same problem as mine. However, the solution there didn’t to work for me – it gave the same results as my second attempt. Knowing the new term “Groupwise Maximum” and how to use The Google, I came across this little nugget on the official MySQL website: 3.6.4. The Rows Holding the Group-wise Maximum of a Certain Column. Jackpot.

The Solution

As I feared, the solution did indeed require a subquery. Here’s my application of MySQL’s suggestion solution:

SELECT *
FROM `logs` outer_logs
WHERE
	`outer_logs`.`user_id` = 1 AND
	`outer_logs`.`when` = (
		SELECT MAX( `inner_logs`.`when` )
		FROM LOGS inner_logs
		WHERE `outer_logs`.`task_id` = `inner_logs`.`task_id`
)

Providing the desired output:

+--------+---------+---------+---------------------+----------+--------------------------------------------------------------------------------------------------------+
| log_id | user_id | task_id | when                | duration | description                                                                                            |
+--------+---------+---------+---------------------+----------+--------------------------------------------------------------------------------------------------------+
|      3 |       1 |       2 | 2010-06-26 15:00:44 |      120 |                                                                                                        |
|      4 |       1 |       3 | 2010-06-27 14:00:40 |      300 | over 30 serves for school lunches                                                                      |
|      7 |       1 |       4 | 2010-06-29 16:30:03 |      240 | on the YesMen WordPress theme                                                                          |
|      8 |       1 |       5 | 2010-06-30 17:32:13 |      240 | Checking out the market, looking at competition and discussions involving successful developers   12pm |
|     17 |       1 |       1 | 2010-07-08 06:50:39 |       45 | Finalising transition to Linux development environment                                                 |
+--------+---------+---------+---------------------+----------+--------------------------------------------------------------------------------------------------------+

Feels mostly good, except the subquery part. Oh well.

Image from mwin.

Related Posts:

• Lomadaba, The Automatic MySQL Database Dump Backup PHP Script
• Check if Headers Have Already Been Sent in PHP

Notice how one of them has no favicon and a particularly unhelpful title. Now I’ll have to click on that tab (or press CTRL+3, or whatever)
to find out what it is – how annoying, I shouldn’t have to do this.

Because I can tell that you’re smart – I know that you want to use favicons on your site. It’s pretty easy – just create the icon and add some codeThe easiest way to get some favicon action is to use an online ico generator, here are some:

• Favicon.cc
• Dynamic Drive FavIcon Generator
• Favicon.co.uk

Then just add a some lines of code to your template:

<link rel="icon" href="http://yoursite.tld/favicon.ico" type="image/x-icon">

It’s worth noting that some browsers automatically search for “favicon.ico” on the document root of your website so it might be a good idea to name it “(httpdocs)/favicon.ico”. If you don’t want to do that, you can save it anywhere and just use a PNG file, just change the MIME type:

<link rel="icon" href="http://yoursite.tld/favicon.ico" type="image/png">

I personally prefer to edit my favicons locally, so I can make them transparent and high resolution for extra shine. Keep your eyes out for a post on that.

Related Posts:

• Processing PHP Code in CSS files to Improve Productivity and Browser Cross-Compatibility (using Apache)
• XHTML and HTML5 Compliant Flash – Stop Using Embed and Invalid XHTML/HTML5
• Launched: Artist Guysel
• Pretty Smarties 0.5 – Pretty URLs, Smarty Templates and Faster Web Design
• PNGs Have Different Colours in Different Browsers?
• New Content brings Crowds

Executing PHP in CSS Files

In order to parse and execute PHP in a CSS file, all you have to do is tell Apache to treat CSS files as PHP, and just make sure you tell the browser that it’s NOT text/html (default mime type) but CSS.Very easy.

.htaccess File

Place a .htaccess file in the directory of the CSS file (if there isn’t one already). Simply add a directive to process the PHP in CSS files. Depending on your configuration, you might have to use a different directive. Here are the two most common ones I’ve been able to use:
Mod_PHP (Apache PHP Module)

#MOD PHP

	SetHandler application/x-httpd-php

Others:

#OTHERS
AddType application/x-httpd-php5 .css

(If you’re using php4, use x-httpd-php4)

CSS (and PHP) File

I recommend using this code just to test that your Apache directive is working. Hopefully this example shows the potential use for (server-side) executable code in CSS files.

<?php
	//make sure the browser treats this as CSS
	header("Content-Type: text/css");
 
	//browser detection
	if (strpos($_SERVER['HTTP_USER_AGENT'],"Internet Explorer") > 0) {
		$internet_explorer = true;
	}
 
	$baseColour = "#F3AA9C";
	$secondaryColour = "#CCAF1F";
	$foregroundColour = "#FFFFFF";
	$moduleWidth = "125px";
?>
 
#content {
	background:<?php echo $baseColour; ?>;
	colour:<?php echo $foregroundColour ?>;
}
 
#sideBar {
	background: <?php echo $secondaryColour; ?>;
	color:<?php echo $baseColour; ?>;
	width:<?php echo $moduleWidth; ?>;
}
 
#footer {
	color: <?php echo $secondaryColour; ?>;
	background:<?php echo $foregroundColour; ?>;
}

Obviously mixing PHP and CSS stuffs up syntax highlighting sorry.

Caveat

Most browsers will download the CSS file on every pageload – it’s not too difficult to implement cache-control, but I haven’t done it for this code.

Related Posts:

• Pretty Smarties 0.5 – Pretty URLs, Smarty Templates and Faster Web Design
• Choose MySpace Comment Colors, Fonts and Sizes
• PNGs Have Different Colours in Different Browsers?
• Introducing the Lovely Caption Maker
• Accessible, Valid Dropdown Menu or Popup Menu using CSS and Semantic HTML
• Extract GET Variables from URL String to Array – PHP Function

1. Close all tags, use lower-case tags, use lower-case attributes and maintain nesting order.
2. Markup is for content, CSS is for presentation. That one was easy.
3. Use the right tag for the right job (in the right place) and make things accessible.

However, one thing that can’t be covered by a general rule is the complete removal of tags. Most removed tags were non-standard and started out as proprietary – like <marquee> and the tag we’re going to talk about, <embed>.

The <embed> tag was used to ‘embed’ objects (plugins) into a web page. Even though it’s not a standard tag, it had become the de facto method of inserting an object (like a Flash object, or a video) into a web page. You’ll notice that the code YouTube, PhotoBucket and other sites provide for you uses the <embed> tag and therefore this practice is known as “embedding”. Even though these sites still use it, that doesn’t mean you have to. “Embedding” objects without using is actually very easy and cross-(modern)browser compatible. Dear reader, please meet the HTML5 and XHTML-compliant <object> tag.

Valid HTML5 and XHTML Flash Tag

Rather than explaining it to you first, I’ll show you the before and after of some YouTube “embed” code.
Before:

<object width="425" height="344">
	<param name="movie" value="http://www.youtube.com/v/bz8Pv-QeNQI&hl=en_GB&fs=1&"></param>
	<param name="allowFullScreen" value="true"></param>
	<param name="allowscriptaccess" value="always"></param>
	<embed src="http://www.youtube.com/v/bz8Pv-QeNQI&hl=en_GB&fs=1&" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="425" height="344"></embed>
</object>

After:

<object type="application/x-shockwave-flash" style="width:425px; height:344px;" data="http://www.youtube.com/v/bz8Pv-QeNQI&amp;hl=en&amp;fs=1">
	<param name="movie" value="http://www.youtube.com/v/bz8Pv-QeNQI&amp;hl=en&amp;fs=1" />
	YouTube Video, flash required.
</object>

Basically, this is all you have to do:

• Add a type attribute to the object, and set its value to "application/x-shockwave-flash"
• Add a data attribute to the object and set its value the param "movie" had as its value – or simply the path of the SWF
• Use CSS to set the width, height and position
• Maintain other params that you want, or delete the ones you don’t want

See, it works:

Actually for some reason it doesn’t work on my iPhone…

That is all, happy (valid) coding.

Related Posts:

• Making Your Site Stand Out With Favicons
• Processing PHP Code in CSS files to Improve Productivity and Browser Cross-Compatibility (using Apache)
• Pretty Smarties 0.5 – Pretty URLs, Smarty Templates and Faster Web Design
• Introducing the Lovely Caption Maker
• Removing MovieClip Children from MovieClip in Flash Using ActionScript
• New Content brings Crowds

Transactions are managed by the shopping cart software and can automatically calculate postage, handling and then process the transaction.

logon2 Contact Form is used to allow customers easily enquire about specific products without hassle, as well as make general enquiries.

Visit Rose’s Knitting  Centre.

Related Posts:

• New Site – Barrabool Rural Protection Group
• Launched: Artist Guysel
• Launched: Adamas Fishing Charters – Sports Fishing in Bass Strait

Already, the backups have been of great use. With dynamic websites, customers can have access to administration panels, add content, manage their shop catalogue, add photos to their photo gallery, or send emails to their mail list. From time to time, even with appropriate documentation and instruction, customers can accidentally make pretty significant mistakes. I certainly have made mistakes myself. With access to daily backups, these occurrences are much less stressful.

If you haven’t got an automatic database backup system, you should consider Lomadaba as your solution – or at least your first step. Go and download or pull Lomadaba from github.

Features:

• Can be used to backup one database at a time or 20. Very little effort involved in adding databases.
• Success and/or failure email reporting.
• Designed to play nicely with existing scripts and their config files.
• Configurable and small enough to completely understand within five minutes.
• Uses MySQL Dump command, mysqldump to create backups. Essentially the most reliable way to create a backup.
• Designed to be execute regularly using cron jobs. Simply make an entry in crontab and allow the cronjob to back up your data.

Related Posts:

• Returning the entire row of maximum value for each group (Group-wise Maximum in SQL / MySQL )
• Pretty Smarties 0.5 – Pretty URLs, Smarty Templates and Faster Web Design

<a href="/">Home</a> |
<a href="/about/">About</a> |
<a href="/contact/">Contact</a>

I guess it’s OK to do that, but it’s not really great practice because the pipes ( | ) are not actually part of the content and are only meant for presentation, so they shouldn’t really be part of the HTML. Another problem with this is that it’s inflexible. What if we want more space between the pipes and the links? Do we enter a bunch of “&nbsp;”s? That’s ugly^.

We can use the CSS border property to add the separators for us by adding a left-border to each of the links.

“But what about the first link?“

The answer is the :first-child CSS pseudo-selector. It allows us to define CSS properties to the first element of its kind within a container. So in this instance, we can apply no border to the first child. Here’s how the lot would look:

<ul id="footer">
	<li><a href="/">Home</a></li>
	<li><a href="/about/">About</a></li>
	<li><a href="/contact/">Contact</a></li>
</ul>

ul#footer li {
    display:inline; /* so they display horizontally */
    border-left:1px solid #000000; /* our 'pipe' */
    padding-left:1em;
    padding-right:1em;
}
 
/* here it is, the first-child pseudo-selector */
ul#footer li:first-child {
    border:none; /* no 'pipe' before the first element */
}

It requires a bit more coding initially but it’s more elegant because it separates concerns and it’s also more accessible for screen readers and our friendly neighbourhood search engines*.

^ I know, this very site doesn’t follow this site doesn’t follow these practices. I’m a hypocrite!
* FACT

Related Posts:

• Pretty Smarties 0.5 – Pretty URLs, Smarty Templates and Faster Web Design
• Introducing the Lovely Caption Maker
• Accessible, Valid Dropdown Menu or Popup Menu using CSS and Semantic HTML
• Processing PHP Code in CSS files to Improve Productivity and Browser Cross-Compatibility (using Apache)
• PNGs Have Different Colours in Different Browsers?
• Clean URLs Using Apache’s mod_rewrite and PHP – Beginner’s Tutorial

Warning: Unknown([PATH HERE]): failed to open stream: No such file or directory in Unknown on line 0

Some other Fatal error came up but I forgot to copy it, sorry.

The error message is unhelpful but it was pretty easy to fix. I just deleted the .htaccess file from the root and tested. It worked! After restoring a backup of the .htaccess file everything worked. Hooray!

Related Posts:

• Processing PHP Code in CSS files to Improve Productivity and Browser Cross-Compatibility (using Apache)
• Check if Headers Have Already Been Sent in PHP
• Pretty Smarties 0.5 – Pretty URLs, Smarty Templates and Faster Web Design
• Clean URLs Using Apache’s mod_rewrite and PHP – Beginner’s Tutorial
• Extract GET Variables from URL String to Array – PHP Function

The turnaround time for Barrabool Rural Protection Group’s blog was 42 hours including domain registration and discussion.

Have a look at Barrabool Rural Protection Group‘s site to learn more about how they want to protect McAdam Park from over development as a result of a new motorbike / motorcross track.

Related Posts:

• Site Launched: Rose’s Knitting Centre
• Launched: Artist Guysel
• Launched: Adamas Fishing Charters – Sports Fishing in Bass Strait
• Does Your Site Need Fresh Content, Regularly?

• Gallery2 instead of miniGal for photo gallery management
• Pretty Smarties, logon2′s very own Template System, was used to keep pages consistent and content separated from presentation at source.
• Working with PHP as CGI on an external server

Artist Guysel in logon2′s folio

Related Posts:

• Site Launched: Rose’s Knitting Centre
• New Site – Barrabool Rural Protection Group
• Pretty Smarties 0.5 – Pretty URLs, Smarty Templates and Faster Web Design
• Launched: Adamas Fishing Charters – Sports Fishing in Bass Strait
• Making Your Site Stand Out With Favicons

This can happen when you try doing a HTTP redirect or send HTTP 404, as it can happen whenever you try to send headers once they’ve already been sent. When a user sees this, they are basically left high and dry, often on a blank page. The solution is simple:

Detect if Headers Have Already Been Sent

Whenever you call header(); , call headers_sent(); first!

Example:

1
2
3
4
5
6
7

    if (!headers_sent()) {
        header('Location: ' . (!$absolute ? HOME_URL : "") . $page);
        die();
    } else {
        echo "\n\n<p>Couldn't redirect to " . htmlentities((!$absolute ? HOME_URL : "") . $page) . ", headers already sent.</p>\n\n";
        //do something here...
    }

Of course you should probably do thing useful

Related Posts:

• Returning the entire row of maximum value for each group (Group-wise Maximum in SQL / MySQL )
• Processing PHP Code in CSS files to Improve Productivity and Browser Cross-Compatibility (using Apache)
• PHP – No such file or directory in Unknown on line 0 Error
• Pretty Smarties 0.5 – Pretty URLs, Smarty Templates and Faster Web Design
• Clean URLs Using Apache’s mod_rewrite and PHP – Beginner’s Tutorial
• Extract GET Variables from URL String to Array – PHP Function

This is the simple PHP template system which integrates Pretty URLs and Smarty Templates. The release is only two months later than I said, but I’ve made the release fairly decent. Here’s a rundown on the system:

Features

• Uses the Smarty template engine to place content and render templates. Smarty is easy to learn and well known.
• No actual PHP programming required, just HTML and a few Smarty tags
• Low overhead – no database calls and Smarty compiles templates
• Employs ‘pretty URLs’ by default – with automatic redirects for malformed  URLs and 404s for bad requests
• Content  inheritance from default or parent pages
• Support for dynamic content
• User friendly, automatic installer with optional sample templates and content

License

Pretty Smarties is licensed under the GNU General Public License, and includes code from WordPress, another GPL project.

Still to Come

• Pretty variables (Pass variables through a pretty URL)
• Support for GET variables (Currently unsupported – very easy to fix)
• Object orientated design
• Warnings for missing 404s, favicons
• Consistency improvements

Download Now

Pretty Smarties 0.5

Related Posts:

• Processing PHP Code in CSS files to Improve Productivity and Browser Cross-Compatibility (using Apache)
• Introducing the Lovely Caption Maker
• Clean URLs Using Apache’s mod_rewrite and PHP – Beginner’s Tutorial
• Extract GET Variables from URL String to Array – PHP Function
• Nicer Footer Navigation with pseudo-selectors
• Launched: Artist Guysel

Have you ever been working on a website and noticed that in certain browsers a background image isn’t blending properly with one of your background colours or another image? This phenomenon occurs in Internet Explorer and it’s caused by metadata in the PNG file itself. There’s a great program that solves this problem without any hacks.

The problem? Gamma. Some programs (like Adobe ImageReady) export PNGs with Gamma metadata. While I’m sure this metadata could be useful, it causes colour inconsistencies in Internet Explorer (6 and 7 confirmed.)

Solution – TweakPNG. Download this Windows program – consistent PNGs are X steps away:

1. Open TweakPNG
2. Load the problem PNG into TweakPNG (Either drag and drop or File > Open)
3. In the list of “Chunk”s, select “gAMA” and press the delete key.
4. Save (Ctrl+S or File > Save)

Done.

Related Posts:

• Accessible, Valid Dropdown Menu or Popup Menu using CSS and Semantic HTML
• Processing PHP Code in CSS files to Improve Productivity and Browser Cross-Compatibility (using Apache)
• Making Your Site Stand Out With Favicons
• Nicer Footer Navigation with pseudo-selectors
• Pretty Smarties 0.5 – Pretty URLs, Smarty Templates and Faster Web Design
• Introducing the Lovely Caption Maker

Unfortunately, this effect can’t be achieved without knowing and entering the width and height of an image – making it kind of tedious to implement. After deciding that I’d like to use it with wordpress posts, it was decided that a tool should be built. And then The Lovely Caption Maker was born. Here’s an example of Lovely Caption Maker’s glory:

This Is How We Party

Expressing ourselves on the last day of year twelve in 2006. Very sexy stuff.

Related Posts:

• Pretty Smarties 0.5 – Pretty URLs, Smarty Templates and Faster Web Design
• Processing PHP Code in CSS files to Improve Productivity and Browser Cross-Compatibility (using Apache)
• Nicer Footer Navigation with pseudo-selectors
• Accessible, Valid Dropdown Menu or Popup Menu using CSS and Semantic HTML
• XHTML and HTML5 Compliant Flash – Stop Using Embed and Invalid XHTML/HTML5
• PNGs Have Different Colours in Different Browsers?

Go with Adamas Fishing Charters to catch Mako Sharks, Thresher Sharks, Blue and Bronze Whalers, Snapper, Tiger Flathead, Barracouta, Squid, Gummy Sharks, Seven Gill Sharks, Yellowtail Kingfish, St. George Whiting, Trevally, Salmon, Calamari, Pike, Flathead and Tuna.

View Adamas Fishing Charters logon2 Portfolio Profile

Related Posts:

• Site Launched: Rose’s Knitting Centre
• New Site – Barrabool Rural Protection Group
• Launched: Artist Guysel

Setting Up Apache’s “mod_rewrite” Modul

To implement these URLs with Apache, you will need to have the mod_rewrite module enabled. Here’s how to enable mod_rewrite:

1. Open the httpd.conf file from the …apache/conf/ directory
2. Uncomment the line “LoadModule rewrite_module modules/mod_rewrite.so” (by removing preceding #)

If you have more than one virtual server or directory set up, you might have to add something like this as well:

<Directory "PATHOFDIRECTORY">
    AllowOverride all
    Order allow,deny
    Allow from all
</Directory>

Next, you need to create a file named “.htaccess” at the website’s root directory (if you haven’t got one already)

In your .htaccess file, add the following rules:

<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>

This will redirect all requests that don’t point to an existing file or directory to ‘index.php’.

You might (or might not) be thinking “How does that help implement clean URLs?” The next part will answer that question, but before proceeding – test your new Apache config and .htaccess file – restart Apache if necessary and try loading a directory that doesn’t exist (ie. http://yourwebsitehost/page/5/your-information/). If it loads your index.php page – we’re ready to continue.

Getting PHP to Interpret The URLs

Ok, the hard part is done. Now I’ll explain what we want when a user requests a page:

1. User requests “/page/5/your-information/”
2. Apache redirects the request to “index.php” without changing the user’s URL
3. index.php breaks up the requet URI and loads page.php instructing it to load page ’5′

This might seem a bit difficult (or, if you’re experienced, very easy) – it honestly is rather easy. Once you understand how it works, you might decide to do it differently, but here is a really simple example of a website that contains information ‘pages’ and information about the ‘authors’ of those pages.

In our example, we have three php files:

• index.php
• page.php
• author.php

“index.php”

<?php
//$urlVariables is an array that contains the different bits of information in the request.
$urlVariables = explode("/",$_SERVER['REQUEST_URI']);
//If the user requested '/page/6/about-elephans/' then $urlVariables[1] would be 'page', $urlVariables[2] would be '6' and so on.

if ($urlVariables[1] == "page") {
//the user is requesting an information page
    include "page.php";
} elseif $urlVariables[2] == "author" {
    //the user is requesting author information
    include "author.php";
} else {
    //load the home page
    include "default.php";
}?>

“page.php”

<?php//load an object that deals with pages (to keep the tutorial simple)
include "classes/page.php";
$page = new page;
//$urlVariables will contain the page id as the 2nd array element (ie. /page/pageid/page-name-here/)$page_id = $urlVariables[2];
//the page name part of the URL is ignored when loading because we only use ID to load pages - it's just good for search engines and people.

//get the page class to load the page
if ($page->load_page($page_id)) {?>

<h1><?php echo $page->page_name(); ?></h1>
<p><?php echo $page->page_content(); ?></p>
<p>Written by <a href="<?php echo $page->author_url(); ?>"> <?php echo $page->author_name(); ?> </a></p><?php

} else {

    //error!
    include "error.php";
}>

“about.php”

<?php

//load an object that deals with authors (again, to keep the tutorial simple)
include "classes/author.php";
$author = new author;
//$urlVariables will contain the page id as the 2nd array element (ie. /author/authorid/author-name-here/)
$author_id = $urlVariables[2];
//again, the author name part of the URL is ignored when loading because we also only use ID to load authors - it is just good for search engines and people.

//get the author class to load the page
if ($author->load_author($author_id)) {?>
<h1><?php echo $author->author_name(); ?></h1>
<h2>Bio</h2><p><?php echo $author->author_information(); ?></p>
<h2>All pages by <?php echo $author->author_name; ?></h2>
<$php echo $author->page_list; 

} else {
    //error!
    include "error.php";
}
?>

Now that example was probably a bit excessive. Here’s a basic overview of how it works:

1. The index.php page is loaded, and ‘explodes’ the request part of the URL into an array ($urlVariables in the example)
2. You then interpret the array elements to decide what to show to the user. ($urlVariables[1] determined whether to show a page or an author profile and $urlVariables[2] was an ID for either the page or the author in our example)

It’s that simple. This method is SUPER flexible if you build a strong framework around it.

Good luck!

Related Posts:

• Pretty Smarties 0.5 – Pretty URLs, Smarty Templates and Faster Web Design
• Extract GET Variables from URL String to Array – PHP Function
• Processing PHP Code in CSS files to Improve Productivity and Browser Cross-Compatibility (using Apache)
• Nicer Footer Navigation with pseudo-selectors
• PHP – No such file or directory in Unknown on line 0 Error
• Check if Headers Have Already Been Sent in PHP

While working on an update for Once Upon a Bride’s handmade jewellery website, I had to overcome a certain bug or problem in Internet Explorer that caused images loaded into Loader Components to render incorrectly and scale incorrectly, usually with incorrect width and height. This was occurring after loading about 12 – 15 images.

So instead of loading them all at once, I made it load only eight images, and let the users view a page of eight at a time. The only problem I had was clearing the old thumbnails before loading the new ones.

The Solution

The Solution After a bit of looking around, here’s the code:

function clearMovieClips(parentMovieClip) {
	for (obj in parentMovieClip){

		if (typeof(parentMovieClip[obj])=="movieclip"){
			parentMovieClip[obj].removeMovieClip();
		}
	}
}

The Proof

Now a nice before and after shot:

Before:

After:

Related Posts:

• Accessible, Valid Dropdown Menu or Popup Menu using CSS and Semantic HTML
• XHTML and HTML5 Compliant Flash – Stop Using Embed and Invalid XHTML/HTML5
• PNGs Have Different Colours in Different Browsers?
• Opera says Microsoft “deprives consumers of a real choice”

In JavaScript terms, I needed to be able to add (or create) and remove (or delete) elements, within another element, the form. After a little bit of research on the internet, I had what I needed to do just that. See a basic example of javascript dynamically adding and removing elements… Here’s how to do it:

To begin with, here’s the commented JavaScript code for adding an element using the DOM in JavaScript

function appendElement(containerId, newElementId, newElementContent) {
	//First, we need to create a new DIV element
	var newElement=document.createElement("div");
	//New we will give it the specified ID so we can manage it later if necessary
	newElement.setAttribute("id", newElementId);
	//Insert the HTML content into the new element
	newElement.innerHTML=newElementContent;

	//Get a reference to the element that will contain the new element
	var container = document.getElementById(containerId);
	//Now we just need to insert our new element into the containing element
	container.appendChild(newElement, container);
}

And here’s the commented JavaScript code for a function to remove elements:

	function removeElement(parentId, elementId) {
	//Get a reference to the element containgint the element we are removing
	var parentElement = document.getElementById(parentId);
	//Get a reference to the element we are removing
	var childElement = document.getElementById(elementId);
	//remove the
	parentElement.removeChild(childElement);
}

And that’s it. Of course, this by itself isn’t going to do much. Though with a little bit of imagination, these functions can help you improve the usability or usefulness of your website.

Related Posts:

• Accessible, Valid Dropdown Menu or Popup Menu using CSS and Semantic HTML
• Processing PHP Code in CSS files to Improve Productivity and Browser Cross-Compatibility (using Apache)
• Pretty Smarties 0.5 – Pretty URLs, Smarty Templates and Faster Web Design
• Introducing the Lovely Caption Maker
• Extract GET Variables from URL String to Array – PHP Function
• MySpace – Convert Text to HTML

What makes this solution so great is it means that you can easily add new articles, products and pages to your website whenever you want – and without learning anything about web design! It’s just like sending an email, except you’re writing an email for all of your customers and potential customers. The picture further below is a shot of the software used to create this page you are looking at right now.

Here are some of the HUGE benefits:

• You can add and update content whenever you like
• Adding new pages, articles, products is as easy as using Word
• Customers can subscribe by email, and new articles can be sent to customers automatically!
• Get more visitors and customers through search engines
• Keep visitors interested in your site for longer with more for them to read
• Receive feedback on any page
• Make it easy for readers to share your pages with other people

Screenshot of the blog software I used to

post this article in less than 10 mintes…

Try It Out Yourself, Now!

After seeing so much success for my own site by using a blog, I really want to give my customers the same opportunity. So I made a demo blog that you can look at, write demo articles, edit the articles and delete articles…

View the demo blog
Manage the demo blog
Username: demo
Password: demo

The whole “blog” section of the logon2 website and a huge amount of the specific information including the portfolio, areas serviced by logon2, and detailed explanations of some of logon2′s services. Over 60 pages (and constantly growing) of content, all linked and organised, automatically sent to subscribers and bringing over 400 of visitors a week through search engines

Related Posts:

• New Content brings Crowds
• Nicer Footer Navigation with pseudo-selectors
• New Site – Barrabool Rural Protection Group
• Pretty Smarties 0.5 – Pretty URLs, Smarty Templates and Faster Web Design
• PNGs Have Different Colours in Different Browsers?
• Introducing the Lovely Caption Maker

I personally developed the original WizzComb website in 2004, being only the second website I had ever developed it was pretty abysmal when it came to standards, accessibility and even good markup form. The website became out of date so after some tinkering, the WizzComb website is now fresh, valid, accessible, SE-Friendly and better looking.

Popular Posts:

• Free Web Proxy List – Access Blocked Sites From Work or School
• Accessible, Valid Dropdown Menu or Popup Menu using CSS and Semantic HTML
• Choose MySpace Comment Colors, Fonts and Sizes
• Returning the entire row of maximum value for each group (Group-wise Maximum in SQL / MySQL )
• MySpace – Convert Text to HTML
• Extract GET Variables from URL String to Array – PHP Function