In Progress

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

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


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



**Part 1 - Fix vipcode check on [url removed, login to view]**

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 [url removed, login to view] and is saved in the database in the table called 'users'. Partners has already been programmed. Registrants sign up at [url removed, login to view] 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 ([url removed, login to view]) 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 [url removed, login to view] 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 [url removed, login to view]

When the registrant lands on [url removed, login to view], 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: Amazon Web Services, Engineering, PHP, Project Management, Software Architecture, Software Testing, Web Hosting, Website Management, Website Testing

See more: php integration html, php codes create form, loading function php, job values, invalid mail address, incorrect address, incorrect email address, html codes create website, fk solutions, email incorrect, email address incorrect, custom confirm javascript, checks mail, info part time job, website database, the vip, load information mysql, invalid project, flow diagram, email pull database, aweber, simple javascript project example, simple date validation javascript, html form javascript load, mysql load text

About the Employer:
( 119 reviews ) United States

Project ID: #3246259

Awarded to:


See private message.

$84.15 USD in 9 days
(162 Reviews)

4 freelancers are bidding on average $76 for this job


See private message.

$84.15 USD in 9 days
(83 Reviews)

See private message.

$51 USD in 9 days
(8 Reviews)

See private message.

$84.15 USD in 9 days
(27 Reviews)