PHP - Print Local In Php

Hi everyone,

The website I am working on is http://teemagroup.com/puyafolder and I have a global navigation with a drop down menu.

What I want to do is on the right side have a PHP code to pull sub-pages under the drop down menu that its in. I don't quite know how to write it.

For example everything under "Client Services" would go on the right side of that page. You know, to make it locally available instead of a drop down. And this code would work with all other pages. It would just pull what's under that page.

I've added some files for you if you need it. This is done in wordpress if you wanted to know.

im wondering is there any easy way to echo server time and local time... without converting them from unix to timestamp

i have found thi code, but i cant tell is it server or local
Code: [Select]
echo date("H:i" ,time());

I am trying to get local date/time.
In my php file I am setting my timezone using
$timezone = "America/Toronto";
putenv ('TZ=' . $timezone);
Then I use the following to get current date and time
print_r (getdate());
but my date displays in GMT,
What am I doing wrong? As in the code above I am in Toronto and I need EST.

I am trying to do age validation for a beverage site, and losing my mind.  First time trying local storage (to persist across browser sessions) and I assume I have something screwed up.  Anyone able to help me figure out how to make this work?

<?php
    if( isset( $_POST['yes'] ) )
    {
    	localStorage.setItem('age_verification', 'true');

        if( isset( $_GET['url'] ) )
        {
            die( header('Location: ' . $_GET['url'] ) ); 
        } 
        else
        {
            die( header('Location: index.php') );
        }
    }
    elseif( isset( $_POST['no'] ) )
    {
    	localStorage.setItem('age_verification', 'false');
    }
	var age_verification = localStorage.getItem('age_verification'); //new
	if (age_verification = "false" || age_verification = "null") die( header('Location: http://www.bing.com') );	
?>

Above is the code for the file checkagenew.php which I call from other pages using the below:

<?php
	if (localStorage.age_verification) { localStorage.setItem('age_verification', 'null'); }
	var age_verification = localStorage.getItem('age_verification');
	if (age_verification = "false" || age_verification = "null") die( header("Location: checkagenew.php?url=http://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]") );
?>  

Obviously there is a form included in the top part (not shown) that has a submit for yes/no which triggers the $_POST validation... I did not include that for brevity.

Hey all, this is my first post ever and am not really sure if this is the right place for it or not, sorry in advance if it isn't. I'm new to PHP and trying to learn. I'm running Ubuntu 10.04 LTS and Firefox 3.6.22. I have libapache2-mod-php5 installed and running, but for some reason everytime I try to open a local .php file in firefox the download manager pops up and ask me what I want to do with the file. Has anyone else encountered this before? Is it something simple that I overlooked? Any help would be appreciated.

Hello all,
   I'm a PHP newbie, so please pardon me if this question has already been asked somewhere in this forum. I have been reading the PHP documentation. On this page http://www.php.net/manual/en/language.references.pass.php, I came across this code:

<?php
... snip ...
function &bar()
{
    $a = 5;
    return $a;
}
foo(bar());
?>

This is returning a reference to local variable $a. Coming from a C/C++ background, my intuition tells me this just shouldn't work, since the local variable $a should be deleted as soon as the function "bar" returns. The code seems to work, though. My guess is that PHP is basically ref-counting and garbage collecting local variables like $a, and so it will not be automatically cleaned up on call exit. Is this about right? Thanks!

WN

Hi.
I was asked to make a portal to facilitate access information of the company.
There are databases in MSSQL and Oracle, and products made in PHP. NET and access to two different server files via network shares.
Also as a facilitator wanted access to the files (default documents) on the local machines of users.
I've done something, but now I'm locked in for remote access client machines.
Is there any way to do this in PHP? and using another type of language?

Newbie question.

I have a form that uses reCaptcha. If the Captcha is entered correctly it posts the data.

Can I redirect the page using php or do I need to use javascript?

I was going to throw in header('Location: thankyou.php'); but from my limited understanding this cannot be used anywhere except the very top of the page.


  if (!$resp->is_valid) {
//    What happens when the CAPTCHA was entered incorrectly
    die ("The reCAPTCHA wasn't entered correctly. Go back and try it again." .
         "(reCAPTCHA said: " . $resp->error . ")");
  } else {
  echo "Recapture entered correctly!"; // Just for testing purposes
postdata($firstname, $lastname, $company, $email, $phone, $comments); // sends data to my databse

// this is where I would expect to redirect to a new page

  }

Thanks phpfreaks

Hi Guys,   I'm actually a .net programmer, but was asked by a local company to make some improvements / add new features to an internal web app they use to help them manage their project pipeline.   I've been working with them for about a year and learning PHP as I go along. The site was originally built in house by a keen programming hobbyist so between him and me the code is probably a bit non-standard.   I'm looking for an experienced PHPer (with the usual web dev addons: JS/JQuery, CSS, HTML, MYSQL) who would be interested in putting in some hours/days to help move the thing along and happy to pay £150/day or equivalent hours if preferred.   The project is in a Git Repository on Kiln (owned by FogCreek, who do Fogbugz if you've heard of that) but I could move it to GitHub no probs. Current dev site is hosted on Vidahost.   Thanks, Fergus

I wrote this script to rename my many tv series I have on my pc, works by finding a string in the file name and replacing it the script works fine until I want to replace the file name with something that is also in the path file = band ep01.avi path = j:\media\ TV shows\Band of Brothers\   so if I try to change "Band" to "Band of Brothers" the path changes as well  is there a way I can change the code so it dosent effect the path ??

<?php

$path = 'J:\media\TV shows\Band of Brothers';

foreach(glob($path.'/*.*') as $filename){         
              echo $filename."</BR>";
}

?> 
 <table align="center" width="200px" border="0" cellspacing="1" cellpadding="3">
 <form name="form1" method="get" action="mov.php">
 <tr>
 <td colspan="3"><strong> </strong></td>
 </tr>
 <tr>
 <td width="71">Replace</td>
 <td width="6">:</td>
 <td width="301"><input name="rep" type="text" id="rep"></td>
 </tr>
 <tr>
 <td>With</td>
 <td>:</td>
 <td><input name="with" type="text" id="with"></td>
 </tr>
 <tr>
 <tr>
 <td colspan="3" align="center"><input type="submit" name="Submit" value="Submit"></td>
 </tr></form>
 </table>
 
<?php
                if (isset($_GET["rep"])) {
                $rep1=$_GET['rep'];
                }
                if (isset($_GET["with"])) {
                $with1=$_GET['with'];
                }
                
                
 foreach(glob($path.'/*.*') as $filename){        
              $strip =  str_replace($rep1, $with1, $filename);
              echo $strip."</br>";  
              rename($filename,$strip);
}
    
?>

Hey, sorry I'm a newb so prepare for me to do everything wrong even though I read the FAQ.     I'm trying to use a simple php script to input data to register but I get this error:  "Failed to run query: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined"  once I fill out the form.    I've seen other people get this error but I seem to have different problems to them and can't figure it out.    My PHP script is just

<?php


require("config.inc.php");

//if posted data is not empty
if (!empty($_POST)) {
  
    if (empty($_POST['username']) || empty($_POST['password'])) {
		
	
	  
	    $response["success"] = 0;
	    $response["message"] = "Please Enter Both a Username and Password.";

		
        die(json_encode($response));
    }

    $query        = " SELECT 1 FROM users WHERE username = :user";
    $query_params = array(
        ':user' => $_POST['username']
    );
    
    try {
        $stmt   = $db->prepare($query);
        $result = $stmt->execute($query_params);
    }
    catch (PDOException $ex) {
        die("Failed to run query: " . $ex->getMessage());

		$response["success"] = 0;
		$response["message"] = "Database Error. Please Try Again!";
		die(json_encode($response));
    }
    

    $row = $stmt->fetch();
    if ($row) {
        die("This username is already in use");
		$response["success"] = 0;
		$response["message"] = "I'm sorry, this username is already in use";
		die(json_encode($response));
    }
    
    $query = "INSERT INTO users ( username, password ) VALUES ( :user, :pass ) ";
    
    $query_params = array(
        ':username' => $_POST['username'],
        ':password' => $_POST['password']
    );
    
    try {
        $stmt   = $db->prepare($query);
        $result = $stmt->execute($query_params);
    }
    catch (PDOException $ex) {
        die("Failed to run query: " . $ex->getMessage());
		$response["success"] = 0;
		$response["message"] = "Database Error. Please Try Again!";
		die(json_encode($response));
    }

	$response["success"] = 1;
	$response["message"] = "Username Successfully Added!";
	echo json_encode($response);

    
} else {
?>
	<h1>Register</h1> 
	<form action="index.php" method="post"> 
	    Username:<br /> 
	    <input type="text" name="username" value="" /> 
	    <br /><br /> 
	    Password:<br /> 
	    <input type="password" name="password" value="" /> 
	    <br /><br /> 
	    <input type="submit" value="Register New User" /> 
	</form>
	<?php
}

?>

and the config: 

<?php 
	$username = "root"; 
    $password = ""; 
    $host = "localhost"; 
    $dbname = "drinkdealz"; 


   
    $options = array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'); 
     
  
    try 
    { 
       
        $db = new PDO("mysql:host={$host};dbname={$dbname};charset=utf8", $username, $password, $options); 
    } 
    catch(PDOException $ex) 
    { 
       
        die("Failed to connect to the database: " . $ex->getMessage()); 
    } 
     
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 
     
  
    $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC); 
     
 
    if(function_exists('get_magic_quotes_gpc') && get_magic_quotes_gpc()) 
    { 
        function undo_magic_quotes_gpc(&$array) 
        { 
            foreach($array as &$value) 
            { 
                if(is_array($value)) 
                { 
                    undo_magic_quotes_gpc($value); 
                } 
                else 
                { 
                    $value = stripslashes($value); 
                } 
            } 
        } 
     
        undo_magic_quotes_gpc($_POST); 
        undo_magic_quotes_gpc($_GET); 
        undo_magic_quotes_gpc($_COOKIE); 
    } 
     
    header('Content-Type: text/html; charset=utf-8'); 
     
  
    session_start(); 




?>

Sorry if I uploaded anything wrong and it's only a localhost so I don't really care about passwords etc (none will be the same when I upload it)  So if any of you can even point me in the direction of what to look for that would be brilliant. Cheers, Kieran

Hi there. I hope you guys can help :)

This works on local host but once online it fails with "PHP Warning:  session_start(): Cannot start session when headers already sent in /home/martinsb/public_html/switcher/switch.php on line 10"

Here is the nav  part

<!---new code added for style switcher-->
 
Style is set to <?php echo $_SESSION["msg"];?><br/>
      
        <a class="<?php echo $_SESSION['look0'];?>" href="switcher/switch.php?set=default">Default</a>
        <a class="<?php echo $_SESSION['look1'];?>" href="switcher/switch.php?set=ada">ADA</a>
        <a class="<?php echo $_SESSION['look2'];?>" href="switcher/switch.php?set=burrito">Burrito</a><br/>
        <div style="font-size:12px; padding-top:8px; padding-bottom:10px;"><?php echo $_SESSION["why"];?></div>
        

<!--end switcher-->

 

Here is the switcher.php

<?php

    $part= $_SERVER['HTTP_REFERER'];
    $path_parts = pathinfo($part);
     $result = $path_parts['basename'];
    
    
session_start();

?>
<?php
if( !isset($_GET['set'])){
    echo "";
    }
    
elseif ($_GET['set']=='default') {
        
        $_SESSION["css"]="css/mysite.css";
        $_SESSION["msg"]="Default";
        
        
        }    

elseif ($_GET['set']=='dark') {
        
        $_SESSION["css"]="css/darkstyles.css";
        $_SESSION["msg"]="Dark";
        
        
        }
        
elseif($_GET['set']=='light')  {
        
        $_SESSION["css"]="css/lightstyles.css";
        $_SESSION["msg"]="Light";
    
        
        }
        
if   ( !isset($_SESSION["css"]) )
    {$_SESSION["css"]="css/mysite.css";
        $_SESSION["msg"]="Default";
    
        }
        
        
        
?>    
<?php
// 301 Moved Permanently

header("Location: ../$result", true, 301);

exit();
?>

hello,

im trying to figure out how to display a persons local:

Code: [Select]
c:\ProgramData\Microsoft\Windows\Start Menu\Programs\Games
and have it so it shows with icons.  so if they click it will lauch their game locally

any ideas?

I have successfully used the Yahoo local search API and received results in XML format. I am trying to use PHPs Simple XML to parse the data into an array so I can loop through and print specific elements.

I cannot get to specific elements and I have read several threads online.

Below is some code and below that is the XML. I am trying to get to the elements like title, address, etc.

Code: [Select]
$url = 'http://local.yahooapis.com/LocalSearchService/V3/localSearch?appid=<my yahoo api key>&category=Casinos&query=blackjack&zip=95035&radius=20&results=10';

$xml = file_get_contents($url);

$phpobject = simplexml_load_string($xml);

foreach($phpobject->attributes() as $name=>$attr) {
   $res[$name]=$attr;   
}

Code: [Select]
<ResultSet xsi:schemaLocation="urn:yahoo:lcl http://local.yahooapis.com/LocalSearchService/V3/LocalSearchResponse.xsd" totalResultsAvailable="48" totalResultsReturned="10" firstResultPosition="1">
−
<ResultSetMapUrl>
http://maps.yahoo.com/broadband/?q1=Milpitas%2C+CA+95035&tt=poker&tp=1
</ResultSetMapUrl>
−
<Result id="34179399">
<Title>Bay Area Poker Chip</Title>
<Address>1274 Piper Dr</Address>
<City>Milpitas</City>
<State>CA</State>
<Phone>(408) 263-8611</Phone>
<Latitude>37.412359</Latitude>
<Longitude>-121.891794</Longitude>
−
<Rating>
<AverageRating>5</AverageRating>
<TotalRatings>1</TotalRatings>
<TotalReviews>1</TotalReviews>
<LastReviewDate>1198993183</LastReviewDate>
−
<LastReviewIntro>
I bought 100% real clay chips from here and obsolutely love it. I had a poker game that night and needed chips and a table. They had everything in stock and saved me time to look around. Great products and great service and I highly recommend this place to anybody
</LastReviewIntro>
</Rating>
<Distance>1.33</Distance>
−
<Url>
http://local.yahoo.com/info-34179399-bay-area-poker-chip-milpitas
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-34179399-bay-area-poker-chip-milpitas
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=1274+Piper+Dr+Milpitas+CA&gid1=34179399
</MapUrl>
<BusinessUrl>http://bayareapokerchip.com/</BusinessUrl>
<BusinessClickUrl>http://bayareapokerchip.com/</BusinessClickUrl>
−
<Categories>
<Category id="96928631">Graphic Design</Category>
</Categories>
</Result>
−
<Result id="44540748">
<Title>Bay Area Poker Chip</Title>
<Address>519 Montague Expy</Address>
<City>Milpitas</City>
<State>CA</State>
<Phone>(408) 263-8611</Phone>
<Latitude>37.409925</Latitude>
<Longitude>-121.89489</Longitude>
−
<Rating>
<AverageRating>NaN</AverageRating>
<TotalRatings>0</TotalRatings>
<TotalReviews>0</TotalReviews>
<LastReviewDate/>
<LastReviewIntro/>
</Rating>
<Distance>1.48</Distance>
−
<Url>
http://local.yahoo.com/info-44540748-bay-area-poker-chip-milpitas
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-44540748-bay-area-poker-chip-milpitas
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=519+Montague+Expy+Milpitas+CA&gid1=44540748
</MapUrl>
<BusinessUrl>http://www.bayareapokerchip.com/</BusinessUrl>
<BusinessClickUrl>http://www.bayareapokerchip.com/</BusinessClickUrl>
−
<Categories>
<Category id="96925976">Sporting Goods</Category>
<Category id="96935378">Games</Category>
</Categories>
</Result>
−
<Result id="67710717">
<Title>Poker Da Vinci</Title>
<Address>51 E Campbell Ave</Address>
<City>Campbell</City>
<State>CA</State>
<Phone>(408) 866-4446</Phone>
<Latitude>37.287157</Latitude>
<Longitude>-121.94942</Longitude>
−
<Rating>
<AverageRating>NaN</AverageRating>
<TotalRatings>0</TotalRatings>
<TotalReviews>0</TotalReviews>
<LastReviewDate/>
<LastReviewIntro/>
</Rating>
<Distance>10.40</Distance>
−
<Url>
http://local.yahoo.com/info-67710717-poker-da-vinci-campbell
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-67710717-poker-da-vinci-campbell
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=51+E+Campbell+Ave+Campbell+CA&gid1=67710717
</MapUrl>
<Categories/>
</Result>
−
<Result id="21599986">
<Title>Bay 101 Banquet Facilities</Title>
<Address>1801 Bering Dr</Address>
<City>San Jose</City>
<State>CA</State>
<Phone>(408) 451-8888</Phone>
<Latitude>37.373044</Latitude>
<Longitude>-121.912125</Longitude>
−
<Rating>
<AverageRating>4</AverageRating>
<TotalRatings>2</TotalRatings>
<TotalReviews>2</TotalReviews>
<LastReviewDate>1200040214</LastReviewDate>
−
<LastReviewIntro>
If youre looking for high limit action Bay 101 is the place to go in San Jose. You can regularly find limit games up to $80-$160 in their spacious high ceiling room.
</LastReviewIntro>
</Rating>
<Distance>4.13</Distance>
−
<Url>
http://local.yahoo.com/info-21599986-bay-101-banquet-facilities-san-jose
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-21599986-bay-101-banquet-facilities-san-jose
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=1801+Bering+Dr+San+Jose+CA&gid1=21599986
</MapUrl>
<BusinessUrl>http://bay101.com/</BusinessUrl>
<BusinessClickUrl>http://bay101.com/</BusinessClickUrl>
−
<Categories>
<Category id="96929273">Casinos</Category>
</Categories>
</Result>
−
<Result id="21401964">
<Title>Thwart Poker Incorporated</Title>
<Address>525 Lincoln Ave</Address>
<City>Palo Alto</City>
<State>CA</State>
<Phone>(650) 329-9627</Phone>
<Latitude>37.444049</Latitude>
<Longitude>-122.151513</Longitude>
−
<Rating>
<AverageRating>NaN</AverageRating>
<TotalRatings>0</TotalRatings>
<TotalReviews>0</TotalReviews>
<LastReviewDate/>
<LastReviewIntro/>
</Rating>
<Distance>14.09</Distance>
−
<Url>
http://local.yahoo.com/info-21401964-thwart-poker-incorporated-palo-alto
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-21401964-thwart-poker-incorporated-palo-alto
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=525+Lincoln+Ave+Palo+Alto+CA&gid1=21401964
</MapUrl>
−
<Categories>
<Category id="96926908">Internet Access Providers</Category>
<Category id="96932773">Computer Business Solutions</Category>
</Categories>
</Result>
−
<Result id="21574436">
<Title>Blinky's Can't Say Lounge</Title>
<Address>1031 Monroe St</Address>
<City>Santa Clara</City>
<State>CA</State>
<Phone>(408) 985-7201</Phone>
<Latitude>37.348893</Latitude>
<Longitude>-121.94816</Longitude>
−
<Rating>
<AverageRating>5</AverageRating>
<TotalRatings>3</TotalRatings>
<TotalReviews>3</TotalReviews>
<LastReviewDate>1228667811</LastReviewDate>
−
<LastReviewIntro>
Good drinks good prices good people. Who could ask for more.....
</LastReviewIntro>
</Rating>
<Distance>6.39</Distance>
−
<Url>
http://local.yahoo.com/info-21574436-blinky-s-can-t-say-lounge-santa-clara
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-21574436-blinky-s-can-t-say-lounge-santa-clara
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=1031+Monroe+St+Santa+Clara+CA&gid1=21574436
</MapUrl>
−
<Categories>
<Category id="96926057">All Bars, Pubs, & Clubs</Category>
<Category id="96926063">Bars & Pubs</Category>
</Categories>
</Result>
−
<Result id="21619987">
<Title>Barbara of Pauline's Cake Decorating Supplies</Title>
<Address>1093 Malone Rd</Address>
<City>San Jose</City>
<State>CA</State>
<Phone>(408) 978-9740</Phone>
<Latitude>37.293702</Latitude>
<Longitude>-121.889876</Longitude>
−
<Rating>
<AverageRating>4.5</AverageRating>
<TotalRatings>8</TotalRatings>
<TotalReviews>8</TotalReviews>
<LastReviewDate>1268173462</LastReviewDate>
−
<LastReviewIntro>
I love this store. No matter what it is i am looking for weather it is some thing i remember from my child hood or some thing i saw in a magazine and i need it i know i can find it there. Yes they are a little rough around the edges but that is only because they are trying to get it across to you what will work and what will not. This is an old school store with people who know their stuff and are only trying to help you get the best end result possible. I am 46 years old and i took my class from Barbara when i first came out of high school and believe me she will not try to up sale you or tell you some thing is going to work if it will not. Go in expecting to be overwhelmed by stock and know you are going to get the best prices in town. Take the time to get to know the employees and the store and you will always go back to Paulines. I travel all the way from Livermore to get stuff i know i can only find there. Thanks for all your many years of being in business
</LastReviewIntro>
</Rating>
<Distance>9.52</Distance>
−
<Url>
http://local.yahoo.com/info-21619987-barbara-of-pauline-s-cake-decorating-supplies-san-jose
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-21619987-barbara-of-pauline-s-cake-decorating-supplies-san-jose
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=1093+Malone+Rd+San+Jose+CA&gid1=21619987
</MapUrl>
−
<Categories>
<Category id="96928859">Wedding Supplies & Services</Category>
</Categories>
</Result>
−
<Result id="21602089">
<Title>Carey David Incorporated</Title>
<Address>1624 Remuda Ln</Address>
<City>San Jose</City>
<State>CA</State>
<Phone>(408) 453-7843</Phone>
<Latitude>37.372385</Latitude>
<Longitude>-121.908305</Longitude>
−
<Rating>
<AverageRating>NaN</AverageRating>
<TotalRatings>0</TotalRatings>
<TotalReviews>0</TotalReviews>
<LastReviewDate/>
<LastReviewIntro/>
</Rating>
<Distance>4.13</Distance>
−
<Url>
http://local.yahoo.com/info-21602089-carey-david-incorporated-san-jose
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-21602089-carey-david-incorporated-san-jose
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=1624+Remuda+Ln+San+Jose+CA&gid1=21602089
</MapUrl>
<BusinessUrl>http://dc-enterprises.com/</BusinessUrl>
<BusinessClickUrl>http://dc-enterprises.com/</BusinessClickUrl>
−
<Categories>
<Category id="96928508">Clothing Wholesalers</Category>
<Category id="96928509">Clothing Manufacturers</Category>
<Category id="96931030">Apparel Manufacturing</Category>
</Categories>
</Result>
−
<Result id="30246475">
<Title>Royal Casino Parties</Title>
<Address>943 Berryessa Rd, #6</Address>
<City>San Jose</City>
<State>CA</State>
<Phone>(408) 213-0904</Phone>
<Latitude>37.363563</Latitude>
<Longitude>-121.886341</Longitude>
−
<Rating>
<AverageRating>NaN</AverageRating>
<TotalRatings>0</TotalRatings>
<TotalReviews>0</TotalReviews>
<LastReviewDate/>
<LastReviewIntro/>
</Rating>
<Distance>4.71</Distance>
−
<Url>
http://local.yahoo.com/info-30246475-royal-casino-parties-san-jose
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-30246475-royal-casino-parties-san-jose
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=943+Berryessa+Rd%2C+%236+San+Jose+CA&gid1=30246475
</MapUrl>
<BusinessUrl>http://www.royalcasinoparties.com/</BusinessUrl>
<BusinessClickUrl>http://www.royalcasinoparties.com/</BusinessClickUrl>
−
<Categories>
<Category id="96925812">Entertainment Production</Category>
<Category id="96930362">Gambling</Category>
</Categories>
</Result>
−
<Result id="25247620">
<Title>Bay Casino Gaming, Casino Party Rentals</Title>
<Address/>
<City>San Jose</City>
<State>CA</State>
<Phone>(408) 747-1977</Phone>
<Latitude>37.338475</Latitude>
<Longitude>-121.885794</Longitude>
−
<Rating>
<AverageRating>NaN</AverageRating>
<TotalRatings>0</TotalRatings>
<TotalReviews>0</TotalReviews>
<LastReviewDate/>
<LastReviewIntro/>
</Rating>
<Distance>6.44</Distance>
−
<Url>
http://local.yahoo.com/info-25247620-bay-casino-gaming-casino-party-rentals-san-jose
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-25247620-bay-casino-gaming-casino-party-rentals-san-jose
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=+San+Jose+CA&gid1=25247620
</MapUrl>
<BusinessUrl>http://www.baycasinogaming.com/</BusinessUrl>
<BusinessClickUrl>http://www.baycasinogaming.com/</BusinessClickUrl>
−
<Categories>
<Category id="96925812">Entertainment Production</Category>
<Category id="96925814">Party Rentals</Category>
</Categories>
</Result>
</ResultSet>

I have all the dates stored in my database as UTC and I want to retrieves these UTC date/time to show the local time zone. So, example, If I live in New York, I want it to show east coast time zone and not the Universal Time. Any idea?