Cancelado

Need Mysql/PHP Expert to do some work within 2 hours

Hi, I need somebody to create a page for me that I don't have time to do myself.

It will use PHP and MySQL and Javascript and must be completed within 2 - 2.5 hours, you must be free to do this today as soon as bid is accepted.

See detailed requirements for full details and **please read carefully**

## Deliverables

Hi, I need somebody to create a page for me that I don't have time to do myself.

It will use PHP and MySQL and Javascript and must be completed within 2 - 2.5 hours, you must be free to do this today as soon as bid is accepted.

The page will work like this:

**ONE - There is a dropdown list of hotels**

------

SelectBox1 - This will be a list of hotels and will using the following query:

<?php

$sql = "SELECT title, nid FROM node where type= 'hotel'";

$hotels = mysql_query($sql);

?>

<select name="hotels" id="hotels">

<?php

while($row = mysql_fetch_array($hotels))

{

echo "<option value=\"".$row['nid']."\">".$row['title']."\n ";

}

?>

</select>

----------

**TWO - A user selects a hotel from the dropdown**

When a user selects from this dropdown, the following will happen

----------------------

SelectBox2 - This will be a list of seasons that belong to that hotel, and will use the following mySQL query: It will show the seasons from the database, based on the hotel selected.

mySQL Query like this

SELECT title, nid from node where type = 'season' AND hotel_nid = X (**X will be passed from the selection the user makes for hotel)

------------------

THREE - The user is presented with a form to complete, this pulls data from the database to get a list of rooms, for each room there needs to be a row to enter information.

**There will be a row in the form **for each room** to enter the following:

Dropdown list - options are: "halfboard" or "Bed and Breakfast"

Textbox labelled "Price per night"

Textbox labelled "DUS"

Textbox labelled "3 Bed Discount (Child)"

Textbox labelled "3 Bed Discount (Adult)"

Textbox labelled "4 Bed Discount (Child)"

Textbox labelled "4 Bed Discount (Adult)"

As well as letting them enter this it needs to tell them which room they are entering it for on each row.

When they submit this page it will store the data they typed into the database.

Into a table called "room_prices"

with the following columns:

ID (Unique ID generated auto)

Room_Id (The room ID to indicate which room the price was entered for)

Season_Id (The season ID - This is taken from the dropdown list populated in SelectBox2)

Board (This is the value stored in the dropdownbox either "halfboard" or "bedandbreakfast")

Price (This is entered from the price per night textbox as a double or float)

DUS (This is the value entered in the DUS textbox and will be a double or float)

discount_3bed_child

discount_3bed_adult

discount_4bed_child

discount_4bed_adult (All the discount values are stored as an int based on their related text fields on the form)

The table to store the prices must use the field names specified above.

You wil need to recreate the tables described above to make sure this is working. It isn't difficult and most of the sql is already there, I just don't have time to complete this and need it done very quickly.

If you can not deliver in the 2 - 2.5 hours timeframe please do not bid

Habilidades: Amazon Web Services, Javascript, MySQL, PHP, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website, XML

Ver mais: work values, sql query to get list of database, sql create table price, do you work, node mysql, javascript and mysql, work to do, to do list, php expert with 10, one night show, NID, mysql query, Mysql php, mysql dropdown, mysql and sql, full node, dus, Do some work, php room, use php, php form dropdown list, php user generated, hotel name list, hotel price database, time today php

Acerca do Empregador:
( 4 comentários ) United Kingdom

ID do Projeto: #3037060

2 freelancers estão ofertando em média $85 para este trabalho

solutionvw

See private message.

$42.49 USD in 14 dias
(14 Comentários)
5.3
indyamail

See private message.

$127.5 USD in 14 dias
(0 Comentários)
0.0