Closed

PHP/MySQL project

This project received 6 bids from talented freelancers with an average bid price of $42 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
6
Project Description

Very quick PHP/MySQL project, should be finished in the next hour after approved by the coder:

We need one page with on top of it 2 drop-down list and 2 buttons (submit, reset)

The first drop-down list will contain following values: Observer and Witness. The second drop-down list will contain following values : province, circonscription, etd, site.

We have 8 tables with nearly the same structure:

v_obs_circonscription (circonscription, ANDEKA, BOMBOLE, KABILA, KAKESE, KAMERHE, KASHALA, KENGO, MBUSA, MOBUTU, MUKENDI, TSHISEKEDI)
v_obs_etd (etd, ANDEKA, BOMBOLE, KABILA, KAKESE, KAMERHE, KASHALA, KENGO, MBUSA, MOBUTU, MUKENDI, TSHISEKEDI)
v_obs_province (province, ANDEKA, BOMBOLE, KABILA, KAKESE, KAMERHE, KASHALA, KENGO, MBUSA, MOBUTU, MUKENDI, TSHISEKEDI)
v_obs_site (site, ANDEKA, BOMBOLE, KABILA, KAKESE, KAMERHE, KASHALA, KENGO, MBUSA, MOBUTU, MUKENDI, TSHISEKEDI)
v_wit_circonscription (circonscription, ANDEKA, BOMBOLE, KABILA, KAKESE, KAMERHE, KASHALA, KENGO, MBUSA, MOBUTU, MUKENDI, TSHISEKEDI)
v_wit_etd (etd, ANDEKA, BOMBOLE, KABILA, KAKESE, KAMERHE, KASHALA, KENGO, MBUSA, MOBUTU, MUKENDI, TSHISEKEDI)
v_wit_province (province, ANDEKA, BOMBOLE, KABILA, KAKESE, KAMERHE, KASHALA, KENGO, MBUSA, MOBUTU, MUKENDI, TSHISEKEDI)
v_wit_site (site, ANDEKA, BOMBOLE, KABILA, KAKESE, KAMERHE, KASHALA, KENGO, MBUSA, MOBUTU, MUKENDI, TSHISEKEDI)

All the columns ANDEKA, BOMBOLE, KABILA, KAKESE, KAMERHE, KASHALA, KENGO, MBUSA, MOBUTU, MUKENDI, TSHISEKEDI are numbers

When one selects from the 2 drop-down menus, the following tables should be read:
Observer + Province = v_obs_province
Observer + circonscription = v_obs_circonscription
Observer + etd = v_obs_etd
Observer + Site = v_obs_site
Witness + Province = v_wit_province
Witness + circonscription = v_wit_circonscription
Witness + etd = v_wit_etd
Witness + Site = v_wit_site

And the content of the corresponding table should be displayed. At the bottom of the table, under the columns ANDEKA, BOMBOLE, KABILA, KAKESE, KAMERHE, KASHALA, KENGO, MBUSA, MOBUTU, MUKENDI, TSHISEKEDI, one should have the sum of the corresponding columns.

When first accessing the page, no content should be displayed except the drop-down lists and the buttons.

The page shouldn't be very blank, put some style in it so it can look good.

Prepare variables for the database connection details so we can change them ourselves.

No bid of more than 30 USD please.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online