2 Form fields not being picked up on submit (PHP/MySQL)
Posted: Wed Aug 20, 2003 7:56 am
Hey guys. I've been working on this one off and on for about two weeks. It has me pretty stumped.
In this form, there are two fields which will not save into the database. I have checked the formatting in the table, and the fields are defined as follows
The last two fields are the ones that concern me. I didn't do anything different or fancy with the form besides some basic error-trapping. And, nothing at all with these fields except your old basic input and save.
All fields on the form save just fine except these two. And it beats the heck out of me to figure why.
Can anyone see what I've done wrong? Sorry,but I figure a good sleuth wil need the whole source code and not just the forms.
The actual page can be seen at http://www.kokusaibuhin.com/us_english/e_register.php. You will note that the form is a skeleton for a bilingual site.
I would appreciate another set of eyes on this one.
Also, my next project for this is to make it so that the values are not deleted if the user makes a mistake and triggers an error. I have no idea how to do this either. Input on this issue would be greatly appreciated too.
Thanks
--------------------
SteedVLX
In this form, there are two fields which will not save into the database. I have checked the formatting in the table, and the fields are defined as follows
Code: Select all
member_ship_postal_code VARCHAR(8)
member_ship_pref_prov VARCHAR(25)
member_ship_city VARCHAR(50)
member_ship_address_1 VARCHAR(50)<------
member_ship_address_1 VARCHAR(50)<------All fields on the form save just fine except these two. And it beats the heck out of me to figure why.
Can anyone see what I've done wrong? Sorry,but I figure a good sleuth wil need the whole source code and not just the forms.
Code: Select all
<?php
<?php
require_once('../Connections/kb_conn.php');
include '../includes/common_db.php';
mysql_select_db($database_kb_conn, $kb_conn);
function in_use($userid) {
global $user_tablename;
$query = "SELECT userid FROM $user_tablename WHERE userid = '$userid'";
$result = mysql_query($query);
if (!mysql_num_rows($result)) return 0;
else return 1;
}
function register_form() {
global $userid, $userpassword, $userpassword2, $usercountry, $useremail, $member_make, $member_model, $member_year, $member_comment;
global $user_challenge_phrase, $user_challenge_response, $member_first_name, $member_first_name_furi, $member_first_name_kanji;
global $member_last_name, $member_last_name_furi, $member_last_name_kanji, $member_ship_postal_code, $member_ship_pref_prov;
global $member_ship_city, $member_ship_address_1, $member_ship_address_2, $account_enable, $wishlist_enable, $email_offers;
global $partner_email, $onsale_email, $forum_access, $custom_cruzer_access, $unused_flag8, $unused_flag9, $unused_flag10;
global $unused_flag11, $unused_flag12, $unused_flag13, $unused_flag14, $unused_flag15;
//unused_flag variables will be renamed and implemented as the need arises
global $PHP_SELF;
?>
<title>Member Registration Page</title>
<body bgcolor="#FFFFFF">
<CENTER>
<H3><span id="Layer1" style="position:absolute; width:200px; height:115px; z-index:-1; left: 0; top: 3;"><img src="../images/banner_with_flag_english3.gif" width="800" height="175"></span></H3>
</CENTER>
<span id="Layer2" style="position:absolute; width:799px; height:882px; z-index:0; left: 0px; top: 156px;">
<FORM ACTION="<?php echo $PHP_SELF ?>" METHOD="POST" name="fm_register" id="fm_register">
<DIV ALIGN="CENTER">
<CENTER>
<TABLE WIDTH="790" BORDER="0" align="center" cellpadding="0" cellspacing="0">
<TR bgcolor="#A40404">
<TH height="35" NOWRAP><a href="../e_index.php"><img src="../images/e_home.gif" width="72" height="22" border="0"></a></TH>
<TH height="35" colspan="6" NOWRAP><font color="#FFFFFF" size="4" face="Arial, Helvetica, sans-serif">Create
Your Own KokusaiBuhin Member Account!</font></TH>
</TR>
<tr bordercolor="#FFCC00">
<td height="27" colspan="7" bgcolor="#FFCC00"><font color="#000000" size="3" face="Arial, Helvetica, sans-serif"><strong> <font size="4"> Information
About You:</font></strong></font></td>
</tr>
<tr bordercolor="#FFCC00">
<td width="91" align="center" valign="middle" bgcolor="#CCCCCC"><center>
<font size="2" face="Arial, Helvetica, sans-serif"><strong>Name</strong></font><strong> </strong>
</center>
</td>
<td width="48" align="right" valign="middle" bgcolor="#CCCCCC"><font size="2" face="Arial, Helvetica, sans-serif">Kanji
:</font></td>
<td colspan="3" align="left" valign="middle" bgcolor="#CCCCCC"><font size="2" face="Arial, Helvetica, sans-serif"><strong>Last:</strong>
<input name="member_last_name_kanji" type="text" id="member_last_name_kanji" size="15" maxlength="15">
<strong> First</strong>:<strong>
<input name="member_first_name_kanji" type="text" id="member_first_name_kanji" size="15" maxlength="15">
</strong></font></td>
<td align="center" valign="middle" bgcolor="#FFCC00"> </td>
<td width="229" align="center" valign="middle" bgcolor="#000000">
<div align="center"><font size="2" face="Arial, Helvetica, sans-serif"><strong><font color="#00FFFF">Why
enter your name three different ways?</font><font color="#000000"><br>
</font> </strong></font></div>
</td>
</tr>
<tr bordercolor="#FFCC00">
<td height="29" colspan="2" align="center" valign="middle" bgcolor="#DDDDDD">
<div align="right"><font size="2" face="Arial, Helvetica, sans-serif">Furigana
:</font></div>
</td>
<td colspan="3" align="left" valign="middle" bgcolor="#DDDDDD"><font size="2" face="Arial, Helvetica, sans-serif"> <strong>Last:
<input name="member_last_name_furi" type="text" id="member_last_name_furi2" size="15" maxlength="15">
First:
<input name="member_first_name_furi" type="text" id="member_first_name_furi" size="15" maxlength="15">
</strong><strong> </strong></font></td>
<td rowspan="5" align="center" valign="middle" bgcolor="#FFCC00"> </td>
<td width="229" rowspan="5" align="center" valign="middle" bgcolor="#C5C5C5"><font size="2" face="Arial, Helvetica, sans-serif">KokusaiBuhin
is an International Agent. And, we assist you in acquiring the
BEST accessories "from Around the World". <br>
Due to the international nature of our services, it is necessary to provide
this information in varying forms to different people who may not have
the ability to operate with non-Western script.</font></td>
</tr>
<tr bordercolor="#FFCC00">
<td height="26" colspan="2" align="right" valign="middle" bgcolor="#CCCCCC"><font size="2" face="Arial, Helvetica, sans-serif"><font color="#FF0000" size="3"><strong>*</strong></font>Romaji
:</font></td>
<td colspan="3" align="left" valign="middle" bgcolor="#CCCCCC"><strong><font size="2" face="Arial, Helvetica, sans-serif">Last:
<input name="member_last_name" type="text" id="member_last_name" size="15" maxlength="15">
First:
<input name="member_first_name" type="text" id="member_first_name" size="15" maxlength="15">
</font> </strong> </td>
</tr>
<tr bordercolor="#FFCC00">
<td height="34" colspan="2" align="left" valign="middle" bgcolor="#DDDDDD"><div align="right"><font size="4" face="Arial, Helvetica, sans-serif"><strong><font size="3" face="Arial, Helvetica, sans-serif"><font color="#FF0000">*</font></font><font size="2">E-mail
Address:</font> </strong></font></div>
</td>
<td colspan="3" align="left" valign="middle" bgcolor="#DDDDDD"><font size="4" face="Arial, Helvetica, sans-serif"><strong>
<input name="useremail" type="text" id="useremail" size="50" maxlength="50">
</strong></font> </td>
</tr>
<tr bordercolor="#FFCC00">
<td height="35" colspan="2" align="left" valign="middle" bgcolor="#CCCCCC"><div align="right"><font size="4" face="Arial, Helvetica, sans-serif"><strong><font size="3" face="Arial, Helvetica, sans-serif"><font color="#FF0000">*</font></font><font size="2">Verify
E-mail address:</font> </strong></font></div>
</td>
<td colspan="3" align="left" valign="middle" bgcolor="#CCCCCC"><font size="2" face="Arial, Helvetica, sans-serif"><strong>
<input name="useremail2" type="text" id="useremail2" size="50" maxlength="50">
</strong></font></td>
</tr>
<tr bordercolor="#FFCC00">
<td height="31" colspan="2" align="left" valign="middle" bgcolor="#DDDDDD"><div align="right"><font size="3" face="Arial, Helvetica, sans-serif"><font color="#FF0000" size="5"><strong><font size="3">*</font></strong></font><strong>Country:</strong></font></div>
</td>
<td colspan="3" align="left" valign="middle" bgcolor="#DDDDDD"><font size="3" face="Arial, Helvetica, sans-serif">
<select name="usercountry" size="1">
<option value="Japan">Japan</option>
<option value="Singapore">Singapore</option>
<option value="Hong Kong">Hong Kong</option>
<option value="Malaysia">Malaysia</option>
<option value="Australia">Australia</option>
<option value="US Outer Territories">US Outer Territories</option>
<option value="Other">Other</option>
</select>
</font></td>
</tr>
<tr bordercolor="#FFCC00" bgcolor="#FFFFFF">
<td height="31" colspan="7"><div align="center"><font size="1"><font face="Arial, Helvetica, sans-serif"><strong>All
members will periodically receive the "KB News" E-Bulletin
which will contain information on additional features and
developments at KokusaiBuhin Dot Com as well as developments
in motorcycle customizing from around the world.</strong></font></font></div>
</td>
</tr>
<TR>
<TH height="25" colspan="7" NOWRAP bgcolor="#FFCC33"><div align="left"><font color="#000000" size="3" face="Arial, Helvetica, sans-serif"><strong> <font size="4"> Password-Protect
Your Information: Choose or change your login information</font></strong></font></div>
</TH>
</TR>
<TR>
<td height="24" colspan="2" align="right" valign="middle" bordercolor="#FFCC00" bgcolor="#DDDDDD">
<div align="right"><font size="2" face="Arial, Helvetica, sans-serif"><strong><font color="#FF0000">*</font>Unique
User ID:</strong></font></div>
</td>
<td colspan="3" align="left" valign="middle" bordercolor="#FFCC00" bgcolor="#DDDDDD"><font size="2" face="Arial, Helvetica, sans-serif">
<input name="userid" type="text" id="userid" size="15" maxlength="10">
(10 characters maximum)</font> </td>
<td width="7" align="center" valign="middle" bordercolor="#FFCC00" bgcolor="#FFCC00"> </td>
<td width="229" align="center" valign="middle" bordercolor="#FFCC00" bgcolor="#000000">
<div align="center"><font size="2" face="Arial, Helvetica, sans-serif"><strong><font color="#FFCC00"> <font color="#00FFFF">Choosing
a User Name and Password</font></font><font color="#00FFFF"><br>
</font> </strong></font></div>
</td>
</TR>
<TR>
<td height="26" colspan="2" align="center" valign="middle" bordercolor="#FFCC00" bgcolor="#CCCCCC">
<div align="right"><font size="2" face="Arial, Helvetica, sans-serif"><font color="#FF0000">*</font>Enter
Password:</font></div>
</td>
<td colspan="3" align="left" valign="middle" bordercolor="#FFCC00" bgcolor="#CCCCCC"><font size="2" face="Arial, Helvetica, sans-serif">
<input name="userpassword" type="password" id="userpassword" size="15" maxlength="10">
(10 characters maximum)<strong> </strong></font></td>
<td width="7" rowspan="5" align="center" valign="middle" bordercolor="#FFCC00" bgcolor="#FFCC00"> </td>
<td width="229" rowspan="5" align="center" valign="middle" bordercolor="#FFCC00" bgcolor="#CCCCCC">
<div align="justify">
<p align="center"><font size="2" face="Arial, Helvetica, sans-serif">Choose
a unique username and password that is easy to remember but
will be difficult or impossible for other people to guess. <br>
<br>
Challenge Phrase and Challenge Response will soon be used for automated
email password recovery.</font></p>
</div>
</td>
</TR>
<TR>
<td height="25" colspan="2" align="right" valign="middle" bordercolor="#FFCC00" bgcolor="#DDDDDD"><font size="2" face="Arial, Helvetica, sans-serif"><font color="#FF0000">*</font>Re-enter
Password: </font></td>
<td colspan="3" align="left" valign="middle" bordercolor="#FFCC00" bgcolor="#DDDDDD"><font size="2" face="Arial, Helvetica, sans-serif">
<input name="userpassword2" type="password" id="userpassword2" size="15" maxlength="10">
</font></td>
</TR>
<TR>
<td height="26" colspan="2" align="left" valign="middle" bordercolor="#FFCC00" bgcolor="#CCCCCC"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"><strong>Challenge
Phrase:</strong> </font></div>
</td>
<td height="26" colspan="3" align="left" valign="middle" bordercolor="#FFCC00" bgcolor="#CCCCCC"><font size="2" face="Arial, Helvetica, sans-serif">
<input name="user_challenge_phrase" type="text" id="user_challenge_phrase" size="50">
</font></td>
</TR>
<TR>
<td height="25" colspan="2" align="center" valign="middle" bordercolor="#FFCC00" bgcolor="#DDDDDD"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"><strong>Challenge
Response:</strong></font></div>
</td>
<td height="25" colspan="3" align="center" valign="middle" bordercolor="#FFCC00" bgcolor="#DDDDDD"><div align="left"><font face="Arial, Helvetica, sans-serif"><font size="2">
<input name="user_challenge_response" type="text" id="user_challenge_response" size="40" maxlength="40">
</font></font></div>
</td>
</TR>
<TR>
<TH height="21" colspan="5" NOWRAP bgcolor="#CCCCCC"><font size="2" face="Arial, Helvetica, sans-serif">Please
write this information in a SAFE place.</font></TH>
</TR>
<TR>
<td height="26" colspan="7" bordercolor="#FFCC00" bgcolor="#FFCC00"><font color="#000000" size="3" face="Arial, Helvetica, sans-serif"><strong> <font size="4"> Your
Shipping Information:</font></strong></font></td>
</TR>
<TR>
<td width="91" height="25" align="right" valign="middle" bordercolor="#FFCC00" bgcolor="#DDDDDD">
<div align="right"><font size="2" face="Arial, Helvetica, sans-serif"></font> </div>
</td>
<td colspan="4" align="left" valign="middle" bordercolor="#FFCC00" bgcolor="#DDDDDD">
<center>
<font size="2" face="Arial, Helvetica, sans-serif">Please provide
your exact shipping address below</font>
</center>
</td>
<TH NOWRAP bgcolor="#FFCC33"> </TH>
<td align="center" valign="middle" bgcolor="#000000"><font color="#00FFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>Personal
Information</strong></font></td>
</TR>
<TR>
<td height="24" align="left" valign="middle" bordercolor="#FFCC00" bgcolor="#CCCCCC">
<div align="right"><font size="2" face="Arial, Helvetica, sans-serif"><strong>Post
Code: </strong></font></div>
</td>
<td height="24" colspan="4" align="left" valign="middle" bordercolor="#FFCC00" bgcolor="#CCCCCC"><font size="2" face="Arial, Helvetica, sans-serif">
<input name="member_ship_postal_code" type="text" id="member_ship_postal_code2" size="8" maxlength="8">
</font></td>
<TH height="24" NOWRAP bgcolor="#FFCC33"> </TH>
<td rowspan="4" align="center" valign="middle" bgcolor="#CCCCCC"><font size="2" face="Arial, Helvetica, sans-serif">It
is not necessary to provide this data if you have no plans to make
a purchase directly from<strong> </strong>the<strong> KB </strong> web
site. <br>
For instance, online auction customers do not need to provide this information.</font></td>
</TR>
<TR>
<td height="26" align="left" valign="middle" bordercolor="#FFCC00" bgcolor="#DDDDDD">
<div align="right"><font size="2" face="Arial, Helvetica, sans-serif"><strong>Prefecture: </strong></font></div>
</td>
<td width="48" height="26" align="left" valign="middle" bordercolor="#FFCC00" bgcolor="#DDDDDD"><font size="2" face="Arial, Helvetica, sans-serif">
<input name="member_ship_pref_prov" type="text" id="member_ship_pref_prov2" size="8" maxlength="8">
</font></td>
<td colspan="2" align="center" valign="middle" bordercolor="#FFCC00" bgcolor="#DDDDDD"> </td>
<td width="271" align="left" valign="middle" bordercolor="#FFCC00" bgcolor="#DDDDDD"><font size="2" face="Arial, Helvetica, sans-serif"><strong>City:
<input name="member_ship_city" type="text" id="member_ship_city">
</strong></font><font size="2" face="Arial, Helvetica, sans-serif"> </font> </td>
<TH height="26" NOWRAP bgcolor="#FFCC33"> </TH>
</TR>
<TR>
<td height="29" align="left" valign="middle" bordercolor="#FFCC00" bgcolor="#CCCCCC">
<div align="right"><font size="2" face="Arial, Helvetica, sans-serif"><strong>Address: </strong></font></div>
</td>
<td height="29" colspan="4" align="left" valign="middle" bordercolor="#FFCC00" bgcolor="#CCCCCC"><font size="2" face="Arial, Helvetica, sans-serif">
<input name="member_ship_address_1" type="text" id="member_ship_address_1" size="50" maxlength="50">
</font></td>
<TH height="29" NOWRAP bgcolor="#FFCC33"> </TH>
</TR>
<TR>
<td height="24" align="right" valign="middle" bordercolor="#FFCC00" bgcolor="#DDDDDD"><font size="2" face="Arial, Helvetica, sans-serif"><strong> </strong></font></td>
<td height="24" colspan="4" bordercolor="#FFCC00" bgcolor="#DDDDDD"><font size="2" face="Arial, Helvetica, sans-serif">
<input name="member_ship_address_2" type="text" id="member_ship_address_2" size="50" maxlength="50">
</font></td>
<TH height="24" NOWRAP bgcolor="#FFCC33"> </TH>
</TR>
<tr bordercolor="#000000">
<td height="27" colspan="7" bgcolor="#FFCC00"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><strong> <font size="4"> Advanced
Services: (Optional)</font></strong></font></td>
</tr>
<tr bordercolor="#000000">
<td align="center" valign="middle" bgcolor="#CCCCCC"><font size="2" face="Arial, Helvetica, sans-serif">
<input name="account_enable" type="checkbox" disabled="true" id="account_enable" value="1" checked>
</font>
<td height="21" colspan="4" align="left" valign="middle" bgcolor="#CCCCCC"> <font size="2" face="Arial, Helvetica, sans-serif"><strong>Enable
My Member Account <font color="#339900">(Required)</font></strong></font>
<td align="center" valign="middle" bgcolor="#FFCC33"><div align="justify"><font size="2" face="Arial, Helvetica, sans-serif"><strong> </strong></font></div>
</td>
<td align="center" valign="middle" bgcolor="#000000"><font size="2" face="Arial, Helvetica, sans-serif"><strong><font color="#00FFFF">NOTICE</font></strong></font></td>
</tr>
<tr bordercolor="#000000">
<td align="center" valign="middle" bgcolor="#DDDDDD"> <font size="2" face="Arial, Helvetica, sans-serif">
<input name="wishlist_enable" type="checkbox" id="wishlist_enable" value="1" checked>
</font></td>
<td height="23" colspan="4" align="left" valign="middle" bgcolor="#DDDDDD"><p><font size="2" face="Arial, Helvetica, sans-serif"><strong>Activate
My Personal Wishlist (available Fall/Winter 2003)</strong></font></p>
</td>
<td rowspan="6" align="center" valign="middle" bgcolor="#FFCC33"><font size="2" face="Arial, Helvetica, sans-serif"> </font></td>
<td rowspan="6" align="center" valign="middle" bgcolor="#CCCCCC"><font size="2" face="Arial, Helvetica, sans-serif">Shopping
cart and Wishlist access require complete personal information
to be provided. <br>
Your personal information wil not be divulged to any third party without
your permission.</font></td>
</tr>
<tr bordercolor="#000000">
<td height="23" align="center" valign="middle" bgcolor="#CCCCCC"><font size="2" face="Arial, Helvetica, sans-serif">
<input name="email_offers" type="checkbox" id=="email_offers" value="1" checked>
</font></td>
<td height="23" colspan="4" align="left" valign="middle" bgcolor="#CCCCCC"><font size="2" face="Arial, Helvetica, sans-serif"><strong>E-mail
me with monthly special offers</strong></font></td>
</tr>
<tr bordercolor="#000000">
<td height="25" align="center" valign="middle" bgcolor="#DDDDDD"><font size="2" face="Arial, Helvetica, sans-serif">
<input name="partner_email" type="checkbox" id="partner_email" value="1" checked>
</font></td>
<td height="25" colspan="4" align="left" valign="middle" bgcolor="#DDDDDD"><strong><font size="2" face="Arial, Helvetica, sans-serif">Allow
Email from our trusted partners</font></strong></td>
</tr>
<tr bordercolor="#000000">
<td height="24" align="center" valign="middle" bgcolor="#CCCCCC"><font size="2" face="Arial, Helvetica, sans-serif">
<input name="onsale_email" type="checkbox" id="onsale_email" value="1" checked>
</font></td>
<td height="24" colspan="4" align="left" valign="middle" bgcolor="#CCCCCC"><font size="2" face="Arial, Helvetica, sans-serif"><strong>Email
me when an item on my Wishlist is on sale.</strong></font></td>
</tr>
<tr bordercolor="#000000">
<td height="25" align="center" valign="middle" bgcolor="#DDDDDD"><font size="2" face="Arial, Helvetica, sans-serif">
<input name="forum_access" type="checkbox" id="forum_access" value="1" checked>
</font></td>
<td height="25" colspan="4" align="left" valign="middle" bgcolor="#DDDDDD"><font size="2" face="Arial, Helvetica, sans-serif"><strong>Enable
Forum Access: <font color="#FF0000">(available Summer 2004)</font></strong></font></td>
</tr>
<tr bordercolor="#000000">
<td height="19" align="center" valign="middle" bgcolor="#CCCCCC"><font size="2" face="Arial, Helvetica, sans-serif">
<input name="custom_cruzer_access" type="checkbox" id="custom_cruzer_access" value="1" checked>
</font></td>
<td height="19" colspan="4" align="left" valign="middle" bgcolor="#CCCCCC"><font size="2" face="Arial, Helvetica, sans-serif"><strong>Enable "Custom
Cruzer" Access: <font color="#FF0000">(available Spring
2004)</font></strong></font></td>
</tr>
<TR bgcolor="#FFCC33">
<td height="27" colspan="7"><div align="left"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><strong> <font size="4"> Your
Public Profile:</font></strong></font></div>
</td>
</TR>
<TR>
<td height="21" colspan="5" bgcolor="#DDDDDD"><center>
<strong><font size="3" face="Arial, Helvetica, sans-serif">Tell
us a little bit about your ride. </font></strong>
</center>
</td>
<TD bgcolor="#FFCC00"> </TD>
<TD bgcolor="#000000"><center>
<font color="#00FFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>Public
Information</strong></font><strong> </strong>
</center>
</TD>
</TR>
<TR>
<td height="16" colspan="2" align="right" valign="middle" bgcolor="#CCCCCC"><strong>Year:</strong></td>
<TD width="81" bgcolor="#CCCCCC"><select name="member_year" id="select">
<option value="1990">1990</option>
<option value="1991">1991</option>
<option value="1992">1992</option>
<option value="1993">1993</option>
<option value="1994">1994</option>
<option value="1995">1995</option>
<option value="1996">1996</option>
<option value="1997">1997</option>
<option value="1998">1998</option>
<option value="1999">1999</option>
<option value="2000">2000</option>
<option value="2001">2001</option>
<option value="2002">2002</option>
<option value="2003">2003</option>
<option value="2004">2004</option>
</select>
</TD>
<TD width="63" bgcolor="#CCCCCC"><strong>Make:</strong></TD>
<TD bgcolor="#CCCCCC"> <strong>
<select name="member_make" size="1" id="member_make">
<option value="Harley-Davidson">Harley-Davidson</option>
<option value="Honda">Honda</option>
<option value="Kawasaki">Kawasaki</option>
<option value="Suzuki">Suzuki</option>
<option value="Yamaha">Yamaha</option>
<option value="Other">Other</option>
</select>
</strong></TD>
<TD bgcolor="#FFCC00"> </TD>
<TD rowspan="7" align="center" valign="middle" bgcolor="#CCCCCC"><font size="2" face="Arial, Helvetica, sans-serif">In
addition to your UserID, the information in your public profile
will be visible to other members in the forums and "Custom
Cruzer" areas when they become available to the public.</font></TD>
</TR>
<TR>
<td height="16" colspan="2" align="right" valign="middle" bgcolor="#DDDDDD"> </td>
<TD colspan="2" bgcolor="#DDDDDD"> </TD>
<TD bgcolor="#DDDDDD"> </TD>
<TD bgcolor="#FFCC00"> </TD>
</TR>
<TR>
<td height="16" colspan="2" align="right" valign="middle" bgcolor="#CCCCCC"><strong>Model: </strong></td>
<TD colspan="2" bgcolor="#CCCCCC"><strong>
<input name="member_model" type="text" id="member_model4">
</strong></TD>
<TD align="center" valign="middle" bgcolor="#CCCCCC"> <div align="left"><font size="1" face="Arial, Helvetica, sans-serif"> examples;
VT-600C, NV-400C, SteedVLX etc.</font></div></TD>
<TD bgcolor="#FFCC00"> </TD>
</TR>
<TR>
<td colspan="2" rowspan="4" align="right" valign="middle" bgcolor="#DDDDDD"><font size="3" face="Arial, Helvetica, sans-serif"><strong>Personal
Comments:</strong></font></td>
<TD colspan="3" rowspan="4" bgcolor="#DDDDDD"><font size="3" face="Arial, Helvetica, sans-serif">
<textarea
name="member_comment" cols="60" rows="3" wrap="VIRTUAL" id="member_comment"></textarea>
</font></TD>
<TD bgcolor="#FFCC00"> </TD>
</TR>
<TR>
<TD bgcolor="#FFCC00"> </TD>
</TR>
<TR>
<TD bgcolor="#FFCC00"> </TD>
</TR>
<TR>
<TD height="21" bgcolor="#FFCC00">_</TD>
</TR>
<TR bgcolor="#CCCCCC">
<TH COLSPAN="7" NOWRAP>
<div align="left"><font color="#FF0000" size="5" face="Arial, Helvetica, sans-serif"> *</font><font face="Arial, Helvetica, sans-serif"> =
Indicates a Mandatory Field</font></div>
</TH>
</TR>
</TABLE>
<TABLE WIDTH="790" BORDER="0" align="center" cellpadding="0" cellspacing="0">
<TR bgcolor="#FFFFFF">
<TH width="66%" height="44" NOWRAP> <font size="3" face="Arial, Helvetica, sans-serif">
<INPUT name="SUBMIT" TYPE="SUBMIT" VALUE="JOIN KokusaiBuhin Dot Com">
<img src="../images/t_spacer.gif" width="118" height="20" border="0" align="absmiddle">
<INPUT name="RESET" TYPE="RESET" VALUE="Erase This Form">
</font></TH>
</TR>
<TR bgcolor="#FFFFFF">
<TH NOWRAP> </TH>
</TR>
</TABLE>
<font size="3" face="Arial, Helvetica, sans-serif">
<input type="HIDDEN" name="action" value="register">
</font>
</CENTER>
</DIV>
</FORM>
</span>
<?php
}
function create_account() {
global $userid, $userpassword, $userpassword2, $usercountry, $useremail, $member_make, $member_model, $member_year, $member_comment;
global $user_challenge_phrase, $user_challenge_response, $member_first_name, $member_first_name_furi, $member_first_name_kanji;
global $member_last_name, $member_last_name_furi, $member_last_name_kanji, $member_ship_postal_code, $member_ship_pref_prov;
global $member_ship_city, $member_ship_address1, $member_ship_address2, $account_enable, $wishlist_enable, $email_offers;
global $partner_email, $onsale_email, $forum_access, $custom_cruzer_access, $unused_flag8, $unused_flag9, $unused_flag10;
global $unused_flag11, $unused_flag12, $unused_flag13, $unused_flag14, $unused_flag15;
global $default_dbname, $user_tablename;
if(empty($userid)) error_message("You did not enter your desired User ID!");
if(empty($userpassword)) error_message("You did not enter your desired password!");
if(strlen($userpassword) < 4 ) error_message("Your password is too short! Please enter a password of 5 characters or more");
if(empty($userpassword2))
error_message("Retype your password for verification!");
if(empty($member_last_name)) error_message("Please enter your last name!");
if(empty($member_first_name)) error_message("Please enter your first name!");
if(empty($useremail)) error_message("Please enter your email address!");
if(empty($member_comment)) $member_comment = "No Comment.";
if($userpassword != $userpassword2) error_message("Your desired password and retyped password do not match!");
$link_id = db_connect($default_dbname);
if(in_use($userid)) error_message("$userid is in use. Please choose a different ID.");
$query = "INSERT INTO user VALUES(NULL, '$userid', password('$userpassword'), '$usercountry', '$useremail', '$member_make', '$member_model', '$member_year', '$member_comment', '$user_challenge_phrase', '$user_challenge_response', curdate(), NULL, '1', NULL, '$member_first_name', '$member_first_name_furi', '$member_first_name_kanji', '$member_last_name', '$member_last_name_furi', '$member_last_name_kanji', NULL, NULL, NULL, NULL, NULL, '$member_ship_postal_code', '$member_ship_pref_prov', '$member_ship_city', '$member_ship_address_1', '$member_ship_address_2', '$account_enable', '$wishlist_enable', '$email_offers', '$partner_email', '$onsale_email', '$forum_access', '$custom_cruzer_access', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)";
global $default_dbname, $user_tablename, $username;
$username = $member_first_name . " " .$member_last_name;
$result = mysql_query($query);
if(!$result) error_message(sql_error());
$usernumber = mysql_insert_id($link_id);
html_header();
?>
<CENTER>
<H3><span id="Layer3" style="position:absolute; width:691px; height:115px; z-index:3; left: 42px; top: 1243px;">
<CENTER>
<H3> <?php echo $username ?>, thank you for registering with us! </H3>
</CENTER>
<DIV ALIGN="CENTER">
<CENTER>
<TABLE WIDTH="90%" BORDER="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#990000">
<TR>
<TH WIDTH="30%" NOWRAP> <div align="right">Member Number : </div></TH>
<TD colspan="3"><?php echo $usernumber ?></TD>
</TR>
<TR>
<TH WIDTH="30%" NOWRAP> <div align="right">Member ID : </div></TH>
<TD colspan="3"><?php echo $userid ?></TD>
</TR>
<TR>
<TH WIDTH="30%" NOWRAP> <div align="right"> Your Password : </div></TH>
<TD colspan="3"><?php echo $userpassword ?> (Please keep in a safe
place)</TD>
</TR>
<TR>
<TH WIDTH="30%" NOWRAP> <div align="right">Full Name : </div></TH>
<TD colspan="3"><?php echo $username ?></TD>
</TR>
<TR>
<TH WIDTH="30%" NOWRAP> <div align="right">Country : </div></TH>
<TD colspan="3"><?php echo $usercountry ?></TD>
</TR>
<TR>
<TH WIDTH="30%" NOWRAP> <div align="right">Correspondence Email : </div></TH>
<TD colspan="3"><?php echo $useremail ?></TD>
</TR>
<TR>
<TH WIDTH="30%" NOWRAP> <div align="right">Comment : </div></TH>
<TD colspan="3"><?php echo htmlspecialchars($member_comment) ?></TD>
</TR>
<TR bgcolor="#FFFFFF">
<TH height="51" colspan="4" NOWRAP><img src="../images/continue.gif" width="156" height="33" border="0" usemap="#MapMap"></TH>
</TR>
</TABLE>
</CENTER>
</DIV>
<map name="MapMap">
<area shape="rect" coords="2,0,155,32" href="../index.php">
</map>
</span></H3>
</CENTER>
<DIV ALIGN="CENTER"></DIV>
<?php
html_footer();
}
switch($action) {
case "register":
create_account();
break;
default:
html_header();
register_form();
html_footer();
break;
}
?>
<map name="Map">
<area shape="rect" coords="2,0,155,32" href="../index.php">
</map>
?>I would appreciate another set of eyes on this one.
Also, my next project for this is to make it so that the values are not deleted if the user makes a mistake and triggers an error. I have no idea how to do this either. Input on this issue would be greatly appreciated too.
Thanks
--------------------
SteedVLX