Devam Ediyor

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

Beceriler: Elektronik Formlar, HTML, MySQL, PHP

Daha fazlasını görün: query excel, php form mysql, html data query, working from, working target, usd 305, time complexity, star alliance, sample programme, purchase skills, programme sample, post star, n query, hand coding html, guess sheets, grid html, free php coding, free mysql server, excel source, build skills, build mysql query, build direct, anything dollar, alliance data, dollar business

İşveren Hakkında:
( 1 değerlendirme ) Victoria, Canada

Proje NO: #730633

Seçilen:

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 Daha fazlası

15 gün içinde 300$ USD
(1 Değerlendirme)
3.8

40 freelancer bu iş için ortalamada 415$ teklif veriyor

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

in 7 gün içinde450$ USD
(477 Değerlendirme)
8.9
SigmaVisual

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

in 5 gün içinde325$ USD
(241 Değerlendirme)
7.8
BestWeb4U

Hi, please check the PMB. Thanks!

in 5 gün içinde320$ USD
(184 Değerlendirme)
7.6
USAGraphicPR0

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

in 10 gün içinde750$ USD
(45 Değerlendirme)
7.6
abraham66

check pmb pls

in 7 gün içinde350$ USD
(97 Değerlendirme)
6.8
arnab0143

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

in 2 gün içinde260$ USD
(72 Değerlendirme)
6.6
freeworks

Please check my PM

in 3 gün içinde400$ USD
(95 Değerlendirme)
6.6
ASYanush

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

in 10 gün içinde400$ USD
(13 Değerlendirme)
6.5
MAnkita

Hello,Please refer your PMB.Thank you.

in 10 gün içinde375$ USD
(50 Değerlendirme)
6.5
agstech123

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

in 10 gün içinde650$ USD
(12 Değerlendirme)
6.3
mrlonganh

Hi , Pls contact me.

in 5 gün içinde300$ USD
(75 Değerlendirme)
6.0
souvikghosh

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

in 5 gün içinde309$ USD
(21 Değerlendirme)
5.7
pegla

hi, check PMB

in 20 gün içinde450$ USD
(20 Değerlendirme)
5.2
m4manas

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

in 10 gün içinde300$ USD
(17 Değerlendirme)
4.8
venkatmca06

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

in 5 gün içinde650$ USD
(21 Değerlendirme)
4.8
anjeko

Hello, Please read my PM Regards Jerry

in 5 gün içinde550$ USD
(3 Değerlendirme)
4.5
albariconsulting

please check PMB for details

in 30 gün içinde1000$ USD
(2 Değerlendirme)
4.3
athenainc

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

in 7 gün içinde700$ USD
(1 Değerlendirme)
3.7
Yurilad

I can help you

in 7 gün içinde270$ USD
(1 Değerlendirme)
3.1
demse

*** satisfaction guaranteed ***

in 2 gün içinde250$ USD
(5 Değerlendirme)
2.5