I have figured out a project for learning PHP and MySQL; it’s a queue management tool for work. Basically, it maintains a queue for each engineer (list of projects for them to work on, in order). It has functions to add a queue item, edit a queue item, and delete a queue item from an engineer’s queue, and an admin and non-admin display.
It seemed a bit overwhelming when I wrote out the use cases and did the wireframes, but I spent some time last night thinking about the various functions required, and it seems much more possible now. I just need to figure out how PHP interacts with MySQL and user interfaces, which will take me 2-3 weeks, I suspect. Definitely a steep learning curve, but at least I know how I’m going to tackle it.
And it should be fun! I love learning new things.