327320 Php/Mysql Functioning Website

This project was awarded to zsun for $50 USD.

Get free quotes for a project like this
Project Budget
Total Bids
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.



Awarded to:

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