PHP - Setting A Particular Time

Hi I was wondering how I could set up a time mod to set time 3 times per hour.

DROP TABLE IF EXISTS og_updateattacks;
CREATE TABLE og_updateattacks (
  lasttime int(20) default NULL,
  id int(11) NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

That is what I got, but I want it so users can attack at random times per hour.

I am sorry I have absolutely no idea where this question fits in this forum bcoz its related to PHP , MySQL and Javascript... 

So here is my question ..

I use MySql database to store posts.. where 'postdate and time' is saved using  'CURRENT_TIMESTAMP' of MySql that offcourse gives "2010-08-31 09:47:10" format...

When I have to calculate when the post was posted just before loading the posts on users wall e.g.

"2 min ago"...

I take the 'postdate and time' from database then use strtotime() function in php to convert it to string you know since jan 1 1970.

Now this time stamp is sent to javascript function which uses 'Date' Object to create current time and then 'getTime' to get the string like one Mentioned earlier. it then calculates the difference and displays it..

Just to inform you.. I used javascript to I may refresh "posted since" periodically using "SetInterval()"

But the problem here arises. There is difference of 1 Hour and 24 Sec in both times.......

  Sorry If I confused you... But the problem is simple. In javascript date object and MySql  --> strtotime()
there is time difference...

How I can correct it ???


please Help ...

Codes:

1. function to convert str to time


function change($date){

$time_early=strtotime($date);

return $time_early;


}



 

2. javascript Code to check "Post Since"



function calc_difference() {

$("[name=posttime]").each(function() {

 var current=$(this).attr("id");
  localtimevalue = new Date();
d = localtimevalue.getTime();

         
 
 var d= parseInt(d)/1000;
 var diff=d-parseInt(current);  

 var diff=parseInt(diff);
 var min=parseInt(diff/60);         
 var hours=parseInt(diff/3600);
var days=parseInt(diff/86400);
var months=parseInt(diff/2592000);
var years=parseInt(diff/31104000);


if( min==0 ){ 


$(this).text("Posted: "+diff +" seconds ago ");

}



if(min>0 && hours==0 && days==0 && months==0){ 
if(min==1){
 $(this).text("Posted:  a minute ago ");
        
}else{
 
$(this).text("Posted: "+min +" minutes ago ");
}

}

if(min>0 && hours>0 && days==0 && months==0){ 

if(hours==1){
 $(this).text("Posted:  an hour ago ");
        
}else{
 
$(this).text("Posted: "+hours +" hours ago ");
}



}

if(days>0 && months==0 && years==0){ 


if(days==1){
 $(this).text("Posted:  a day ago ");
        
}else{
 
$(this).text("Posted: "+days +" days ago ");
}



}



if(months>0 && years==0 ){ 


if(months==1){
 $(this).text("Posted:  a month ago ");
        
}else{
 
$(this).text("Posted: "+months +" months ago ");
}



}


if(years>0){ 


if(years==1){
 $(this).text("Posted:  a year ago ");
        
}else{
 
$(this).text("Posted: "+years +" years ago ");
}



}








  });


   
}






 
Javascript function is called on load and Jquery's .each function is used to update all post's time.


 

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

I am trying to simulate an ad expiration and carry out an action if the ad is expired. And I cannot get the if/else to work properly... I've tried many variations and I cannot see what I am doing wrong here. Any tips please 3 hours and counting of no solution!

$ad_start = time()-14 . "<br />"; // 14 days from today in the past (negative)
echo $ad_start;

$current_time = time() . "<br />"; // current epoch time
echo $current_time;

$days_past = $ad_start - $current_time; // days past

echo "<br />$days_past days have past since the ad started!<br />";

if($days_past <= 14)
{
echo "<br />Ad is less than 14 days.  Not expired.";
}
else
{
echo "<br />Ad is over 14 days. Expired.";
}

Basically I have recently been playing around with parsing a csv file. What I am looking to do at this point is simply take the date/timestamp (part of the csv file), which is in the following format:DD/MM HH:MM:SS.100th/s
For the sake of argument, lets say I have this in an array string called $csv[0] and the file has several lines that span the course of a couple hours. I wouldn't mind having to use explode() to breakup/remove the date or 100th/s IF that would make things a lot simpler.

So where would I start in trying to achieve this?. The result I am looking for will simply return "X Seconds". Storing this in a string variable would be a bonus, as I plan to use this to divide a separate piece of information.

Any examples or ideas would be great. Thank you.

ps:
Here is an example time from the csv file itself:
Code: [Select]
11/19 22:23:18.143