Đang Thực Hiện

158244 Webpage/Database addition

A bit more about the project requirements:

Extensive mySQL knowledge (database architecture)

Knowledge of HTTP Cookies (setting and clearing)

Able to write PHP embedded within HTML

About the project:

We are heavily reliant on your timeframe in your bid. Should you be selected, we will strictly hold you to your schedule.

What we need:

We have a website and forum ([url removed, login to view]) that resides on an apache webserver (using html/php/mysql). We need a few webpages that integrate into our current layout (includes our header and footer and matches our color scheme) in which users can purchase items (via PayPal checkout).

The first page to be designed will have:

-a login form (for returning members)

-a link to another page where new members can register (via a form) and add themselves to a user database

The registration page (for new members) will have:

-a web form that asks for their first name, last name, e-mail address, desired username, desired password, confirmation of password, date of birth

-when a new user has filled out the form, we need to add them to the user database (checking to see if that username is taken, email address is currently in use, etc)

-once the user has successfully registered, they should be directed to the content page

-the user's password should be encrypted/salted

The content page should:

-only be accessed by registered/logged in users (once the user logs in, we should set a cookie that somehow signifies their "permissions"

-based on each user's permissions, they should be able to see information that is pulled down from a database

-also on this page should be a list of items available to purchase(this information should be pulled from a database table) via PayPal checkout ([url removed, login to view], we will provide the PayPal information). Each item should have an "Add to Cart" button, or have a form with check boxes and a "Purchase" button.

-there should also be a log out button which will log the user out and clear all cookies

The administration page should:

-only be available to select members

-not be linked to anywhere on the site (only able to login by manually typing the address)

-have the ability to add/edit/remove (probably from a web form) user permissions (based on what they've purchased)

-be able to add/edit/remove (probably from a web form) database entries (both user and game information)

The game table should have the following fields:

-permission level (probably some sort of bitfield, or a big integer)

-game time (time)

-favoring team (some sort of string)

-game location (some sort of string)

-underdog team (some sort of string)

-time of data entry (time)

-result (boolean)

-description (some sort of string, probably varchar, maximum of 1024 characters)

The user table should have the following fields:

-permission level (should be of the same type in the game table)

-username (some string)

-password (some string, should be encrypted, via salting or other method)

-email address (some string)

-first name (some string)

-last name (some string)

-date of birth (time)

The product table should have the following fields:

-product name (some string)

-product description (some string max of 1024 characters)

-product cost (some USD amount)

-product permission (some number, this number will be added to the user's permissions when they purchase this)

-product owner (some string)

Kĩ năng: Bất kì công việc gì, CSS, MySQL, PHP, An ninh Web, Thiết kế trang web

Xem nhiều hơn: what is database entry, what is a data entry form in a database, webpage layout design, webpage design with php, webpage content, web design color number, underdog design, schedule anywhere, product description of cookies, paypal email confirmation number, paypal architecture design, game design webpage, from where we can write a content to our website, first bit set, data entry web page design, cost of webpage design, cost of webpage, cookies by design, cookie by design, clear a string in c, what is your paypal address, type of cookies, set max schedule, max p, www designed items

Về Bên Thuê:
( 3 nhận xét ) Bremerton, United States

ID dự án: #1904432