Simple Website/Database Job and Integration with Aweber(repost)

IN PROGRESS
Bids
4
Avg Bid (USD)
$76
Project Budget (USD)
$30 - $99

Project Description:
Will require Javascript/PHP/mySQL/and HTML. Need a login page coded, psd provided. Need to fix some javascript validation and integrate with Aweber. Detailed requirements below.

## Deliverables

**System Flow Diagram
**

**http://www.gliffy.com/publish/2589131/**

**
**

**Part 1 - Fix vipcode check on index.php**

The vipcheck code check function currently on the page is not sufficient. It loads all the vip codes, puts them into a string, and then checks the vipcode text field against it onSubmit. This in not currently working up to par because the field will accept values that are found in the string.

For example, if the vip codes in the database are (1548,9818,5476,1885) and I enter 1886, it will display an invalid code. However, if I enter 188, it will accept because 188 does exist within the string created from the database codes even though 188 is not a valid vip code. A better solution might be to use an array and check the whole array values. Other robust solutions would also be acceptable.

We need a solution coded where it would prevent these incorrect codes from working.

**Part 2 - Pass and store registrant data user data into Aweber and database**

There are 2 kinds of system users. There are partners and registrants. A partner signs up at http://www.3StepSystem.com/register and is saved in the database in the table called 'users'. Partners has already been programmed. Registrants sign up at http://www.3StepSystem.com using a vipcode they obtained from a partner.

Registrants will need to be saved in a database table called 'registrants'

On our index page we are loading the database table 'users' which contains all the partners information on page load.

As a person fills out the vipcode, javascript will need to be used to pull the information of the partner who's code is entered so it can be passed into aweber.

When a registrant registers, we need to pass the following fields to Aweber.

? registrant email (done)

? partner vipcode(done)

? partner firstname

? partner lastname

? partner phonenumber

? partner email

These need to be saved into Aweber using custom fields. Aweber will then pass these variables back to a thankyou page where they will be pulled from the URL using PHP Get and saved into the database into the table registrants. The registrant table will be constructed as follows.

registrant[id(PK), email address, pvipcode, pfname, plname, pphone, pemail, pid(FK)] **
**

**Part3 - Webinar Login**

We need to create a webinar login page (wlogin.php) where a registrant will go to login to the webinar using their e-mail address. When they submit, they will be redirected to webinar.php. We have designed wlogin.php and the psd is attached. We need this psd converted into the login page.

When the form is submitted, the registrant information will be passed into aweber to a new list called 3ss-webinarview. Again we will need to use custom fields in Aweber. This info will then be passed out of aweber to webinar.php

When the registrant lands on webinar.php, an e-mail will be sent using php mail to the partner who's vipcode they are attached to. This e-mail will confirm that the registrant logged into the webinar and give the date and time of login.

Skills required:
Amazon Web Services, Engineering, PHP, Project Management, Software Architecture, Software Testing, Web Hosting, Website Management, Website Testing
Additional Files: vw_2011___04___07___3SSWebinarLogin_RAC_NameCryptedToProtectYourPrivacy_X201147125220826244570401687848583416483.zip
Hire davidfrey
Project posted by:
davidfrey United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.