PHP - Converting Time() After Retrevial

PHP 5.2.6

We rent PHP server space on a server in California. Several of my pages generated by PHP show the current date and time, so when the page is printed, the user knows when the data was printed. Our users could be anywhere in the US, I am in Michigan. How do I convert the server time (PDT) into local time, regardless of where the user is?

Thanks.

What are the differences and implications of UTC time and Zulu time?
  

<?php
function getArr(string $time):array
{
    $dateTime = new \DateTime($time);
    return [
        'time'=>$time,
        'timestamp'=> $dateTime->getTimestamp(),
        'dateTime' => $dateTime
    ];
}
$arr = getArr('2020-08-05');  
$arr_z = getArr('2020-08-05T00:00:00Z');  

print_r($arr);
print_r($arr_z);

echo('equal timestamps: '.($arr['timestamp'] === $arr['timestamp']?'true':'false'));

 

Array
(
    [time] => 2020-08-05
    [timestamp] => 1596585600
    [dateTime] => DateTime Object
        (
            [date] => 2020-08-05 00:00:00.000000
            [timezone_type] => 3
            [timezone] => UTC
        )

)
Array
(
    [time] => 2020-08-05T00:00:00Z
    [timestamp] => 1596585600
    [dateTime] => DateTime Object
        (
            [date] => 2020-08-05 00:00:00.000000
            [timezone_type] => 2
            [timezone] => Z
        )

)
equal timestamps: true

 

This topic has been moved to Application Design.

http://www.phpfreaks.com/forums/index.php?topic=316461.0

I am having a problem with PHP displaying the correct date and time. It updates as it should, but is fast by 4min and is always displaying a date in 2004. I ran a basic php script to make sure the application im using itself is not wrong. go to lunenburgledger.com/time.php

Anybody had any ideas on where to check? The system time on the Windows Server 2003 is correct. The only thing I can think of is that it was converted to a virtual machine on vmware esxi, but the system time stayed right. Any ideas?

Thanks!

OK So I've got a datepicker that sends a date in d/m/y format. My DB stores the data in Unix Timestamp Which I can convert the date to with strtotime however this does the exact date & time.

All I want is the actual day. I've spent hours trying to convert this with just the day with mixed results...

Thanks.

Hello,

I tried to implement some PHP code to enable a web page to show "Dinner" specials versus "Lunch" specials based on the time.

The business is located in the Eastern Time Zone, so I only need to routine to work based on Eastern Time (New York).

What I am noticing is that the server is processing the lines of code so fast that the command to establish the correct time for the remaining code is not always being acknowledged.

This line of code appears to be processing too fast for the remaining lines of code:
date_default_timezone_set ( "America/New_York" );

Is there some additional code I can put in place to make sure the correct time is always ascertained?

I need the $hourmin variable to always return a combination of hour + minute based on 24-hour time and Eastern Time zone.

My code is as follows:


 <?php
   $name8 = file_get_contents("test/special8name.txt");
date_default_timezone_set ( "America/New_York" );
$gethour = date("H");
$getminutes = $gettimedate["minutes"];
$gettimedate = date();
$hourmin = $gethour . $getminutes;
$currentday = date("l", time());
$currentdate = date("M j, Y");
if ($hourmin < 1500 && $currentday <> "Saturday" && $currentday <> "Sunday") {
   echo "<span class=\"namesred\">$name8 </span>";
}
  else if ( $hourmin > 1500 && $hourmin < 2300 && $currentday <> "Saturday" && $currentday <> "Sunday") {
   echo "<span class=\"namesblue\">$name8 </span>";
  }
  else if ( $currentday == "Saturday" or $currentday == "Sunday") {
   echo "<span class=\"namesblue\">$name8 </span>";
  }
?>

I have this:

    $sql = mysqli_query($conn, "SELECT ip
                                     , page
                                     , CASE WHEN referrer = ''
                                            THEN 'N/A'
                                            ELSE referrer
                                       END as referrer     
                                     , DATE_FORMAT(date, '%m/%d/%y') as date
                                     , TIME_FORMAT(time, '%T') as time
                                FROM tblTraffic 
                                ORDER BY date DESC, time DESC");

most of my traffic report contains the correct times, my time, which is CST in the USA.  but some records are off by a lot.  Does the time() function capture the time of the actual location from which the visitor is coming from?  if so, what could I do to return my timezone for any visitor?  w3 schools and php.net don't mention this.

Let's say I am buying a share for $10.

If I sell the share on the same day BEFORE 3:30PM, it will be sold for $10, but if I keep the share past 3:30PM, I want the code to automatically add $1 (Taxes and such) once in the the price of the share in database, after that no matter how many days pass by, the price will remain the same.

 

I've thought about CRON jobs, but I have no idea how to make/use them or set them up.

 

Any direction or help is appreciated.

 

 

I am making a time clock, and I was wondering what is the best way to calculate the number of hours an employee worked?

I have a table called "statuses" it holds names of punch types:
- id = the auto_inc
- status = "in/out/break/lunch" text statuses
- paid = whether or not the punch is paid or not (true/false)

I have another table called "logging" This table holds the information about the punch type:
- id = the auto_inc
- owner = the member id
- ip = members ip
- inout = the punch type from the statuses table
- location = the city/state of where the punch took place
- date = the time the member punched

Maybe I am over thinking this, but what is the best way to calculate the hours a person has worked?

Right now I am getting all the punches for for a particular member between a date range. then loop through the data to display it and passing it to a method in a class called Calc. I want to then add the times from punch in to punch out, then the next punch in to punch out.

Any suggestions?

Hi,

The hosting provider for my domain confirm me that the server time is in EST (UTC-5). They also sent me a grab supporting that
Code: [Select]
server time is now:
----------------------
Sun Nov 7 02:20:01 EST 2010
-------------------

But when I use the following code, the output I get is has 1 hr difference (UTC-6)
echo date("d M, Y h:i:s A",time());

Output==> 07 Nov, 2010 01:20:01 AM

But it suppose to give the same time as the server, ryt? Can anybody please explain?

Thanks,

Would someone please take a look at this.

I am trying to use a form to allow users to answer yes or no with radio buttons, and then print it out on another page.
I can only get the script to print the number 1 no matter which button is selected.
When I check the database the number 1 is recorded no matter which button is selected.
In the top of the input form I have
Code: [Select]
<input type='hidden' name='electricity' value='0'>In the body of the input form I have
Code: [Select]
Electricity <input type='radio' name='electricity' value='0'>no <input type='radio' name='electricity' value='1'>yesAnd on the output page I have
Code: [Select]
$electricity = $row['electricity'];
if ($electricity == 1) 
{
$answer = "YES";
}
else
{
$answer = "NO";
}and
Code: [Select]
echo $row['electricity'];I have been over and over this and can not discover my error.
Thank you for looking.

Hi All,

I am trying to "echo" a result from a SQL query, that returns a size in KB, but I want this to read in MB or GB - can PHP change this for me, or is it something I need to do in SQL?

Cheers
Matt

Hi Guys,

I am trying to use htmlentities and htmlspecialchars to convert a ampersand (&) to the html markup eqivalant (&amp;) to no avail. any ideas ?

htmlentities("this is & that");

xml file:
Code: [Select]
<PRICES>
<PRICE>
<WIC>HDE0AAFGRBOX</WIC>
<STOCK>100+</STOCK>
<MY_PRICE>219.00</MY_PRICE>
</PRICE>
</PRICES>php file:
Code: [Select]
<?
$filexml='stock.xml';
if (file_exists($filexml)) {
$xml = simplexml_load_file($filexml);
$f = fopen('stock.csv', 'w');
foreach($xml->PRICES->PRICE as $price) {
fputcsv($f, get_object_vars($price),',','"');
}
fclose($f);
}
?>
Error:
Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\stock.php on line 6

Please help with this.

Hello guys, I have been away for a couple of days. Its nice to be back   Yesterday night I was practicing an AJAX/PHP delete tutorial and file "delete.php" was wrtiten in mysql* which I converted to PDO but it didnt seem to work after conversion. The three bits of code are as follows

//I got the results using PDO::FETCH_ASSOC in following div getting ID of row in link
while ($r = $getData->fetch(PDO::FETCH_ASSOC)){
  echo ("
     <div class='record' id='record-".$r['id']."'>
       <a href='?delete=".$r['id']."' class='delete'>[x]</a>
     </div> 
  ");
} 

$(document).ready(function() {
	$('a.delete').click(function(e) {
		e.preventDefault();
		var parent = $(this).parent();
		$.ajax({
			type: 'get',
			url: 'delete.php',
			data: 'ajax=1&delete=' + parent.attr('id').replace('record-',''),
			beforeSend: function() {
				parent.animate({'backgroundColor':'#fb6c6c'},300);
				},
			success: function() {
				parent.slideUp(300,function() {
					parent.remove();
				});
			}
		});
	});
}); 

and delete.php contains

 include "inc.connect.php";
 if(isset($_GET['delete'])){
   $id = $_GET['delete'];
   $query = "DELETE FROM tempdata WHERE id=?";
   $runThis = $db->prepare($query);
   $runThis->bindValue(1,$id);
   $runThis->execute();
 } 

/*The problem I am facing is in delete.php. because If i run the same script in mysql_*,
it works, which is as follows first (I had to write connect in mysql as
original connection is written in PDO)
------------------------------------------------------

$con = mysql_connect('localhost','munni****','*******');
mysql_select_db('stockcontrol',$con);

if(isset($_GET['delete'])) {
  $result = mysql_query('DELETE FROM tempdata WHERE id = '.(int)$_GET['delete'],$con);
}
mysql_close($con); */

Edited by Digitizer, 11 September 2014 - 07:08 AM.