|
|
I have a button that needs to validate a form then submit it to script one and another button that need to submit to script two. Button one needs to validate the form and only submit it true.
below is the entire script (sorry for the length). The problem is: after the javascript returns false the page continues and the SQL insert statement is executed which should not happen.
<?php
include ("/forum/header.html");
?>
<html>
<head>
<link rel=stylesheet type=text/css href=style.css>
<script language="JavaScript" src="/forum/date_picker.js"></script>
<script language="JavaScript">
<!--
function validate_form()
{
var error_string = "";
valid = true;
if (document.Orders.PartNumber.value == "" )
{
error_string += "You must enter a part number value.\n";
//document.Create_Edit.PartNumber.focus()
valid = false;
}
if (document.Orders.PreferredVender.value == "" )
{
error_string += "You must enter a preferred vender value.\n";
// document.Create_Edit.PreferredVender.focus()
valid = false;
}
if (isNaN(parseInt(document.Orders.QuantityOrdered.value)))
{
error_string += "Quantity must be a number.\n";
// document.Create_Edit.MinInv.focus()
valid = false;
}
if(document.Orders.QuantityOrdered=="")
{
error_string += "You must enter a quantity value.\n";
// document.Create_Edit.MinInv.focus()
valid = false;
}
if (document.Orders.PONumber.value == "" )
{
// document.Create_Edit.MaxInv.focus()
error_string += "You must enter a PO number.\n";
valid = false;
}
if (document.Orders.OrderedBy.value == "" )
{
error_string += "You must enter who created the order.\n";
// document.Create_Edit.Location.focus()
valid = false;
}
if(error_string==""){
value= true;
}else {
error_string="Please correct the following errors: \n" + error_string;
alert(error_string);
valid = false;
return false;
}
document.Orders.submit();
}
//-->
</script>
</head>
<body>
<form name=Orders method=post action="<?php echo $_SERVER['PHP_SELF'];?>">
<?php
switch ($_POST[Complete]){
case "Add to this PO":
################## validate for existing part number ################################
$num_rows=0;
$check_part=mysql_query("SELECT * from part_master where PartNumber='$_POST[PartNumber]' and Facility='$_COOKIE[UPlant]'");
while($myrow=mysql_fetch_array($check_part)){
$num_rows=$num_rows+1;
}
if ($num_rows<'1'){
#echo $num_rows;
echo "The part number you have entered does not exist in the database. Before you can order this part you must enter it in the Parts Master. To
do so please <a href=create_edit.php>click here</a>";
exit();
}else{
echo ("<div align=center>Add to PO</div>");
#include("/forum/orderform.html");
?>
<div align=center><table>
<tr>
<td>Order ID:</td><td><?php echo $_COOKIE[NextOrderID] ?></td><td>PO:</td><td><input type=text name=PONumber size=15
value="<?php echo $_POST[PONumber]?>";></td></tr>
<tr><td>Ordered By:</td><td><select name=SOrderedBy
onchange='javascript:document.Orders.OrderedBy.value=document.Orders.SOrderedBy.value'>><option value=0>Select</option>
<?php
$OrderedBy=mysql_query("SELECT OrderedBy from Orders");
while($myrow=mysql_fetch_array($OrderedBy))
{
echo "<option value=$myrow[OrderedBy]>$myrow[OrderedBy]</option>";
}
?>
</select>
</td>
<td>Ordered On:</td><td><input type=text SIZE=15 name=OrderedOn value=<?php echo gmdate("m/d/Y") ?>>
<a href="javascript:show_calendar('Orders.OrderedOn');" onmouseover="window.status='Date Picker';return true;"
onmouseout="window.status='';return true;"><img src="/images/show_calendar.gif" width=16 height=16 border=0></a> </td>
</tr>
<td>OR</td><td><input type=text name=OrderedBy value="<?php echo $_POST[OrderedBy]?>";></td><td>Quantity Ordered:</td><td><input
type=text name=QuantityOrdered></td></tr>
<tr><td>Part Number:</td>
<td><select name=SPartNumber onchange='javascript:document.Orders.PartNumber.value=document.Orders.SPartNumber.value'>><option
value=0>Select</option>
<?php
$PartNumber=mysql_query("SELECT PartNumber from Part_Master");
while($myrow=mysql_fetch_array($PartNumber))
{
echo "<option value=$myrow[PartNumber]>$myrow[PartNumber]</option>";
}
?>
</select>
</td><td>Ordered from:</td>
<td><select name=SPreferredVender
onchange='javascript:document.Orders.PreferredVender.value=document.Orders.SPreferredVender.value'><option value=0>Select</option>
<?php
$PreferredVender=mysql_query("SELECT PreferredVender from Part_Master");
while($myrow=mysql_fetch_array($PreferredVender))
{
echo "<option value=$myrow[PreferredVender]>$myrow[PreferredVender]</option>";
}
?>
</select>
</td></tr>
<td>OR</td><td><input type=text name=PartNumber></td><td>OR</td><td><input type=text name=PreferredVender></td></tr>
<tr><td>Unit Cost:</td><td><input type=text name=UnitCost></td></tr>
<td colspan=4 align=center><input type=submit name=Complete value="Add to this PO" onclick="validate_form();"><input type=submit
name=Complete value="Create a new PO">
</td></tr>
</table></div>
<?php
echo "hello";
$create="INSERT into
orders(UnitCost,Facility,PartNumber,OrderedBy,OrderedOn,QuantityOrdered,PreferredVender,PONumber)VALUES('$_POST[UnitCost]','$_CO
OKIE[UPlant]','$_POST[PartNumber]','$_POST[OrderedBy]','$_POST[OrderedOn]','$_POST[QuantityOrdered]','$_POST[PreferredVender]','$_P
OST[PONumber]')";
$result=mysql_query($create);
#$errors=mysql_error();
#echo $errors;
#echo ("<div align=center>Create Order</div>");
echo "<div align=center>This item has been processed</div>";
exit();
}
break;
case "Create a new PO":
echo ("<div align=center>Create New PO</div>");
include("/forum/orderform.html");
exit();
default:
echo ("<div align=center>Create Order</div>");
break;
}
?>
<?php
$get_OrderID=mysql_query("SELECT * from orders ORDER BY OrderID DESC limit 1");
while($myrow=mysql_fetch_array($get_OrderID))
{
$OrderID=$myrow[OrderID];
}
$NextOrderID=$OrderID+1;
#setcookie("Flag","Y",time()+4600);
setcookie("NextOrderID","$NextOrderID",time()+1000);
?>
<div align=center><table>
<tr>
<td>Order ID:</td><td><?php echo $NextOrderID ?></td><td>PO:</td><td><input type=text name=PONumber size=15></td></tr>
<tr><td>Ordered By:</td><td><select name=SOrderedBy
onchange='javascript:document.Orders.OrderedBy.value=document.Orders.SOrderedBy.value'>><option value=0>Select</option>
<?php
$OrderedBy=mysql_query("SELECT OrderedBy from Orders");
while($myrow=mysql_fetch_array($OrderedBy))
{
echo "<option value=$myrow[OrderedBy]>$myrow[OrderedBy]</option>";
}
?>
</select>
</td>
<td>Ordered On:</td><td><input type=text SIZE=15 name=OrderedOn value=<?php echo gmdate("m/d/Y") ?>>
<a href="javascript:show_calendar('Orders.OrderedOn');" onmouseover="window.status='Date Picker';return true;"
onmouseout="window.status='';return true;"><img src="/images/show_calendar.gif" width=16 height=16 border=0></a> </td>
</tr>
<td>OR</td><td><input type=text name=OrderedBy></td></tr>
<tr><td>Part Number:</td>
<td><select name=SPartNumber onchange='javascript:document.Orders.PartNumber.value=document.Orders.SPartNumber.value'>><option
value=0>Select</option>
<?php
$PartNumber=mysql_query("SELECT PartNumber from Part_Master");
while($myrow=mysql_fetch_array($PartNumber))
{
echo "<option value=$myrow[PartNumber]>$myrow[PartNumber]</option>";
}
?>
</select>
</td><td>Ordered from:</td>
<td><select name=SPreferredVender
onchange='javascript:document.Orders.PreferredVender.value=document.Orders.SPreferredVender.value'><option value=0>Select</option>
<?php
$PreferredVender=mysql_query("SELECT PreferredVender from Part_Master");
while($myrow=mysql_fetch_array($PreferredVender))
{
echo "<option value=$myrow[PreferredVender]>$myrow[PreferredVender]</option>";
}
?>
</select>
</td></tr>
<td>OR</td><td><input type=text name=PartNumber></td><td>OR</td><td><input type=text name=PreferredVender></td></tr>
<tr><td>Quantity Ordered:</td><td><input type=text name=QuantityOrdered></td><td>Unit Cost:</td><td><input type=text
name=UnitCost></td></tr>
<td colspan=4 align=center><input type=button name=Complete value="Add to this PO" onclick="validate_form();"><input type=submit
name=Complete value="Create a new PO">
</td></tr>
</table></div>
</body>
</html>
|
|
|
|
|
|
|
|
skicrud
