Getting/Displaying the Customer's Country

[ultimate_zc]

Is there a way to display the customer's country on the checkout success page. The ideal would be for something simple such as

<?php echo CUSTOMER_COUNTRY_SOMETING;?>

but I have found that to be a little much more difficult to do.

To give an idea of what I'm doing. I'm trying to integrate a Survey/Rating script which as options have the customer's email, name and country.

The email and name are easy to get...

    if($_SESSION['customer_id']) {
      $sql = "SELECT customers_id, customers_firstname, customers_lastname, customers_password, customers_email_address, customers_default_address_id
              FROM " . TABLE_CUSTOMERS . "
              WHERE customers_id = :customersID";

      $sql = $db->bindVars($sql, ':customersID', $_SESSION['customer_id'], 'integer');
      $check_customer = $db->Execute($sql);
      $customer_email= $check_customer->fields['customers_email_address'];
      $customer_name= $check_customer->fields['customers_firstname'] . ' ' . $check_customer->fields['customers_lastname'];
    } 

Any idea how to get the country. The best I can do is get a country ID.

Thanks

[Design75]

If you know the customer id you can do a query on the address book table to get the customers country

[ultimate_zc]

Hi, thanks. Can you give me an example? Or tell me a module that may have a code similar to what I'm looking for?

[Design75]

I have not tested it, but it should be something like this I think

<?php
    if($_SESSION['customer_id']) {
      $sql = "SELECT customers_id, customers_firstname, customers_lastname, customers_password, customers_email_address, customers_default_address_id
              FROM " . TABLE_CUSTOMERS . "
              WHERE customers_id = :customersID";

      $sql = $db->bindVars($sql, ':customersID', $_SESSION['customer_id'], 'integer');
      $check_customer = $db->Execute($sql);
      $customer_email= $check_customer->fields['customers_email_address'];
      $customer_name= $check_customer->fields['customers_firstname'] . ' ' . $check_customer->fields['customers_lastname'];

      $CountryId = $db->Execute("SELECT entry_country_id FROM address_book WHERE address_book_id = '" . $check_customer->fields['customers_default_address_id'] . "' ");

      $Country = $db->Execute("SELECT countries_name FROM countries WHERE countries_id = '" . $CountryId->fields['entry_country_id'] . "'");
    }

  echo $Country;

[ultimate_zc]

Thanks,

I got it working with this:

        $country_query = "SELECT entry_country_id FROM " . TABLE_ADDRESS_BOOK . " WHERE customers_id = :customersID";
        $country_query = $db->bindVars($country_query, ':customersID', $_SESSION['customer_id'], 'integer');
        $check_customer = $db->Execute($country_query);
        $customer_country= $check_customer->fields['entry_country_id'];
        $country = zen_get_country_name($customer_country); 

[Design75]

Thanks,

I got it working with this:

        $country_query = "SELECT entry_country_id FROM " . TABLE_ADDRESS_BOOK . " WHERE customers_id = :customersID";
        $country_query = $db->bindVars($country_query, ':customersID', $_SESSION['customer_id'], 'integer');
        $check_customer = $db->Execute($country_query);
        $customer_country= $check_customer->fields['entry_country_id'];
        $country = zen_get_country_name($customer_country); 

What happens if the customer has multiple countries in his address book ?

[Ajeh]

When a customer logs in, the country id is set to:
$_SESSION['customer_country_id']

You could use that to look up the country name in the countries table ...

[ultimate_zc]

Thanks to you both.