Sanara Creations - Creative explorations to promote art and humanity

Web

Creating a MySQL Database with PHP and Exporting It as CSV

Post author By Janne Särkelä
Post date 29.04.2011

Download the example package: php_mysql_csv_example.zip

This package provides a simple, modular intranet database example built with PHP and MySQL, designed for easy modification and learning. It includes CSV export functionality and is based on tutorials I’ve adapted and commented into a compact, practical form. While slightly over-modular, the code is intended as a set of reusable building blocks for your own projects.

The example is intended for local development environments such as MAMP (Mac), WAMP (Windows), or XAMPP (Linux). Make sure you have a MySQL user root with password root (commonly preconfigured). Edit the dbinfo.inc.php file to set database credentials (user, password, host, dbname, table), which are referenced throughout the code.

To get started:

Open createdatabase.php in your browser to create the database and table.
Then open index.php to access the basic interface.

Forms are used to submit data to PHP scripts, which build SQL queries accordingly. Sorting by column headers is also implemented.

Security considerations:

Protect sensitive files (like dbinfo.inc.php) using .htaccess and .htpasswd.
For public use, implement SQL injection protection — this example is intentionally left open for learning purposes.

Download: php_mysql_csv_example.zip

Tags coder, coding, html, mysql, php

Film

Composed original soundtrack music for a documentary film.

Post author By Janne Särkelä
Post date 08.04.2011

Musical contributions for the Finnish Zeitgeist-inspired documentary film Ajan henki. Not all tracks on this reel were included in the final soundtrack. In addition to original compositions created specifically for the film, SARANA live sets were used for selected scenes.

I also produced the Dolby Digital 3.1 mix for the final soundtrack and handled the post-processing of the audio.

Tags audio engineer, composer, logic, mixing, producer

Film

Sound Designer for an Independent Feature Film

Post author By Janne Särkelä
Post date 28.01.2011

https://www.youtube.com/watch?v=30XJhUVNIio

I worked as the sound designer for Anni, a Finnish indie feature film directed by Jussi Einola and produced by Joonas Einola. My responsibilities included on-site recording, Foley effects, and mixing. In addition to mixing the film’s soundtrack, I mixed and mastered the music and composed several original pieces using material from composer Simo Salo. Anni also incorporates samples from Freesound.org contributors, listed below.

acclivity, adcbicycle, amszala, Anton, audible edge, Benboncan, bennychico11, Bram, boziav, csengeri, dobroide, dkristian, dommygee, Dynamicell, fonogeno, FreqMan, gadzooks, gelo papas, gezortenplotz, Glaneur de sons, hazure, hello flowers, HerbertBoland, homejrande, inchadney, ingeos, j1987, jasinski, jimblodget, juskiddink, LG, lonemonk, malexmedia, martian, miastodzwiekow, mikaelfernstrom, MRQZ, nathanprtII, pempi, pushtobreak, RHumphries, Robinhood76, rutgermuller, RZ 1, sagetyrtle, sandyrb, Schalkalwis, scarfield, Slanesh, slerner, stephsinger22, thealchemist12, THE bizniss, tigersound, Timbre, timofei, timtube, tmc zach, ToddBradley, Tomlija, ViaTorci, zebraphone, xef6, xyzr kx, YngvieM

Tags audio engineer, composer, cubase, mixing, producer, sound design, sound designer, sound recordist

Web

Website for a Campaign Encouraging Children’s Active Participation.

Post author By Janne Särkelä
Post date 03.11.2010

MunVuoro! (MyTurn!) was a collaborative project by eight Finnish youth organizations focused on developing child participation methods and promoting democratic education.