swansond/LavatoryLocatorDB — pull request #2 by aasav (2013-04-20 22:52:25+00:00)
Title: Review Submission Service

The form in submissions.php will submit to submitReview.php, which will handle insertion of reviews into the database (once the 'review' table has been created).

submitReview.php expects the following POST parameters:
"toilet": the ID of the bathroom the review is for
"rating": the rating out of 5
"review": the text of the review (service will escape the text)
"userID": the ID of the user submitting the review (webpage submits with an ID of 0).

Currently, inserted reviews will all have ID of 1 and helpfulness of 0.