Jump to content

Archived

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

Colleen

Update Form Validation

Recommended Posts

Below is code from a page that was developed using dreamweaver, php, mysql, and some javascript. The form validations work with the data entry form, but I want to validate the form when it is updated also. A lot of this code was written by another individual and/or autogenerated with dreamweaver. Could someone look at it to see if there is a way to get the ... onSubmit="return CheckRequiredFields()" form action to work?

 

<form action="<?php echo $editFormAction; ?>" method="POST" name="frmChangeProposalInfo" id="frmChangeProposalInfo" onSubmit="return CheckRequiredFields()">

 

 

 

<?php

//Connection statement

require_once('../../../Connections/PropDB.php');

 

//Aditional Functions

require_once('../../../includes/functions.inc.php');

 

// build the form action

$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'] . (isset($HTTP_SERVER_VARS['QUERY_STRING']) ? "?" . $HTTP_SERVER_VARS['QUERY_STRING'] : "");

 

$varCID = $HTTP_GET_VARS['CID'];

$varYRS = $HTTP_GET_VARS['YRS'];

$varPID = $HTTP_GET_VARS['PID'];

 

if ((isset($HTTP_POST_VARS["MM_update"])) && ($HTTP_POST_VARS["MM_update"] == "frmChangeProposalInfo")) {

$updateSQL = sprintf("UPDATE Projects SET SentDate=%s, ProbPercent=%s, Amount=%s, TMorFixed=%s, AwardDate=%s, ProjectMgr=%s, BusID=%s, Outcome=%s, SFKOptions=%s, QA=%s, DataEnteredBy=%s, Title=%s, StatusDate=%s WHERE $varCID=CID and $varYRS=YRS and $varPID=PID",

GetSQLValueString($HTTP_POST_VARS['SentDate'], "date"),

GetSQLValueString($HTTP_POST_VARS['ProbPercent'], "int"),

GetSQLValueString($HTTP_POST_VARS['Amount'], "double"),

GetSQLValueString($HTTP_POST_VARS['TMorFixed'], "int"),

GetSQLValueString($HTTP_POST_VARS['AwardDate'], "date"),

GetSQLValueString($HTTP_POST_VARS['ProjectMgr'], "text"),

GetSQLValueString($HTTP_POST_VARS['BusinessArea'], "text"),

GetSQLValueString($HTTP_POST_VARS['Status'], "int"),

GetSQLValueString($HTTP_POST_VARS['SKFOptions'], "int"),

GetSQLValueString(isset($HTTP_POST_VARS['QA']) ? "true" : "", "defined","1","0"),

GetSQLValueString($HTTP_POST_VARS['DataEnteredBy'], "text"),

GetSQLValueString($HTTP_POST_VARS['Title'], "text"),

GetSQLValueString($HTTP_POST_VARS['StatusDate'], "date"));

 

$Result1 = $PropDB->Execute($updateSQL) or die($PropDB->ErrorMsg());

$updateGoTo = "/11_Accounting/ActiveProposalList/Forms/frmDisplayChangeProposalInfo.php";

if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {

$updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";

$updateGoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];

}

KT_redir($updateGoTo);

}

 

// begin Recordset

$varCID__ChangeProposalInfo = '-1';

if (isset($HTTP_GET_VARS['CID'])) {

$varCID__ChangeProposalInfo = $HTTP_GET_VARS['CID'];

}

$varYRS__ChangeProposalInfo = '-1';

if (isset($HTTP_GET_VARS['YRS'])) {

$varYRS__ChangeProposalInfo = $HTTP_GET_VARS['YRS'];

}

$varPID__ChangeProposalInfo = '-1';

if (isset($HTTP_GET_VARS['PID'])) {

$varPID__ChangeProposalInfo = $HTTP_GET_VARS['PID'];

}

$query_ChangeProposalInfo = sprintf("SELECT *, DATE_FORMAT(SentDate, '%%m/%%d/%%Y') AS Sdate, DATE_FORMAT(AwardDate, '%%m/%%d/%%Y') AS Adate, DATE_FORMAT(StatusDate, '%%m/%%d/%%Y') AS Statdate FROM Projects WHERE CID = %s and YRS = %s and PID = %s", $varCID__ChangeProposalInfo,$varYRS__ChangeProposalInfo,$varPID__ChangeProposalInfo);

$ChangeProposalInfo = $PropDB->SelectLimit($query_ChangeProposalInfo) or die($PropDB->ErrorMsg());

$totalRows_ChangeProposalInfo = $ChangeProposalInfo->RecordCount();

// end Recordset

 

// begin Recordset

$query_ProjectManagers = "SELECT * FROM Engineers WHERE Engineers.Active=1 ORDER BY Engineers.`EngineerName`";

$ProjectManagers = $PropDB->SelectLimit($query_ProjectManagers) or die($PropDB->ErrorMsg());

$totalRows_ProjectManagers = $ProjectManagers->RecordCount();

// end Recordset

 

// begin Recordset

$query_BusinessArea = "SELECT * FROM BusinessGroups";

$BusinessArea = $PropDB->SelectLimit($query_BusinessArea) or die($PropDB->ErrorMsg());

$totalRows_BusinessArea = $BusinessArea->RecordCount();

// end Recordset

 

// begin Recordset

$varCID__ClientList = '-1';

if (isset($HTTP_GET_VARS['CID'])) {

$varCID__ClientList = $HTTP_GET_VARS['CID'];

}

$query_ClientList = sprintf("SELECT * FROM ClientNumber WHERE ClientNo = %s", $varCID__ClientList);

$ClientList = $PropDB->SelectLimit($query_ClientList) or die($PropDB->ErrorMsg());

$totalRows_ClientList = $ClientList->RecordCount();

// end Recordset

//PHP ADODB document - made with PHAkt 2.7.1?>

<html>

<head>

 

<script language="JavaScript" type="text/JavaScript">

<!--VALIDATIONS

<!--

<!--Copyright 2003 Bontrager Connection, LLC

//Code obtained from http://WillMaster.com/

function CheckRequiredFields() {

var errormessage = new String();

// Put field checks below this point.

if(WithoutSelectionValue(document.frmChangeProposalInfo.ClientName))

{ errormessage += "\n\nPlease select the Client Name from the dropdown list."; }

if(WithoutContent(document.frmChangeProposalInfo.Title.value))

{ errormessage += "\n\nPlease enter a Project Title in the \"Project Title\" field."; }

if(WithoutSelectionValue(document.frmChangeProposalInfo.ProjectMgr))

{ errormessage += "\n\nPlease select a Project Manager from the dropdown list."; }

if(WithoutSelectionValue(document.frmChangeProposalInfo.BusinessArea))

{ errormessage += "\n\nPlease select the Business Area from the dropdown list."; }

if(WithoutContent(document.frmChangeProposalInfo.DataEnteredBy.value))

{ errormessage += "\n\nPlease enter a your initials in the \"Data Entered By\" field."; }

// Need to enter validation here for the numerical field Amount

if(ValidNumber(document.frmChangeProposalInfo.Amount))

{ errormessage += "\n\nPlease enter a valid number in the \"Amount\" field."; }

 

if(NoneWithCheck(document.frmChangeProposalInfo.TMorFixed))

{ errormessage += "\n\nPlease click one radio button under TM or Fixed?."; }

// Need to enter validation for two date fields here

if(ValidateDate(document.frmChangeProposalInfo.SentDate))

{ ; }

else

{ errormessage += "\n\nPlease enter a valid SENT DATE. The date format for the SENT DATE is: mm/dd/yyyy"; }

 

if(ValidateDate(document.frmChangeProposalInfo.AwardDate))

{ ; }

else

{ errormessage += "\n\nPlease enter a valid AWARD DATE. The date format for the AWARD DATE is: mm/dd/yyyy"; }

 

// Need to enter validation for the Probability field here

if(ValidProb(document.frmChangeProposalInfo.ProbPercent))

{ errormessage += "\n\nPlease enter a valid number in the \"Probability\" field."; }

if(NoneWithCheck(document.frmChangeProposalInfo.SKFOptions))

{ errormessage += "\n\nPlease click one radio button under SKF Option."; }

if(NoneWithCheck(document.frmChangeProposalInfo.Status))

{ errormessage += "\n\nPlease click one radio button under Status."; }

 

// Need to enter validation for date field here

if(ValidateDate(document.frmChangeProposalInfo.AwardDate))

{ ; }

else

{ errormessage += "\n\nPlease enter a valid AWARD DATE. The date format for the AWARD DATE is: mm/dd/yyyy"; }

 

// Put field checks above this point.

if(errormessage.length > 2) {

alert('NOTE:' + errormessage);

return false;

}

return true;

}

// end of function CheckRequiredFields()

 

 

function WithoutContent(ss) {

if(ss.length > 0) { return false; }

return true;

}

 

//function NoneWithContent(ss) {

//for(var i = 0; i < ss.length; i++) {

// if(ss.value.length > 0) { return false; }

// }

//return true;

//}

 

function NoneWithCheck(ss) {

for(var i = 0; i < ss.length; i++) {

if(ss.checked) { return false; }

}

return true;

}

 

//function WithoutCheck(ss) {

//if(ss.checked) { return false; }

//return true;

//}

 

function WithoutSelectionValue(ss) {

for(var i = 0; i < ss.length; i++) {

if(ss.selected) {

if(ss.value.length) { return false; }

}

}

return true;

}

 

// Validation test area

 

function ValidNumber(ss){

 

var digits="0123456789"

var temp

 

if (ss.value=="") {

return true

}

for (var i=0;i<ss.value.length;i++){

temp=ss.value.substring(i,i+1)

if (digits.indexOf(temp)==-1){

return true

}

}

return false;

}

 

function ValidProb(ss){

 

var digits="0123456789"

var temp

 

if (ss.value=="") {

return true

}

for (var i=0;i<ss.value.length;i++){

temp=ss.value.substring(i,i+1)

if (digits.indexOf(temp)==-1){

return true

}

if (ss.value>100){

return true

}

}

return false;

}

 

//-->

// Date Validation Function Test Area

/**

* DHTML date validation script. Courtesy of SmartWebby.com (http://www.smartwebby.com/dhtml/)

*/

// Declaring valid date character, minimum year and maximum year

var dtCh= "/";

var minYear=1900;

var maxYear=2100;

 

function isInteger(s){

var i;

for (i = 0; i < s.length; i++){

// Check that current character is number.

var c = s.charAt(i);

if (((c < "0") || (c > "9"))) return false;

}

// All characters are numbers.

return true;

}

 

function stripCharsInBag(s, bag){

var i;

var returnString = "";

// Search through string's characters one by one.

// If character is not in bag, append to returnString.

for (i = 0; i < s.length; i++){

var c = s.charAt(i);

if (bag.indexOf© == -1) returnString += c;

}

return returnString;

}

 

function daysInFebruary (year){

// February has 29 days in any year evenly divisible by four,

// EXCEPT for centurial years which are not also divisible by 400.

return (((year % 4 == 0) && ( (!(year % 100 == 0)) || (year % 400 == 0))) ? 29 : 28 );

}

function DaysArray(n) {

for (var i = 1; i <= n; i++) {

this = 31

if (i==4 || i==6 || i==9 || i==11) {this = 30}

if (i==2) {this = 29}

}

return this

}

 

function isDate(dtStr){

var daysInMonth = DaysArray(12)

var pos1=dtStr.indexOf(dtCh)

var pos2=dtStr.indexOf(dtCh,pos1+1)

var strMonth=dtStr.substring(0,pos1)

var strDay=dtStr.substring(pos1+1,pos2)

var strYear=dtStr.substring(pos2+1)

strYr=strYear

if (strDay.charAt(0)=="0" && strDay.length>1) strDay=strDay.substring(1)

if (strMonth.charAt(0)=="0" && strMonth.length>1) strMonth=strMonth.substring(1)

for (var i = 1; i <= 3; i++) {

if (strYr.charAt(0)=="0" && strYr.length>1) strYr=strYr.substring(1)

}

month=parseInt(strMonth)

day=parseInt(strDay)

year=parseInt(strYr)

if (pos1==-1 || pos2==-1){

//alert("The date format for the Sent Date and the Award Date should be: mm/dd/yyyy")

return false

}

if (strMonth.length<1 || month<1 || month>12){

//alert("Please enter a valid month for the Sent Date and/or the Award Date")

return false

}

if (strDay.length<1 || day<1 || day>31 || (month==2 && day>daysInFebruary(year)) || day > daysInMonth[month]){

//alert("Please enter a valid day for the Sent Date and/or the Award Date")

return false

}

if (strYear.length != 4 || year==0 || year<minYear || year>maxYear){

//alert("Please enter a valid 4 digit year between "+minYear+" and "+maxYear +" for the Sent Date and the Award Date")

return false

}

if (dtStr.indexOf(dtCh,pos2+1)!=-1 || isInteger(stripCharsInBag(dtStr, dtCh))==false){

//alert("Please enter a valid date for the Sent Date and the Award Date")

return false

}

return true

}

 

function ValidateDate(ss){

var dt=ss

if (isDate(dt.value)==false){

dt.focus()

return false

}

return true

}

 

// end validate date test area

//-->

</script>

 

 

<title>Update Proposal Information</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<link href="/Styles/Styles.css" rel="stylesheet" type="text/css">

</head>

 

<body>

<form action="<?php echo $editFormAction; ?>" method="POST" name="frmChangeProposalInfo" id="frmChangeProposalInfo" onSubmit="return CheckRequiredFields()">

<div id="Layer1" style="position:absolute; left:2px; top:3px; width:152px; height:34px; z-index:1;">

<div align="center"><font size="2"><a href="../Switchboard_01.php">Click

Here to Return to the Switchboard</a></font></div>

</div>

<p class="PageHeading">UPDATE PROPOSAL NUMBER INFORMATION</p>

<div align="center">

<table width="753" border="0" cellspacing="2" cellpadding="2">

<!--DWLayoutTable-->

<tr>

<td height="49" valign="top" class="FormLabel">Client Number:</td>

<td colspan="8" valign="middle" class="FormText"><span class="FormLabel"><font size="2"><?php echo $ChangeProposalInfo->Fields('CID'); ?></font></span> - <span class="FormLabel"><font size="2"><?php echo $ChangeProposalInfo->Fields('YRS'); ?></font></span> - <span class="FormLabel"><font size="2"><?php echo $ChangeProposalInfo->Fields('PID'); ?></font></span></td>

</tr>

<tr>

<td width="141" height="49" valign="top" class="FormLabel"> Client Name:</td>

<td colspan="8" align="left" valign="middle"><p class="FormText"><font color="#000066" size="2"><strong><?php echo $ClientList->Fields('ClientName'); ?></strong></font> </p>

</td>

</tr>

<tr>

<td height="32" valign="top" class="FormLabel">Project Title:</td>

<td colspan="8" valign="middle"><input name="Title" type="text" id="Title2" value="<?php echo $ChangeProposalInfo->Fields('Title'); ?>" size="60">

</td>

</tr>

<tr>

<td height="36" valign="top" class="FormLabel">Project Manager:</td>

<td colspan="2" valign="middle"><select name="ProjectMgr" size="1" id="ProjectMgr" title="<?php echo $ChangeProposalInfo->Fields('ProjectMgr'); ?>">

<option value="-1" <?php if (!(strcmp(-1, $ChangeProposalInfo->Fields('ProjectMgr')))) {echo "SELECTED";} ?>>Select

Project Manager</option>

<?php

while(!$ProjectManagers->EOF){

?>

<option value="<?php echo $ProjectManagers->Fields('Initials')?>"<?php if (!(strcmp($ProjectManagers->Fields('Initials'), $ChangeProposalInfo->Fields('ProjectMgr')))) {echo "SELECTED";} ?>><?php echo $ProjectManagers->Fields('EngineerName')?></option>

<?php

$ProjectManagers->MoveNext();

}

$ProjectManagers->MoveFirst();

?>

</select>

</td>

<td width="73" valign="" class="FormLabel">Business Area: </td

>

<td colspan="3" valign="top"><select name="BusinessArea" size="1" id="BusinessArea" title="<?php echo $ChangeProposalInfo->Fields('BusID'); ?>">

<option value="-1" <?php if (!(strcmp(-1, $ChangeProposalInfo->Fields('BusID')))) {echo "SELECTED";} ?>>Select Business Area</option>

<?php

while(!$BusinessArea->EOF){

?>

<option value="<?php echo $BusinessArea->Fields('BusinessArea')?>"<?php if (!(strcmp($BusinessArea->Fields('BusinessArea'), $ChangeProposalInfo->Fields('BusID')))) {echo "SELECTED";} ?>><?php echo $BusinessArea->Fields('BusinessArea')?></option>

<?php

$BusinessArea->MoveNext();

}

$BusinessArea->MoveFirst();

?>

</select>

</td>

<td width="95" valign="middle" nowrap><div align="right"><span class="FormLabel">QA? </span> </div>

</td>

<td width="36" valign="middle"><input name="QA" type="checkbox" id="QA2" value="<?php echo $ChangeProposalInfo->Fields('QA'); ?>">

</td>

</tr>

<tr>

<td height="36" valign="top" class="FormLabel">Data Entered By<br>

(initials only):</td>

<td width="42" valign="middle"> <input name="DataEnteredBy" type="text" id="DataEnteredBy2" value="<?php echo $ChangeProposalInfo->Fields('DataEnteredBy'); ?>" size="6">

</td>

<td width="157"> </td>

<td></td>

<td width="87"> </td>

<td width="12"> </td>

<td width="54"> </td>

<td></td>

<td></td>

</tr>

<tr>

<td height="33" colspan="9" valign="top"><hr>

</td>

</tr>

<tr>

<td height="33" valign="middle" class="FormLabel">Amount: </td>

<td colspan="2" valign="middle"> <p>

<input name="Amount" type="text" id="Amount" value="<?php echo $ChangeProposalInfo->Fields('Amount'); ?>" size="12">

</p></td>

<td colspan="3" rowspan="2" valign="top" bordercolor="#990033" class="FormLabel"><p><u>TM

or Fixed?</u> </p> <p align="left">

<label>

<input <?php if (!(strcmp($ChangeProposalInfo->Fields('TMorFixed'),"1"))) {echo "CHECKED";} ?> type="radio" name="TMorFixed" value="1">

Time and Materials</label>

<br>

<label>

<input <?php if (!(strcmp($ChangeProposalInfo->Fields('TMorFixed'),"2"))) {echo "CHECKED";} ?> type="radio" name="TMorFixed" value="2">

Fixed Price</label>

<br>

</p>

</td>

<td> </td>

<td> </td>

<td> </td>

</tr>

<tr>

<td height="39"></td>

<td> </td>

<td> </td>

<td> </td>

<td></td>

<td></td>

</tr>

<tr>

<td height="28" colspan="9" valign="top"><hr>

</td>

</tr>

<tr>

<td height="34" valign="top" class="FormLabel">Date Proposal Sent (mm/dd/yyyy):</td>

<td colspan="2" valign="middle"><input name="SentDate" type="text" id="SentDate2" value="<?php echo $ChangeProposalInfo->Fields('Sdate'); ?>">

</td>

<td colspan="2" rowspan="3" valign="top" class="FormLabel"><p><u> SKF Option</u></p> <p align="left">

<label>

<input <?php if (!(strcmp($ChangeProposalInfo->Fields('SFKOptions'),"1"))) {echo "CHECKED";} ?> type="radio" name="SKFOptions" value="1">

SKF Client</label>

<br>

<label>

<input <?php if (!(strcmp($ChangeProposalInfo->Fields('SFKOptions'),"2"))) {echo "CHECKED";} ?> type="radio" name="SKFOptions" value="2">

SKF Internal</label>

<br>

<label>

<input <?php if (!(strcmp($ChangeProposalInfo->Fields('SFKOptions'),"3"))) {echo "CHECKED";} ?> type="radio" name="SKFOptions" value="3">

SKF Referral</label>

<br>

<label>

<input <?php if (!(strcmp($ChangeProposalInfo->Fields('SFKOptions'),"4"))) {echo "CHECKED";} ?> type="radio" name="SKFOptions" value="4">

Not Applicable</label>

<br>

</p>

</td>

<td colspan="4" rowspan="3" valign="top" class="FormLabel"><p><u>Status

as of:

<input name="StatusDate" type="text" id="StatusDate" value="<?php echo $ChangeProposalInfo->Fields('Statdate'); ?>">

</u></p> <p align="left">

<label>

<input <?php if (!(strcmp($ChangeProposalInfo->Fields('Outcome'),"1"))) {echo "CHECKED";} ?> type="radio" name="Status" value="1">

Active</label>

<br>

<label>

<input name="Status" type="radio" value="2" <?php if (!(strcmp($ChangeProposalInfo->Fields('Outcome'),"2"))) {echo "CHECKED";} ?>>

Won</label>

<br>

<label>

<input <?php if (!(strcmp($ChangeProposalInfo->Fields('Outcome'),"3"))) {echo "CHECKED";} ?> type="radio" name="Status" value="3">

Lost</label>

<br>

<label>

<input <?php if (!(strcmp($ChangeProposalInfo->Fields('Outcome'),"4"))) {echo "CHECKED";} ?> type="radio" name="Status" value="4">

Cancelled</label>

<br>

</p>

</td>

</tr>

<tr>

<td height="64" valign="top" class="FormLabel"><p>Anticipated<br>

Award Date<br>

(mm/dd/yyyy): </p>

</td>

<td colspan="2" valign="middle"><u>

<input name="AwardDate" type="text" id="AwardDate" value="<?php echo $ChangeProposalInfo->Fields('Adate'); ?>">

</u> </td>

</tr>

<tr>

<td height="34" valign="top" class="FormLabel">Probability (%):</td>

<td colspan="2" valign="middle"><input name="ProbPercent" type="text" id="ProbPercent2" value="<?php echo $ChangeProposalInfo->Fields('ProbPercent'); ?>">

</td>

</tr>

</table>

</div>

<p align="center">

<input name="Submit" type="submit" value="Submit">

</p>

<p align="center"> </p>

<div align="center">

<input type="hidden" name="MM_update" value="frmChangeProposalInfo">

</div>

</form>

</body>

</html>

<?php

$ChangeProposalInfo->Close();

 

$ProjectManagers->Close();

 

$BusinessArea->Close();

 

$ClientList->Close();

?>

 

Share this post


Link to post
Share on other sites

×

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.