homepage Welcome to WebmasterWorld Guest from 54.166.14.218
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
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

10+ Year Member



 
Msg#: 3148652 posted 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

WebmasterWorld Administrator coopster us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 3148652 posted 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.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved