JS check Date format

by **PetiteRuby** Wed Feb 08, 2012 11:22 am

Code:: <?php require_once "../include/function.php"; require_once "../include/config.php"; require_once "lang/admin_vn.inc"; $error=0; require_once "inc/top.inc"; $arrday = getdate(); ?> <script language="javascript" src="../javascript/style1.js" type="text/javascript"></script> <script language="javascript" src="javascript/admin_search.js" type="text/javascript"></script> <script language="javascript" src="javascript/check_image.js" type="text/javascript"></script> <script type="text/javascript"> /**-------------------------- //* Validate Date Field script- By JavaScriptKit.com //* For this script and 100s more, visit http://www.javascriptkit.com //* This notice must stay intact for usage ---------------------------**/ function checkdate(input){ var validformat=/^\d{2}\-\d{2}\-\d{4}$/; if (input.match(validformat)){ var monthfield=input.split("-")[1]; var dayfield=input.split("-")[0]; var yearfield=input.split("-")[2]; var dayobj = new Date(yearfield, monthfield-1, dayfield); if ((dayobj.getMonth()+1!=monthfield)||(dayobj.getDate()!=dayfield)||(dayobj.getFullYear()!=yearfield)) { alert("Invalid Day, Month, or Year range detected. Please correct and submit again."); return false; } else { return true; } return true; } else{ alert("Invalid Date Format. Please correct and submit again."); return false; } } function a(){ if(document.getElementById("postday").value!="") if(checkdate(document.getElementById("postday").value)) return true; else { document.getElementById("postday").focus(); return false; } if(document.getElementById("postdayaf").value!="") if(checkdate(document.getElementById("postdayaf").value)) return true; else { document.getElementById("postdayaf").focus(); return false; } return true; } </script> </div> <div id="name_step"><?php echo "Report";?></div> <div id="approve"> <div class="content_approve"> <form name="frmreport" action="" method="post" onsubmit="return a();"> <div> <ul style="clear:both; margin:0px; padding:0px;"> <li style="list-style-type:none; float:left; text-align:right; width:300px; padding:3px 5px 3px 0px;">Post before date:</li> <li style="list-style-type:none; float:left; padding:0px 5px 5px 0px;"><input type="text" style="width:220px;" name="postday" id="postday"/></li> <li style="list-style-type:none; float:left; width:300px; padding:3px 5px 3px 0px;">(dd-mm-yyyy)</li> </ul> <ul style="clear:both; margin:0px; padding:0px;"> <li style="list-style-type:none; float:left; text-align:right; width:300px; padding:3px 5px 3px 0px;">Post after date:</li> <li style="list-style-type:none; float:left; padding:0px 5px 5px 0px;"><input type="text" style="width:220px;" name="postdayaf" id="postdayaf"/></li> <li style="list-style-type:none; float:left; width:300px; padding:3px 5px 3px 0px;">(dd-mm-yyyy)</li> </ul> <ul style="clear:both; margin:0px; padding:0px;"> <li style="list-style-type:none; float:left; text-align:right; width:300px; padding:3px 5px 8px 0px;"> </li> <li style="list-style-type:none; float:left; padding:0px 5px 10px 0px;"><input type="submit"value="Show Report" id="ShowReport" name="ShowReport" o/></li> </ul> </div> </form> <div class="box_camnang" id="hienthidulieu"> <?php if(isset($_POST['ShowReport'])){ if(($_POST['postday']=='') && ($_POST['postdayaf']=='')) { $sql_select = "SELECT j.Id, j.OtherJobTitle, j.DateCreate, e.Email, e.FullName, e.CompanyName FROM tableprefix_jobs AS j, tableprefix_employers AS e WHERE j.UserId = e.Id ORDER BY j.DateCreate DESC "; echo "<br />".$sql_select."<br />"; } else if($_POST['postday']==''){ $postdayaf = date('Y-m-d',strtotime($_POST['postdayaf'])); $sql_select = "SELECT j.Id, j.OtherJobTitle, j.DateCreate, e.Email, e.FullName, e.CompanyName FROM tableprefix_jobs AS j, tableprefix_employers AS e WHERE j.UserId = e.Id and DATE_FORMAT(j.DateCreate, ''%Y-%m-%d')<= '".$postdayaf."' ORDER BY j.DateCreate DESC "; echo "<br />".$sql_select."<br />"; } else if($_POST['postdayaf']==''){ $postday = date('Y-m-d',strtotime($_POST['postday'])); $sql_select = "SELECT j.Id, j.OtherJobTitle, j.DateCreate, e.Email, e.FullName, e.CompanyName FROM tableprefix_jobs AS j, tableprefix_employers AS e WHERE j.UserId = e.Id and DATE_FORMAT(j.DateCreate, '%Y-%m-%d') >= '".$postday."' ORDER BY j.DateCreate DESC "; } else { $postday = date('Y-m-d',strtotime($_POST['postday'])); $postdayaf = date('Y-m-d',strtotime($_POST['postdayaf'])); $sql_select = "SELECT j.Id, j.OtherJobTitle, j.DateCreate, e.Email, e.FullName, e.CompanyName FROM tableprefix_jobs AS j, tableprefix_employers AS e WHERE j.UserId = e.Id and DATE_FORMAT(j.DateCreate, '%Y-%m-%d') >= '".$postday."' and DATE_FORMAT(j.DateCreate, '%Y-%m-%d')<= '".$postdayaf."' ORDER BY j.DateCreate DESC "; echo "<br />".$sql_select."<br />"; } Connect_Database(); $query = QuerySQL($sql_select); if(!$query) { echo "Error connect !"; Close_Connect(); } $js_numrows_page = @mysql_num_rows($query); //paging set $maxpage, $start if(empty($_GET['page'])) { $page=1; } else { $page=$_GET['page']; } $rs_maxpage = ceil($js_numrows_page/$numof_record_perpage); $rs_start = ($page*$numof_record_perpage)-$numof_record_perpage; $sql_search = $sql_select." limit $rs_start, $numof_record_perpage"; $query = QuerySQL($sql_search); if(!$query) { echo "Error connect !"; Close_Connect(); } else { if(@mysql_num_rows($query) > 0) { ?> <ul class="notes_display" style="clear:both"> <li><?php echo str_replace("<number>", "<b>".$js_numrows_page."</b>", $admin_total_users);?></li> <li><?php echo str_replace("<number>", "<b> <label id=\"number_display\">1 - ".$numof_record_perpage."</label></b>", str_replace("<number1>", "<b>".$js_numrows_page."</b>", $admin_display_users));?></li> </ul> <ul class="rows_display"> <li class="rows1" style="width:30px;"><?php echo "No.";?></li> <li class="rows1" style="width:250px;"><?php echo "Job";?></li> <li class="rows1" style="width:136px;"><?php echo "Post date";?></li> <li class="rows1" style="width:150px;"><?php echo "Name";?></li> <li class="rows1" style="width:150px;"><?php echo "Email";?></li> <li class="rows1" style="width:250px;"><?php echo "Company";?></li> </ul> <div id="display_paging"> <?php $i=1; while($r = mysql_fetch_array($query)) { ?> <ul class="rows_display" id="rows<?php echo $i;?>" onmouseover="changeBG('rows<?php echo $i;?>');" onmouseout="defaultBG('rows<?php echo $i;?>');" style="clear:both"> <li class="rows2" style="width:30px; text-align:center"><?php echo $i;?></li> <li class="rows2" style="width:250px;"><?php echo $r['OtherJobTitle'];?></li> <li class="rows2" style="width:136px;text-align:center"><?php echo $r['DateCreate'];?></li> <li class="rows2" style="width:150px;text-align:center"><?php echo $r['FullName'];?></li> <li class="rows2" style="width:150px; text-align:center"><?php echo $r['Email'];?></li> <li class="rows2" style="width:250px;"><?php echo $r['CompanyName'];?></li> </ul> <?php $i++; } } else { echo "Not found data"; } Close_Connect(); } ?> </div> <?php if($rs_maxpage > 1) { ?> <ul class="banpaging"> <li class="cols1" style="padding-top:2px;">Page number </li> <li class="cols2" style="width:500px;"> <select onchange="pagingSearchJobsPost(this.value, <?php echo $numof_record_perpage;?>,'')"> <?php for($j=1; $j<=$rs_maxpage; $j++) { if($j==$page) { echo "<option value=\"$j\" style=\"font-weight:bold\" selected=\"selected\"><b>$j</b></option>"; } else { echo "<option value=\"$j\">$j</option>"; } } ?> </select> </li> </ul> <?php } } ?> </div> </body> </html>