[RESOLVED] UNIX time conversion with date function

Shadowing

Im at my last resort here really needing some help. I hope someone can help me out
I have a variable which equals a UNIX time stamp called $recieve

I need to replace it with time() in this code below and cant figure out how to do it

 <?php $offset = date('m/d/Y/H:i:s', time()+$send1['time_offset']); ?>

ive tried this below but it ignores the +$send1['time_offset']); and only formats the $recieve

 <?php $offset = date('m/d/Y/H:i:s', $recieve + $send1['time_offset']); ?>

bradgrafelman

I'm confused... which is it you're trying to use, the value from time() or the value from $receive? Why confuse us with both ways when only one is relevant to what you want?

If you do a [man]var_dump/man on both $receive and $send1['time_offset'], what are their values?

Shadowing

Thanks for the responce bradgrafelman

$recieve is 1324618332 "which is a UNIX timestamp"
and $send1['time_offset'] is -21600 "which is -21600 seconds"

 <?php $offset = date('m/d/Y/H:i:s', $recieve + $send1['time_offset']); ?>

so im trying to get the date format of $recieve with the time offset. and the code above is ignoring the $send1['time_offset']

bradgrafelman

So you're saying that this:

echo date('m/d/Y/H:i:s', $recieve + $send1['time_offset']);

and this:

echo date('m/d/Y/H:i:s', $recieve);

produce the same output?

Can you copy and paste the output of the two var_dump()'s I asked for above?

Shadowing

I just notice a huge error Send1 is suppose to be take1

I got what I wanted to achieve by using this code. I wanted to make it more simple though

I did a var_dump like this

var_dump($recieved);

and I get a $end syntax error
thats how you do that right?

<?php

					$take3 = "SELECT time_offset FROM users WHERE id='".mysql_real_escape_string($_SESSION['user_id'])."'"; 
					$take2 = mysql_query($take3) or die(mysql_error());
					$take1 = mysql_fetch_array($take2);

		$result = mysql_query("SELECT * FROM pm WHERE id = '".($_SESSION['user_id'])."' ORDER BY time DESC");

		// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {

		$pm_id = $row['pm_id'];
		$msggoauld = $row['sentfrom'];
		$subject = $row['subject'];
		$recieved = $row['time'];

		$time = ($recieved + $take1['time_offset']);



date_default_timezone_set('UTC');

$offset = date('m/d/Y/H:i:s', $time); ?>

bradgrafelman

Why store the dates in a format that doesn't let you actually use them as dates? Why not store them in a DATETIME column instead? If you did that, then you could do a simple JOIN between the users table and the pm table and let MySQL calculate and format the new date/time string for you.

In other words, you could get rid of a lot of the code you have now, including an entire SQL query.

EDIT: Even if you did want to go the more complicated/inefficient route you're currently going, the least you could do is use some sensible variable names. $take3, $take2, ... you might as well just use names like $variable1, $variable2, etc. for every single variable in the script - that way you're sure to keep yourself on your toes! :p

Shadowing

yah i had a choice to use sql or use php time stamps and finally decided to use php.

I couldnt figure out how to do this using sql so i gave up and went with php 🙁

if ($get1['time'] < strtotime('-24 hours')) {

yah i should choose better names
im still confused on a few things since im a noob and been doing this for about 3 weeks now.

I have a script that is able to read a sql query that is out side of the brackets and I thought i knew why because the query was at the very top of the page and before the first if statment "cause its outside of the brackets". So yesterday i tried doing that on another script and it didnt work

I posted the code and cant figure out how this is able to read the query at the top of the page

if ($safe1['state'] == 1){

 <?php 
include_once("connect.php");



		//checks to make sure the user has signup ip address
	$safe3 = "SELECT name,goauld,state,vacation FROM users WHERE id = '".mysql_real_escape_string($_SESSION['user_id'])."'";
	$safe2 = mysql_query($safe3) or die(mysql_error());
	$safe1 = mysql_fetch_array($safe2);

		//if user doesnt have a signup ip address they die
if (empty($safe1['goauld'])) { // if user has a goauld name then die
		header("Location: signup.php"); // redirects you to dominion.php
		exit();
   }





		// checks to make sure login_time was set and if its not blank. mainly this keeps people out that hasnt loged in
if (!(isset($_SESSION['login_time']) && $_SESSION['login_time'] != '')) {

	header ("Location: signup.php");
	session_destroy();
	exit();

} else {

		// logs user out after 60 minutes and redirects to login and ends session   .login_time is the future 
if ($_SESSION['login_time'] < strtotime('-500 minutes')) {

		header("Location: signup.php");
		session_destroy();              
		exit();

} else {

		// checks and updates last activity of user
	$safe4 = "UPDATE users SET lastactive = NOW() WHERE id='".mysql_real_escape_string($_SESSION['user_id'])."'";
 	mysql_query($safe4); 

		// updates the login_time each time ingame pages are loaded. this keeps players loged in as long as they are flipping webpages
 	$_SESSION['login_time'] = time();



}
   }



	$get3 = "SELECT time,date,name,reason FROM banned WHERE id = '".mysql_real_escape_string($_SESSION['user_id'])."'";
	$get2 = mysql_query($get3) or die(mysql_error());
	$get1 = mysql_fetch_array($get2); 

	$get = $get1['reason'];
	$get5 = $get1['name'];


if ($safe1['state'] == 1){


	if($get1['time'] < strtotime('-24 hours')) {	


				mysql_query("DELETE FROM `banned` WHERE `id`= '".mysql_real_escape_string($_SESSION['user_id'])."'");	
				mysql_query("UPDATE users SET state='' WHERE id = '".mysql_real_escape_string($_SESSION['user_id'])."'");
	}else{

	header("Location: signup.php?reason=$get&name=$get5");
		session_destroy();              
		exit();
}		
}


?>

Shadowing

what i mean on the time issue is i couldnt figure out how to put sql stuff in if statments

Shadowing

course this was last week we are talking about too. I think its done like this

If ("SELECT DATE_ADD( UTC_TIME(), INTERVAL offset_field HOUR )

   and then statement