Find Jobs
Hire Freelancers

299040 php mysql database, easy?

N/A

Complété
Publié il y a plus de 20 ans

N/A

Payé lors de la livraison
php mysql database. Hi, i'm looking for a new way to do my hockey team stats for me and my friend. We like to look at them and talk about them durring the week, you know, just fun stuff. Since this is a personal thing that i don't have time to do, i'm not looking to spend a whole lot of money, so it doesn't need to be done in 1 day (if that helps on price). I will want more added a later date also, so we can work together more. Please make sure you understand what i want before bidding. I want this done in PHP using mySql as the database, it should be easy & quick for someone who knows this stuff. Right now this is done by hand (html). I would like to get it all in a database so i can manage it better and be able to get better stats in the future, and not have to do so much by hand. Here's the rundown of what i do and what is done. The hockey league i play on is 10 games plus 2 playoff games (if we make the playoffs), so 12 games per season. After each game i put the our team stats, and stats for a few people (me and my 2 good friends). Here are the fields i use. For each season i have: Season # (every season it increases by 1, can also be a letter + #, like g1, w1, s1, etc) Location (the rink name) Season date (start and end dates, mm/dd/yy - mm/dd/yy) Team Name (my team name) Level (what level the league is) Day (day of week it is) For each game i do this: season # Team Name (my team name) game # (1-12) date (date the game is on, mm/dd/yy) time (time of game hh:mm, 12 hour format) opponent (team we play) Win/loss/tie (if we W, L, T) Goals For (GF) (how many goals we get) Goals Against (GA) (how many goals we let up) Game Notes (a link to an HTML file that we type what happened). For each player that i want to do stats for that season i have the following info: Player Name (the name) Season # (season we are in, 1-???) game # (1-12) goals (how many goals that game) assists (how many assists) points (=g+a) (goals + assists) Penalty Minutes (how many minutes in penaltys) This is all i want to put in the database. The i can have a page that shows all of the Season #'s Level, and team name. then when i click one, it pulls up a table that shows the headers Game # - Date - Time - Opponenet - W/L/T - GF - GA - Record - PlayerName - PlayerName - Game Notes or something close to that, then it shows all the stuff. I included a jpg of what it currently looks like (done manually). Please write with any question, or samples, etc. Thanks for your time Brian
N° de projet : 2045160

Concernant le projet

1 proposition
Projet à distance
Actif à il y a 12 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
Décerné à :
Avatar de l'utilisateur
Hi, I have a plenty of free time now. Please look at PMB. Thanks. Sirka
$10 USD en 2 jours
0,0 (0 commentaires)
0,0
0,0

À propos du client

Drapeau de UNITED STATES
El Mirage, United States
5,0
1
Membre depuis juil. 24, 2004

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.