Em Andamento

Create Three Dropdown Lists using HTML/PHP and Ajax

**Three Dropdown Lists and Submit Button:**

* Country

* Region

* City

**Region changes based on country and cities changes based on region. If country doesn't have region then cities loads based on country.

If user click submit, show the city name on label.** **

All the above should not cause full postback page, postback partially, so i guess its Ajax or jQuery, i don't know.** **

Language: PHP**

**THAT'S IT

**

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

I have the SQL table schema and the appropriate queries ready.

**Here is the database, it is in T-SQL, you could tweak it for MySQL (don't change the design):**

CREATE TABLE Country

(

countryID int IDENTITY (5,3) PRIMARY KEY,

countryName nvarchar(50) NOT NULL

);

CREATE TABLE Region

(

regionID int IDENTITY (8,3) PRIMARY KEY,

countryID int NOT NULL REFERENCES Country(countryID),

regionName nvarchar(20) NOT NULL

);

CREATE TABLE City

(

cityID int IDENTITY (11,3) PRIMARY KEY,

regionID int NOT NULL REFERENCES Region(regionID),

cityName nvarchar(40) NOT NULL

);

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

**Note:** countries that don't have region, put region name as: "------" 6 dashes.

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

**

SQL Queries**

Get cities based on selected region:

SELECT * FROM City WHERE regionID = ##

Get regions based on selected country:

SELECT * FROM Region WHERE countryID = ##

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

## Deliverables

**If you need more clarification, let me know.**

Habilidades: CSS, Engenharia, PHP, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website, XML

Ver mais: dropdown lists html, php create table, php ajax sql, html 5 submit, html 5 regions, create table php, postback, php jquery ajax, mysql dropdown, html php, dropdown, dropdown select, design using html, country dropdown city, button html jquery, create schema mysql, mysql create schema, html create table, create table html, submit dropdown jquery, create table using, jquery create button, mysql php jquery table, mysql create table, select dropdown

Acerca do Empregador:
( 15 comentários ) Canada

ID do Projeto: #3013527

Premiar a:

w3worker

See private message.

$2 USD em 14 dias
(13 Avaliações)
4.6

4 freelancers estão ofertando em média $5 para este trabalho

rajanbhadauria

See private message.

$5.95 USD in 14 dias
(14 Comentários)
4.2
shahid864

See private message.

$5.95 USD in 14 dias
(32 Comentários)
3.1
maheshmorevw

See private message.

$5.95 USD in 14 dias
(3 Comentários)
0.0