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 user@localhost IDENTIFIED BY 'password';
exit
Add postalcode table and test data
$ mysql -u user -ppassword postalcodesoivi < create.sql
$ mysql -u user -ppassword postalcodesoivi < insert.sql