Date Validation

reethu

Actually,

I have selected the Date of Joiniing of a particular student and I defined as

$doj.

Please see the below coding

$datequery="Select * from student_profile where StudentID='$studentid' ";
echo "$datequery";
$datequery1=mysql_query($datequery);
while($datequery2=mysql_fetch_array($datequery1))
{
$doj=$datequery2["DOJ"];
}
echo "The date is $doj";

The result will be like this 2003-11-01

Now I want to check whether $doj falls between 1st May to 30th September.

How can I check this???

Thats what I want to know.

Thanx a lot..

Regards,
Richard.

AstroTeg

In your query, you could do:

SELECT mystudents, mydate FROM mytable WHERE MONTH(mydate) BETWEEN 5 AND 9

This would select all students between the months of May and September.

If you didn't feel like parsing the date with PHP, you could also do this:

SELECT mystudents, mydate, MONTH(mydate) AS mymonth FROM mytable WHERE MONTH(mydate) BETWEEN 5 AND 9

Here mymonth will just contain the month value of the student's date and you don't need to do any further parsing with PHP (let MySQL do the work).

I think this is what you're looking for - this help?

reethu

Actually,

I have selected the Date of Joiniing of a particular student and I defined as

$doj.

Please see the below coding

The result will be like this 2003-11-01

Now I want to check whether $doj falls between 1st May to 30th September.

How can I check this???

Thats what I want to know.

Thanx for understanding me....

Regards,
Richard.

AstroTeg

You can use PHP's date() function to extract the month. You could just include MONTH(DOJ) in your SELECT clause and extract it while parsing the database data. Then do an if() on the month value (basically, I'm saying you could let MySQL pull the month out for you). PHP can do it as well. Its something like date('m', strtotime($doj)) but don't quote me on that.

reethu

Hi,

I had used like this

$array=split("-",$doj);
$year=$array[0];
$month=$array[1];
$date=$array[2];
echo "The month is $month";

Suppose if I want to put it ii "If" condition, can I use this format..

Actually I want to check whether $month falls in between may and September..

if($month>04 && $month<09)
{
echo "Yes you are right";
}
else
{
echo "Sorry wrong";
}

If it is wrong please advise me the right statement.

Regards,
Richard.

AstroTeg

As long as the code works, its never wrong. 🙂

I was looking at the date() function on php.net and instead of 'm', 'n' might work better since it will not add the leading zero (but both may work just fine).

Using the parsing you're doing will work. But if the date format changes (which is possible but probably unlikely), then you'd have to update your algorithm you have there. The beauty of using the date() function teamed up with strtotime() is regardless of the date format you pass it, it will attempt to always dig out the month (using 'm', or 'n'). This makes your code a little more portable and cleaner (in my opinion - you'd have 1 line of code instead of the several lines you have).

Regarding your if statements -

I think just

if($month > 4 && $month < 9)

should work - although note month 4 (April) and month 9 (September) will not be included as defined by your if().

reethu

Thanx buddy..

Thanx for giving advise to me..

Can I have u r email please. For that I can have a touch with you.

By the the by I am Richard, new programmer from Malaysia. I am originally from India and working..

All the best..

Regards,
Richard.

AstroTeg

The best way to reach me is probably by the PM button to send me a private message...