The website shows lightning strikes on a map, and it is based on the real time lightning strike data by the Finnish Meteorological Institute. It is also possible to play the lightning strikes as a melody, which is based on the properties of the lightning strikes.
A piece of music which is based on an improvised session over the soundtrack of the lightning strikes: R Dimensio – Salamatar
International Teletext Art Festival website needed to be transformed into a responsive WordPress site. Besides being the main site for the festival it presents the works by the artists in a virtual gallery.
A unique custom WordPress theme was created from the ground up.
KAVA, The national audiovisual archive of Finland has its own cinema, but they don’t provide standard .ics vCalendar of the movie showtimes for downloading or subscription. However, they have their own web store to buy tickets, and the page is neatly formatted.
I decided to practice website scraping a bit and as a bonus to try to create an ICS vCalendar file from the scraped data. The result is basically for my own use, but available for everybody (Download link of the generated calendar). The caveat is that if KAVA decides to change the layout the code wouldn’t work anymore, so be warned that the calendar may be broken then for a while.
The showtimes don’t change that much, so it’s safe to set the update period to once per week. Set the subscription to the address
https://www.sanaracreations.fi/apps/kavacal/kavacal.php
KAVA has changed their site’s layout and the code is not functional any longer. Take a peek at the website scraper code and hack on!
You might except a grander programme from that title, but this is actually a quite simple and straigthforward project. I needed to have a neat visual effect for a WordPress based website I was renovating and at first used the default options to make a gallery. I had five images in the gallery for testing. Because all of the images didn’t happen fit to the same row three were in the upper row and two in the lower. By accident the images made an inverted staircase pattern of two rows. From that I got and idea of creating a complete staircase of three rows by adding one extra row with one image. The images would be picked randomly from a larger gallery.
Download the example package: php_mysql_csv_example.zip
I needed to create a simple and easy to modify intranet database for certain project, and I now offer the setup as a complete working example. PHP and MySql are probably the most commonly used tools to organize information on the internet. The files have been derived from a couple of tutorials about creating a MySql database with PHP and .csv export, and I have compiled and commented the package from the ready job to an easily digestable form. The package is needlessly modular but I hope it provides building blocks for something of your own.