p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

beginning_php thread: RE: first name and last name


Message #1 by Graham.Tritt@B... on Mon, 2 Sep 2002 11:16:03 +0200
>Hi-
>I'm creating a user registration form and was planning 
>on asking people for their first name ($first_name) 
>and last name ($last_name). I would 
>also like to have $full_name at some point 
>in the mySQL database. 
>Bob

What do you do with Kim Lee or John w. O'Hara III ? 
I hope you also allow for people who write their
personal name last and family name first, and 
those with a double first name or last name.
Why not call them forename and surname, it is
less culturally dependent and recognised by
international standards.

Graham



Message #2 by "Bob Dolan" <rdolan@n...> on Wed, 4 Sep 2002 13:48:59
>> >Hi-
>>I'm creating a user registration form and was planning 
>>on asking people for their first name ($first_name) 
>>and last name ($last_name). I would 
>>also like to have $full_name at some point 
>>in the mySQL database. 
>>Bob

>What do you do with Kim Lee or John w. O'Hara III ? 
>I hope you also allow for people who write their
>personal name last and family name first, and 
>those with a double first name or last name.
>Why not call them forename and surname, it is
>less culturally dependent and recognised by
>international standards.

>Graham

We, too, are constructing a registration form using PHP.  We are using 
MySQL to maintain information about invitees, registrants, and attendees. 
Actually, we are converting from a simple HTML form calling a CGI-Perl 
script, so the Name issue is not new to us.  Here's how we plan to do it:

* We store 'first_name', 'last_name', and 'nickname' as fields.  We are 
still debating a 'prefix' field for Mr., Ms., Dr., Prof. and so on. Most 
likely it will be a single selection list box.  [We store that currently 
in our address book.]

* We explain on the reg form that the 'nickname' plus the 'last_name' will 
be what we print on the badge.  This gives the registrant control over the 
name others see.

* We do *not* store 'full_name' as a separate field.  I get real antsy 
about the potential for conflicts between fields with the same or similar 
data. 

* We allow blanks, periods, and hyphens in the name fields.  If F. Scott 
Fitzgerald or Arantxa Sanchez-Vicario choose to register, it's up to them 
to determine where they want to split their name, but they can enter it.  

We are a membership organization, and that is driving the form design.  
Four out of five attendees at events are members.  Our members attend up 
to six events per year.  They have provided clear feedback that they want 
a streamlined registration process.  [We are going to email invitations 
containing individualized urls to make registration a two-click process 
for the invitees.]

Bob too,

  Return to Index