PHP - Current Time And Date

Hi, Currently I am making a module for joomla. every article has an publish date, if the article was published in 7 days ago, it will displayed as "article in last week", My idea is to use today's date - publish date, if the result is greater than 7 and smaller than 14, the article will be displayed as "article in last week.
Any one know how to write this code?
Here is what I have got, but not working.

<?php
$todays_date = date("Y-m-d"); 

$result = mysql_query("select * from jos_content where $test between $todays_date-14 and $todays_date-7");  
while($row = mysql_fetch_array($result))
  {
echo "$todays_date - $row[title]";
}
?>

Hi,

I have database stored a field of date. I want to check if the date in the DB field is the same as the current date, how to do it?

Code:

$oracle = mysqli_real_escape_string($con, $_POST['oracle']);
$query 	= mysqli_query($con, "SELECT indate FROM staff WHERE OracleID ='$oracle'");
$row	= mysqli_fetch_array($query);
$num_row = mysqli_num_rows($query);
		
	if ($num_row > 0) 
	{	
		$curdate = date();
		if ($row['indate'] !== $curdate)
		{
			$query1=mysqli_query($con, "update staff set ClockedIn = 0, ClockedOut = 0 where OracleID='$session_id'")or die('Error In Session');
			header('location:home.php');				
		}
	}

 

PHP date and time function is not showing correct time on my local system

I have the following php code

date_default_timezone_set("Africa/Lagos");

$date = date('d-m-y h:i:s');

echo "Server Time ".$date ."<br>";

echo "The time is " . date("h:i:sa")."<br>";

$current_datetime = date("Y-m-d") . ' ' . date("H:i:s", STRTOTIME(date('h:i:sa')));

echo "Current time1: ".$current_datetime . "<br>";

 

Output

Server Time 21-05-21 09:55:39
The time is 09:55:39am
Current time1: 2021-05-21 09:55:39

 

Expected Output

Server Time 21-05-21 10:55:39
The time is 10:55:39am
Current time1: 2021-05-21 10:55:3

 

Any help would be appreciated.

 

Edited May 21 by Ponel

Hi;   I would like to get the current timestamp but the question is that i want to get the real time which is the machine bios time that can't change by the server administrator and not the server time which can be modified to any value.   Thanks

Hi guys,

I will like to insert a countdown timer of 5 mins after form has been submitted to a php page.

At the moment when they submit the form they see the date and time they submitted:

echo date("M d Y  H:i", time()) ";

Any ideas?

Ok, I have a variable ($incubation) set as 04:00:00.
Then I have another variable ($starttime) set to the current time.
Both are printing out fine.
But I'm trying to get an $endtime from adding the incubation time to the start time.

Code: [Select]
$incubation = $row['incubation']; //IM GRABBING THIS TIME FROM THE DATABASE. It prints 04:00:00

$starttime = date("H:i:s"); //prints 16:23:39

$endtime = date("H:i:s", $starttime+$incubation);  //prints 20:00:00 when it's suppose to print 20:23:39

What I am trying to do is I am making a Event page and I would like to have it list the events in 2 sections. One being "On" or "Before" current date and the next being "Past" current date so I can list the events in "Upcoming Events" and "Past Events"

the code im showing here is for the listing of my event page
I just need help turning this query into two separate querys with the date function im looking for.

Code: [Select]
<?php 
$result = mysql_query("SELECT * FROM event ORDER by eventdate DESC");
if (!$result) {
   die("query failed: " . msql_error());
}

while ($row = mysql_fetch_array($result)) {
list($id, $eventdate, $header, $description, $image, $location) = $row;
$description = nl2br($description);
$eventdate = date("M j, Y",strtotime("$eventdate"));

print('
<table width="680" border="0" cellpadding="14" cellspacing="0">
 <tr>
 <td>
<div class="myFont"><font size="+1" color="#4e8baf">'.$eventdate.' - </font><font size="+1"><b>'.$header.'</b></font></div>
<font size="+1"><a href="event.php?list=true&eventid='.$id.'">Details</a></font><br />
<hr color="#FFFFFF" width="100" align="left" size="1">
</td>
</tr>
  </table>
');

}
?>

I am building a site that needs to update member accounts on a weekly basis.  At the moment I have a cron job set for 12:01 am on Monday, that resets five database fields for all of my members. The first field is the current week, the second field is the previous week, the third field is from two weeks ago, the fourth field is from three weeks ago, and the fifth field is from four weeks ago.  Obviously the cron job resets the first field to 0, and the data from this field is moved to field two (last week), and so on and so forth, and the data from the fifth field is just removed altogether.  However, this is really not preferred, because if/when I get 1000+ users, the cron job will take up a crapload of CPU as many mysql queries need to be executed for each account.

So, I am trying to implement a script that checks the last login date for a user, and if they have have not logged in since before the latest Monday, the Monday before that, the Monday before that, or the Monday before that, etc.

I have never really worked with dates, so I don't even know how to begin.

The last user login is stored as a DATA datatype in a mysql database, and is in the following format: YYYY-MM-DD.

Thanks in advance!

Hi,

when i try to insert to table date value it gives me wrong current date.

$joindate = date('m-d-Y');
		
$sql = mysqli_query($con,"INSERT INTO staff (OracleID,StaffName,Des,joindate,username,password,isadmin)
VALUES ('$oracleid','$name','$des','$joindate','$username', '$pass','$isadmin')");

i get this in the main page after making date("d-m-Y",strtotime(date))

30-11--0001

why is that?

Edited April 7, 2020 by ramiwahdan

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.

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!

Hello, I am trying to subtract the current time from a list of times in a mysql database. The first page inserts the time into mysql.

<?php
$var_Time = date("h:i:s");
$mysqli = new mysqli('localhost','root','blah','test');
if ($mysqli->connect_error) {
    die('Error : ('. $mysqli->connect_errno .') '. $mysqli->connect_error);
}
$insert_row = $mysqli->query("REPLACE  INTO test_table (id, time)  Values(NULL, '$var_Time')");
if($insert_row){
    while (false);
}else{
    die('Error : ('. $mysqli->errno .') '. $mysqli->error);
}
$mysqli->close();
?>

The second page is supposed to iterate through all of the times in the database and subtract the current time, but i cant figure out how to do it.

<?php
$mysqli = new mysqli('localhost','root','blah','test');
if ($mysqli->connect_error) {
    die('Error : ('. $mysqli->connect_errno .') '. $mysqli->connect_error);
}
$query = "SELECT * FROM `test_table`";
$result = $mysqli->query($query) or die($mysqli->error.__LINE__);
$var_set_time = stripslashes($row['time']);
$var_current_time = date("h:i:s");
$diff = strtotime( $var_current_time .' UTC' ) - strtotime( $var_set_time .' UTC');
echo $diff;
?>

Edited by Ch0cu3r, 09 October 2014 - 01:40 PM.
Added code tags

When I echo the current time, the hour is what it is plus one:

echo date("h:i:s:A");


Real time is 3:46:33

Would display 4:46:33


What is wrong here?

I'm building an article system, what im trying to do is when a user choose the article to be published tomorrow to able to.  Write today the article but the system will show it from tomorrow

Code: [Select]
        $gettoday = date("Y:m:d");
$query = "SELECT * FROM tblnews WHERE MainArticle = 1 AND NewsDate = '".$gettoday."'  ORDER BY `Id` DESC LIMIT 1";
$result = mysql_query($query);

This is my code, but when i use this and the article is not posted for today is not showing anything.. any suggestions please?

Thank you

I am writing code in the ZEND framework and i need to get the current day in like 2012-02-03:
In the controller:
Code: [Select]
$time=date('YYYY-mm-dd',time());
$this->view->time=$time;In view:

Code: [Select]
<?php echo $this->time; ?>
Output:
2012201220122012-0202-0303

I dont know why it is displaying like that instead of once...there is no loop anywhere.