Static conversion - LATV

[Craig]

I did this a while ago, but thought I might as well post it now with a bit of a story.

The site: Learning Abilities TV.

The website is essentially a YouTube front-end. I initially built the website in about 2009 using plain PHP, with a bit of help from some Flourish classes. I gave the administrator (and myself!) a basic control panel for managing the videos using Adminer Editor, and it worked quite well.

This summer, they got back in touch with me regarding some additional features and a whole host of video changes. It came at a time when I had either built one or two PW sites already or had another one or two in progress. I was also on a training course through work at the time, and had to get the changes done with quite a tight turnaround. I was dreading adding a load of content and files to the existing static site. So, in the end, I spent just two short evenings in my hotel room converting the existing site to ProcessWire, and adding all the new features & content at the same time.

The structure is quite straightforward. Each video is kept under a hidden parent page of /videos/. As well as title and summary, the video template has a Page reference field to link each video to one or more categories, and it has a URL field for the YouTube URL. I created a module that gets the preview image from YouTube when saving a video which just adds it to the video's Image field (but custom images can also be uploaded).

The new features/downloads were catered for with the File fieldtype and sub-pages.

Apart from that, it's very very simple.

[pwired]

Followed your link Adminer Editor. Found there Adminer and tried it out on a hosting server.

Adminer is really a nice alternative to phpmyadmin. It is even a single php file. Good found !

[Craig]

Yes, Adminer is really good - it's what I use most of the time in my day-to-day SQL work. I will switch to the Windows app HeidiSQL when the database dumps are massive, or I need to do a lot of playing around with queries.

But yes, I do find Adminer a lot better than phpMyAdmin for doing most things