Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help getting information into the database


ronb

Recommended Posts

Hi

This question is about a "how did you find us" contribution, which has been posted in the correct section, but noone has answered.

 

I have installed the contribution, but it doesnt work, because I also have purchase without an account,

 

I have been given the code to make it work

 

The following is added to order_info_check.php

 

<!-- //rmh referral start -->
<tr>
<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
</tr>
<tr>
<td class="main"><b><?php echo CATEGORY_SOURCE; ?></b></td>
</tr>
<tr>
<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
<tr class="infoBoxContents">
<td><table border="0" cellspacing="2" cellpadding="2">
<tr>
<td class="main"><?php echo ENTRY_SOURCE; ?></td>
<td class="main"><?php echo tep_get_source_list('source', (DISPLAY_REFERRAL_OTHER == 'true' ? true : false)) . ' ' . (tep_not_null(ENTRY_SOURCE_TEXT) ? '<span class="inputRequirement">' . ENTRY_SOURCE_TEXT . '</span>': ''); 
if ($entry_source_error) {
echo '  ' . ENTRY_SOURCE_ERROR;
} 
?></td>
</tr>
<?php
if (DISPLAY_REFERRAL_OTHER == 'true') {
?>
<tr>
<td class="main"><?php echo ENTRY_SOURCE_OTHER; ?></td>
<td class="main"><?php echo tep_draw_input_field('source_other') . ' ' . (tep_not_null(ENTRY_SOURCE_OTHER_TEXT) ? '<span class="inputRequirement">' . ENTRY_SOURCE_OTHER_TEXT . '</span>': ''); 
if ($entry_source_other_error) {
echo '  ' . ENTRY_SOURCE_OTHER_ERROR;
} 

?></td>
</tr>
<?php
}
?>
</table></td>
</tr>
</table></td>
</tr>


<!-- //rmh referral end -->

 

the above displays perfectly, but it doesnt enter the information into the database

 

If you look at the code above, it doesnt shown any database details

 

 

how can i get the referrer to be entered into the database like it does with account creation

thanks

ronnie

 

 

this is the full page

 

<?php
/*
 $Id: Order_Info_Check.php,v 0.52 2002/09/21 hpdl Exp $
by Cheng

	OSCommerce v2.2 CVS (09/17/02)

  Modified versions of create_account.php and related
 files.  Allowing 'purchase without account'.		


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

 Copyright (c) 2002 osCommerce

 Released under the GNU General Public License
*/
?>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
 <tr>
<td class="formAreaTitle"><?php echo CATEGORY_PERSONAL; ?></td>
 </tr>
 <tr>
<td class="main"><table border="0" width="100%" cellspacing="0" cellpadding="2" class="formArea">
  <tr>
	<td class="main"><table border="0" cellspacing="0" cellpadding="2">
<?php
 if (ACCOUNT_GENDER == 'true') {
$male = ($account['customers_gender'] == 'm') ? true : false;
$female = ($account['customers_gender'] == 'f') ? true : false;
?>
	  <tr>
		<td class="main"> <?php echo ENTRY_GENDER; ?></td>
		<td class="main"> 
<?php
if ($is_read_only) {
  echo ($account['customers_gender'] == 'm') ? MALE : FEMALE;
} elseif ($error) {
  if ($entry_gender_error) {
	echo tep_draw_radio_field('gender', 'm', $male) . '  ' . MALE . '  ' . tep_draw_radio_field('gender', 'f', $female) . '  ' . FEMALE . ' ' . ENTRY_GENDER_ERROR;
  } else {
	echo ($gender == 'm') ? MALE : FEMALE;
	echo tep_draw_hidden_field('gender');
  }
} else {
  echo tep_draw_radio_field('gender', 'm', $male) . '  ' . MALE . '  ' . tep_draw_radio_field('gender', 'f', $female) . '  ' . FEMALE . ' ' . ENTRY_GENDER_TEXT;
}
?></td>
	  </tr>
<?php
 }
?>
	  <tr>
		<td class="main"> <?php echo ENTRY_FIRST_NAME; ?></td>
		<td class="main"> 
<?php
 if ($is_read_only) {
echo $account['customers_firstname'];
 } elseif ($error) {
if ($entry_firstname_error) {
  echo tep_draw_input_field('firstname') . ' ' . ENTRY_FIRST_NAME_ERROR;
} else {
  echo $firstname . tep_draw_hidden_field('firstname');
}
 } else {
echo tep_draw_input_field('firstname', $account['customers_firstname']) . ' ' . ENTRY_FIRST_NAME_TEXT;
 }
?></td>
	  </tr>
	  <tr>
		<td class="main"> <?php echo ENTRY_LAST_NAME; ?></td>
		<td class="main"> 
<?php
 if ($is_read_only) {
echo $account['customers_lastname'];
 } elseif ($error) {
if ($entry_lastname_error) {
  echo tep_draw_input_field('lastname') . ' ' . ENTRY_LAST_NAME_ERROR;
} else {
  echo $lastname . tep_draw_hidden_field('lastname');
}
 } else {
echo tep_draw_input_field('lastname', $account['customers_lastname']) . ' ' . ENTRY_LAST_NAME_TEXT;
 }
?></td>
	  </tr>
<?php
 if (ACCOUNT_DOB == 'true') {
?>
	  <tr>
		<td class="main"> <?php echo ENTRY_DATE_OF_BIRTH; ?></td>
		<td class="main"> 
<?php
if ($is_read_only) {
  echo tep_date_short($account['customers_dob']);
} elseif ($error) {
  if ($entry_date_of_birth_error) {
	echo tep_draw_input_field('dob') . ' ' . ENTRY_DATE_OF_BIRTH_ERROR;
  } else {
	echo $dob . tep_draw_hidden_field('dob');
  }
} else {
  echo tep_draw_input_field('dob', tep_date_short($account['customers_dob'])) . ' ' . ENTRY_DATE_OF_BIRTH_TEXT;
}
?></td>
	  </tr>
<?php
 }
?>
	  <tr>
		<td class="main"> <?php echo ENTRY_EMAIL_ADDRESS; ?></td>
		<td class="main"> 
<?php
 if ($is_read_only) {
echo $account['customers_email_address'];
 } elseif ($error) {
if ($entry_email_address_error) {
  echo tep_draw_input_field('email_address') . ' ' . ENTRY_EMAIL_ADDRESS_ERROR;
} elseif ($entry_email_address_check_error) {
  echo tep_draw_input_field('email_address') . ' ' . ENTRY_EMAIL_ADDRESS_CHECK_ERROR;
} elseif ($entry_email_address_exists) {
  echo tep_draw_input_field('email_address') . ' ' . ENTRY_EMAIL_ADDRESS_ERROR_EXISTS;
} else {
  echo $email_address . tep_draw_hidden_field('email_address');
}
 } else {
echo tep_draw_input_field('email_address', $account['customers_email_address']) . ' ' . ENTRY_EMAIL_ADDRESS_TEXT;
 }
?></td>
	  </tr>
	</table></td>
  </tr>
</table></td>
 </tr>
<?php
 if (ACCOUNT_COMPANY == 'true') {
?>  
 <tr>
<td class="formAreaTitle"><br><?php echo CATEGORY_COMPANY; ?></td>
 </tr>
 <tr>
<td class="main"><table border="0" width="100%" cellspacing="0" cellpadding="2" class="formArea">
  <tr>
	<td class="main"><table border="0" cellspacing="0" cellpadding="2">
	  <tr>
		<td class="main"> <?php echo ENTRY_COMPANY; ?></td>
		<td class="main"> 
<?php
if ($is_read_only) {
  echo $account['entry_company'];
} elseif ($error) {
  if ($entry_company_error) {
	echo tep_draw_input_field('company') . ' ' . ENTRY_COMPANY_ERROR;
  } else {
	echo $company . tep_draw_hidden_field('company');
  }
} else {
  echo tep_draw_input_field('company', $account['entry_company']) . ' ' . ENTRY_COMPANY_TEXT;
}
?></td>
	  </tr>
	</table></td>
  </tr>
</table></td>
 </tr>
<?php
 }
?>
 <tr>
<td class="formAreaTitle"><br><?php echo CATEGORY_ADDRESS; ?></td>
 </tr>
 <tr>
<td class="main"><table border="0" width="100%" cellspacing="0" cellpadding="2" class="formArea">
  <tr>
	<td class="main"><table border="0" cellspacing="0" cellpadding="2">
	  <tr>
		<td class="main"> <?php echo ENTRY_STREET_ADDRESS; ?></td>
		<td class="main"> 
<?php
 if ($is_read_only) {
echo $account['entry_street_address'];
 } elseif ($error) {
if ($entry_street_address_error) {
  echo tep_draw_input_field('street_address') . ' ' . ENTRY_STREET_ADDRESS_ERROR;
} else {
  echo $street_address . tep_draw_hidden_field('street_address');
}
 } else {
echo tep_draw_input_field('street_address', $account['entry_street_address']) . ' ' . ENTRY_STREET_ADDRESS_TEXT;
 }
?></td>
	  </tr>
<?php
 if (ACCOUNT_SUBURB == 'true') {
?>
	  <tr>
		<td class="main"> <?php echo ENTRY_SUBURB; ?></td>
		<td class="main"> 
<?php
if ($is_read_only) {
  echo $account['entry_suburb'];
} elseif ($error) {
  if ($entry_suburb_error) {
	echo tep_draw_input_field('suburb') . ' ' . ENTRY_SUBURB_ERROR;
  } else {
	echo $suburb . tep_draw_hidden_field('suburb');
  }
} else {
  echo tep_draw_input_field('suburb', $account['entry_suburb']) . ' ' . ENTRY_SUBURB_TEXT;
}
?></td>
	  </tr>
<?php
 }
?>
	  <tr>
		<td class="main"> <?php echo ENTRY_CITY; ?></td>
		<td class="main"> 
<?php
 if ($is_read_only) {
echo $account['entry_city'];
 } elseif ($error) {
if ($entry_city_error) {
  echo tep_draw_input_field('city') . ' ' . ENTRY_CITY_ERROR;
} else {
  echo $city . tep_draw_hidden_field('city');
}
 } else {
echo tep_draw_input_field('city', $account['entry_city']) . ' ' . ENTRY_CITY_TEXT;
 }
?></td>
	  </tr>
<?php
 if (ACCOUNT_STATE == 'true') {
?>
	  <tr>
		<td class="main"> <?php echo ENTRY_STATE; ?></td>
		<td class="main"> 
<?php
$state = tep_get_zone_name($country, $zone_id, $state);
if ($is_read_only) {
  echo tep_get_zone_name($account['entry_country_id'], $account['entry_zone_id'], $account['entry_state']);
} elseif ($error) {
  if ($entry_state_error) {
	if ($entry_state_has_zones) {
	  $zones_array = array();
	  $zones_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = '" . tep_db_input($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) . ' ' . ENTRY_STATE_ERROR;
	} else {
	  echo tep_draw_input_field('state') . ' ' . ENTRY_STATE_ERROR;
	}
  } else {
	echo $state . tep_draw_hidden_field('zone_id') . tep_draw_hidden_field('state');
  }
} else {
  echo tep_draw_input_field('state', tep_get_zone_name($account['entry_country_id'], $account['entry_zone_id'], $account['entry_state'])) . ' ' . ENTRY_STATE_TEXT;
}
?></td>
	  </tr>
<?php
 }
?>		  
	  <tr>
		<td class="main"> <?php echo ENTRY_POST_CODE; ?></td>
		<td class="main"> 
<?php
 if ($is_read_only) {
echo $account['entry_postcode'];
 } elseif ($error) {
if ($entry_post_code_error) {
  echo tep_draw_input_field('postcode') . ' ' . ENTRY_POST_CODE_ERROR;
} else {
  echo $postcode . tep_draw_hidden_field('postcode');
}
 } else {
echo tep_draw_input_field('postcode', $account['entry_postcode']) . ' ' . ENTRY_POST_CODE_TEXT;
 }
?></td>
	  </tr>

	  <tr>
		<td class="main"> <?php echo ENTRY_COUNTRY; ?></td>
		<td class="main"> 
<?php
 if ($is_read_only) {
echo tep_get_country_name($account['entry_country_id']);
 } elseif ($error) {
if ($entry_country_error) {
  echo tep_get_country_list('country') . ' ' . ENTRY_COUNTRY_ERROR;
} else {
  echo tep_get_country_name($country) . tep_draw_hidden_field('country');
}
 } else {
echo tep_get_country_list('country', $account['entry_country_id']) . ' ' . ENTRY_COUNTRY_TEXT;
 }
?></td>
	  </tr>

	</table></td>
  </tr>
</table></td>
 </tr>
 <tr>
<td class="formAreaTitle"><br><?php echo CATEGORY_CONTACT; ?></td>
 </tr>
 <tr>
<td class="main"><table border="0" width="100%" cellspacing="0" cellpadding="2" class="formArea">
  <tr>
	<td class="main"><table border="0" cellspacing="0" cellpadding="2">
	  <tr>
		<td class="main"> <?php echo ENTRY_TELEPHONE_NUMBER; ?></td>
		<td class="main"> 
<?php
 if ($is_read_only) {
echo $account['customers_telephone'];
 } elseif ($error) {
if ($entry_telephone_error) {
  echo tep_draw_input_field('telephone') . ' ' . ENTRY_TELEPHONE_NUMBER_ERROR;
} else {
  echo $telephone . tep_draw_hidden_field('telephone');
}
 } else {
echo tep_draw_input_field('telephone', $account['customers_telephone']) . ' ' . ENTRY_TELEPHONE_NUMBER_TEXT;
 }
?></td>
	  </tr>
	  <tr>
		<td class="main"> <?php echo ENTRY_FAX_NUMBER; ?></td>
		<td class="main"> 
<?php
 if ($is_read_only) {
echo $account['customers_fax'];
 } elseif ($processed) {
echo $fax . tep_draw_hidden_field('fax');
 } else {
echo tep_draw_input_field('fax', $account['customers_fax']) . ' ' . ENTRY_FAX_NUMBER_TEXT;
 }
?></td>
	  </tr>
	</table></td>
  </tr>
</table></td>
 </tr>




  <!-- //rmh referral start -->
<tr>
  <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
</tr>
<tr>
  <td class="main"><b><?php echo CATEGORY_SOURCE; ?></b></td>
</tr>
<tr>
  <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
	<tr class="infoBoxContents">
	  <td><table border="0" cellspacing="2" cellpadding="2">
		<tr>
		  <td class="main"><?php echo ENTRY_SOURCE; ?></td>
		  <td class="main"><?php echo tep_get_source_list('source', (DISPLAY_REFERRAL_OTHER == 'true' ? true : false)) . ' ' . (tep_not_null(ENTRY_SOURCE_TEXT) ? '<span class="inputRequirement">' . ENTRY_SOURCE_TEXT . '</span>': ''); 
if ($entry_source_error) {
  echo '  ' . ENTRY_SOURCE_ERROR;
} 
 ?></td>
		</tr>
<?php
if (DISPLAY_REFERRAL_OTHER == 'true') {
?>
		<tr>
		  <td class="main"><?php echo ENTRY_SOURCE_OTHER; ?></td>
		  <td class="main"><?php echo tep_draw_input_field('source_other') . ' ' . (tep_not_null(ENTRY_SOURCE_OTHER_TEXT) ? '<span class="inputRequirement">' . ENTRY_SOURCE_OTHER_TEXT . '</span>': ''); 
if ($entry_source_other_error) {
  echo '  ' . ENTRY_SOURCE_OTHER_ERROR;
} 

 ?></td>
		</tr>
<?php
}
?>
	  </table></td>
	</tr>
  </table></td>
</tr>


<!-- //rmh referral end -->




 <tr>
<td class="formAreaTitle"><br><?php //echo CATEGORY_OPTIONS; ?></td>
 </tr>
 <tr>
<td class="main"><table border="0" width="100%" cellspacing="0" cellpadding="2" class="formArea">
  <tr>
	<td class="main"><table border="0" cellspacing="0" cellpadding="2">
	  <tr>
		<td class="main"> <?php //echo ENTRY_NEWSLETTER; ?></td>
		<td class="main"> 
<?php /*
 if ($is_read_only) {
if ($account['customers_newsletter'] == '1') {
  echo ENTRY_NEWSLETTER_YES;
} else {
  echo ENTRY_NEWSLETTER_NO;
}
 } elseif ($processed) {
if ($newsletter == '1') {
  echo ENTRY_NEWSLETTER_YES;
} else {
  echo ENTRY_NEWSLETTER_NO;
}
echo tep_draw_hidden_field('newsletter');  
 } else {
echo tep_draw_pull_down_menu('newsletter', $newsletter_array, $account['customers_newsletter']) . ' ' . ENTRY_NEWSLETTER_TEXT;
 }*/
?></td>
	  </tr>
	</table></td>
  </tr>
</table></td>
 </tr>
<?php
 if (!$is_read_only) {
?>
 <!--tr>
<td class="formAreaTitle"><br><?php echo CATEGORY_PASSWORD; ?></td>
 </tr>
 <tr>
<td class="main"><table border="0" width="100%" cellspacing="0" cellpadding="2" class="formArea">
  <tr>
	<td class="main"><table border="0" cellspacing="0" cellpadding="2">
	  <tr>
		<td class="main"> <?php echo ENTRY_PASSWORD; ?></td>
		<td class="main"> 
<?php
if ($error) {
  if ($entry_password_error) {
	echo tep_draw_password_field('password') . ' ' . ENTRY_PASSWORD_ERROR;
  } else {
	echo PASSWORD_HIDDEN . tep_draw_hidden_field('password') . tep_draw_hidden_field('confirmation');
  }
} else {
  echo tep_draw_password_field('password') . ' ' . ENTRY_PASSWORD_TEXT;
}
?></td>
	 </tr>
<?php


if ( (!$error) || ($entry_password_error) ) {
?>
	  <tr>
		<td class="main"> <?php echo ENTRY_PASSWORD_CONFIRMATION; ?></td>
		<td class="main"> 
<?php
  echo tep_draw_password_field('confirmation') . ' ' . ENTRY_PASSWORD_CONFIRMATION_TEXT;
?></td>
	  </tr>
<?php
}
?>
	</table></td>
  </tr>
</table></td>
 </tr//-->
<?php
 }
?>
</table>

 

 

should be a very simple addition... but i dont know how :(

 

it should be stored in customers_info table in customers_info_source_id row

 

Thanks

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...