homepage Welcome to WebmasterWorld Guest from 67.202.56.112
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Subscribe to WebmasterWorld
Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
Name and account matching
How to match names and addresses from form input
Tourex




msg:3148654
 2:00 pm on Nov 7, 2006 (gmt 0)

I need to build a PHP/MySQL reservation management system for a client. The client manages reservations for accommodation, tours and a variety of other services. They handle reservations from various tour operators and/or directly from their own website.

Rather than having a collection of reservation records containing disparate unrelated customer names, it would make sense to have a main ‘customer’ database. The problem is how do we ‘match’ the customers from various bookings. We shall have a name and address in the vast majority of cases (and an email case in some, but not all, cases), but we can’t guarantee that the customer or tour operator will have entered/spelled the details exactly the same in any case. We certainly can’t rely on the customer providing a customer or reservation number – in fact they may have booked their accommodation through one of the agencies tour operators and then book car rental and tours directly from the client’s website without realising any connection until they arrive.

Has anyone got any clever ideas of the best way to take form data and reliably match the customer’s details with existing database records?

 

coopster




msg:3148708
 2:41 pm on Nov 7, 2006 (gmt 0)

How about having them select a customer from a pre-determined list (with a search feature that allows them to find any given customer by name or phone number perhaps? That way you can use your serial id to relate keys across the tables.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved