create_account: data not writing to DB

tfoolen · February 24, 2011

All,

I have added some fields to my DB for the create account page. In one way or another, these fields are not showing up in my DB. If I open my admin, the fields are empty (in the DB itself as well). If I fill them out in the admin, they are writing to the DB. Here's the code with the new fields customers_website, customers_vat en customers_representative:

<?php
/*
 $Id: create_account.php 1739 2007-12-20 00:52:16Z hpdl $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

 require('includes/application_top.php');

// needs to be included earlier to set the success message in the messageStack
 require(DIR_WS_LANGUAGES . $language . '/create_wholesale_account.php');

 $process = false;
 if (isset($HTTP_POST_VARS['action']) && ($HTTP_POST_VARS['action'] == 'process')) {
   $process = true;

   if (ACCOUNT_GENDER == 'true') {
     if (isset($HTTP_POST_VARS['gender'])) {
       $gender = tep_db_prepare_input($HTTP_POST_VARS['gender']);
     } else {
       $gender = false;
     }
   }
   $firstname = tep_db_prepare_input($HTTP_POST_VARS['firstname']);
   $lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']);
   if (ACCOUNT_DOB == 'true') $dob = tep_db_prepare_input($HTTP_POST_VARS['dob']);
   $email_address = tep_db_prepare_input($HTTP_POST_VARS['email_address']);
   if (ACCOUNT_COMPANY == 'true') $company = tep_db_prepare_input($HTTP_POST_VARS['company']);
   $company_tax_id = tep_db_prepare_input($_POST['company_tax_id']);
   $street_address = tep_db_prepare_input($HTTP_POST_VARS['street_address']);
   if (ACCOUNT_SUBURB == 'true') $suburb = tep_db_prepare_input($HTTP_POST_VARS['suburb']);
   $postcode = tep_db_prepare_input($HTTP_POST_VARS['postcode']);
   $city = tep_db_prepare_input($HTTP_POST_VARS['city']);
   if (ACCOUNT_STATE == 'true') {
     $state = tep_db_prepare_input($HTTP_POST_VARS['state']);
     if (isset($HTTP_POST_VARS['zone_id'])) {
       $zone_id = tep_db_prepare_input($HTTP_POST_VARS['zone_id']);
     } else {
       $zone_id = false;
     }
   }
$customers_website = tep_db_prepare_input($HTTP_POST_VARS['customers_website']);
$customers_vat = tep_db_prepare_input($HTTP_POST_VARS['customers_vat']);
$customers_representative = tep_db_prepare_input($HTTP_POST_VARS['customers_representative']);
$customer_connectie = tep_db_prepare_input($HTTP_POST_VARS['customer_connectie']);
   $country = tep_db_prepare_input($HTTP_POST_VARS['country']);
   $telephone = tep_db_prepare_input($HTTP_POST_VARS['telephone']);
   $fax = tep_db_prepare_input($HTTP_POST_VARS['fax']);
   if (isset($HTTP_POST_VARS['newsletter'])) {
     $newsletter = tep_db_prepare_input($HTTP_POST_VARS['newsletter']);
   } else {
     $newsletter = false;
   }
   $password = tep_db_prepare_input($HTTP_POST_VARS['password']);
   $confirmation = tep_db_prepare_input($HTTP_POST_VARS['confirmation']);

   $error = false;

   if (ACCOUNT_GENDER == 'true') {
     if ( ($gender != 'm') && ($gender != 'f') ) {
       $error = true;

       $messageStack->add('create_account', ENTRY_GENDER_ERROR);
     }
   }

   if (strlen($firstname) < ENTRY_FIRST_NAME_MIN_LENGTH) {
     $error = true;

     $messageStack->add('create_account', ENTRY_FIRST_NAME_ERROR);
   }

   if (strlen($lastname) < ENTRY_LAST_NAME_MIN_LENGTH) {
     $error = true;

     $messageStack->add('create_account', ENTRY_LAST_NAME_ERROR);
   }

   if (ACCOUNT_DOB == 'true') {
     if (checkdate(substr(tep_date_raw($dob), 4, 2), substr(tep_date_raw($dob), 6, 2), substr(tep_date_raw($dob), 0, 4)) == false) {
       $error = true;

       $messageStack->add('create_account', ENTRY_DATE_OF_BIRTH_ERROR);
     }
   }

   if (strlen($email_address) < ENTRY_EMAIL_ADDRESS_MIN_LENGTH) {
     $error = true;

     $messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_ERROR);
   } elseif (tep_validate_email($email_address) == false) {
     $error = true;

     $messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_CHECK_ERROR);
   } else {
     $check_email_query = tep_db_query("select count(*) as total from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "'");
     $check_email = tep_db_fetch_array($check_email_query);
     if ($check_email['total'] > 0) {
       $error = true;

       $messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_ERROR_EXISTS);
     }
   }

   if (strlen($street_address) < ENTRY_STREET_ADDRESS_MIN_LENGTH) {
     $error = true;

     $messageStack->add('create_account', ENTRY_STREET_ADDRESS_ERROR);
   }

   if (strlen($postcode) < ENTRY_POSTCODE_MIN_LENGTH) {
     $error = true;

     $messageStack->add('create_account', ENTRY_POST_CODE_ERROR);
   }

   if (strlen($city) < ENTRY_CITY_MIN_LENGTH) {
     $error = true;

     $messageStack->add('create_account', ENTRY_CITY_ERROR);
   }

   if (is_numeric($country) == false) {
     $error = true;

     $messageStack->add('create_account', ENTRY_COUNTRY_ERROR);
   }

   if (ACCOUNT_STATE == 'true') {
     $zone_id = 0;
     $check_query = tep_db_query("select count(*) as total from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country . "'");
     $check = tep_db_fetch_array($check_query);
     $entry_state_has_zones = ($check['total'] > 0);
     if ($entry_state_has_zones == true) {
       $zone_query = tep_db_query("select distinct zone_id from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country . "' and (zone_name = '" . tep_db_input($state) . "' or zone_code = '" . tep_db_input($state) . "')");
       if (tep_db_num_rows($zone_query) == 1) {
         $zone = tep_db_fetch_array($zone_query);
         $zone_id = $zone['zone_id'];
       } else {
         $error = true;

         $messageStack->add('create_account', ENTRY_STATE_ERROR_SELECT);
       }
     } else {
       if (strlen($state) < ENTRY_STATE_MIN_LENGTH) {
         $error = true;

         $messageStack->add('create_account', ENTRY_STATE_ERROR);
       }
     }
   }

   if (strlen($telephone) < ENTRY_TELEPHONE_MIN_LENGTH) {
     $error = true;

     $messageStack->add('create_account', ENTRY_TELEPHONE_NUMBER_ERROR);
   }


   if (strlen($password) < ENTRY_PASSWORD_MIN_LENGTH) {
     $error = true;

     $messageStack->add('create_account', ENTRY_PASSWORD_ERROR);
   } elseif ($password != $confirmation) {
     $error = true;

     $messageStack->add('create_account', ENTRY_PASSWORD_ERROR_NOT_MATCHING);
   }

   if ($error == false) {
     $sql_data_array = array('customers_firstname' => $firstname,
                             'customers_lastname' => $lastname,
                             'customers_email_address' => $email_address,
                             'customers_telephone' => $telephone,
                             'customers_fax' => $fax,
                             'customers_newsletter' => $newsletter,
						  'customers_connectie' => $customer_connectie,
						  'customers_website' => $customers_website,
						  'customers_vat' => $customers_vat,
						  'customers_representative' => $customer_representative,
                             'customers_password' => tep_encrypt_password($password));

     if (ACCOUNT_GENDER == 'true') $sql_data_array['customers_gender'] = $gender;
     if (ACCOUNT_DOB == 'true') $sql_data_array['customers_dob'] = tep_date_raw($dob);
// BOF Separate Pricing Per Customer
  // if you would like to have an alert in the admin section when either a company name has been entered in
  // the appropriate field or a tax id number, or both then uncomment the next line and comment the default
  // setting: only alert when a tax_id number has been given
  //    if ( (ACCOUNT_COMPANY == 'true' && tep_not_null($company) ) || (ACCOUNT_COMPANY == 'true' && tep_not_null($company_tax_id) ) ) {
  if ( ACCOUNT_COMPANY == 'true' && tep_not_null($company_tax_id)  ) {
     $sql_data_array['customers_group_ra'] = '1';
// entry_company_tax_id moved from table address_book to table customers in version 4.2.0
     $sql_data_array['entry_company_tax_id'] = $company_tax_id; 
   }
// EOF Separate Pricing Per Customer
     tep_db_perform(TABLE_CUSTOMERS, $sql_data_array);

     $customer_id = tep_db_insert_id();

     $sql_data_array = array('customers_id' => $customer_id,
                             'entry_firstname' => $firstname,
                             'entry_lastname' => $lastname,
                             'entry_street_address' => $street_address,
                             'entry_postcode' => $postcode,
                             'entry_city' => $city,
                             'entry_customers_website' => $customers_website,
                             'entry_customers_vat' => $customers_vat,
                             'entry_customers_representative' => $customers_representative,
                             'entry_country_id' => $country);

     if (ACCOUNT_GENDER == 'true') $sql_data_array['entry_gender'] = $gender;
     if (ACCOUNT_COMPANY == 'true') $sql_data_array['entry_company'] = $company;
     if (ACCOUNT_SUBURB == 'true') $sql_data_array['entry_suburb'] = $suburb;
     if (ACCOUNT_STATE == 'true') {
       if ($zone_id > 0) {
         $sql_data_array['entry_zone_id'] = $zone_id;
         $sql_data_array['entry_state'] = '';
       } else {
         $sql_data_array['entry_zone_id'] = '0';
         $sql_data_array['entry_state'] = $state;
       }
     }

     tep_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array);

     $address_id = tep_db_insert_id();

     tep_db_query("update " . TABLE_CUSTOMERS . " set customers_default_address_id = '" . (int)$address_id . "' where customers_id = '" . (int)$customer_id . "'");

     tep_db_query("insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('" . (int)$customer_id . "', '0', now())");

     if (SESSION_RECREATE == 'True') {
       tep_session_recreate();
     }
// BOF Separate Pricing Per Customer
// register SPPC session variables for the new customer
// if there is code above that puts new customers directly into another customer group (default is retail)
// then the below code need not be changed, it uses the newly inserted customer group
     $check_customer_group_info = tep_db_query("select c.customers_group_id, cg.customers_group_show_tax, cg.customers_group_tax_exempt, cg.group_specific_taxes_exempt from " . TABLE_CUSTOMERS . " c left join " . TABLE_CUSTOMERS_GROUPS . " cg using(customers_group_id) where c.customers_id = '" . $customer_id . "'");
     $customer_group_info = tep_db_fetch_array($check_customer_group_info);
     $sppc_customer_group_id = $customer_group_info['customers_group_id'];
     $sppc_customer_group_show_tax = (int)$customer_group_info['customers_group_show_tax'];
     $sppc_customer_group_tax_exempt = (int)$customer_group_info['customers_group_tax_exempt'];
     $sppc_customer_specific_taxes_exempt = '';
     if (tep_not_null($customer_group_info['group_specific_taxes_exempt'])) {
       $sppc_customer_specific_taxes_exempt = $customer_group_info['group_specific_taxes_exempt'];
     }
// EOF Separate Pricing Per Customer

     $customer_first_name = $firstname;
     $customer_default_address_id = $address_id;
     $customer_country_id = $country;
     $customer_zone_id = $zone_id;
     tep_session_register('customer_id');
     tep_session_register('customer_first_name');
     tep_session_register('customer_default_address_id');
     tep_session_register('customer_country_id');
     tep_session_register('customer_zone_id');
// BOF Separate Pricing Per Customer
     tep_session_register('sppc_customer_group_id');
     tep_session_register('sppc_customer_group_show_tax');
     tep_session_register('sppc_customer_group_tax_exempt');
     tep_session_register('sppc_customer_specific_taxes_exempt');
// EOF Separate Pricing Per Customer
// restore cart contents
     $cart->restore_contents();

// build the message content
//---  Beginning of addition: Ultimate HTML Emails  ---//
if (EMAIL_USE_HTML == 'true') {
require(DIR_WS_MODULES . 'UHtmlEmails/'. ULTIMATE_HTML_EMAIL_LAYOUT .'/create_account.php');
$email_text = $html_email;
}else{
//---  End of addition: Ultimate HTML Emails  ---//
     $name = $firstname . ' ' . $lastname;

     if (ACCOUNT_GENDER == 'true') {
        if ($gender == 'm') {
          $email_text = sprintf(EMAIL_GREET_MR, $lastname);
        } else {
          $email_text = sprintf(EMAIL_GREET_MS, $lastname);
        }
     } else {
       $email_text = sprintf(EMAIL_GREET_NONE, $firstname);
     }

     $email_text .= EMAIL_WELCOME . EMAIL_TEXT . EMAIL_CONTACT . EMAIL_WARNING;
//---  Beginning of addition: Ultimate HTML Emails  ---//
}

if(ULTIMATE_HTML_EMAIL_DEVELOPMENT_MODE === 'true'){
//Save the contents of the generated html email to the harddrive in .htm file. This can be practical when developing a new layout.
$TheFileName = 'Last_mail_from_create_account.php.htm';
$TheFileHandle = fopen($TheFileName, 'w') or die("can't open error log file");
fwrite($TheFileHandle, $email_text);
fclose($TheFileHandle);
}
//---  End of addition: Ultimate HTML Emails  ---//	  
     tep_mail($name, $email_address, EMAIL_SUBJECT, $email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

// BOF Separate Pricing Per Customer: alert shop owner of account created by a company
// if you would like to have an email when either a company name has been entered in
// the appropriate field or a tax id number, or both then uncomment the next line and comment the default
// setting: only email when a tax_id number has been given
//    if ( (ACCOUNT_COMPANY == 'true' && tep_not_null($company) ) || (ACCOUNT_COMPANY == 'true' && tep_not_null($company_tax_id) ) ) {
     if ( ACCOUNT_COMPANY == 'true' && tep_not_null($company_tax_id) ) {
     $alert_email_text = "Please note that " . $firstname . " " . $lastname . " of the company: " . $company . " has created an account.";
     tep_mail(STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, 'Company account created', $alert_email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
     }
// EOF Separate Pricing Per Customer: alert shop owner of account created by a company

     tep_redirect(tep_href_link(FILENAME_CREATE_ACCOUNT_SUCCESS, '', 'SSL'));
   }
 }

 $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_CREATE_ACCOUNT, '', 'SSL'));
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<meta name="author" content="Tom Foolen & Manon Foolen-den Ouden">
<meta name="description" content="<?php echo META_DESCRIPTION; ?>">
<meta name="keywords" content="<?php echo META_KEYWORDS; ?>">
<title><?php echo PAGE_TITLE; ?></title>
<link rel="shortcut icon" href="<?php echo DIR_WS_IMAGES . 'favicon.ico';?>">
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
<?php require('includes/form_check.js.php'); ?>
</head>

<body>
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
	<td>
		<!-- header //-->
		<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
		<!-- header_eof //-->
	</td>
</tr>
<tr>
	<td>
		<table align="center" cellspacing="0">
			<tr>
				<td> </td>
				<!-- central body //-->
				<td width="<?php echo OUTER_PAGE_WIDTH; ?>">
					<table class="achtergrond" align="center" cellspacing="0" cellpadding="7" width="<?php echo OUTER_PAGE_WIDTH; ?>">
						<tr>
							<td>				
								<table border="0" align="center" width="100%" cellspacing="0" cellpadding="0"> 
									<tr valign="top">
								    	<td width="<?php echo BOX_WIDTH; ?>" valign="top">
										<!-- left_navigation //-->
										<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
										<!-- left_navigation_eof //-->
								    	</td>
										<td width="7"><?php echo tep_draw_separator('pixel_trans.gif', '7', '100%'); ?></td>
								<!-- body_text //-->
									    <td valign="top"><?php echo tep_draw_form('create_account', tep_href_link(FILENAME_CREATE_ACCOUNT, '', 'SSL'), 'post', 'onSubmit="return check_form(create_account);"') . tep_draw_hidden_field('action', 'process'); ?><table border="0" width="100%" cellspacing="0" cellpadding="0">
									    	<table width="100%" cellspacing="0" cellpadding="0">
												<tr>
													<td>
														<table class="outerFrame" width="100%" cellspacing="0" cellpadding="7">
															<tr>
												        		<td>
												        			<table class="dottedBottom" width="100%" cellspacing="0" cellpadding="0">
																          <tr valign="bottom">
																            <td class="pageHeading"><h1><?php echo HEADING_TITLE; ?></h1></td> 
																          </tr>
																    </table>
														        </td>
														    </tr>

														    <tr valign="top">
														        <td class="smallText"><br><?php echo sprintf(TEXT_ORIGIN_LOGIN, tep_href_link(FILENAME_LOGIN, tep_get_all_get_params(), 'SSL')); ?></td>
														    </tr>

																<?php
															  if ($messageStack->size('create_account') > 0) {
																?>
														 	<tr>
														        <td><?php echo $messageStack->output('create_account'); ?></td>
														    </tr>
														    <tr>
														        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '7'); ?></td>
													      	</tr>
																<?php
																  }
																?>
															<tr>
																<td>
																	<table width="100%" class="outerFrame" cellpadding="0" cellspacing="0">
																		<tr>
																			<td><div>
																				<table border="0" cellpadding="2" cellspacing="4">
																						<?php
																						  if (ACCOUNT_COMPANY == 'true') {
																						?>
																		      		<tr>
																				        <td class="main">Nadat u onderstaande gegevens heeft ingevuld, dienen wij het account goed te keuren. Na goedkeuring ziet u de groothandelsprijzen in plaats van de reguliere prijzen. U ontvangt een e-mail zodra uw account is goedgekeurd.</td>
																				    </tr>
																				    <tr>
																				        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '5'); ?></td>
																				    </tr>													
																				    <tr>
																				        <td>
																				        	<table border="0" width="100%" cellspacing="0" cellpadding="0" class="infoBox">
																				          		<tr class="infoBoxContents">
																				            		<td>
																				            			<table border="0" cellspacing="0" cellpadding="0">
																							              	<tr>
																							                	<td width="146" class="main"><?php echo ENTRY_COMPANY; ?></td>
																							                	<td class="main"><?php echo tep_draw_input_field('company') . ' ' . (tep_not_null(ENTRY_COMPANY_TEXT) ? '<span class="inputRequirement">' . ENTRY_COMPANY_TEXT . '</span>': ''); ?></td>
																							              	</tr>
																							              	<tr>
																							                	<td width="146" class="main"><?php echo ENTRY_CUSTOMERS_VAT; ?></td>
																							                	<td class="main"><?php echo tep_draw_input_field('customers_vat') . ' ' . (tep_not_null(ENTRY_CUSTOMERS_VAT) ? '<span class="inputRequirement">' . ENTRY_CUSTOMERS_VAT . '</span>': ''); ?></td>
																							              	</tr>
																							              	<tr>
																							                	<td width="146" class="main"><?php echo ENTRY_CUSTOMERS_WEBSITE; ?></td>
																							                	<td class="main"><?php echo tep_draw_input_field('customers_website') . ' ' . (tep_not_null(ENTRY_CUSTOMERS_WEBSITE) ? '<span class="inputRequirement">' . ENTRY_CUSTOMERS_WEBSITE . '</span>': ''); ?></td>
																							              	</tr>

																							            </table>
																							      	</td>
																				          		</tr>
																				        	</table>
																				        </td>
																				    </tr>

																				<?php
																				  }
																				?>
																					<tr>
																				        <td>
																				        	<table border="0" width="100%" cellspacing="0" cellpadding="0">
																				          		<tr>
																				            		<td class="main"><b>Contactgegevens</b></td>
																				           			<td class="inputRequirement" align="right"><?php echo FORM_REQUIRED_INFORMATION; ?></td>
																				          		</tr>
																				        	</table>
																				        </td>
																				    </tr>
																				    <tr>
																				        <td>
																				        	<table border="0" width="100%" cellspacing="0" cellpadding="0" class="infoBox">
																				          		<tr class="infoBoxContents">
																				            		<td>
																				            			<table border="0" cellspacing="0" cellpadding="0">
																										<?php
																										  if (ACCOUNT_GENDER == 'true') {
																										?>
																							              	<tr>
																								                <td width="146" class="main"><?php echo ENTRY_GENDER; ?></td>
																								                <td class="main"><?php echo tep_draw_radio_field('gender', 'm') . '  ' . MALE . '  ' . tep_draw_radio_field('gender', 'f') . '  ' . FEMALE . ' ' . (tep_not_null(ENTRY_GENDER_TEXT) ? '<span class="inputRequirement">' . ENTRY_GENDER_TEXT . '</span>': ''); ?></td>
																				              				</tr>
																								<?php
																								  }
																								?>
																			  				                <tr>
																								                <td class="main"><?php echo ENTRY_FIRST_NAME; ?></td>
																								                <td class="main"><?php echo tep_draw_input_field('firstname') . ' ' . (tep_not_null(ENTRY_FIRST_NAME_TEXT) ? '<span class="inputRequirement">' . ENTRY_FIRST_NAME_TEXT . '</span>': ''); ?></td>
																								            </tr>
																								            <tr>
																								                <td class="main"><?php echo ENTRY_LAST_NAME; ?></td>
																								                <td class="main"><?php echo tep_draw_input_field('lastname') . ' ' . (tep_not_null(ENTRY_LAST_NAME_TEXT) ? '<span class="inputRequirement">' . ENTRY_LAST_NAME_TEXT . '</span>': ''); ?></td>
																								            </tr>
																											<?php
																											  if (ACCOUNT_DOB == 'true') {
																											?>
																								            <tr>
																								                <td class="main"><?php echo ENTRY_DATE_OF_BIRTH; ?></td>
																								                <td class="main"><?php echo tep_draw_input_field('dob') . ' ' . (tep_not_null(ENTRY_DATE_OF_BIRTH_TEXT) ? '<span class="inputRequirement">' . ENTRY_DATE_OF_BIRTH_TEXT . '</span>': ''); ?></td>
																								            </tr>
																												<?php
																												  }
																												?>
																							              	<tr>
																							                	<td class="main"><?php echo ENTRY_EMAIL_ADDRESS; ?></td>
																							                	<td class="main"><?php echo tep_draw_input_field('email_address') . ' ' . (tep_not_null(ENTRY_EMAIL_ADDRESS_TEXT) ? '<span class="inputRequirement">' . ENTRY_EMAIL_ADDRESS_TEXT . '</span>': ''); ?></td>
																							              	</tr>
																							              	<tr>
																								            <tr>
																								                <td width="146" class="main"><?php echo ENTRY_TELEPHONE_NUMBER; ?></td>
																								                <td class="main"><?php echo tep_draw_input_field('telephone') . ' ' . (tep_not_null(ENTRY_TELEPHONE_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_TELEPHONE_NUMBER_TEXT . '</span>': ''); ?></td>
																								            </tr>									            																							</table>
																							     	</td>
																							  	</tr>
																							</table>
																						</td>
																					</tr>

																				    <tr>
																				        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
																				    </tr>
																				    <tr>
																				        <td class="main"><b>Factuuradres</b> (u kunt een afwijkend afleveradres opgeven tijdens gedurende het afrekenproces)</td>
																				    </tr>
																				    <tr>
																				        <td>
																				        	<table border="0" width="100%" cellspacing="0" cellpadding="0" class="infoBox">
																				          		<tr class="infoBoxContents">
																				            		<td>
																				            			<table border="0" cellspacing="0" cellpadding="0">
																								              <tr>
																								                <td width="146" class="main"><?php echo ENTRY_STREET_ADDRESS; ?></td>
																								                <td class="main"><?php echo tep_draw_input_field('street_address') . ' ' . (tep_not_null(ENTRY_STREET_ADDRESS_TEXT) ? '<span class="inputRequirement">' . ENTRY_STREET_ADDRESS_TEXT . '</span>': ''); ?></td>
																								              </tr>
																								<?php
																								  if (ACCOUNT_SUBURB == 'true') {
																								?>
																								              <tr>
																								                <td class="main"><?php echo ENTRY_SUBURB; ?></td>
																								                <td class="main"><?php echo tep_draw_input_field('suburb') . ' ' . (tep_not_null(ENTRY_SUBURB_TEXT) ? '<span class="inputRequirement">' . ENTRY_SUBURB_TEXT . '</span>': ''); ?></td>
																								              </tr>
																								<?php
																								  }
																								?>
																								              <tr>
																								                <td class="main"><?php echo ENTRY_POST_CODE; ?></td>
																								                <td class="main"><?php echo tep_draw_input_field('postcode') . ' ' . (tep_not_null(ENTRY_POST_CODE_TEXT) ? '<span class="inputRequirement">' . ENTRY_POST_CODE_TEXT . '</span>': ''); ?></td>
																								              </tr>
																								              <tr>
																								                <td class="main"><?php echo ENTRY_CITY; ?></td>
																								                <td class="main"><?php echo tep_draw_input_field('city') . ' ' . (tep_not_null(ENTRY_CITY_TEXT) ? '<span class="inputRequirement">' . ENTRY_CITY_TEXT . '</span>': ''); ?></td>
																								              </tr>
																								<?php
																								  if (ACCOUNT_STATE == 'true') {
																								?>
																								              <tr>
																								                <td class="main"><?php echo ENTRY_STATE; ?></td>
																								                <td class="main">
																								<?php
																								    if ($process == true) {
																								      if ($entry_state_has_zones == true) {
																								        $zones_array = array();
																								        $zones_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country . "' order by zone_name");
																								        while ($zones_values = tep_db_fetch_array($zones_query)) {
																								          $zones_array[] = array('id' => $zones_values['zone_name'], 'text' => $zones_values['zone_name']);
																								        }
																								        echo tep_draw_pull_down_menu('state', $zones_array);
																								      } else {
																								        echo tep_draw_input_field('state');
																								      }
																								    } else {
																								      echo tep_draw_input_field('state');
																								    }

																								    if (tep_not_null(ENTRY_STATE_TEXT)) echo ' <span class="inputRequirement">' . ENTRY_STATE_TEXT;
																								?>
																								                </td>
																								              </tr>
																								<?php
																								  }
																								?>
																								              <tr>
																								                <td width="146" class="main"><?php echo ENTRY_COUNTRY; ?></td>
																								                <td class="main"><?php echo tep_get_country_list('country') . ' ' . (tep_not_null(ENTRY_COUNTRY_TEXT) ? '<span class="inputRequirement">' . ENTRY_COUNTRY_TEXT . '</span>': ''); ?></td>
																								            </tr>
																				            			</table>
																				            		</td>
																						       </tr>
																				        	</table>
																				   		</td>
																					</tr>

																				    <tr>
																				        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
																				    </tr>

																				    <tr>
																				        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
																				    </tr>
																				    <tr>
																				        <td class="main"><b><?php echo CATEGORY_PASSWORD; ?></b></td>
																				    </tr>
																				    <tr>
																				        <td>
																				        	<table border="0" width="100%" cellspacing="0" cellpadding="0" class="infoBox">
																				          		<tr class="infoBoxContents">
																				            		<td>
																				            			<table border="0" cellspacing="0" cellpadding="0">
																								            <tr>
																								                <td width="146" class="main"><?php echo ENTRY_PASSWORD; ?></td>
																								                <td class="main"><?php echo tep_draw_password_field('password') . ' ' . (tep_not_null(ENTRY_PASSWORD_TEXT) ? '<span class="inputRequirement">' . ENTRY_PASSWORD_TEXT . '</span>': ''); ?></td>
																								            </tr>
																								            <tr>
																								                <td class="main"><?php echo ENTRY_PASSWORD_CONFIRMATION; ?></td>
																								                <td class="main"><?php echo tep_draw_password_field('confirmation') . ' ' . (tep_not_null(ENTRY_PASSWORD_CONFIRMATION_TEXT) ? '<span class="inputRequirement">' . ENTRY_PASSWORD_CONFIRMATION_TEXT . '</span>': ''); ?></td>
																								            </tr>
																								      	</table>
																								   	</td>
																								</tr>
																							</table>
																						</td>
																				    </tr>
																				    <tr height="40">
																							<td width="100%" align="center" class="off_grey" onmouseover="this.className='on_black'"onmouseout="this.className='off_grey'"><div><?php echo tep_image_submit('button_continue.png', IMAGE_BUTTON_CONTINUE); ?></div></td> 
																					</tr>
																				</table>
																			</div></td>
																		</tr>
																	</table>
																</tr>																		
															</table>
														</td>
													</tr>
												<!-- body_text_eof //-->
													<tr>
														<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '7'); ?></td>
													</tr>
													<tr>
														<td>
															<!-- footer //-->
															<?php include(DIR_WS_INCLUDES . 'footer.php');?>	
															<!-- footer_eof //-->
														</td>
													</tr>												
												</td>
											</table>	 
										</td>
									</tr>
								</table>
							</td>
						</tr>
					</table>
				</td>
				<!-- eof central body //-->
				<td> </td>
			</tr>
		</table>
	</td>
</tr>
</table>
<!-- body_text_eof //-->

<?php require(DIR_WS_INCLUDES . 'google.php'); ?>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Ideas anyone?

BTW: one thing I need to mention is that I duplicated the create_account.php to create_wholesale_account.php to have a separate account creation page for companies. This does not seem to be the problem however, since all other data are being written to the DB.

tfoolen · March 18, 2011

Hmm, now that I read my post again, I must say I was not very clear. I have added the fields to the database, in which I succeeded. I have added the fields to create_account.php as well. As I create a test-account, the new data are not writing to the database.

I have added the new field to admin/customers.php as well. When I fill out the missing data here and click update, the data are saving to the database. Strange...

Anyone an idea? Seems to me that I have forgotten something in the create_account file. However, I cannot seem to find out what it is!

Ciao,

Tom

tfoolen · June 22, 2011

OK, fixed it. Don't know why it works like this, but I need to add the fields to the queries etc. in create_account.php, even if the fields I added are in a custom create account page named create_wholesale_account.php.

So... Fixed!

sera_archie · August 4, 2011

I am having this same issue - but I don't quite understand your fix... can you explain further?

I have the same issue where the fields are showing in the data base. THey display correctly on the sign up form. When a new account is created the info is not retained and when you access the customer's account to edit the data the fields are blank and it's blank in the admin section as well. BUT if I write them in the admin panel they are retained.

create_account: data not writing to DB

Recommended Posts

tfoolen

Link to comment

Share on other sites

tfoolen

Link to comment

Share on other sites

tfoolen

Link to comment

Share on other sites

sera_archie

Link to comment

Share on other sites

Archived

Browse

Activity