Introducing our newest application, DontForgetMe! This app allows
users to enter the description and quantity of an item they are
looking to buy and add it to their shopping list. Each time the users
press the "Add Item" button, the item and quantity will appear on the
screen as well as be stored in our database. Our app was made for the
convieniece of our users so once they go shopping, they will be 100%
prepared! You may be thinking, what makes this app better than using
pen and paper? Well, instead of using a new paper for each weekly
shopping trip, you could take the more eco-friendly option since this
app allows users to delete their list and make a new one. Everytime
the "Reset List" button is clicked, the list will disappear along with
the data stored in the database. DontForgetMe is here to help you shop
more efficiently and make sure that nothing gets forgotten!
Our app’s name comes from the weekly worries of shoppers who are scared of forgetting an item they really need! So “DontForgetMe” gives off the message that by using this app, no item will be left behind! For the style of the app, we chose to go with a monochromatic look using different tones of blue since this color is very pleasing and relaxing to the eye. Also, we kept the design aspect to a minimum so that users have no confusion when it comes to how to work the app. The main purpose of our app is to allow users to keep track of their weekly grocery needs so minimizing the design keeps the app appealing but not overwhelming.
Our database is composed of four columns. The ID column will store numbers, and with the data type being int(11) and with Auto Increment on, each item and quantity that is entered will be identified with its own unique number. The description column will store all of the user's items, and the data type is varchar(255) so that only letters can be written in this text field. On the other hand, the quantity column is where the quantities of each item are located, and this data type is int(11) in order for the users to only be allowed to write in numbers. Lastly, the created column contains the date and time of the user's activity on the app, meaning each time they add a new item to their list. This column uses the timestamp data type which allows the database to collect this information.
Overall, I learned a lot about the process of making an app and especially making it work! The biggest challenge I encountered was how to change the sample code provided and make it connect to my own database. It took a bit of time however, I was able to figure it out and now I have my DontForgetMe App that serves its purpose of letting users enter items and quantities, create a list, and reset the list once their shopping trip is completed!