Php - Checking a SQL Server Date

Description

This is a simple function that can be used to check a SQL Server date. For example, you have an application that accepts date input from a user to use as part of a SQL statement or stored procedure.

Php in Action

forloop

Php Code

Just cut-n-paste to reuse.

 
     
<?php
$str = '2009-12-31';
$DateStr_yyyy_mm_dd = preg_split('/[-]/', $str, -1, 
                                 PREG_SPLIT_OFFSET_CAPTURE);
 echo "Year is " . $DateStr_yyyy_mm_dd[0][0] . "
";
 echo "Month is " .  $DateStr_yyyy_mm_dd[1][0] . "
";
 echo "Day is " .  $DateStr_yyyy_mm_dd[2][0] . "
";
 $ret = validSQLServerDate($str);  
 echo "am I a valid formatted date? " . $ret; 

function validSQLServerDate($dte)
{
 $status = 'y'; //assume it is good to begin with
 $DateStr = preg_split('/[-]/', $dte, -1, PREG_SPLIT_OFFSET_CAPTURE);
 if (count($DateStr[1][0]) != 2)
 {
 	 $status = 'n';

 }	
 if (count($DateStr[1][0]) != 2)
 {
 	 $status = 'n';
 	
 }	
 if (count($DateStr[0][0]) != 4)
 {
 	 $status = 'n';
	
 }	

 $validdate = checkdate ( $DateStr[1][0] , 
                          $DateStr[2][0] , 
                          $DateStr[0][0] ); 
                                             
  if ($validdate) 
  { 
  	$status = 'y'; 
  } 
  else 
  { 
  	$status = 'n'; 
  }
  
  return $status;
}

?>

If you find this site useful and are a book buyer/reader... Abe Books is one of my affiliates. I only use affiliates that I also purchase products from. I love Abe books. I have purchased many books from them originally cost $40 to $60 for as little as $5 to $10 dollars including shipping costs. By accessing Abe books and clicking on one of my links I receive a small commission on your purchase that helps pay for this site. You pay no more for your books than if you accessed their site directly. Thanks for your support. Click on icon to find books on Php at Abe Books...

The Following are a list of Php books I own PHP Hacks: Tips & Tools for Creating Dynamic Web Sites by Jack D Herrington PHP Cookbook by David Sklar; Adam Trachtenberg Php: Your Visual Blueprint for Creating Open Source, Server-Side Content Php In Action by Dagfinn Reiersol Php 5 Objects, Patterns, and Practice A few notes. Already having a rich programming background when I set out to learn Php I found the Visual Blueprint book invaluable. I was literally able to get up to speed on Php over a weekend. Of course it took many months of working in that language to really feel proficient. Having already had a decent background in Object Oriented Programming in Java I found the two books "Php in Action" and "Php 5 Objects..." very well written and informative. I think they are written by folks with "real world" experience on the subject.