In Progress

Build PHP/MySQL query form from Excel data-base

I have data currently stored in an Excel file.

The data consists of a grid of dollar values for varous round-the-world fares according to:

Airline Alliance (4:- Star Alliance; OneWorld (x2 versions); SkyTeam)

Class of service (2:- Economy; Business Class)

Length of trip (3 or 4 'fare bands' per alliance per class)

Country of purchase/origin of travel (total of 211 jursidictions)

The consolidated data in the final worksheet thus comprises around 7000 cells (many are identical and some are nul (no service provided for certain originating countries and/or fare-bands)

What I require is to have the data converted into a searchable database that will drill down to provide the resultant value of a query for any combination of variables (Alliance/Class/Length/Country). The programme will have to be able to have the data updated easily from the source Excel worksheet by someone (myself!) who has no coding skills (and no understanding of what goes on 'under the hood'). Query responses are to be displayed in an html form on my website (not yet constructed, pending the outcome of of this post). My server is updated to PHP/MySQL version 5.

I am taking a wild guess at the complexity and time required to provide this service so please feel free to bid under and over the target budget.

If you have done anything similar to this please direct me to any projects that I could view.

If you have suggestions or ideas that could improve the functionality of this project, feel free to bring them to my attention. I will appreciate any hand-holding you can provide!

Sample Excel file and Query form suggestions attached below if you need them to figure out what I'm after. In the Excel file the data you will be working from are on sheets 2 and 3 (tabbed 'USD Y [economy class] all fares' and 'USD C [business class] all fares'. Good luck!

Cheers, Barry

Skills: Electronic Forms, HTML, MySQL, PHP

See more: query excel, php form mysql, html data query, working from, working at target, what is time complexity in c, what is time complexity, usd 305, time complexity in c, time complexity, the post star, star alliance, sample programme, purchase skills, programme sample, post star, php and mysql free projects, out source coding, n query, html 5 grid, hand coding html, guess who sheets, grid html 5, free php coding, free mysql server

About the Employer:
( 1 review ) Victoria, Canada

Project ID: #730633

Awarded to:

stefancutrei

Dear Sir, My name is Stefan and I'm a Romanian programmer. I find this project interesting and I think that it matches my skills. In order to complete it in a short time I will need more information about the projec More

$300 USD in 15 days
(1 Review)
3.8

40 freelancers are bidding on average $415 for this job

lightcresent

Expert in doing this sort of stuff... No upfront needed, all payments through GAF Milestone Payment (Escrow).. Online 16 Hours a day, Can start right away.. Thanks

$450 USD in 7 days
(477 Reviews)
8.9
SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

$325 USD in 5 days
(241 Reviews)
7.8
BestWeb4U

Hi, please check the PMB. Thanks!

$320 USD in 5 days
(184 Reviews)
7.6
USAGraphicPR0

****************************************************************.. YOUR SEARCH ENDS HERE .. ****************************************************************** GET IT DONE RIGHT THE FIRST TIME! Hello Sir/Ma'am, I look f More

$750 USD in 10 days
(45 Reviews)
7.6
abraham66

check pmb pls

$350 USD in 7 days
(97 Reviews)
6.8
arnab0143

--Hello Sir, Please check your pm. Thanks.--

$260 USD in 2 days
(72 Reviews)
6.6
freeworks

Please check my PM

$400 USD in 3 days
(95 Reviews)
6.6
ASYanush

Good day! We are the team of developers from Eastern Europe. We can do this job. Thank you!

$400 USD in 10 days
(13 Reviews)
6.5
MAnkita

Hello,Please refer your [url removed, login to view] you.

$375 USD in 10 days
(50 Reviews)
6.5
agstech123

Hi, please check PMB to know more about our technical expertise and capabilities. Regards, Ricku Lohar

$650 USD in 10 days
(12 Reviews)
6.3
mrlonganh

Hi , Pls contact me.

$300 USD in 5 days
(75 Reviews)
6.0
souvikghosh

Sir, I think I stand a chance here! Please view PM for details!

$309 USD in 5 days
(21 Reviews)
5.7
pegla

hi, check PMB

$450 USD in 20 days
(20 Reviews)
5.2
m4manas

Hi there Berry, I will be able to deliver you a project as per your specification. Please see PM. regards,

$300 USD in 10 days
(17 Reviews)
4.8
venkatmca06

------ Kindly check my BMP ----------

$650 USD in 5 days
(21 Reviews)
4.8
anjeko

Hello, Please read my PM Regards Jerry

$550 USD in 5 days
(3 Reviews)
4.5
albariconsulting

please check PMB for details

$1000 USD in 30 days
(2 Reviews)
4.3
athenainc

Detailed explaination and value additions. Please check Inbox for details.

$700 USD in 7 days
(1 Review)
3.7
Yurilad

I can help you

$270 USD in 7 days
(1 Review)
3.1
demse

*** satisfaction guaranteed ***

$250 USD in 2 days
(5 Reviews)
2.5