Find Jobs
Hire Freelancers

displaying sql results on web page

$10-30 USD

Completed
Posted over 10 years ago

$10-30 USD

Paid on delivery
I want people to choose from drop down menu characteristics of product and based on chosen characteristics get result (which is price). [Example] We have three different types of bags that comes in three sizes So that we have following PRODUCTS table in SQL: Type Size Price Product1 Big 150 Product1 Medium 125 Product1 Small 100 Product2 Big 250 Product2 Medium 225 Product2 Small 200 Product3 Big 350 Product3 Medium 325 Product3 Small 300 Products come in different colors and materials. So that we have two more SQL tables. Colors and materials affect prices. So final price depends on chosen color and material. SQL Table COLORS: Color Price adjustment Color1 5% Color2 10% Color3 15% SQL Table MATERIALS: Material Price adjustment Material1 5% Material2 10% Material3 15% [Task] Web page contains four drop down menus and three free cells: Dropdown menu 1: site visitor chooses Product type Dropdown menu 2: site visitor chooses Size Dropdown menu 3: site visitor chooses Color Dropdown menu 4: site visitor chooses Material Free cell 1: name of site visitor Free cell 2: email of site visitor Free cell 3: age of site visitor (let us put this as dropdown menu too please) After choosing all product parameters and filling data into free cells site visitor presses button “Get result”. Button is only clickable if all cells are filled (alternatively we just can say, that result will be displayed only if all free cells are filled and choice from dropdown menu is made). After clicking button: A - new web page pops up with table of results __________________________________ Product type: Product 2 Product size: Big Product color: Color3 Product material: Material1 Product price: 302 __________________________________ * Not need to display following on page. This is to show how 302 is obtained in example: ROUND [(Product2 Big) * (1 + Color3) *(1 + Material1)] = ROUND [250 * (1 + 15%) * (1 + 5%) ]= ROUND [ 301,88 ] = 302 B – email message is sent to site visitors email address with the content of popped up web page Sql tables should be protected with password – “ABCXYZ” All tables are not real. So I am asking to do this task to use it as example for me. I will be doing real tables myself. I ask you to show all codes (php/html5/?) so that I can just replace tables names in coding and use code to create web pages.
Project ID: 4929967

About the project

9 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, First of all thanks for posting this project, I am available to provide you economical services for web development , I have read and understood all of project details. I am expert in software development and completed nice big projects on freelancer with good rating, you can see on my profile. Looking forward for your response. References are also given in PM.
$24 USD in 3 days
4.7 (26 reviews)
5.4
5.4
9 freelancers are bidding on average $91 USD for this job
User Avatar
Lets do this!
$157 USD in 2 days
4.8 (114 reviews)
6.8
6.8
User Avatar
ready to start right now..
$166 USD in 3 days
4.8 (42 reviews)
5.8
5.8
User Avatar
Hello We together can complete this task.. I may also teach you some basics of php..so can roll on.. Hoping for ur reply...
$40 USD in 2 days
4.9 (18 reviews)
5.5
5.5
User Avatar
I can do this. Check PM
$25 USD in 3 days
4.7 (12 reviews)
4.2
4.2
User Avatar
Please let me finish it for you. I am ready to work now.
$122 USD in 2 days
4.1 (18 reviews)
4.4
4.4
User Avatar
Dear Customer! I am an expert PHP developer with over 7 years of experience and very interested to work on this project. Available to start immediately and finish as soon as possible. My bid is for fast professional service exciting my customers. Please contact in PMB to discuss details. Best Regards, Mark
$25 USD in 1 day
1.8 (7 reviews)
3.6
3.6
User Avatar
Please see the Private Message.
$111 USD in 3 days
0.0 (0 reviews)
1.3
1.3

About the client

Flag of KAZAKHSTAN
Almaty, Kazakhstan
0.0
0
Payment method verified
Member since Jul 11, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.