[RESOLVED] Auto Form Complete

Kerant

Hiya,

I have a simple shopping cart, and as part of the checkout process I want to give the users the option to auto complete the shipping address of the form.

For example, if the user has already purchased something from the site, and provided their shipping address, then that address is stored in the database. When the user comes to purchase something else i'd like an option (maybe a tick box) to appear to let them use their previously stored address. When they tick the box to do so, i'd like the details (address line 1, 2, postcode, etc) to automatically go into the relevant fields in the form... then they can just fill out the rest of the fields.

I'm aware that Javascript is probably the best method but after searching around the Internet I can't really find an auto-fill method that extracts the data from the database.

I'd just like a bit of help if possible please. Am I going about this the easiest way?

Thanks a lot! :queasy:

php_dev

I think that PHP and JavaScript is a good combination for this to work. If it were me coding this, you could simply attach the unique key for each customer login (each shopper) to a record of their address and all that, and when they login in, bring in that address and display it as the address on record, should they want to change it they could have it right there. Simply run a query along the lines of

$sql="SELECT addr1 FROM customer_address WHERE unique_key='customer_id_of_user'";

Once you have that in your script, simply set the 'value' parameter of the input boxes to reflect the information collected. If they want to change it, then they could simply retype the information, and if nothing is on file, the input boxes appear blank.

Hope it helps,

php_dev

Kerant

php_dev;10895220 wrote:
I think that PHP and JavaScript is a good combination for this to work. If it were me coding this, you could simply attach the unique key for each customer login (each shopper) to a record of their address and all that, and when they login in, bring in that address and display it as the address on record, should they want to change it they could have it right there. Simply run a query along the lines of

$sql="SELECT addr1 FROM customer_address WHERE unique_key='customer_id_of_user'";

Once you have that in your script, simply set the 'value' parameter of the input boxes to reflect the information collected. If they want to change it, then they could simply retype the information, and if nothing is on file, the input boxes appear blank.

Hope it helps,

php_dev

Ah yeah! I had the address in variables ready to use on the page but I originally wanted them to click a button or something before they appeared in the input boxes, but I guess I could just make them go there straight away, and like you said they could just change them if they need to.

I'll do it like that 🙂

Cheers buddy!