Html Form Validation

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

Post Reply
tobimichigan
Forum Commoner
Posts: 48
Joined: Sun May 10, 2009 1:35 pm

Html Form Validation

Post by tobimichigan »

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%'>&nbsp;</td>
      <td width='69%'>&nbsp;</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>&nbsp;</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>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
  </table>
</form>
tobimichigan
Forum Commoner
Posts: 48
Joined: Sun May 10, 2009 1:35 pm

Re: Html Form Validation

Post by tobimichigan »

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%'>&nbsp;</td>
      <td width='69%'>&nbsp;</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>&nbsp;</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>&nbsp;</td>
      <td>&nbsp;</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");
?>
Post Reply