Database For testing Site

Cancelled Posted Jul 8, 2008 Paid on delivery
Cancelled Paid on delivery

We are now in need a small database script PHP with MYSQL that? will to do the following:

User will enter? information the system will automatically assign them a? unique ID that we can pass directly to the testing site urls. This link will be added to our shopping as a redirect URL after they have made payment. Admin control panel. See attachement for full specs.

First name

Last name

Email address

?

? Each member will have a unique number that is automatically assigned. The starting number? 100707 and it will increment up.

1. When admin or user enters the information above, an email will go to the user to tell them that they can take the test.

2. An email will go to the admin as well to alert them that this email was sent.

3. The link will be sent to the user and will always have the prefix as below and the script will be adding the unique number at the end: Example this is the link that will be sent to the user with instructions.

## Deliverables

We are now in need a small database script PHP with MYSQL that? will to do the following:

Enter a member's name and email and the system will automatically assign them a? unique ID that we can pass directly to the testing site urls. This link will be added to our shopping as a redirect URL after they have made payment.

? Enter Member's Information

Top of Form

First name

Last name

Email address

?

?

Bottom of Form

?

1. Each member will have a unique number that is automatically assigned. The starting number? 100707 and it will increment up.

2. When admin or user enters the information above, an email will go to the user to tell them that they can take the test.

3. An email will go to the admin as well to alert them that this email was sent.

4. The link will be sent to the user and will always have the prefix as below and the script will be adding the unique number at the end: Example this is the link that will be sent to the user with instructions.

Please find below the link to take the Certified Credit Consultant Exam, you have 70 minutes to answer 65 questions and must have a 90% passing score to be certified. We recommend that you study section 1 and the back of the book for success. These questions are things that credit consultants must know.

[url removed, login to view]**100707**

?

Other examples: **(It will be nice if we can hide this link without showing them the entire link).**

[[url removed, login to view]][1]

[[url removed, login to view]][2]

**Basic admin control panel**

1. Password protected for admin access

2. We need the ability to add 3 URLs in the control panel.

3. 1st URL is for first test URL, Second for Second Test URL, Third is for payment URL link that will be added to the uniqueID and it will be attached. For example: <[url removed, login to view]>= (this is where the unique Id will be attached for a direct link to our test site.

4. The second URL will allow us to use if they failed the test.

5. We need the ability to resend the email to user again if they lost the link

6. We need the ability to delete a user and modify their information

7. Each user information and Id will be displayed

8. When the user take the exam, the admin will be notified by the testing company and we want to go to our control and can click pass or failed

9. If passed, an email will be sent to the user to alert them that they pass and will be mailing their certificate.

10. If the user failed the exam, the admin will click failed and? the user will be will be given a new id and the ability to take the test again with the 2nd URL link automatically.

Here is the email that will be sent to user if they failed:

? ?&#8364;&#339;Please find below the link to take the Certified Credit Consultant Exam again, you have 70 minutes to answer 65 questions and must have a 90% passing score to be certified. If you do no pass this time, you must pay an additional fee to take it again. Noticed that we keep the Id but add a -2 to alert us that this is a 2nd time.?&#8364;

? [[url removed, login to view]$cm_user_id=**100707-2**][3]

[[url removed, login to view]$cm_user_id=100708-2][3]

[[url removed, login to view]$cm_user_id=100709-2][3]

1. If they failed a second time, the user will be deleted out of the system completed but the unique ids will never be used again.

2. An email will be sent to user with a link to pay again. When they pay again from our shopping cart, we will direct them back to this system again to start all over.

Engineering MySQL PHP Project Management Software Architecture Software Testing Web Hosting Website Management Website Testing

Project ID: #3039148

About the project

6 proposals Remote project Active Jul 10, 2008

6 freelancers are bidding on average $105 for this job

hitprem

See private message.

$114.75 USD in 7 days
(43 Reviews)
5.1
saikatewu

See private message.

$102 USD in 7 days
(12 Reviews)
3.8
nibssolutions

See private message.

$101.15 USD in 7 days
(16 Reviews)
4.4
ashishbharti

See private message.

$85 USD in 7 days
(9 Reviews)
2.1
asiomas

See private message.

$127.5 USD in 7 days
(5 Reviews)
1.7
thescriptorg

See private message.

$101.15 USD in 7 days
(2 Reviews)
0.0