PHP - Retrieve Date And Time From Mysql Field Using Strtotime

Hey freaks,

running into a little issue with the use of date and strtotime....

basically I wanna present the date in the format m-d-y to the user and insert it into the DB in the Y-m-d format. 

What seems to be happening is a freaky Y-d-m format and I don't know why this is.  This code is an example that expresses my frustration.

Code: [Select]
$nmon = strtotime("next Monday");
$next = date('m-d-Y', $nmon);
$_SESSION['REPORT_DUE'] = $next;


$nfri = strtotime("Friday");
$due = date('m-d-Y', $nfri);
$_SESSION['WEEK_ENDING'] = $due;
$ses1 = $_SESSION['WEEK_ENDING2'] = date('Y-m-d', strtotime($due));
$ses2 = $_SESSION['WEEK_ENDING3'] = date('d-m-Y', strtotime($ses1));


.....output....

Quote

[WEEK_ENDING] => 09-02-2011 [WEEK_ENDING2] => 2011-02-09 [WEEK_ENDING3] => 09-02-2011 )




Thank you for any assistance.

I'm having a bit of trouble converting dates from strings. "171630Z - 181200Z" is what I would like to convert. I want to be able to display more information via date() with strtotime(). The timezone I would prefer is Central. To explain what the string represents:

17 = day (December 17th - today)
1630Z = time in UTC/GMT

18 = day (December 18th - tomorrow)
1200Z = time in UTC/GMT

Is there an easy way of doing this or is it impossible with just the day and time in UTC? Thanks.

Edit: I would also like to convert "1009 AM CST FRI DEC 17 2010" but that isn't working either.

Hi,
I'm struggling a bit with using a date format and strtotime()

Code: [Select]
if(!empty($_GET['utime']))
{
$time = strtotime($_GET['utime']);
}

utime is supplied in the format dd/mm/yyyy but when I use strtotime() it treats it as mm/dd/yyyy....so 07/12/2011 is taken as 12th Aug rather than 7th Dec..which is the date I want to use.

I had a quick ganders through the forums but couldn't find anything specific to this.

is there any other attributes to strtotime() that will help, or a similar fucntion or a neat way of swoping my dd/mm/yyyy round before i use strtotime()

any help greatly appreciated...

Here is the code im using

$dateOfBirth = '';

preg_match('|Born on ([a-zA-Z]*\s[0-9]*,\s[0-9]*)\\\u003c\\\/span>|', $page, $match);
    if($match && count($match)>0) {
      

$date = str_replace(",","",$match[1]);

blue($date);

$timestamp = strtotime($date);  
        $dateOfBirth = date('Y-m-d',$timestamp); // 1994-03-23 

    }

else

{

red("No Age is set on profile");

continue;

}

im getting a match like this
March 9, 1993

When i run my script im getting this error

[2048] strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Chicago' for 'CST/-6.0/no DST' instead
Error: [2048] date() [function.date]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Chicago' for 'CST/-6.0/no DST' instead

What could be the problem??

Hey guys,
How would I go about subtracting Today from a previous day to find the difference?

For example, I want to subtract TODAY from a previous date in my database, to determine if the difference is greater than 1 day.

Any ideas? I tried doing the subraction in TIMESTAMPS, but when I convert the date back to Y-m-d H:i:s, I got some weird year and time.
 

I am using the following code to get the third sunday of every month for +6 Months from todays date.  I have put together the following code which works perfectly when the date is echoed however when it comes to inserting those dates into mysql db it throws a unable to convert to string error.  Im new to this and my head is in a spin as to why those dates can't be inserted if they can echoed ok.  I have spent 2 days at it now and searched many forum however they seem to get side tracked from my issue (or do they)??????? I figure I can't go mixing DateTime and date() the way I have?  Please help???

Code: [Select]
[php]
$month=date('F');
$now=date('Y-m-d');
$year=date('Y');

$num='3'; //example only this will be a $_POST value 0-3
$day='Sunday'; //example only this will be a $_POST value Monday-Sunday

$start= date('Y-m-d', strtotime('+'.$num.' week '.$day.' '.$month.' '.$year.''));

if($start>$now) {
$begin=strtotime('+'.$num.' week '.$day.' '.$month.' '.$year.'');
} else {
$d = new DateTime( $start );
$d->modify( 'first day of next month' );
$nextmonth = $d->format( 'F' );
$year = $d->format( 'Y' );
$begin=strtotime('+'.$num.' week '.$day.' '.$nextmonth.' '.$year.'');
}

$date=date('Y-m-d', $begin);
# insert into db first occurance
//mysql_select_db($database);
//$query_rsFirst = "INSERT INTO event_date VALUES (NULL, '$event', '$d', '$date', '$date')";
//$rsFirst = mysql_query($query_rsFirst) or die(mysql_error());
echo $date.'<br/>';
for($i = 0; $i <= 4; $i++)  {
$d = new DateTime( $date );
$d->modify( 'first day of next month' );
$nextmonth = $d->format( 'F' );
$date=date('Y-m-d', strtotime('+'.$num.' week '.$day.' '.$nextmonth.' '.$year.''));

# insert into db
//mysql_select_db($database);
//$query_rsDate = "INSERT INTO event_date VALUES (NULL, '$event', '$d', '$date', '$date')";
//$rsDate = mysql_query($query_rsDate) or die(mysql_error());
echo $date.'<br/>';
if($nextmonth=="December") {
$d = new DateTime( $date );
$d->modify( 'first day of next year' );
$year = $d->format( 'Y' );
}
}
[/php]

I have a form where you can pick all the days in the week. When the form is posted my code finds the date of the day you picked that most recently went by. Then the code takes that date, and echos the date of every day of the week that you picked that comes after that date for a year.
But for some reason he thinks we're in 2009, even though i know the date puts out that we're in 2010.

Here's the code:

<?php
//function
if(isset($_POST['submit'])) {
function nextWeeksDay($date_begin,$nbrweek)
{
$nextweek=array();
for($i = 1; $i <= $nbrweek; $i++)  { // 52 week in one year of course
$nextweek[$i]=date('d-m-y', strtotime('+'.$i.' week',$date_begin));
}
return $nextweek;
}
//Get what user posted as day, and find the date of the past day gone.
$roday = $_POST['day'];
echo $roday;
echo date('d-m-y',strtotime('last ' . $roday));
$sistdag = date('d-m-y',strtotime('last ' . $roday));
/// end function
/// example of a select date
// var
$date_begin = strtotime($sistdag); //D Day Month Year  - like function format.
$nbrweek=52;
// call function
$result=nextWeeksDay($date_begin,$nbrweek);
// Preview
for($i = 1; $i <= $nbrweek; $i++)  {
echo '<br> - '.$result[$i];
}
}
?>

All help appreciated!

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 apologizing for bothering the expert here again, but I've run into another issue.  I am using the following code because I can't change the default timezone on my shared hosting plan:

$time = date("h:i A", strtotime("+19 hours"));

there are few issues with this.  if I just use: date("h:i: A") the time prints as 7 hours earlier than my timezone, and currently it shows 1:09 AM and it appears in the database as "01:09:00".  if I use the code above, the time prints out as "08:09 PM", but it is inserted into the database as "08:09:00".  Shouldn't it read "20:09:00" instead?  and why isn't the time being inserted into the database with the "PM" suffix on it like it appears in the printout?  the "time" field in my database is set to type TIME.

thanks.

Edited October 14, 2019 by ajetrumpet

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!

This is my first real jump into PHP, I created a small script a few years ago but have not touched it since (or any other programming for that matter), so I'm not sure how to start this.

I need a script that I can run once a day through cron and take the date from one table/filed and insert it into a different table/field, converting the human readable date to a Unix date.

Table Name: Ads
Field: endtime_value (human readable date)

to

Table Name: Node
Field: auto_expire (Converted to Unix time)

Both use a field named "nid" as the key field, so the fields should match each nid field from one table to the next.  Following a tutorial I have been able to insert into a field certain data, but I don't know how to do it so the nid's match and how to convert the human readable date to Unix time.  Thanks in advance!.

Hi:
I'm going crazy trying to do the following:
I'm making a job registration process where the user registers on one php page to the website, must acknowlege and email receipt using an activate php page, then is directed to upload their C.V. (resume) based on the email address they enter in the active page output. I then run an upload page to store the resume in teh MySQL db based on the users email address in the same record.

If I isolate the process of the user registering to the db, it works perfectly.
If I isolate the file upload process into the db, it works perfect.
I simply cannot upload teh file to the existing record based on teh email form field matching the user_email field in the db.
With the processes together, teh user is activated, but teh file is not uploaded.

Maybe I've simply been at this too long today, but am compeled to get through it by end day.
If anyone can help sugest a better way or help me fix this, I will soo greatly appreciate it.

My code is as follows for the 2 pages.

---------activate.php-------
<?php
session_start();
include ('reg_dbc.php');
if (!isset($_GET['usr']) && !isset($_GET['code']) )
{
$msg = "ERROR: The code does not match..";
exit();
}
$rsCode = mysql_query("SELECT activation_code from subscribers where user_email='$_GET[usr]'") or die(mysql_error());
list($acode) = mysql_fetch_array($rsCode);
if ($_GET['code'] == $acode)
{
mysql_query("update subscribers set user_activated=1 where user_email='$_GET[usr]'") or die(mysql_error());
echo "<h3><center>Thank You! This is step 2 of 3. </h3>Your email is confirmed. Please upload your C.V. now to complete step 3.</center>";
} else
{ echo "ERROR: Incorrect activation code... not valid"; }

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<title>Job application activation</title>
</head>
<body>
<center>
<br/><br/><br/>
<p align="center">
        <form name="form1" method="post" action="upload.php" style="padding:5px;">
        <p>Re-enter you Email : <input name="email" type="text" id="email"/></p></form>
          <form enctype="multipart/form-data" action="upload.php" method="POST">
          <input type="hidden" name="MAX_FILE_SIZE" value="4000000">
          Upload your C.V.: <input name="userfile" type="file" id="userfile">
          <input name="upload" type="submit" id="upload" value="Upload your C.V."/></form>
</p>
</center>
</body>

</html>
--------upload.php----------
<?php
session_start();
if (!isset($_GET['usr']) && !isset($_GET['code']) )
{
$msg = "ERROR: The code does not match..";
exit();
}
if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0)
{
$fileName = $_FILES['userfile']['name'];
$tmpName  = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];
$email = $_POST['email']['user_email'];

$fp      = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);

if(!get_magic_quotes_gpc())
{
    $fileName = addslashes($fileName);
}

include 'reg_dbc.php';

$query = "UPDATE subscribers WHERE $email = user_email (name, size, type, content ) ". "VALUES ('$fileName', '$fileSize', '$fileType', '$content')";

mysql_query($query) or die('Error, query failed');
mysql_close($dbname);
}
?>
<center>
<br/>
<br/>
<br/>
<br/>
Thank you for uploading your <?php echo "$fileName"; ?> file, completing your registration, and providing us your C.V. for this position.
<br/>
<br/>
<br/>
We will contact you if your canditature qualifies.
</center>

Hello everybody!   I am trying to figure out how to obtain all the data related to a key, but I've got no results so far and I am becoming really frustated, let's see if any of you could help me out with this.   Imagine I have a table with several columns, but we bother about two of them, let's say we have serial numbers of some product, on the left Incoming serial number (we can repair or swap the unit), on the right the outcoming serial number (same if we have repared the unit, different if we swap it for another unit).   Then we have, for example:   A -> A (Unit A enters and we repaired it) A -> B (Same unit came another day for some reason and we couldn't repair it, so we swap it by giving B to the customer) B -> C (Unluckily B was defective so we have to change it again) C -> C (C had another problem and we repaired it)   We have that in the database from different days and the such, so now, we want to know the historical and we know "C". If we perform a SELECT * FROM... WHERE incoming/outcoming serial number = "C" we'll get:   B -> C C -> C   So we should seek now for B and keep going... but I cannot proceed correctly, 'cause if I SELECT using B I'll get again B -> C (and A -> B, what I want), but when do I know I have to finish? How could I implement this as a function or whatever? showing every not repeated line from the beginning.   Could your minds help mine? Thank you very much in advance!.

I want to use session to do a query and will I be able to do this?

I have a session that was gathered from login and now i was to use this session to do a query

If Yes, How?