 |
Submit Your Code | |
 |
SEO Monitor | |
 |
UpTime Monitor | |
 |
PHP Code Contest | |
 |
My Favorite Examples | |
|
My Favorite Articles | |
 |
Update Your Profile | |
|
|
| More Weber Sites | ||
| PHP Code Search | ||
| Web Development Forums | ||
| Learn MySQL Playing Trivia | ||
| PHPBB2 Templates | ||
| Web Development Index | ||
| PHP Web Logs (BLogs) | ||
| Web Development Resources | ||
| Web Development Content | ||
| Recommended Links | ||
| PHPClasses | ||
| PHP Editor | ||
| PHP Jobs | ||
| Vision.To Design | ||
| Ajax Tutorials | ||
| PHP Programming Help | ||
| PHP/MySQL Programming | ||
| Webmaster Resources | ||
| Webmaster Forum | ||
| XML meta language | ||
| website builder | ||
| Recommended | ||
| Submit Site | ||
| Forex Trading Online forex trading platform | ||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Code | |||||
Someone wanted to have a converter that took a "human" time and converted it to a MySQL timestamp. Use the function cvdate() to convert to a UNIX time stamp, then use timestamp_to_mysql() (fount in the original mysql date/time converters article) to get the MySQL timestamp value. (Also check out strtotime() for a good english to timestamp converter!) <? //paste this into a file named "cvdate.php3" //this function supports dash,slash or space delimiting, numeric/english months, and two- digit years. function cvdate($s) { //this function takes a "human" date and converts it into a UNIX timestamp, zero if error. // echo("$s<p>"); //what is the delimiting character? (support space, slash, dash) $delimiter=""; if (strpos($s,"-")>0) $delimiter="-"; if (strpos($s,"/")>0) $delimiter="/"; if (strpos($s," ")>0) $delimiter=" "; if ($delimiter=="") return 0; //chop it up $p1=strpos($s,$delimiter); $p2=strpos($s,$delimiter,$p1+1); $x=substr($s,0,$p1); $y=substr($s,$p1+1,$p2-$p1); $z=substr($s,$p2+1); //debug // echo("$x/$y/$z"); //the last value is always the year, so check it for 2- to 4-digit convertion if (intval($z)<100) { if (intval($z)>69) $z=strval(1900+intval($z)); else $z=strval(2000+intval($z)); } //intelligently select which converter to use //(default is M/D/Y, but if the month is "spelled out" then the format is D/M/Y) if (intval($y)==0) { return cvdate_english($x,$y,$z); } else { return cvdate_numeric($x,$y,$z); } } //just a helper function function cvdate_english($d,$m,$y) { $d2=0; $m2=0; $y2=0; $d2=intval($d); $m=strtolower($m); switch(substr($m,0,3)) { case "jan": $m2=1; break; case "feb": $m2=2; break; case "mar": $m2=3; break; case "apr": $m2=4; break; case "may": $m2=5; break; case "jun": $m2=6; break; case "jul": $m2=7; break; case "aug": $m2=8; break; case "sep": $m2=9; break; case "oct": $m2=10; break; case "nov": $m2=11; break; case "dec": $m2=12; break; } $y2=intval($y); //check for errors! if (($d2==0)||($m2==0)||($y2==0)) return 0; //debug //echo("$m2/$d2/$y2<br>\n"); return mktime(0,0,0,$m2,$d2,$y2); } //just a helper function function cvdate_numeric($m,$d,$y) { $d2=0; $m2=0; $y2=0; $d2=intval($d); $m2=intval($m); $y2=intval($y); //check for errors! if (($d2==0)||($m2==0)||($y2==0)) return 0; //debug //echo("$m2/$d2/$y2<br>\n"); return mktime(0,0,0,$m2,$d2,$y2); } ?> Example : ======== <html> <? include("datetime.php3"); include("cvdate.php3"); echo("13-sept-99 converted to MySQL timestamp is ".timestamp_to_mysql(cvdate("13-sept- 99"))."<p>\n"); ?> </html> | |||||
| Related Code Examples | |||||
