Postalcode manager


Postalcode manager is made with PHP. It’s webproject where you can add, list and delete information about finnish postalcode areas. Program uses database, sessions and cookies. I have used bootstrap in styles.

Here you can try it: https://postalcode.soivi.net

You can find source codes in GitHub: https://github.com/Soivi/postalcode

Screenshots

Deploy

Install LAMP:
https://soivi.net/2014/how-to-install-lamp/

Install git

$ sudo apt-get install git

Clone repository:

$ git clone https://github.com/Soivi/postalcode.git

Create config.php

$ cd postalcode
$ nano config.php

Inside config.php add these lines.

<?php
        define (DSN, "mysql:host=localhost;dbname=postalcodesoivi");
        define (DB_USER, "user");
        define (DB_PASSWORD, "password");
?>

Create database

$ mysql -u root -p

CREATE DATABASE postalcodesoivi;
GRANT ALL ON postalcodesoivi.* TO [email protected] IDENTIFIED BY 'password';
exit

Add postalcode table and test data

$ mysql -u user -ppassword postalcodesoivi < create.sql
$ mysql -u user -ppassword postalcodesoivi < insert.sql