Database Delay with Session Variables

[janggu]

Hi there,

 

I created a bilingual site and connect two different language tables by two language session variables. However, when a language sesssion is created, population of data is being delayed. Basically, I have to refresh my web browser a couple of times manually in order to see the change of the language. Please see my code below and tell me if this can be fixed. Thanks very much in advance!!!

 

// Trigger language sessions

<?

if (isset ($_SESSION["lang"]))

{

if ($_SESSION['lang'] == "en")

{

echo '<a href='.$_SERVER['PHP_SELF'].'?'.$_SERVER['QUERY_STRING'].'&lang=fr>Francais</a>';

}

else

{

echo '<a href='.$_SERVER['PHP_SELF'].'?'.$_SERVER['QUERY_STRING'].'&lang=en>English</a>';

}

}

?>

 

// Create sessions

<?

session_start();

 

$lg = $_GET['lang'];

 

if (!isset($_SESSION["lang"]))

{

$_SESSION['lang'] = "en";

if ($lg=="en")

{

$_SESSION['lang'] = $lg;

}

if ($lg=="fr")

{

$_SESSION['lang'] = $lg;

}

}

else

{

if ($_SESSION["lang"] == "en" && $lg == "fr")

{

session_destroy();

$_SESSION["lang"] = $lg;

}

if ($_SESSION["lang"] == "fr" && $lg == "en")

{

session_destroy();

$_SESSION["lang"] = $lg;

}

}

?>

 

// Connect two language tables by session variable

<?

session_start();

  $conn = db_connect();

if (isset ($_SESSION["lang"]))

{

if ($_SESSION['lang'] == "en")

{

$query = "select * from tbl_page_en where qs = '$qs'";

}

if ($_SESSION['lang'] == "fr")

{

$query = "select * from tbl_page_fr where qs = '$qs'";

}

}

  else

  {

  $query = "select * from tbl_page_en where qs = '$qs'";

  }

?>

[mikefrederick]

server settings? think your code is fine. with a session you shouldnt have to reload the page to see changes.

[haku]

Try changing this code:

 

<?
if (isset ($_SESSION["lang"]))
{
   if ($_SESSION['lang'] == "en")
      {
         echo '<a href='.$_SERVER['PHP_SELF'].'?'.$_SERVER['QUERY_STRING'].'&lang=fr>Francais[/url]';            
      }
   else
      {
         echo '<a href='.$_SERVER['PHP_SELF'].'?'.$_SERVER['QUERY_STRING'].'&lang=en>English[/url]';
      }
   }
?>

 

To this:

 

<?
    if (isset ($_SESSION['lang']))
    {
        header("Location: " . $_SERVER['PHP_SELF'] . "?" . $_SERVER['QUERY_STRING'] . "&lang=" . $_SESSION['lang']);
    }
?>

 

 

 

 

[janggu]

Thanks for your help but it doesn't make a difference.