----- Original Message ----- 
From: "Jennifer Gardner"

Hello,

I am looking for a good tutorial for having the date submitted when a form
is submitted and then being able to display the date in a results
table/page.  Basically, when the form is submitted I want the date submitted
into the mysql table and then I want to display that on a results page.
Thank you in advance for your help.

 Jennifer
------------------------------

Hi Jennifer,
                Here is some code of mine that may be helpful. It does not 
answer your question about MySQL but it does however show how to deal with 
location issues and how to transfer a time zone (GMT+10) from the server in 
PHP onto the client in Javascript independent of the client locale. You can 
see the generated source at ozwebwiz.info

Thanks, Robert.

<html>
<head>
<title>Current Server Time</title>
<script language="javascript">
<!--
<?php

echo('var cnsDate = new Date(' . (time() + 10 * 60 * 60) . '000);' . "\n");

?>
var postfix = "AM";
if (cnsDate.getUTCHours() > 11)
  {cnsDate.setUTCHours(cnsDate.getUTCHours() - 12);postfix = "PM";}
if (cnsDate.getUTCHours() == 0)
  {cnsDate.setUTCHours(12);}
cairnstime = cnsDate.getUTCHours();

var prefix = ":";
if (cnsDate.getUTCMinutes() < 10)
  {prefix=":0";}
cairnstime = cairnstime + prefix + cnsDate.getUTCMinutes() +postfix;

var day = ["Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", 
"Saturday"];
cairnstime = cairnstime + " " + day[cnsDate.getUTCDay()];

var month = ["January", "February", "March", "April", "May", "June", "July", 
"August", "September", "October", "November", "December"];
cairnstime = cairnstime + " " + month[cnsDate.getUTCMonth()];
cairnstime = cairnstime + " " + cnsDate.getUTCDate();
cairnstime = cairnstime + ", " + cnsDate.getUTCFullYear();

// -->
</script>
</head>
<body>
<?php

echo("Server Time/Date: " . date("g:iA l F j, Y") . "<br>\n");
echo("GMT Time/Date: " . gmdate("g:iA l F j, Y") . "<br>\n");
echo("Cairns Time/Date: " . gmdate("g:iA l F j, Y", time() + 10 * 60 * 60) . 
"<br>\n");

?>
<br>
Javascript Time/Date:&nbsp;
<script language="javascript">
<!--
document.write(cairnstime);
// -->
</script>
<br>
</body>
</html> 

Reply via email to