Closed

327320 Php/Mysql Functioning Website

This project was awarded to zsun for $50 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
N/A
Total Bids
1
Project Description



I require a website for my local sports club with a few basic HTML pages. (I can do all the graphics so I just require the structure and database front end)

The website will contain the following Database
- soccerclub
The following tables will be used in this database
- newsitems (with the following fields "title", "fulltext", "picture", "date(autodate that this item is created on)" )
- history (with 2 fields "text" and "picture")
- fixtures (with the following fields "team", "opposition", "venue", "date", "competition")
- Results (There should be a results table with the following fields "team", "opposition", "Venue", "teamscore", "oppscore", "date", "Competition" and "report")
- gallery (with teh following fields, "title", "date". and "image")
- Admins (This should be for users to modify the website. A field for username and password)

The website will contain the following a secure login page that is accessible to admins (in the "admins" table) Once they login there are links to pages that can do the following
- An Admin Index page - Where they see all the options such as
Add / Edit / Remove any entry from the newsitems table
Edit the history text or remove/add picture from the history table
Add/Edit/remove any entry from the fixtures table
Add/Edit/remove any entry from the results table
Add/Edit/Remove any admin from the "Admins" table

The website will contain the following pages that are accessible to all:
Index (home) - a basic html page (which also displays links to the lastest 5 news items from a MySql database. The table should be titled "newsitems")
History - That displays text from a simple 1 table (history)
Grounds - Static page - not database (I can complete this)
News - a list of all the news items (from the table newsitems) titles and preview of the text (when a user clicks on the title the news displays- picture, full text etc)
Fixtures - A basic html page that displays the upcoming fixtures (table fixtures)
Results - A Basic html page that displays the results (table results) When a user clicks on a result all the tables from that entry are displays (match report, goalscorers)
Gallery - A page that displays all the images from the "gallery" table
Shop - That uses a simple table "shop_items". This will not be an e-commerce site so this table will just show a picture, text and price of items
Committe - Static page - not database (I can complete this)
Contact - Static page - not database (I can complete this)

Please inform me if you have any further queries on this. And a note to anyone bidding for this - I only want people who can guarantee they will do a good professional job. I work with web design although I am not so great with MySQL and PHP so please just concentrate on the database and website functionality with the db. I can do the graphics and design of the site myself.

Regards
James

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online