PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
Moderator: General Moderators
tobimichigan
Forum Commoner
Posts: 48 Joined: Sun May 10, 2009 1:35 pm
Post
by tobimichigan » Thu Jul 30, 2009 3:52 pm
Please could someone help me with a tight code ad that can validate these fields? Please note there r 2 hidden fields, session and date.
Code: Select all
<form action='Yearly_Entry_Action.php' method='post' enctype='multipart/form-data' name='register'>
<table width='28%' border='0' align='center' cellpadding='0' cellspacing='0'>
<tr>
<td colspan='2'><div align='center'>
<p><font size='2' face='verdana'>ADMIN_YEARLY_POST</font></p>
</div></td>
</tr>
<tr>
<td width='31%'> </td>
<td width='69%'> </td>
</tr>
<tr>
<td colspan='2'><hr></td>
</tr>
<tr>
<td height='26'><font size='2' face='verdana'>MEMBER NAME</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='name'>
</font></td>
</tr>
<tr>
<td height='28'><font size='2'>DEPARTMENT</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='department'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2'>PF. NO.</font> </td>
<td><font size='2' face='verdana'>
<input type='text' name='pfno'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2'>SAVINGS</font><font size='2' face='verdana'></td>
<td><font size='2' face='verdana'>
<input type='text' name='savings'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>SHARES</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='shares'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>OUTSTANDING LOAN BAL.</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='outloanbal'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>LOAN REPAID IN YEAR</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='loanrepaid'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>LOAN INTEREST</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='loanint'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>ESSENCO</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='essenco'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>MONTH</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='month'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>YEAR</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='Year'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'></font></td>
<td><font size='2' face='verdana'>
<input type='hidden' name='date'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'></font></td>
<td><font size='2' face='verdana'>
<input type='hidden' name='session'>
</font></td>
</tr>
</tr>
<td> </td>
<td><font size='2' face='verdana'>
<input type='submit' name='Submit' value='Record Yearly Report'>
</font></td>
</tr><tr>
<td colspan='2'><hr></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
</form>
tobimichigan
Forum Commoner
Posts: 48 Joined: Sun May 10, 2009 1:35 pm
Post
by tobimichigan » Thu Jul 30, 2009 3:55 pm
tobimichigan wrote: Please could someone help me with a tight code ad that can validate these fields? Please note there r 2 hidden fields, session and date.
Code: Select all
<form action='Yearly_Entry_Action.php' method='post' enctype='multipart/form-data' name='register'>
<table width='28%' border='0' align='center' cellpadding='0' cellspacing='0'>
<tr>
<td colspan='2'><div align='center'>
<p><font size='2' face='verdana'>ADMIN_YEARLY_POST</font></p>
</div></td>
</tr>
<tr>
<td width='31%'> </td>
<td width='69%'> </td>
</tr>
<tr>
<td colspan='2'><hr></td>
</tr>
<tr>
<td height='26'><font size='2' face='verdana'>MEMBER NAME</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='name'>
</font></td>
</tr>
<tr>
<td height='28'><font size='2'>DEPARTMENT</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='department'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2'>PF. NO.</font> </td>
<td><font size='2' face='verdana'>
<input type='text' name='pfno'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2'>SAVINGS</font><font size='2' face='verdana'></td>
<td><font size='2' face='verdana'>
<input type='text' name='savings'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>SHARES</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='shares'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>OUTSTANDING LOAN BAL.</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='outloanbal'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>LOAN REPAID IN YEAR</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='loanrepaid'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>LOAN INTEREST</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='loanint'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>ESSENCO</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='essenco'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>MONTH</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='month'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>YEAR</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='Year'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'></font></td>
<td><font size='2' face='verdana'>
<input type='hidden' name='date'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'></font></td>
<td><font size='2' face='verdana'>
<input type='hidden' name='session'>
</font></td>
</tr>
</tr>
<td> </td>
<td><font size='2' face='verdana'>
<input type='submit' name='Submit' value='Record Yearly Report'>
</font></td>
</tr><tr>
<td colspan='2'><hr></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
</form>
Here's the form action:
Code: Select all
<?php
include("cn.php");
session_start();
//mt_srand((double)microtime())*1000000;
$session=mt_srand();//create uniqiue sessionid
$date= addslashes($_POST['date']);
$department = addslashes($_POST['department']);
$essenco=addslashes($_POST['essenco']);
$loanint =addslashes($_POST['loanint']);
$loanrepaid =addslashes($_POST['loanrepaid']);
$month=addslashes($_POST['month']);
$name=addslashes($_POST['name']);
$outloanbal=addslashes($_POST['outloanbal']);
$pfno=addslashes($_POST['pfno']);
$savings=addslashes($_POST['savings']);
$session=addslashes($_POST['session']);
$shares=addslashes($_POST['shares']);
$Year=addslashes($_POST['Year']);
var_dump($session); die();
$sql= "Insert into yearly_reports(date, department,essenco,loanint,loanrepaid,month,name,outloanbal,pfno,savings,session,shares,Year) values(SYSDATE(),'$department','$essenco','$loanint','$loanrepaid','$month','$name','$outloanbal','$pfno','$savings','$session','$shares','$Year')" or die .mysql_error();
//$result=mysql_query($sql) or die .mysql_error();
if (!mysql_query($sql))
{
die('Error: ' . mysql_error()." SQL: ".$sql);
}
echo ("1 record added");
?>