535215 Web Form Series via PHP and MySQL with Ajax Validation

Fullført Lagt ut Nov 14, 2011 Betales ved levering
Fullført Betales ved levering

Background Summary:

I need a series of Web Form Pages built in PHP/MySQL, that is for someone applying for rental of a car. We will build the webpage, and create the graphic layout, we would need you to do the php backend end, Ajax validation, and create the webpages in CSS from a Photoshop file (simple graphical layout).

The first page of the form will present the user with the following:

1.1 User Application Form

Upon navigating to the start of the web form application process, the user is presented with the starting question / criteria:

Are you the Primary Applicant, or a Co-Applicant?

If the user chooses "Primary Applicant", the application goes to Section 1.2.

If the user chooses "Co-Applicant", the application goes to Section 1.3.

1.2 Primary Applicant process

The user is presented with a series of 8 Form Pages. This form will go thru a series of basic questions (name, address, phone, previous employer, previous address, etc.)....it will go thru 6 pages, and the user should have the ability to go back to previous pages, and the form shall have the previously entered data still populated in the fields, in case the user wants to make changes. Each, if not all fields, will require AJAX validation of type of data entered, required fields, etc.

At the very end of this form, on page 8, after he/she submits, the application needs to create and assign an ACCOUNT NUMBER in the database, in this naming convention: Last Name Initial, First Name Initial, 2 Digit State Abbreviation, and then a 6 digit number (can be incremental in database). For example: David Smith, from the State of California. If he chose "Primary Applicant" and successfully enters all his information, at the very last page after he clicks Submit, it should assign: SDCA000001, and present a welcome page displaying this Account Number, as well as email the user, a welcome message with this account number.

The application should also send a notification email the Admin(s) that an Application has been processed. The list of Admin emails should be configurable in a php config file. The process ends here.

1.3 Co-Applicant Process

If a user chooses "Co-Applicant", the user is presented with a form that asks "Please enter the Primary Applicant Account Number". This "Primary Account Number" was previously created when a previous user applied as a "Primary Applicant".

If the user enters an account number, the application needs to check the database for the entered account number. The user entered number should not be case sensitive. If no such account number exists, present an error page.

This page should also have a "I forgot my account number" link. If chosen, the application goes to Section1.4.

If a valid account number exists, the User is presented with the same Form series as in Section 1.2, However, at the last form page, the application should NOT assign a new Account Number. Instead, it assign / attach the Primary Applicant Account Number, that this user entered at the beginning.

Section 1.4 Forgot Account Number

The user is presented with a page that asks "Enter your email address that was used for the Primary Applicant".

Upon entering and submitting an email address, that application should check the database if the email address exists.

If the email address exists, email the Account Number to the email address, and present a message "Your account number has been emailed to you".

If the email address is not valid (does not exist in the database), present a message "No such user found. Please enter a valid email address".

Section 2.0 - Admin CMS back end

The Application should have a back-end Content Management System area that allows administrators various functionality. This Admin area should have a login/password protected login page.

Upon successful login, the Admin page should display all the records, with sorting ability (date, name, etc.), and the ability to export everything into a MS Excel Spreadsheet.

AJAX CMS CSS Excel Grafisk design MySQL Odd Jobs Photoshop PHP

Prosjekt-ID: #2281152

Om prosjektet

1 bud Eksternt prosjekt Aktiv Jul 11, 2012

Tildelt til:

lettesciaraphel

I am ready to do this series of forms. Thank you.

$300 USD på 5 dager
(0 omtaler)
0.0