: I want to create a database for keeping work information in that accessable via login for adding to and editing (publicly viewable though) and information entered using a very simple and easy to use form like thing. If possible, I want this to be both something I can have running on a webpage and something I can run off my flash drive (so we can update it from netless work), with a way to import/export updated information between the two. Most import, as the information is added (and new enteries made) for pages containing that information to automatically update/generate.
If there's anyone willing to help or what not, it would be more than appreciated, but for the most part I'm really just looking for advice and tips from anyone who knows even a bit more than me on what's plausable and what to start looking into and learning to make this happen
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -Attempting to explain further, but probably just going to sound even more confusing
: The only thing that's really popping to mind for me is something that basically has all the information stored on a spreadsheet (or two or three) and page templates setup to replace specific spots on the page with type spreadsheet information (probably something that could be done with CSS or whatnot, but I really have no fucking clue XD).
If this helps things make anymore sense at all, this will be a database of all the horses, other animals, and staff at the farm(s). Each section (horses/other/staff) with have different information sections and different page layouts. With each entry for an animal/person there will most likely be multiple pages involved (at least for the horses). For example, here's what I have sketched out for the horse template so far:Main Page/Profile: Horse
- - -
The blue sections with the black x's through them represent pictures while black represents text only areas.
Not to scale; just for reference.
A: Main profile picture of the horse.
B: Contains most of the Horse's basic information - Name, Age, Birthdate, Birthplace, Height, Weight, Current Location, etc... Height and Weight would be linked to the Height and Weight history section of the horse's medical page and if dead, age would be replaced with 'Deceased'.
C: Thumbnails of any other pictures, each linked to the fullsize version (opens in new window, doesn't replace profile picture) and this section scrolls right and left.
D: Text Link to the Lineage and Offspring page.
E: Text Link to the Medical/Health History Page.
F: Link to the Training History Page.
G: Link to the Race/Comeptition Information Page.
H: Scrollable text box of the Horse's personality descriptions.
I: Scrollable text box of the Horse's Physical Traits.
J: A Scrollable text box for special notes.Lineage/Offspring Page
- - -
The Lineage portion will only go back to grandparents. It would be nice if by adding the Sire or Dam here automatically added this horse to the Sire/Dam's offspring (and vice versa), but not necessary.
A: Horse's Sire: Main picture with Sire's name underneat (linked to Sire's profile if available).
B: Horse's Dam: " "
C: Sire's Sire: " "
D: Sire's Dam: " "
E: Dam's Sire: " "
F: Dam's Dam: " "
G: List of Offspring: I haven't decided whether to do this in text only with names linked to the Offsprings profile, or thumbnails of the Offspring's Main pic linked to it's profile in a side scrollable bar much like section C of the main profile. Probably going to go text since the picture way leaves no room for osspring that don't already have a profile or any pictures.Medical/Health Page
- - -
A: Medical History scrollable text box.
B: Family Medical History scrollable text box: This is one of those things that would be cool if it automatically took the information from the Sire, Dam, etc.. Medical history section and listed it here, but not necessary.
C: Status on basic health care aspects: This includes a bunch of different section much like section B of the Main Profile for when they were last shoed, trimmed, wormed, had a vet check, etc...
D: Scrollable list of Height, Weight, Tempurature, and date checked on, sorted by date with the most recent on top.
E: A scrollable text section for any additional info.Training History Page
- - -
A: Scrollable text box for current training.
B: Scrollable text box for past training.
C: Side scrollable bar with thumbnails of staff members main picture that have trained or are currently training this particular horse (so once again, something much like the section C of the main profile page).
D: Scrollable text box for things that need to be worked on.
E: Scrollable textbox for additional notes.Competition/Race Information Page
- - -
A: Winning/Awards: Scrollable text box listing winnings and awards by most recent with the Event Name, Location, Date, Jockey/Rider, Event and Win description.
B: Current Competition/Race schedule: Scrollable text box listed by soonest first with Event Name, Location, Description, Date, Horse Number, and Jockey/Rider.
All of these pages would be for just one horse. So for inputing and editing the information, I would want myself and my co-workers tobe able to login into the database, be able to click on something like 'add horse', 'add animal', 'add staff', or and edit button which lets them select from drop down menus categoried by type (or better yet/in addition to an edit button on the main profile page once logged in). The edit/add page would be the same (except of course the edit page would already have any pre-entered information) and be a very simple form like think where everything can jsut be entered in, pictures added (main picture selected from picture uploaded from here), and so forth. Very very very simple and easy to understand from looking at. One of the co-workers is over the top computer illiterate XD
So yes... help, advice, clarifying questions...?