Find bars and breweries with safety-oriented reviews – written by women, for women.
By: Lily Comeau(@lcomeau01), Elizabeth Cucuzzella (@ecucuzzella), and Rachel Dakermanji (@rdakermanji).
Safe Sips is a web application that helps users find bars and breweries based on keywords, city, postcode, or university location. It allows users to read and submit safety-focused reviews to create a safer nightlife experience. It is targeted towards young women in University, allowing them to find a safe bar within walking distance.
Key Features:
- Search by Keyword, University, or Location
- Displays bars and breweries near you
- Provides directions & reviews for each bar
- Mobile-responsive up to 550px, clean UI
- Frontend: HTML, CSS, JavaScript
- APIs: OpenBreweryDB, Mapbox Geocoding API
- Backend: PHP (for handling user authentication, user databases, and reviews databases), SQL (Hosted Databases)
| File Name | Description |
|---|---|
brewery_search.html |
The main interface for searching and viewing brewery/bar reviews. Includes dynamic elements and links to review forms. |
login.php |
Login page with frontend form validation using JavaScript. Calls loginformvalidation.php to authenticate users. |
loginformvalidation.php |
Validates user credentials against the database and redirects based on success or failure. |
signup.php |
User signup form with client-side JavaScript validation. Sends input to formvalidation.php. |
formvalidation.php |
Handles signup logic, creates a new user in the useraccounts table, and a user-specific reviews table. |
leaveReview.php |
Accepts and stores user reviews for a specific bar, creating entries in both bar-specific and user-specific tables. |
cache_header.php |
PHP include used to disable browser caching for pages like login or signup. |
- Icons by Font Awesome