Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Added new field in "create account.php"


steinberginc

Recommended Posts

Posted

I nee to create a new field in the account setting. Lets say I want the customers to leave the driver license number or SSN. In Germany may be the Passport number. The shop is based in USA and its not really possible to have Verification on the Address outside the USA ( i use Authorize.NET).

 

I don't want the new field to interact with the credit card processing but only for the account sign up page. I attache a link with what I changed in the php file. May be on of you can see it. I am not that great in php...

 

TIA.

Dave

 

See here my PHP file

Posted

you will need to amend the create_account_process.php file along with adding a new field to your customer table - to store the new information.

 

Depending then on where you want to use this information( or you you can just look in your DB) you will need to feed the new data field thorough to the relevant areas.

Your online success is Paramount.

Posted

Hi,

 

Also in the create_account file you need to include the code to show the box on the account sign-up form.

 

e.g.

 

<tr>

<td class="main"><?php echo ENTRY_SSN; ?></td>

<td class="main"><?php echo tep_draw_input_field('ssn') . ' ' . (tep_not_null(ENTRY_SSN_TEXT) ? '<span class="inputRequirement">' . ENTRY_SSN_TEXT . '</span>': ''); ?></td>

</tr>

 

you will need to define:

 

ENTRY_SSN

ENTRY_SSN_TEXT

 

The other element to think about is whether or not this is a compulsory field - for customer completion.

 

Look at how the syntax for telephone number(req'd field) and fax number(not req'd field) differ within both the create_account and create_account_process files.

Your online success is Paramount.

Posted

Ok. Now I got it working but I get this error:

 

1054 - Unknown column 'customers_driver_license_number' in 'field list'

 

insert into customers (customers_firstname, customers_lastname, customers_driver_license_number, customers_email_address, customers_telephone, customers_fax, customers_newsletter, customers_password, customers_gender, customers_dob) values ('Michael', 'Mustermann', '6559-5584-5552S', '[email protected]', '06195-77447', '', '', '48d6ba7d373d78ef83b624cbf61658eb:43', 'm', '19700521')

 

 

 

Here is the website I am working on: http://shop.yipgermany.com/catalog/

 

You can see when you sign up for an account that I added the driver license number.

 

What am I missing???

Posted

have you created the field 'customers_driver_license_number' in the table 'customers' ?

 

If you have just check spelling and that you have called them eaxctly the same thing.

Your online success is Paramount.

Posted

Thanks by the way for talking the time.

 

I have create a new tab or field as you said in the create_account.php

 

then i checked the complete document for where else I have to make some adjustments. Seems ok for me.

 

Secondly I went into each language files and created the names for the filed. Germany and English.

 

It seems to me that in the create_account.php everything is right but once I want to submit the info, something is missing.

 

Where do I have to go now.

 

TIA

David

Posted

have you added the field in the customers table in your database ?

Your online success is Paramount.

Posted

can you access phpmyadmin ?

 

Also what is the maximum length that the SSN can be ?

Your online success is Paramount.

Posted

OK... I did find the customer.php (admin folder)... I saw where i had to make the changes and add the fields...

 

BUT... Still get the error...

 

What do I do wrong? I changed now the:

 

create_account.php

customer.php

and both language files (admin and normal)

 

 

STILL HAVE THIS ERROR:

 

1054 - Unknown column 'customers_driver_license_number' in 'field list'

 

insert into customers (customers_firstname, customers_lastname, customers_driver_license_number, customers_email_address, customers_telephone, customers_fax, customers_newsletter, customers_password, customers_gender, customers_dob) values ('Sebastian', 'Meister', '566587385444', '[email protected]', '3055349898', '', '', '28ed547c980bec131773d8f989ca6a1a:38', 'm', '19700521')

Posted

stick this in your sql editor in phpmyadmin:

 

ALTER TABLE `customers` ADD `customers_driver_license_number` VARCHAR( 36 ) ;

 

 

the number 36 above is the max length of the field - alter this( prior to putting the query in sql editor) to the max length you expect for an ssn.

Your online success is Paramount.

Posted
what is the maximum size an ssn would be ?

max 10 - 15

stick this in your sql editor in phpmyadmin:

 

ALTER TABLE `customers` ADD `customers_driver_license_number` VARCHAR( 15 ) ;

Your online success is Paramount.

Posted
stick this in your sql editor in phpmyadmin:

 

ALTER TABLE `customers` ADD `customers_driver_license_number` VARCHAR( 36 ) ;

 

 

the number 36 above is the max length of the field - alter this( prior to putting the query in sql editor) to the max length you expect for an ssn.

 

thanks... worked great. I could fix this problem now.

 

THANKS TO ALL OF YOU.. Seems to me that PHP Admin was a great tool.

Posted

sorry, one more thing.

 

So the new field works. Cool. I am very relieved:) Now when I check the new entry in my admin section (where I did also made changes and can see the field) nothing gets submitted. The field is blank. Just can see under customers the name but no date of entry and if I edit the user then all info is blank. I get this error in the header:

 

Warning: reset(): Passed variable is not an array or object in /home/yipgerma/public_html/shop/catalog/admin/includes/classes/object_info.php on line 17

 

Warning: Variable passed to each() is not an array or object in /home/yipgerma/public_html/shop/catalog/admin/includes/classes/object_info.php on line 18

 

 

Also, I opened this file. Seems empty. Don't know what to do?

 

Sorry. :))

TIA

David

  • 5 months later...
Posted

hey guys

 

a (sligthly different) version of this problem

 

 

1054 - Unknown column 'p.products_retail_price' in 'field list'

 

select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_retail_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '0' order by pd.products_name

 

[TEP STOP]

 

 

can anybody help me out?

i am THIS close

i love this forum !

 

 

Thank so much in advance for all your help

Archived

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

×
×
  • Create New...