Getting/Displaying the Customer's State

[ultimate_zc]

I think my problem lies here:

if (isset($_SESSION['customer_country_id']) && isset($_SESSION['customer_zone_id'])) { 

Anything I add to that code inside the brackets does not display regardless whether I'm logged in or not. Would that be happening because I'm on a localhost environment?

$state_code = '';
$state_name = '';
if (isset($_SESSION['customer_country_id']) && isset($_SESSION['customer_zone_id'])) {
  $state_info = $db->Execute("SELECT zone_code, zone_name FROM " . TABLE_ZONES . " WHERE zone_country_id = " . $_SESSION['customer_country_id'] . " AND zone_id = " . $_SESSION['customer_zone_id'] . " LIMIT 1");
  if (!$state_info->EOF) {
    $state_code = $state_info->fields['zone_code'];  // 2-character code
    $state_name = $state_info->fields['zone_name']; // Full name
  }
$any_variable_here = 'does not display';
} 

[lat9]

Nope, localhost environment shouldn't affect the display; I'm running a version of XAMPP to do my local testing. Where are you displaying the value; it's not being displayed in the header, just created, so you'll need to add something to your customized tpl_checkout_success_default.php to

echo "State code: ($state_code), state name: ($state_name)";

[ultimate_zc]

I'm testing on a clean installation.

I created a header_php_test.php with the following code:

<?php
        $_SESSION['customer_country_id'] = $check_country->fields['entry_country_id'];
        $_SESSION['customer_zone_id'] = $check_country->fields['entry_zone_id'];

        $state_code = '';
        $state_name = '';
        if (isset($_SESSION['customer_country_id']) && isset($_SESSION['customer_zone_id'])) {
          $state_info = $db->Execute("SELECT zone_code, zone_name FROM " . TABLE_ZONES . " WHERE zone_country_id = " . $_SESSION['customer_country_id'] . " AND zone_id = " . $_SESSION['customer_zone_id'] . " LIMIT 1");
          if (!$state_info->EOF) {
            $state_code = $state_info->fields['zone_code'];  // 2-character code
            $state_name = $state_info->fields['zone_name']; // Full name
          }
        }

        $test = 'this is a test dialog';

?>

On the tpl_checkout_success_default.php I added the following above the last div tag:

<?php echo $test; ?>
<br />
<?php echo $state_code; ?>
<br />
<?php echo $state_name; ?>

Still all I can see at the bottom of index.php?main_page=checkout_success is "this is a test dialog", but still no customer state info is displayed.

[lat9]

Why are you setting the session values for the country and zone IDs (they should already be set)? Try removing the first two lines in your header_php_test.php.

[ultimate_zc]

You are right!!!

You are absolutely awesome. Thank you so much!!!

Yes, I'm excited...

[lat9]

Woo-hoo! Happy to help ...