I have a directed study this fall and after learning php/mySQL this summer, I hope to complete a project (described below). Since most of you have more programming experience than me, I'm looking for some advice.
I want to create a database of lesson plans that basically function as a wiki in that I can "edit" them, add to them, add new ones, and others can as well. I also want to be able to let's say, type in nouns in the search area and pull up all lessons in the database on nouns.
Most importantly, I want to be able to click on checkboxes on pages (for example, check a checkbox on a "nouns" lesson, "book1" lesson, and maybe "art" lesson) and all the lessons I checked are copied and pasted into a template lesson plan (that is standard for the database) so that in the end, I have a week's worth of lesson plans all divided up by objectives, procedures, etc. for all lessons taught.
Make sense so far?
I haven't finished learning php/mySQL yet, but I wanted to write this in php. It seems silly for me to write a wiki when programs for wikis already exist. Obviously though, I'd need to do some serious moding.
Can I do this in php/mySQL? Is the wiki program something I could mod for this, or would it really be easier to just write what I want from scratch?