Getting Customer Name & Email Via PHP

[youderian]

Can someone tell me how to access a customer's name and email address via PHP on the checkout success page? I can't seem to figure it out.... I've tried:


echo $account->fields['customers_lastname'];

-and-

echo $account->fields['customers_email_address'];


But these are obviously wrong. I've looked around in the code for another way / place they are stored, but can't find it.

Any help would be appreciated. Thanks........

[DrByte]

Why ?

[youderian]

Because after a customer finishes a purchase, I'd like to offer the option to enroll in an a follow-up service email list. I'd like to be able to populate the name and email fields automatically so that the customer doesn't need to re-type them in.

[DrByte]

You'll have to manually re-query the data from the database, as it's not extracted for that page's output since it's not normally used there.

/includes/modules/pages/checkout_success/header_php.php

Insert the following at the end of the file, before the closing ?>

$sql = "SELECT customers_firstname, customers_lastname, customers_email_address FROM   " . TABLE_CUSTOMERS . "
                  WHERE  customers_id = :customersID:";

$sql = $db->bindVars($sql, ':customersID:', $_SESSION['customer_id'], 'integer');
$cust = $db->Execute($sql);

Then in your template file, you can reference the info like this:
$cust->fields['customers_firstname']
$cust->fields['customers_lastname']
$cust->fields['customers_email_address']

[youderian]

Fantastic! That was exactly what I needed. Thank you.......