Sedang Disiapkan

220794 Matching cities in a database

Given an arbitrary and un-structured location like:

Leatherhead, London

Lechlade

Leciester

Ledbury

LEEDS

Leeds, Manchester or Live

LEEK

LEICESTER

Leicester Forest East

Leicestershire

Leigh

Leigh On Sea

LEIGHTON BUZZARD

Lemington

LEMINGTON SPA

Lenzie

Leominster

Letchworth

LETCHWORTH GARDEN CITY

Levenshulme, Manchester

North West / Wales

North West London

North Yorkshire

North, Midlands

PARK ROYAL, LONDON

OLD TRAFFORD, MANCHESTER

Oxshott, Sunningdale

Riyadh, Kingdom of Saudi

South Yorkshire

Wales, South West, Midland

ilmslow, Knutsford, Crew

and a mysql table of cities in England, Wales and Scotland, populated with values like

('Barnehurst North', 'Bexley' , 'Greater London' ),

('Bassingbourn', 'South Cambridgeshire' , 'Cambridgeshire' ),

('Mortimer', 'West Berkshire' , '' ),

('Fallowfield', 'Manchester' , 'Greater Manchester' ),

('Eastbrook', 'Barking and Dagenham' , 'Greater London' ),

('Halsall', 'West Lancashire' , 'Lancashire' ),

write a script, which takes de location value, finds the best match possible in the database, and returns a city.

Please use your judgement on what best match is likely to be

I will supply the mysql files with the cities, and a fuller list of arbitrary inputs to test the script.

Kemahiran: Semua Boleh, MySQL, PHP

Lihat lebih lanjut: value city, scotland php, park west, old database, Wales, scotland, saudi, royal, Riyadh, old west, leigh, greater london, east london, crew, berkshire, structured database, write test script, database spa, arbitrary, yorkshire, south wales, matching mysql script, database list saudi, west midlands database, best match

Tentang Majikan:
( 163 ulasan ) London, United Kingdom

ID Projek: #1967028