Đã hoàn thành

151476 Custom php/mySQL script

I require a complete website built. I will supply images and text

content, as well as a description for the layout for most pages.

1: Main index page: this will have specified images & content on the

left, and a box on the right for a user to enter a 'PIN' for a prize

code, along with an image verification code to prevent automated bots

from submitting the form.

Upon entering a code, a query should be made to a DB, containing 10000

records (I will supply DB in excel format) If a match is found for the

PIN number, a corresponding Prize page should be displayed (there will

be 10 different prize pages, I will supply images and content for each

page) If no match is found, an error page should be displayed. Once a

PIN has been entered and claimed, it should be marked in the DB as

already used, and if another user tries to enter that PIN in the future,

it should be rejected indicating an error page that says it is already

claimed (I will supply text for this page too)

On the prize pages, the user will be asked for contact information,

which should be written to a winners database, along with their winning

PIN number, and corresponding prize number. Also the current date/time.

The user should receive a standard confirmation page after submitting

the form.

2: Distributor Registration: This page will be a standard form, where

information collected will be written to a Distributors table in the DB.

3: Distributor Rebate page: This page will allow distributors to log

in using a username/password. Once in, there should be a place for

distributor to enter up to 10 PIN numbers. Upon submit, the script

should verify that PIN numbers exist in prize table, and what each prize is. If a PIN number matches one in DB, that prize & PIN number should be written to a Distributors Rebate table, assigned to that distributor login ID and the PIN should be marked as used in the prize DB. A results page should be displayed, showing which of the PIN numbers entered match the Prize DB, and the associated prize for that PIN. If a PIN does not match, it should show the PIN number entered on the results

page, and indicate that it does not match any prize. The prizes will be dollar amounts, and the results page should show the total amount of all prizes won based on the PIN numbers entered.

4: No Purchase Contest Entry Page: This page will be a form (including image verification link to prevent submit) Fields should be written to a No Purchase Table upon submit, including a unique field identifier number for the record. After successful submit, a confirmation page should be displayed, showing the information they entered, and allowing them to edit any errors, after final submit, a success page should be displayed.

5: Admin area: Admin should be able to search and display records from each individual table (Distributor Registration Table, Distributor Rebate Table, No Purchase entries table, and Winners table) Admin should also be able to export the search results they are viewing into

an excel format file.

Kĩ năng: Bất kì công việc gì, MySQL, Perl, PHP

Xem nhiều hơn: prize login, php verify, php to excel export, custom number format in excel, contest code, code winners, code contest, c code contest, 4 tries, enter prize, index php id, up to 10 winners, mysql index, export php, export mysql, contest image, excel log database, mysql code search, code script link description, format php code, user registration login script php mysql, mysql search area code, php code entry mysql database, mysql login password, mysql excel export

Về Bên Thuê:
( 47 nhận xét ) Mississauga, Canada

ID dự án: #1897656

Được trao cho:

$250 USD trong 8 ngày
(0 Đánh Giá)