Server Time Offset

manhattanpaul · February 28, 2007

Hi All

Anyone got any ideas how I can get the following code to offset by 5 hours. The field that displays the date / time is 'data' and the format is 2007-02-28 11:38:43 , ideally i would like it 11:38:43 28-02-2007.

Any thoughts......here is the code

Paul

<?

include ("../config.php");

include ("../functii_mail.php");

include ("../".$lang);

function accept($id)

{

$sql="update users set approvved=1 where id=$id";

$result=mysql_query($sql);

if (!$result)

{

echo "Error";

echo mysql_error();

}

function upgrade($id)

{

$sql="update users set upgraded=1 where id=$id";

$result=mysql_query($sql);

if (!$result)

{

echo "Error";

echo mysql_error();

}

function downgrade($id)

{

$sql="update users set upgraded=0 where id=$id";

$result=mysql_query($sql);

if (!$result)

{

echo "Error";

echo mysql_error();

}

function delete_u ($id)

{

$sql="delete from users where id=$id";

$result=mysql_query($sql);

if (!$result)

{

echo "Error";

echo mysql_error();

}

function suspend($id)

{

$sql="update users set approvved=0 where id=$id";

$result=mysql_query($sql);

if (!$result)

{

echo "Error";

echo mysql_error();

}

function get_picture($user_id)

{

//mod daca apare sau nu butonul radio

$sql="select nume,id from pictures where user_id=$user_id";

$result=mysql_query($sql);

$num=mysql_numrows($result);

if ($num<>0)

{

$i=0;

while ($i<$num)

{

$nume=mysql_result($result,$i,"nume");

$id=mysql_result($result,$i,"id");

?> <img src="../user_pic/ <?=$nume?>">

<?

$i++;

}

else

{

echo "This user have no pictures uploaded!";

}

function get_sound($user_id)

{

$sql="select nume,id from sounds where user_id=$user_id";

$result=mysql_query($sql);

$num=mysql_numrows($result);

if ($num<>0)

{

$i=0;

while ($i<$num)

{

$nume=mysql_result($result,$i,"nume");

$id=mysql_result($result,$i,"id");

$nume="user_sounds/ $nume";

?> <a href="../play_sound.php?fisier=<?=$nume?>" target="blank"><?echo $nume?></a>

<?

$i++;

}

else

{

echo "This user have no sounds uploaded!";

}

db_connect($dbserver,$dbuser,$dbpass,$dbname);

if (isset($accept_))

{

accept($id);

}

if (isset($delete_))

{

echo $delete;

delete_u($id);

}

if (isset($suspend_))

{

suspend($id);

}

if (isset($upgrade_))

{

upgrade($id);

}

if (isset($downgrade_))

{

downgrade($id);

}

?>

<html>

<head>

<title>Dating site</title>

<?

if (isset($id))

{

//id id-ul userului

get_picture($id);

echo " ";

// get_sound($id);

echo " ";

}

?>

<?

if (isset($id))

{

$sql="SELECT * FROM users where id=$id order by data desc ";

$result=mysql_query($sql);

$num=mysql_numrows($result);

if ($num<>0)

{

$nick=mysql_result($result,0,"nick");

$data=mysql_result($result,0,"data");

$last_access=mysql_result($result,0,"last_access");

$email=mysql_result($result,0,"email");

$password=mysql_result($result,0,"password");

$sex=mysql_result($result,0,"sex");

$sexuality=mysql_result($result,0,"sexuality");

$personal_ad=mysql_result($result,0,"personal_ad");

$location=mysql_result($result,0,"location");

$country=mysql_result($result,0,"country");

$age=mysql_result($result,0,"age");

$birth_date=mysql_result($result,0,"birth_date");

$zodia=mysql_result($result,0,"zodia");

$marital_status=mysql_result($result,0,"marital_status");

$icq=mysql_result($result,0,"icq");

$msn=mysql_result($result,0,"msn");

$web=mysql_result($result,0,"web");

$eyes_colour=mysql_result($result,0,"eyes_colour");

$hair_colour=mysql_result($result,0,"hair_colour");

$weight=mysql_result($result,0,"weight");

$music=mysql_result($result,0,"music");

$partner=mysql_result($result,0,"partner");

$question=mysql_result($result,0,"question");

$newsletter=mysql_result($result,0,"newsletter");

$approvved=mysql_result($result,0,"approvved");

echo $nume_users."".$nick;

echo " ".$data_intrarii."".$data;

echo " ".$last_access_text."".$last_access;

echo " ".$email_text."".$email;

echo " ".$password_text."". $password;

echo " ".$sex_text." ". $sex;

echo " ".$sexuality_text." ". $sexuality;

echo " ".$personal_ad_text." ". $personal_ad;

echo " ".$location_text." ". $location;

echo " ".$country_text."". $country;

echo " ".$age_text." ". $age;

echo " ".$birth_date_text."". $birth_date;

echo " ".$zodia_text."". $zodia;

echo " ".$marital_status_text."". $marital_status;

echo " ".$icq_text."". $icq;

echo " ".$msn_text."". $msn;

echo " ".$web_text."". $web;

echo " ".$eyes_colour_text."". $eyes_colour;

echo " ".$hair_colour_text."". $hair_colour;

echo " ".$weight_text."". $weight;

echo " ".$music_text."". $music;

echo " ".$partner_text."". $partner;

echo " ".$question_text."". $question;

if ($newsletter==1)

{

echo $accept_newsletters;

}

else

{

echo $not_accept_newsletters;

}

if ($approvved==1)

{

echo $profile_accepted;

}

else

{

echo $profile_not_accepted;

}

?>

itsmeArry · February 28, 2007

$arrDateTime = explode(" ", $data);

//from here you will get
//$arrDateTime[0] = 2007-02-28 
//$arrDateTime[1] = 11:38:43

$arrdate = explode("-", $arrDateTime[0]);
$strDate = $arrdate[2]."-".$arrdate[1]."-".$arrdate[0];

//now Rearragge them like....



$data = $arrDateTime[1]." " .$strDate;

// data will be 11:38:43  28-02-2007

Sign In

Server Time Offset

Recommended Posts

manhattanpaul

Link to comment

Share on other sites

itsmeArry

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information