PHP - Check If A Date Is Near Todays Date?

Currently I have an Input field for a "Written On Date".

What is the best way to make sure a valid date is entered?

Should I use Regular Expressions?

Some PHP Date-Checking Function?

Or switch to Drop-Down Lists to better control the selectable values?  (Which won't catch things like June 31?!)


Debbie

What is the best way to check for a Date in a Form?

I see there is a CheckDate() function, but how does that know what format the Date is in?

Should I use a Regular Expression?

My Form Field is just a Text Box...

Thanks,


Debbie

check date is in format of Y-m-d

Hi all,

How can I check in PHP if this date has already passed in the following format:

2012-12-12

I am trying to check if a credit card has expired.

My criterion is whether or not the date submitted is prior to this month if the year matches 2011.

Code: [Select]
// Check for Expired Card.
if (($expYear = date('Y')) && ($expMonth < date('M'))){
$errors['expDate'] = 'Expiration Date cannot be in the past.';
}

Why is this not working?

I chose March 2011 and it fails.

In fact, it fails for any date?!   



Debbie

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=313543.0

I have two text fields in a form. Both accepts dates. I'd like to check whether the second date provided is exactly one year in the future from the first provided date. I can easily do this in PHP but since I need to do the check once the user leaves the second field, I have to resort to JavaScript, using onblur or something.   There are two issues I have. 1. Make sure that the strings provided are indeed dates (I would use strtodate() in PHP for this) 2. Regardless of month provided, making sure that the second date is exactly a year in the future of the already provided year   I've only captured the values and passed them to Date(). However, it can only handle european style, and if I enter 1981-06-16, the value returned is Jun 15 1981 17:00:00 which is obviously wrong.   Here is the simple broken code I have

var text1 = document.getElementById("text1");
var start_date = new Date(text1.value);
    
 var text2 = document.getElementById("text2");
 var end_date = new Date(text2.value);
    
 alert(start_date);

I need some guidance.

Hello. I'm new to pHp and I would like to know how to get my $date_posted to read as March 12, 2012, instead of 2012-12-03.
Here is the code:
Code: [Select]
<?php

$sql = " SELECT id, title, date_posted, summary FROM blog_posts ORDER BY date_posted ASC LIMIT 10 ";

$result = mysql_query($sql);

while($row = mysql_fetch_assoc($result)) {
$id = $row['id'];
$title = $row['title'];
$date_posted = $row['date_posted'];
$summary = $row['summary'];

echo "<h3>$title</h3>\n";
echo "<p>$date_posted</p>\n";
echo "<p>$summary</p>\n";
echo "<p><a href=\"post.php?id=$id\" title=\"Read More\">Read More...</a></p>\n";
}

?>
I have tried the date() function but it always updates with the current time & date so I'm a little confused on how I get this to work.

I have tried a large number of "solutions" to  this but everytime I use them I see 0000-00-00 in my date field instead of  the date even though I echoed and can see that the date looks correct.

Here's where I'm at:
I have a drop down for the month (1-12) and date fields (1-31) as well as a text input field for the year.  Using the POST array, I  have combined them into the xxxx-xx-xx format that I am using in my field as a date field in mysql. 

<code>
$date_value =$_POST['year'].'-'.$_POST['month'].'-'.$_POST['day'];
echo $date_value;
</code>

This outputs 2012-5-7 in my test echo but 0000-00-00 in the database.

I have tried unsuccessfully to use in a numberof suggested versions of:
strtotime()
mktime

Any help would be extremely appreciated.
I am aware that I need to validate this data and insure  that it is a valid date. That I'm okay with. I would like some help on getting it into the database.

Alright, I have a Datetime field in my database which I'm trying to store information in. Here is my code to get my Datetime, however it's returning to me the wrong date. It's returning:
1969-12-31 19:00:00

$mysqldate = date( 'Y-m-d H:i:s', $phpdate );
$phpdate = strtotime( $mysqldate );
echo $mysqldate;


Is there something wrong with it?

Hello guys, i have a problem that i am trying to solve myself for the entire past week. I am not a php programmer and i wish you can help me.
There is a russian project called Crot Anti-Plagiarism, it is a open source moodle plugin. I started to use it and it is a really nice feature. The problem is that there are quite few people that are developing it and new features are coming once a year...
I see a big "hole" in this project (at least for me) : The plugin checks for plagiarism in the file that you submit only once, if a student resubmits the file it doesn't see that and you need to start the plugin's test again for all the files which is time consuming if you have a lot of submitted files to check.
I would like to add a function that will check if a file changed his modified date , if yes - mark for checking, if no - skip the checking.
I already added a similar function that checks if the name has changed, but it seems harder to check it by uploaded time(modified time).
Things i have already done:
I added a new column "assignment_submissions_timemodified" in database.
I added a new function that records the "time modified" of the file in the database.
But i can't add and i cannot make the comparison between the date of the first time the file submitted versus the date of the second time the same file was resubmitted.
Alright no more bullsh**t here is the code: (there are 3 comments that shows what i've changed, starting with  //my job...)
Thanks a lot!
Code: [Select]
$apath= $CFG->dataroot."/$assignment->course/moddata/assignment/$asubmission->assignment/$asubmission->userid";
        $timemodified= filemtime($apath);    //my job... it checks the file's modified time.
$files = scandir($apath, 1);
if (! $unprocessedsubm = get_record("crot_submissions", "submissionid", $asubmission->id, "crot_submission_file_name", $files[0], "assignment_submissions_timemodified", $timemodified))  //my job...now i guess here is the problem ( "assignment_submissions_timemodified", $timemodified)
{
        echo "$timemodified";
        echo "$unprocessedsubm";
print_r($unprocessedsubm);
echo "\nsubmission $asubmission->id was not processed yet. start processing now ... \n" ;
$atime = microtime();
$atime = explode(" ",$atime);
$atime = $atime[1] + $atime[0];
$astarttime = $atime;
if(!count($files))break;
//TODO we should verify if filename changed
//TODO add loop on the documents folder as well as loop for unzipping
$apath = $apath."/$files[0]";
// call tokenizer to get plain text and store it in crot_submissions
$atext = tokenizer ($apath);
// update the crot_submissions table
// delete if exists
delete_records("crot_submissions", "submissionid", $asubmission->id);
// insert the new record
$record->submissionid=$asubmission->id;
$record->updated = time();
$record->crot_submission_file_name = $files[0];                                   
$record->assignment_submissions_timemodified = $timemodified;        //this is my job.... it is recording the date as it has to.
$submid = insert_record("crot_submissions", $record);
// insert into documents
$docrecord->crot_submission_id = $submid;
Also i have attached the whole file crot_crone.php.

(continuing from topic title)
So if I set a date of July 7 2011 into my script, hard coded in, I would like the current date to be checked against the hard coded date, and return true if the current date is within a week leading up to the hard coded date.

How could I go about doing this easily?

I've been researching dates in php but I can't seem to work out the best way to achieve what I'm after.

Cheers
Denno

Hi,

I have a job listing website which displays the closing date of applications using:

$expired_date

(This displays a date such as 31st December 2019)

I am trying to show a countdown/number of days left until the closing date.

I have put this together, but I can't get it to show the number of days.

                    <?php 
                    $expired_date = get_post_meta( $post->ID, '_job_expires', true );
                    $hide_expiration = get_post_meta( $post->ID, '_hide_expiration', true );
                    if(empty($hide_expiration )) {
                        if(!empty($expired_date)) { ?>
                                <span><?php echo date_i18n( get_option( 'date_format' ), strtotime( get_post_meta( $post->ID, '_job_expires', true ) ) ) ?></span>
                    
                    <?php
                                        $datetime1 = new DateTime($expired_date);
                                        $datetime2 = date('d');
                                        $interval = $datetime1->diff($datetime2);
                                        echo $interval->d;

                     ?>
                        <?php }
                    } 
                    ?>

Can anyone help me with what I have wrong?

Many thanks

Hi,

I am trying to convert a String date into numeric date using PHP function's, but haven't found such function.
Had a look at date(), strtotime(), getdate();

e.g. Apr 1 2011  ->    04-01-2011

Could someone please shed some light on this?

Regards,
Abhishek

Hi there,

I have a string '12/04/1990', that's in the format dd/mm/yyyy.

I'm attempting to convert that string to a Date, and then insert that date into a MySQL DATE field.

The problem is, every time I try to do so, I keep getting values like this in the database: 1970-01-01.


Any ideas?


Much appreciated.