Horse racing database - preferably using mysql and php
$100-500 USD
Cancelado
Publicado hace alrededor de 12 años
$100-500 USD
Pagado a la entrega
PLEASE QUOTE "LOCK IT IN EDDIE" IN YOUR BID SO I KNOW YOU ARE GENUINE
I need a database created with a front end for my website.
I have a rudimentary knowledge of MySQL and PHP, and have used them to build my own horse racing results database. However I don't have the knowledge to create what I need here. Therefore, I'd like it created using MySQL and PHP.
I am familiar with editing PHP code and using PHPmyadmin, so I'm happy enough to enter information in the back end, however if it is easy I would like everything to be done thru the front end, ie on the website.
## Deliverables
**WHAT I WANT TO DO**
**1. Horse Profiles**
I want to be able to search for horses by name, to bring up their information, and I want to be able to edit this information from the front end:
HORSE NAME
Racing Style: comments
Likes: comments
Dislikes: comments
Raceday Comments: I want the ability to add a new comment and have them come up ordered with most recent at the top.
**2. Raceday Reports**
I want the ability to enter the fields (which can be found by selecting a race meeting on [login to view URL] - I can explain further if needed) - most likely into a spreadsheet - and combine the raceday information with my horse profiles to produce a report such as:
12.30 - RACE 1 - 1100M MDN
1 - 7622222X - SKI DUBAI - MAX COWEN -BULENT MUHCU (a3) -7 - 58.5KG
Racing style?
Likes?
Dislikes?
2 - 3x2 - ESPRY - PETER LUTTRELL - BRENDON MCCOULL - 11 - 58KG
Racing style?
Likes?
Dislikes?
And so on?
The header line for the race, and the information on each horse would be loaded in from the fields on risa - then the report grabs the racing style, likes and dislikes from the horse profile and displays it underneath.
I'm quite happy to copy/paste the risa fields into a spreadsheet to format it and load it into the backend to produce the report, but I would like the editing required to be of a minimum.
**2. Race Times Analysis**
I want to keep a database of race times with the following information for each race:
TRACK - DISTANCE - CLASS - GOING - RACE TIME - SECTIONAL TIME
I want the ability to produce reports to show race times and sectional times for specific tracks, distances, classes and going - so I can compare times from a certain race to a history of times run under similar conditions.
I require front end capability to select certain conditions to produce these reports, and would like the ability to show different results, such as medians, averages, fastest and slowest times etc - I'd like a bit of guidance on what's actually possible.
I understand this might take a bit of data entry to put the race times and conditions into a spreadsheet to load into the database also.
I'm open to the option of producing just one of the 3 requirements, and working together over a period of time to get what I want sorted.