Date and time code error

[divinequran]

Hello,

 

The below code works on my home machine.. but not on my Linux machine, I am unable to figure out the problem, please help

 

require_once("dbconnection.php");

function coun_list()
{
$rs=mysql_query("select name from timezones") or die(mysql_error());
while($row=mysql_fetch_row($rs))
  {
   $tzone=$row[0];
   if($tzone=='Asia/Calcutta') $tzone='Asia/Kolkata';
   try {
       $tz = new DateTimeZone("$tzone");
       $lt=$tz->getLocation();
       $lat=$lt['latitude'];
       $lon=$lt['longitude'];
       echo "$tzone";		
       }
      catch (Exception $e) {
        echo 'Caught exception: ',  $e->getMessage(), "\n";
       }
  }
}

coun_list();

 

 

I get the below error on my Linux machine,

Caught exception: DateTimeZone::__construct() [datetimezone.--construct]: Unknown or bad timezone ()

 

Please help me to figure out the issue..

 

[joel24]

try run this so you can see the timezone that's throwing the error and post back

require_once("dbconnection.php");

function coun_list()
{
$rs=mysql_query("select name from timezones") or die(mysql_error());
while($row=mysql_fetch_row($rs))
  {
   $tzone=$row[0];
   if($tzone=='Asia/Calcutta') $tzone='Asia/Kolkata';
   try {
       $tz = new DateTimeZone("$tzone");
       $lt=$tz->getLocation();
       $lat=$lt['latitude'];
       $lon=$lt['longitude'];
       echo "$tzone";		
       }
      catch (Exception $e) {
        echo 'Caught exception on timezone ['.$tzone.']: ',  $e->getMessage(), "\n";
       }
  }
}

coun_list();

[divinequran]

I am getting below error.

 

Caught exception on timezone []: DateTimeZone::__construct() [datetimezone.--construct]: Unknown or bad timezone () 

[joel24]

it seems there some null / blank values in your table?

check that $tzone is echoing the correct value and maybe add a where clause to the SQL to test it,

WHERE name != '' AND name IS NOT NULL