$_SESSION['customer_last_name'] ??

[crazy_chris]

hey,

okay, i have $_SESSION['customer_first_name'], but where can i find the family name?

thx for any help!

[Ajeh]

That is not built into Zen Cart as a session variable ... you would need to do a look up for that ...

[paulm]

I guess you already found it, but else I suggest you add it here:
(module/pages/login/header_php.php)

  // Check if email exists
  $check_customer_query = "SELECT customers_id, customers_firstname, customers_password,
                                    customers_email_address, customers_default_address_id,
                                    customers_authorization, customers_referral
                           FROM " . TABLE_CUSTOMERS . "
                           WHERE customers_email_address = :email";

  $check_customer_query  =$db->bindVars($check_customer_query, ':email', $email_address, 'string');
  $check_customer = $db->Execute($check_customer_query);

  if (!$check_customer->RecordCount()) {
    $error = true;
  } else {
    // Check that password is good
    if (!zen_validate_password($password, $check_customer->fields['customers_password'])) {
      $error = true;
    } else {
      if (SESSION_RECREATE == 'True') {
        zen_session_recreate();
      }

      $check_country_query = "SELECT entry_country_id, entry_zone_id
                              FROM " . TABLE_ADDRESS_BOOK . "
                              WHERE customers_id = :customersID
                              AND address_book_id = :adressBookID";

      $check_country_query = $db->bindVars($check_country_query, ':customersID', $check_customer->fields['customers_id'], 'integer');
      $check_country_query = $db->bindVars($check_country_query, ':adressBookID', $check_customer->fields['customers_default_address_id'], 'integer');
      $check_country = $db->Execute($check_country_query);

      $_SESSION['customer_id'] = $check_customer->fields['customers_id'];
      $_SESSION['customer_default_address_id'] = $check_customer->fields['customers_default_address_id'];
      $_SESSION['customers_authorization'] = $check_customer->fields['customers_authorization'];
      $_SESSION['customer_first_name'] = $check_customer->fields['customers_firstname'];
      $_SESSION['customer_country_id'] = $check_country->fields['entry_country_id'];
      $_SESSION['customer_zone_id'] = $check_country->fields['entry_zone_id'];

[crazy_chris]

yeah, i also used "includes/modules/pages/login/header_php.php"


i simply added "customers_lastname" to $check_customer_query at line 44

$check_customer_query = "SELECT customers_id, customers_firstname, customers_password,
                                    customers_email_address, customers_default_address_id,
                                    customers_authorization, customers_referral, customers_lastname 
                           FROM " . TABLE_CUSTOMERS . "
                           WHERE customers_email_address = :email"; 

and at the "$_SESSION[...] =" part at line 77 i added that line:

      $_SESSION['customer_last_name'] = $check_customer->fields['customers_lastname']; 

now at any point in the zencart i can write "<?php echo $_SESSION['customer_last_name']; ?>" to display the lastname

[paulm]

Somehow I already expected you had done exactly that