Install SimpleInvoices on Windows

Trabla: Install SimpleInvoices 2011.1 on Windows ( XAMPP 5.6.21 )

Simple Invoices is a simple web based invoicing solution for personal/home-office/small business needs. Simple Invoices offers the basic option to enable people to create and manage invoicing.

Watch on YouTube

Solving:

1.  Download and install XAMPP 5.6.21 from official site:
https://www.apachefriends.org/download.html

2. Download Simple Invoices 2011.1  source files from :
http://www.simpleinvoices.org/go

3. Create folder \simpleinvoices in XAMPP htdocs folder
C:\xampp\htdocs\simpleinvoices
and copy all files from downloaded Simple Invoices 2011.1   .zip source

4. Run XAMPP Control Panel 
- start Apache
- start Database

5. Now we need to create Database for Simple Invoices 2011.1


1) Open phpMyAdmin in new browser tab (or window :) ) - http://localhost/phpmyadmin
2) Open SQL tab
3) Execute following query

( our database name will be - `simpleinvoice-db`
user(s) -  
'simpleinvoice-db-owner'@'localhost'  
'simpleinvoice-db-owner'@'127.0.0.1' 
'simpleinvoice-db-owner'@'::1'
with password 'SimpleInvoice123$%'
)

CREATE DATABASE `simpleinvoices-db` 
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE USER 'simpleinvoices-db-owner'@'localhost'; 
CREATE USER 'simpleinvoices-db-owner'@'127.0.0.1';
CREATE USER 'simpleinvoices-db-owner'@'::1';

SET PASSWORD 
FOR 'simpleinvoices-db-owner'@'localhost' = PASSWORD('SimpleInvoices123$%');
SET PASSWORD 
FOR 'simpleinvoices-db-owner'@'127.0.0.1' = PASSWORD('SimpleInvoices123$%');
SET PASSWORD 
FOR 'simpleinvoices-db-owner'@'::1' = PASSWORD('SimpleInvoices123$%');


GRANT ALL PRIVILEGES ON 
`simpleinvoices-db`.* TO 'simpleinvoices-db-owner'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON 
`simpleinvoices-db`.* TO 'simpleinvoices-db-owner'@'127.0.0.1' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON 
`simpleinvoices-db`.* TO 'simpleinvoices-db-owner'@'::1' WITH GRANT OPTION;

6.  Now we need to change config.ini file - set database connection parameters
Open file
C:\xampp\htdocs\simpleinvoices\config\config.ini

Change params in [production] section to
database.params.username = simpleinvoices-db-owner
database.params.password = SimpleInvoices123$%
database.params.dbname   = simpleinvoices-db

7. Open in browser following url to start Simple Invoices 2011.1  web installation
http://localhost/simpleinvoice

Click "Install Database"

8. "Step 2: Install essential data" page - click "Install essential data" button

9. "Step 3: Import sample data" page - if sample data needed click "Import sample data"

Enjoy Simple Invoices 2011.1

Example Invoice PDF