wvchallenges/se-challenge — pull request #11 by rlmas (2014-09-02 01:16:03+00:00)
Title: Ryan's Submission for Wave Challenge

Dear Wave,

Thank you for the wonderful challenge. As mentioned in the readme.md, the backend portion of the stack is Apache, MySQL and PHP. You'll have to connect to your DB set up to deposit data. On line 38 of processexpensefile.php, customize the line with the hostname, username, password and database name of the database the program will upload data:

$mysqli = mysqli_connect(hostname,username,password,database name);

The following MySQL query creates the table where the data that is uploaded is deposited.

CREATE TABLE employee_expenses( expenseid int(11) NOT NULL AUTO_INCREMENT, UNIQUE (expenseid), CHECK (expenseid>0), PRIMARY KEY (expenseid), datestamp datetime, expense_date date, category varchar(255), employee_name varchar(255), employee_address varchar(255), expense_description varchar(255), pretax_amount decimal(11,2), tax_name varchar(255), tax_amount decimal(11,2) )

Hope this helps!
Thanks,
Ryan