So I have been thinking of an idea for a basic web app that would really speed up a process for a small community I am part of - but I need some advice. I’ll warn you all, this is going to seem super basic to some of you - but we all have to start somewhere right?
The basics are:
User uploads a spreadsheet in a specific format (it is exported from another system so will be consistent).
Web app checks each line against another list to get a price for each line item.
Web app then returns some basic stats:
Price per item
Overall price for all items
If an item has gone up or down significantly within a week (this is nice to have)
I would like the list to be sortable on item type and price high to low etc.
My question for the lovely people of HT would be, where would you all start with soemthing like this? If you were attempting to make this, what routes would you investigate?
I am really looking forward to this as a learning and development experience but I am a little lost as to where to even begin!
Might be a shot in the dark since I am not really much into coding with WordPress being my go-to solution for websitew, but couldn’t you assign fixed variables for each item that could possibly appear on the list then later make the script scan the list for these items and fill in the price. At the end sum it all up?
var apple = 2;
var banana = 1;
var total = var apple + banana;
What they alwayw recommend at CS50 Code course is first write pseudo code like:
define variables and prices
Scan submitted data for variables
Put price tags on submitted data sheet where applicable
use oldschool serverside php, create a form with the upload, parse the file into a mapping and run your calculations. output the result in rows. learn about sanitizing var and stuff on the way. no tools needed, just a running lamp stack.
oh and maybe make it look nice later with tons of css.
So this was sort of what I was thinking in my simple mind!
As it is for a small group and will be offline (in terms running locally) I am not too worried about security which I know is a big consideration with any app (and according to half the internet PHP is basically a virus anyway) lol.
use some nice code editor, php I consider good and easy for beginners. I don’t care about people hating this or that. without php 90% of all web pages would be off. no wordpress, no magento, no other shit.
end of discussion.
Hope I’m not derailing the thread, but what would you use for basic form handling (i.e. a contact form) on a regular shared host. Need basic submit, no fancy stuff. Would also need something effective to prevent spam, like reCaptcha …
(Would probably want to set it up to use SMTP to send the form …) Could also use something lile formspree.io I guess …