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