# BugBears <iframe src="https://giphy.com/embed/wpci3xdYmUZG" width="480" height="451" frameBorder="0" class="giphy-embed" allowFullScreen></iframe> ### Christine, Martha, Emmanuel, Andy --- ### Idea Feeling stressed and bugged out? Worry not! Let it all out on our BearBug website. Share your peetpeeves and rant, or simply see what buggs others <iframe src="https://giphy.com/embed/l1J9u3TZfpmeDLkD6" width="419" height="480" frameBorder="0" class="giphy-embed" allowFullScreen></iframe> --- ![image alt](https://i.imgur.com/Vlbokhw.jpg "title" =400x600) --- ### How We Worked * We mobbed for critical things - Initial Setup/Dom Manipulation * Pair programming * Planned quite extensively * Stopped when someone didn't understand something * Swore an oath to the BigBears code of conduct --- ### BugBears code of conduct - BEM - Ensure equal number of commits - Commit often - Switch regularly but (do few commits first) - Compartmentalise and work on the dedicated branch (pushing only needed after milestones) - feature and fix branches --- ### MVP - [x] Mobile first design - [x] Basic site with long list of previous inputs by user - [x] Logo in centre, description - [x] Field inputs are category, name and rant  --- ### Stretchgoals - [ ] GIFS - [ ] Colour coded based upon your level of rage - [ ] On selection - order previous entries by category - [ ] Favicon - [ ] Search bar --- ## Our Database ```sql CREATE TABLE bugbears ( id SERIAL PRIMARY KEY, category VARCHAR(100), name VARCHAR(100), rage_level INTEGER, description VARCHAR(280) ); ``` --- ## What we have learned? #### Simplifying Pools  --- #### Security! <iframe src="https://giphy.com/embed/6Bb8N1G22zc4g" width="480" height="349" frameBorder="0" class="giphy-embed" allowFullScreen></iframe> --- ##### How can I prevent SQL injection in PHP?  --- ##### LIKE THIS! Node-postgres supports parameterized queries, passing your query text unaltered as well as your parameters to the PostgreSQL server where the parameters are safely substituted into the query with battle-tested parameter substitution code within the server itself. documentation = https://node-postgres.com/features/queries ---  --- #### Submit buttons & needing to reload the page for database to update  ---  --- ## Challenges <iframe src="https://giphy.com/embed/T8Dhl1KPyzRqU" width="480" height="330" frameBorder="0" class="giphy-embed" allowFullScreen></iframe> --- ### What did we struggle with? - CSS --> Structure of our lists + spacing - Understanding how files connect - Battling with auto redirecting submit buttons - Creating a database? :cold_sweat:  --- ### Questions? <iframe src="https://giphy.com/embed/3o6Ztmsbx7HpCHiRJC" width="480" height="366" frameBorder="0" class="giphy-embed" allowFullScreen></iframe>