Jump to content

How to control date


new_php85

Recommended Posts

i...i have some problem to control entry date.i want, user cannot add claim when the "date_me" have over limit which the date is not valid anymore. for example date_me only can accept date in october but after october the date is not valid.currently i only use like this.but i think there is some better code.

 

this is is my example coding

 

<?php session_start();
include 'includes/db_connect.php';
include 'includes/css.php';

if (isset($_POST['bttnAdd']))
{
$me_id = $_POST['me_id'];
$staff_id = $_POST['staff_id'];
$date_me = $_POST['date_me'];
$particular = $_POST['particular'];
$bill_me = $_POST['bill_me'];
$ammount_me = $_POST['ammount_me'];

$data = 1;
$query = "INSERT INTO me(staff_id, date_me, particular, bill_me, ammount_me)
		  VALUES('$staff_id','$date_me','$particular','$bill_me','$ammount_me') WHERE date_me != '2008-10-28'";
mysql_query($query) or die('Query failed. ' . mysql_error());

echo "<script language='JavaScript'> alert('The record is successfully added');</script>";
echo "<script language='JavaScript'> window.location ='me.php';</script>";
}
?>

<form name="me" action='me.php' method = "post" onSubmit="return validateForm(this,arrFormValidation);">
<table width="678" align="center">
<tr> 
    	<td height="20" colspan="2" class="tajukkecil"><b>Miscellaneous Expense</b></td>     
    </tr>

<tr>
	<td width="85">Date</td>
       	<td width="581">: <input class="special" type="text" name = "date_me" maxlength = "10" size = "16"><a href="Javascript:ShowCalendar('document.me.date_me',1900,2030,'dd-mm-yyyy');"><img src="pic/ew_calendar.gif"></a>
					  <input class="special" type = "hidden" name = "staff_id"  value = "<?php echo $_SESSION['staff_id']?>" Readonly></td>		
    </tr>

<tr>
	<td width="85">Particular</td>
       	<td width="581">: <input class="special" name = "particular" maxlength = "150" size = "46"></td>		
    </tr>

<tr>
	<td width="85">Bill No.</td>
       	<td width="581">: <input class="special" name = "bill_me" maxlength = "15" size = "16"></td>		
    </tr>

<tr>
	<td width="85">Amount</td>
       	<td width="581">: RM <input class="special" name = "ammount_me" maxlength = "7" size = "10"></td>		
    </tr>

<tr> 
        <td> </td>

      <td align="left"> <div align="left">
  	  <input class="button" type = "button" name = "bttnList" value = "List Miscellaneous Expenses" onClick="listMe()">
          <input class="button" type = "submit" name = "bttnAdd" value = "Add">
          <input class="button" type = "reset" name = "bttnCancel" value = "Reset">
        </div></td>
    </tr>
</table>

Link to comment
https://forums.phpfreaks.com/topic/128160-how-to-control-date/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.