TIME and DATE issue

[jjoves]

I want to be able to display the correct time format which should be PST - since Im in california.

here is the insert code to MySQL

$sql = "insert into notes (notes_date,notes_note,notes_time,notes_user) values ('$mydate','$mynotes',CURTIME(),'$user')";

here is the display code:

$row[notes_user] $row[notes_time]

here is the html output:
USER 04:24:34 --------- which should be 2:24AM

I am not even sure what time 4:24 is - I guest it's EST time.

THANK YOU

[jassh]

hi ther jjoves..

hey mate.. ur entering the php-notes contest dude??
if you do, gewd luck eh...

anyway, here's a function that u can use...

$thetime = date ("h:i:s A");

this will echo 04:24:23 AM,
but this depend on the server time..
the time that is diplayed in the machine
where the code is executed..

checkout this page for more details...

http://www.php.net/manual/en/function.date.php

hope that helps...

• jassh

[jjoves]

Thanks -- well that's what happen when your learning on your own - Anyways where should I put your code:

here's mine

<?
					$sql = "select * from notes order by notes_id desc";
					$result = mysql_query($sql);
						while ($row=mysql_fetch_array($result)) {
							echo "
							<strong style='font-size: 11px;'>$row[notes_user]</strong> $row[notes_time]
							<br>-------------------------------------------------------------------------------------
							<br/>".nl2br(stripslashes($row[notes_note]))."<br /><br />";
							}
							mysql_free_result($result);
							 if ($mynotes && $user) { 
							 	if ($allowhtml == "0") {
									$mynotes = str_replace("<", "&lt;", "$mynotes");
									$mynotes = str_replace(">", "&gt;", "$mynotes");
									}
						if ($mydate && $todayonly == "0") {
						$sql = "insert into notes (notes_date,notes_note,notes_time,notes_user) values ('$mydate','$mynotes',CURTIME(),'$user')";}
							 else {	
						 $mydate = date("Y-m-d");
							$sql = "insert into notes (notes_date,notes_note,notes_time,notes_user) values ('$mydate','$mynotes',CURTIME(),'$user')";}
								mysql_query($sql) or die("error 324343");
							$adate = explode("-", $mydate);
							$mymonth = $adate[1]-1;
					header("Refresh:0;url=$PHP_SELF?day=$adate[2]&month=$mymonth&year=$adate[0]");	}
						if ($todayonly == "1") {
					$posttext = "<strong style='font-size: 10px;color:#666699;'>Note: You can only post under today's date</strong>"; }
				 else {	
					$posttext = "<strong style='font-size: 10px;color:#666699;'>Note: You can post notes under any date, past, present or future</strong>";	
			      }
			?>

[jassh]

hi there jjoves...

okay.. first of all,
have you tried the code that i gave you..
well, if that's how you would like your time to be displayed, then...

here's my suggestion on how you can go about it..

//first, i guess u can make a var to display the time

$thetime = date ("h:i:s A");
.
.
.
.
.

//here, you just put the time var in the sql query..


if ($mydate && $todayonly == "0") {
                        $sql = "insert into notes (notes_date,notes_note,notes_time,notes_user) values ('$mydate','$mynotes','$thetime','$user')";}
                             else {    

                         $mydate = date("Y-m-d");
                            $sql = "insert into notes (notes_date,notes_note,notes_time,notes_user) values ('$mydate','$mynotes','$thetime','$user')";}

so this mean, it will display the time for that machine
in this case, your code will display the time on ur PC
(which i believe is ur server, and it follow california time...)
Note that, if you change your server time,
it will reflect the time echoed in the coding..

i hope that helps...
but i'm sure, there's a lot of pro out there,
who probably havef better idea..
good luck, and have a nice day..

• jassh

p/s: dude, u entering the contest??

[jjoves]

THANKS for the help -- what contest are you talking about?

anyways tried your code and here is the result:

USER 12:54:44 --------- which is off by 2 hours -- I think this goes by the server time - and it does not display AM or PM still -- I'll be reading the manual though.

[jjoves]

Almost there again ---

K

this is what i have so far -

$thetime = date("F j, Y, g:i a");

output:
USER 00:00:27 ------>

I want it to show this
[03:26:03 - 11:00 pm]