Solved

Convert table with dynamic time data to be viewable as a web page online?

Posted on 2014-11-17
6
97 Views
Last Modified: 2014-11-20
I have a table with dynamically changing time data.  Each time the sheet is refreshed, the correct time for each time zone is shown.  I need to convert that so that it shows up online.
Countries.xlsx
0
Comment
Question by:frugalmule
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 9

Assisted Solution

by:Brian Tao
Brian Tao earned 167 total points
ID: 40447714
Why don't you just use a page that's already on the Internet? like http://www.timeanddate.com/worldclock/full.html
0
 

Author Comment

by:frugalmule
ID: 40447729
I do not know how to combine it with the data I already have in the table.  I need all the data in the table, not just the times.
0
 
LVL 110

Assisted Solution

by:Ray Paseur
Ray Paseur earned 333 total points
ID: 40447817
You can set the time according to a locale with date_default_timezone_set().  Please see the first demonstration script in this article.
http://iconoun.com/demo/temp_frugalmule.php

<?php // demo/temp_frugalmule.php
error_reporting(E_ALL);
echo '<pre>';

// TIMEZONES AROUND THE GLOBE
$locations
= array
( 'Pacific/Auckland'
, 'Australia/Sydney'
, 'Australia/Perth'
, 'Asia/Tokyo'
, 'Asia/Calcutta'
, 'Asia/Tel_Aviv'
, 'Africa/Cairo'
, 'Europe/Rome'
, 'Europe/London'
, 'Atlantic/Bermuda'
, 'America/Chicago'
, 'America/Anchorage'
, 'Pacific/Honolulu'
, 'UTC'
)
;
// ITERATE OVER THE TIMEZONES
foreach ($locations as $location)
{
    // SET THE TIMEZONE FOR DISPLAY
    date_default_timezone_set($location);

    // SHOW THE LOCATION AND THE CURRENT DATE / TIME
    echo PHP_EOL . str_pad($location, 24, ' ');
    echo date('r');

    // SHOW THE NUMBER OF SECONDS SINCE THE EPOCH, RECOMPUTED IN EACH TIMEZONE
    echo ' ' . number_format( time() );
}

Open in new window

0
Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

 

Author Comment

by:frugalmule
ID: 40447841
That is only showing the syntax > http://tedpenner.com/countries/
0
 
LVL 110

Accepted Solution

by:
Ray Paseur earned 333 total points
ID: 40447850
It's a standalone script, meant to be used as a teaching example.  It's not designed to be embedded into a blog.  You can see it in action on my server, here:
http://iconoun.com/demo/temp_frugalmule.php
0
 

Author Closing Comment

by:frugalmule
ID: 40455780
Thanks
0

Featured Post

Why You Need a DevOps Toolchain

IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to write a Context Sensitive Help (an online help that is obtained from a specific point in state of software to provide help with that state) ,  first we need to make the file that contains all topics, which are given exclusive IDs. …
Dramatic changes are revolutionizing how we build and use technology. Every company is automating, digitizing, and modernizing operations. We need a better, more connected way to work together as teams so we can harness the insights from our system…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question