327320 Php/Mysql Functioning Website

Avg Bid (USD)
Project Budget (USD)

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.


Skills required:
Anything Goes, MySQL, PHP, Website Design
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.