Section 1. Objective and Planning
Our objectives are to create an interactive shopping website that is targeted at females, primarily at young women. We looked at websites such as Pretty Little Thing, Oh Polly and Femme Luxe to get inspiration. We plan on naming it pretty drippy ♥, with a picture of all the models on the front page and 4 pages (home, dresses, cosmetics, and help) and a search bar in the corner. For the relational database we plan on making 2 of them.One being a login system and the other being an active search-bar. The login-system will be relational because it will be joined by two tables.One containing the login details and the other containing user details.
RESEARCH
Section 2. The Process
We made the mistake of worrying too much about the look of the website rather than the actual code and work that needed to be put in behind the relational database, and we ended up having a lovely website with a tiny search bar that did nothing thinking we were way ahead of everyone else. When we finally realised how behind we were we made a login button to make it relational, however it didn't properly work until the very end of the project. Our main complication was getting the login to actually save the inputted information. When we clicked on the login button nothing would happen. We also came across plenty of struggles such as not getting the search bar to indicate where the search would be located. What we planned on doing was typing in something into the search bar, that being the input, for example, 'blue dress' then when the submit button is pressed it will take you down to the section of the page that had a blue dress, that being the output. Which would show that the information inputted was saved. But that still didn't work for us. So we decided to leave that and come back to it at the end if we had time. The HTML, CSS and Java Script were all doable, the sqlite was the hardest part of the entire code.The relational database was indeed our downfall. We spent less time attempting to configure it and more coming up with ideas that will create a relational database which also fit in and can be applied to our website. We believe we started too complicated -for example we thought of ideas such as making a shopping cart and researched this however we soon concluded we had no time for such and that it was too complicated. Finally at the end of our project we realised our main problem for our login button not working. In our code we made it that the button was supposed to call a function when it was pressed, but we never actually made that function so nothing was happening. I think we were overthinking it so much that we didn't even realise that the problem was as simple as that. So we began to make changes to the project to try get the login button to save the information we need. Thankfully,we finally realised where we were going wrong and rectified the mistake in relation to the login button.However our sign up form which is meant to be our connection for the relational database still doesnt operate 100% successfully.However we still do have a relational database as our UserDetails table and LoginDetals table are connected joined by the use of ID. The project meets the brief's requirements, including the relational database, which we have two of (the search bar and login system).
Snippets of our code
Section 3. The Webpage
How did we abstract our code?
Well to make the the foot of the page we had the information, e.g(contacts, location and social media sections) all under one so we wouldnt have to use css for each seperate part, and instead for the entire footer as a whole.So for example, we wanted it to be listed in seperate parts (social media: instagram,snapchat,etc) would all have the same css. This made our code a lot easier for us because it prevented repetition.
What data did we use?
We used data from pretty little thing and our own personal input to decide the price of our products to make the most accurate predictions of what young women will appreciate.This is how we used computational and non-computational tools to collect, store, analyse and present our data.