Find Jobs
Hire Freelancers

displaying sql results on web page

$10-30 USD

完了済み
投稿日: 10年以上前

$10-30 USD

完了時にお支払い
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.
プロジェクト ID: 4929967

プロジェクトについて

9個の提案
リモートプロジェクト
アクティブ 11年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
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 3日以内
4.7 (26 レビュー)
5.4
5.4
この仕事に9人のフリーランサーが、平均$91 USDで入札しています
ユーザーアバター
Lets do this!
$157 USD 2日以内
4.8 (114 レビュー)
6.8
6.8
ユーザーアバター
ready to start right now..
$166 USD 3日以内
4.8 (42 レビュー)
5.8
5.8
ユーザーアバター
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 2日以内
4.9 (18 レビュー)
5.5
5.5
ユーザーアバター
I can do this. Check PM
$25 USD 3日以内
4.7 (12 レビュー)
4.2
4.2
ユーザーアバター
Please let me finish it for you. I am ready to work now.
$122 USD 2日以内
4.1 (18 レビュー)
4.4
4.4
ユーザーアバター
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 1日以内
1.8 (7 レビュー)
3.6
3.6
ユーザーアバター
Please see the Private Message.
$111 USD 3日以内
0.0 (0 レビュー)
1.3
1.3

クライアントについて

KAZAKHSTANのフラグ
Almaty, Kazakhstan
0.0
0
お支払い方法確認済み
メンバー登録日:7月 11, 2013

クライアント確認

このクライアントからの他の仕事

website to excel, then excel to website
$10-30 USD
ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。