327320 Php/Mysql Functioning Website

In Progress

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

Skills: Anything Goes, MySQL, PHP, Website Design

See more: work from home sports, website design with shop, web design competition site, sports gallery web, price list of website design, login page graphics design, james list, graphics design price list, design myself item website, date entry from home, competition web design, competition graphics, competition for website design, club web design, club php, basic website price list, basic 5 page website, html add picture, web design titles, sports graphics design, mysql report, mysql index, modify php website, i want a complete e-commerce website, fixtures

Project ID: #2073127

Awarded to:

zsun

From your description, the web site you are creating is simple. I can set it up very quickly. I don't do graphics very well. But it seems that you are very good at it. Perfect. I am looking forward to working with you.

$50 USD in 7 days
(0 Reviews)
0.0