PHP form some data from mySQL how to send total back to mySQL?

[ozmariners]

Enter id and seven fields populate from mySQL - works
Two drop down lists from mySQL - works
Number of checkboxes for user input - works
To be entered into mySQL and emailed to three addresses from filled fields - maybe works
Currently have two submit buttons, different names, but I would appreciate help to enable fields from mySQL to continue to work, but for the "total" form to be inserted into mySQL.
No mySQL probs. just getting the final submit to work, code below is current attempt (have been 100s so far)

<?php
if(isset($_REQUEST['lookup'])) {
//first button was used
}
else if(isset($_REQUEST['total'])) {
//second button was used
}
?>

Help with fixing and understanding solution would be much appreciated.
Thanks

[johny10151981]

where is your code?

[ozmariners]

Thanks for looking at this Johny

<?php
session_start();
function sanitize($value, $type)
{
  $value = (!get_magic_quotes_gpc()) ? addslashes($value) : $value;
 
  switch ($type) {
    case "text":
      $value = ($value != "") ? "'" . $value . "'" : "NULL";
      break;
    case "long":
    case "int":
      $value = ($value != "") ? intval($value) : "NULL";
      break;
    case "double":
      $value = ($value != "") ? "'" . doubleval($value) . "'" : "NULL";
      break;
    case "date":
      $value = ($value != "") ? "'" . $value . "'" : "NULL";
      break;
  }
 
  return $value;
}
//This function highlights a required field that has not been filled in
function missingField($var) {
    if(($_GET['m'] == 'empty') && empty($_SESSION["$var"])) {
        echo "class='missing'";
    } else {
    }
}
// end function
//This function highlights an invalid email address
function badEmail() {
    if(($_GET['m'] == 'email')) {
        echo "class='missing'";
    } else {
    }
}
// end function
//Checkbox session function
function checkBox($var) {
    if(!empty($_SESSION["$var"])) {
        echo "checked='checked'";
    } else {
    }
}
// end function
// this displays a message if an error or a missing field is detected
if($_GET['m'] == 'error') {
    $msg = "<p class='error'>Sorry an error has occoured, please contact the site administrator</p>";
} elseif($_GET['m'] == 'empty') {
    $msg = "<p class='error'>Sorry a required field has been left blank, please enter all fields marked with (*)</p>";
}
elseif($_GET['m'] == 'email')
{
$msg = "<p class='error'>Sorry the email address you have supplied seems to be invalid, please recheck the address supplied.</p>";
}
 
/////////////////////////////////////////////////////////////
// do all validation here
/////////////////////////////////////////////////////////////
$valid = 1;
if ($_POST['baust'] = "" &&
    $_POST['gbask'] = "" &&
    $_POST['bbask'] = "" &&
    $_POST['gcrik'] = "" &&
    $_POST['bcrik'] = "" &&
    $_POST['gfoot'] = "" &&
    $_POST['bfoot'] = "" &&
    $_POST['gnetb'] = "" &&
    $_POST['bhock'] = "" &&
    $_POST['ghock'] = "" &&
    $_POST['bleag'] = "" &&
    $_POST['gsoft'] = "" &&
    $_POST['bunio'] = "" &&
    $_POST['gtouc'] = "" &&
    $_POST['bsoft'] = "" &&
    $_POST['mixed'] = "" &&    
    $_POST['btouc'] = "" ) {
    $valid = 0;
    $msg = "You must select at lease one Sport to enter.";
}
if ($_POST['location'] = "") {
    $valid = 0;
    $msg = "You must select a location.";
}
/////////////////////////////////////////////////////////////
// once validation is successful, then insert to db and send email.
/////////////////////////////////////////////////////////////
if ($valid == 1) {
    //include the connection file
    require_once('connection.php');
    //save the data on the DB and send the email
    if(isset($_POST['action']) && $_POST['action'] == 'submitform')
        //receive the variables
        $schoolid = $_POST['schoolid'];
        $name = $_POST['name'];
        $street = $_POST['street'];
        $town = $_POST['town'];
        $phone = $_POST['phone'];
        $fax = $_POST['fax'];
        $email = $_POST['email'];
        $category = $_POST['category'];
        $subcategory = $_POST['subcategory'];
        $location = $_POST['location'];
        $baust = $_POST['baust'];
        $gback = $_POST['gbask'];
        $bbask = $_POST['bbask'];
        $gcrik = $_POST['gcrik'];
        $bcrik = $_POST['bcrik'];
        $gfoot = $_POST['gfoot'];
        $bfoot = $_POST['bfoot'];
        $gnetb = $_POST['gnetb'];
        $bhock = $_POST['bhock'];
        $ghock = $_POST['ghock'];
        $bleag = $_POST['bleag'];
        $gsoft = $_POST['gsoft'];
        $bunio = $_POST['bunio'];
        $gtouc = $_POST['gtouc'];
        $bsoft = $_POST['bsoft'];
        $mixed = $_POST['mixed'];
        $btouc = $_POST['btouc'];
        $money = $_POST['money'];
        $organiser = $_POST['organiser'];
        $pemail = $_POST['oemail'];
        $principal = $_POST['principal'];
        $pemail = $_POST['pemail'];
        $ip = gethostbyname($_SERVER['REMOTE_ADDR']);
        //save the data on the DB
        mysql_select_db($database_connection, $connection);
        $insert_query = sprintf("INSERT INTO knockouts (schoolid, name, street, town, phone, fax, email, category, subcategory, in, out, baust, gbask, bbask, gcrik, bcrik, gfoot, bfoot, gnetb, bhock, ghock, bleag, gsoft, bunio, gtouc, bsoft, mixed, btouch, money, organiser, oemail, principal, pemail, ip) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,  %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, NOW(), %s)",
                            sanitize($schoolid, "text"),
                            sanitize($name, "text"),
                            sanitize($street, "text"),
                            sanitize($town, "text"),
                            sanitize($phone, "text"),
                            sanitize($fax, "text"),
                            sanitize($seg, "text"),
                            sanitize($email, "text"),
                            sanitize($category, "text"),
                            sanitize($subcategory, "text"),
                            sanitize($in, "text"),
                            sanitize($out, "text"),
                            sanitize($baust, "text"),
                            sanitize($gbask, "text"),
                            sanitize($bbask, "text"),
                            sanitize($gcrik, "text"),
                            sanitize($bcrik, "text"),
                            sanitize($gfoot, "text"),
                            sanitize($bfoot, "text"),
                            sanitize($gnetb, "text"),
                            sanitize($bhock, "text"),
                            sanitize($ghock, "text"),
                            sanitize($bleag, "text"),
                            sanitize($gsoft, "text"),
                            sanitize($bunio, "text"),
                            sanitize($gtouc, "text"),
                            sanitize($bsoft, "text"),
                            sanitize($mixed, "text"),
                            sanitize($btouc, "text"),
                            sanitize($money, "text"),
                            sanitize($organiser, "text"),
                            sanitize($oemail, "text"),
                            sanitize($principal, "text"),
                            sanitize($pemail, "text"),
                            sanitize($ip, "text"));
 
//        $result = mysql_query($insert_query, $connection) or die(mysql_error());
 
        if($result) {
            //send the email
 
            $to = "[e-mail]";
            $subject = "New contact from the website";
            //headers and subject
            $headers  = "MIME-Version: 1.0\r\n";
            $headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
            $headers .= "From: ".$name." <".$email.">\r\n";
            $body = "New Application<br />";
            $body .= "Schoolid: ".$schoolid."<br />";
            $body .= "School: ".$name."<br />";
            $body .= "Address: ".$street."<br />";
            $body .= "Suburb/Town: ".$town."<br />";
            $body .= "Phone: ".$phone."<br />";
            $body .= "Fax: ".$fax."<br />";
            $body .= "in Zone: ".$in."<br />";
            $body .= "out Zone: ".$out."<br />";
            $body .= "Boys Australian Football: ".$baust."<br />";
            $body .= "Girls Basketball: ".$gback."<br />";
            $body .= "Boys Basketball: ".$bbask."<br />";
            $body .= "Email: ".$email."<br />";
            $body .= "IP: ".$ip."<br />";
 
            mail($to, $subject, $body, $headers);
            //ok message
            echo "Your message has been sent";
    }
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="en-ie" http-equiv="Content-Language" />
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<title>Knockout Sports Competitions</title>
<link rel="shortcut icon" href="/favicon.ico" type="image/x-icon" />
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="Keywords" content="sports, pssa" />
<meta http-equiv="pragma" content="no-cache" />
<meta http-equiv="cache-control" content="no-cache" />
<link rel="stylesheet" type="text/css" href="style.css" />
<script type="text/javascript">
function showUser(str)
{
if (str=="")
  {
  document.getElementById("txtHint").innerHTML="";
  return;
  }
if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
else
  {// code for IE6, IE5
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
    document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
    }
  }
xmlhttp.open("GET","getuser.php?q="+str,true);
xmlhttp.send();
}
</script>
<!--[if ie]>
<style type="text/css">
html { scrollbar-face-color: #ccccc2; scrollbar-shadow-color: #ccccc2; scrollbar-highlight-color: #ccccc2; scrollbar-3dlight-color: #ccccc2; scrollbar-darkshadow-color: #ccccc2; scrollbar-track-color: #e9e9e2; scrollbar-arrow-color: #e9e9e2; }
</style>
<![endif]-->
<script language="JavaScript">
    <!-- hide javascript from non-JavaScript browsers.
        // This function calculates the total for items in the form which are selected
    function calculateTotal(inputItem) {
        with (inputItem.form) {
            // process each of the different input types in the form.
            if (inputItem.type == "radio") { // process radio buttons
                // subtract the previously selected radio button value from the total
                calculatedTotal.value = eval(calculatedTotal.value) - eval(previouslySelectedRadioButton.value);
                // save the current radio selection value
                previouslySelectedRadioButton.value = eval(inputItem.value);
                // add the current radio button selection value to the total
                calculatedTotal.value = eval(calculatedTotal.value) + eval(inputItem.value);
            } else { // process check boxes
                if (inputItem.checked == false) { // item was uncheck. subtract item value from total
                    calculatedTotal.value = eval(calculatedTotal.value) - eval(inputItem.value);
                } else { // item was checked. add the item value to the total
                    calculatedTotal.value = eval(calculatedTotal.value) + eval(inputItem.value);
                }
            }
 
            // total value should never be less than 0
            if (calculatedTotal.value < 0) {
                InitForm();
            }
 
            // return total value
            return(formatCurrency(calculatedTotal.value));
        }
    }
 
    // format a value as currency.
    function formatCurrency(num) {
        num = num.toString().replace(/\$|\,/g,'');
 
        if(isNaN(num))
           num = "0";
 
        sign = (num == (num = Math.abs(num)));
        num = Math.floor(num*100+0.50000000001);
        cents = num%100;
        num = Math.floor(num/100).toString();
 
        if(cents<10)
            cents = "0" + cents;
 
        for (var i = 0; i < Math.floor((num.length-(1+i))/3); i++)
            num = num.substring(0,num.length-(4*i+3)) + ',' + num.substring(num.length-(4*i+3));
 
          return (((sign)?'':'-') + '$' + num + '.' + cents);
    }
 
    // This function initialzes all the form elements to default values
    function InitForm() {
        //Reset values on form
        document.selectionForm.total.value='$0';
        document.selectionForm.calculatedTotal.value=0;
        document.selectionForm.previouslySelectedRadioButton.value=0;
 
        //Set all checkboxes and radio buttons on form to unchecked:
        for (i=0; i < document.selectionForm.elements.length; i++) {
            if (document.selectionForm.elements[i].type == 'checkbox' | document.selectionForm.elements[i].type == 'radio') {
                document.selectionForm.elements[i].checked = false;
            }
        }
 
    }
 
    // end commenting javascript -->
    </SCRIPT>
 
</head>
<body onload="InitForm();" onreset="InitForm();">
<div id="page">
<div id="header">
<h2 class="headertitle">Knockout Competition Nomination Form</h2>
</div>
 
 
<div id="entry">
<div class="set1">
<fieldset>
<legend><strong>Details:</strong></legend>
<?php
    require_once('connection.php');
    mysql_select_db("ozlists_pssa")or die( "<p><span style=\"color: red;\">Unable to select database</span></p>");
        $search=$_POST['schoolid'];
        $data = 'SELECT * FROM `schools` WHERE `schoolid` = "'.$search.'"';
        $query = mysql_query($data) or die("Couldn't execute query. ". mysql_error());
        $data2 = mysql_fetch_array($query);
print_r($_POST);        
?>
<?php
if(isset($_REQUEST['lookup'])) {
//first button was used
}
else if(isset($_REQUEST['total'])) {
//second button was used
}
?>
<form name="total" method="POST" action="<?php echo $_SERVER['PHP_SELF'];?>">
<ol>
<li class="column1"><label for="schoolid"> ID:</label><input type="text" name="schoolid" value="<?php echo $data2[schoolid]?>"/><input class="details" type="submit" name="lookup" value="Lookup"></li></li>
<li class="column1"><label for="name">Name:</label><input id="name" name="name" class="text" type="text" value="<?php echo $data2[name]?>"/></li>
<li class="column1"><label for="street">Address:</label><input id="street" name="street"  class="text" type="text" value="<?php echo $data2[street]?>"/></li>
<li class="column1"><label for="town">Town / Suburb:</label><input id="town" name="town"  class="text" type="text" value="<?php echo $data2[town]?>"/></li>
<li class="column1"><label for="phone">Phone:</label><input id="phone" name="phone"  class="text" type="text" value="<?php echo $data2[phone]?>"/></li>
<li class="column1"><label for="fax">Fax:</label><input id="fax" name="fax"  class="text" type="text" value="<?php echo $data2[fax]?>"/></li>
<li class="column1"><label for="email">Email:</label><input id="email" name="email"  class="text" type="text" value="<?php echo $data2[email]?>"/></li>
<li class="column2 reset"><img src="http://bytes.com/images/logo.png"/></li>
</ol>
</fieldset>
</div>
<!--end of set1-->
 
<div class="set2">
<fieldset>
<legend><strong>Sports Region and Zone:</strong></legend>
<div id="both">
<div id="cat">
<?php
    require_once('connection.php');
    mysql_select_db("ozlists_pssa")or die( "<p><span style=\"color: red;\">Unable to select database</span></p>");
 
$cat=$_GET['cat']; // Use this line or below line if register_global is off
if(strlen($cat) > 0 and !is_numeric($cat)){ // to check if $cat is numeric data or not.
echo "Data Error";
exit;
}
// Getting the data from Mysql table for first list box //
$quer2=mysql_query("SELECT DISTINCT category,cat_id FROM category order by category");
// End of query for first list box//
 
/////// for second drop down list we will check if category is selected else we will display all the subcategory/////
if(isset($cat) and strlen($cat) > 0){
$quer=mysql_query("SELECT DISTINCT subcategory FROM subcategory where cat_id=$cat order by subcategory");
}else{$quer=mysql_query("SELECT DISTINCT subcategory FROM subcategory order by subcategory"); }
////////// end of query for second subcategory drop down list box ///////////////////////////
 
echo "<form method=post name=f1 action='send.php'>";
/// Add your form processing page address to action in above line. Example  action=dd-check.php////
//////////        Starting of first drop downlist /////////
echo "<select name='cat' onchange=\"reload(f1)\"><option value=''>Select one</option>";
while($noticia2 = mysql_fetch_array($quer2)) {
if($noticia2['cat_id']==@$cat){echo "<option selected value='$noticia2[cat_id]'>$noticia2[category]</option>"."<BR>";}
else{echo  "<option value='$noticia2[cat_id]'>$noticia2[category]</option>";}
}
echo "</select>";
//////////////////  This will end the first drop down list ///////////
 
 
//////////        Starting of second drop downlist /////////
echo "<select name='subcat'><option value=''>Select one</option>";
while($noticia = mysql_fetch_array($quer)) {
echo  "<option value='$noticia[subcategory]'>$noticia[subcategory]</option>";
}
echo "</select>";
//////////////////  This will end the second drop down list ///////////
?>
</div>
</div>
<div id="right">
<p>Please indicate <stong>where</strong> you would like to play your early round matches:</p>
<p><input type="checkbox" name="location" value="in" />    in Zone&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input type="checkbox" name="location" value="out" />   out Zone</label></p>
</div>
</fieldset>
</div>   <!--end of set2--  -- is no set 3 -->
<div class="set4">
<fieldset>
<legend><strong>We wish to enter the following Sports:</strong></legend><br />
<table align="center" cellpadding="5">
<thead>
<tr><th colspan="2">BOYS</th><th colspan="2">GIRLS</th></tr>
</thead>
<tbody>
<tr>
<td><h4>Australian Football</h4><p>Entries Close: 04.02.2011</p></td>
<td><div class="checkbox"><input id="baust" type="checkbox" name="Australian Football"   value=10.00  onclick="this.form.total.value=calculateTotal(this);">    Yes<br />
</div>  &nbsp;</td>
<td><h4>Basketball</h4><p>Entries Close: 04.02.2011</p></td>
<td><div class="checkbox">  <input id="gbask" type="checkbox" name="Basketball" value=10.00 onclick="this.form.total.value=calculateTotal(this);">    Yes<br />
</div>  &nbsp;</td>
</tr>
<tr>
<td><h4>Basketball</h4><p>Entries Close: 04.02.2011</p></td>
<td><div class="checkbox">  <input id="gbask" type="checkbox" name="Basketball" value=10.00 onclick="this.form.total.value=calculateTotal(this);">    Yes<br />
</div>  &nbsp;</td>
<td><h4>Cricket</h4><p>Entries Close: 26.11.2010</p></td>
<td><div class="checkbox">  <input id="gcric" type="checkbox" name="Cricket" value=10.00 onclick="this.form.total.value=calculateTotal(this);">    Yes<br />
</div>  &nbsp;</td>
</tr>
<tr>
<td><h4>Cricket</h4><p>Entries Close: 26.11.2010</p></td>
<td><div class="checkbox">
  <input id="bcric" type="checkbox" name="Cricket" value=10.00 onclick="this.form.total.value=calculateTotal(this);">    Yes<br />
</div>  &nbsp;</td>
<td><h4>Football</h4><p>Entries Close: 04.02.2011</p></td>
<td><div class="checkbox">  <input type="checkbox" name="Football" value=10.00 onclick="this.form.total.value=calculateTotal(this);">    Yes<br />
</div>  &nbsp;</td>
</tr>
<tr>
<td><h4>Football</h4><p>Entries Close: 04.02.2011</p></td>
<td><div class="checkbox">
<input id="bfoot" type="checkbox" name="Football" value=10.00 onclick="this.form.total.value=calculateTotal(this);">    Yes<br />
</div>  &nbsp;</td>
<td><h4>Netball</h4><p>Entries Close: 04.02.2011</p></td>
<td><div class="checkbox">  <input id="gnett" type="checkbox" name="Netball" value=10.00 onclick="this.form.total.value=calculateTotal(this);">    Yes<br />
</div></td>
</tr>
<tr>
<td><h4>Hockey</h4><p>Entries Close: 04.02.2011</p></td>
<td><div class="checkbox">
<input id="bfoot" type="checkbox" name="Hockey" value=10.00 onclick="this.form.total.value=calculateTotal(this);">    Yes<br />
</div>  &nbsp;</td>
<td><h4>Hockey</h4><p>Entries Close: 04.02.2011</p></td>
<td><div class="checkbox">  <input id="ghock" type="checkbox" name="Hockey" value=10.00 onclick="this.form.total.value=calculateTotal(this);">    Yes<br />
</div></td>
</tr>
<tr>
<td><h4>Rugby League</h4><p>Entries Close: 04.02.2011</p></td>
<td><div class="checkbox">
  <input id="brugb" type="checkbox" name="Rugby League" value=10.00 onclick="this.form.total.value=calculateTotal(this);">    Yes<br />
</div>  &nbsp;</td>
<td><h4>Softball</h4><p>Entries Close: 17.12.2010</p></td>
<td><div class="checkbox">  <input id="gsoft" type="checkbox" name="Softball" value=10.00 onclick="this.form.total.value=calculateTotal(this);">    Yes<br />
</div>  &nbsp;</td>
</tr>
<tr>
<td><h4>Rugby Union</h4><p>Entries Close: 04.02.2011</p></td>
<td><div class="checkbox">
  <input id="brugb" type="checkbox" name="Rugby Union" value=10.00 onclick="this.form.total.value=calculateTotal(this);">    Yes<br />
</div><td><h4>Touch</h4><p>Entries Close: 04.02.2011</p></td>
<td><div class="checkbox">  <input type="checkbox" name="Touch" value=10.00 onclick="this.form.total.value=calculateTotal(this);">    Yes<br />
</div></td>
</tr>
<tr>
<td valign="top"><h4>Softball</h4><p>Entries Close: 04.02.2011</p></td>
<td><div class="checkbox">
  <input id="bsoft" type="checkbox" name="Softball" value=10.00 onclick="this.form.total.value=calculateTotal(this);">    Yes<br />
</div>  &nbsp;</td>
<td><h4>Tennis Mixed<br />2 boys and 2 girls<br /></h3><p>Entries Close: 26.11.2010</p></td>
<td><div class="checkbox"><input id="mixed" type="checkbox" name="mixed" value=10.00 onclick="this.form.total.value=calculateTotal(this);">    Yes<br />
</div></td></tr>
<tr>
<td><h4>Touch</h4><p>Entries Close: 04.02.2011</p></td>
<td><div class="checkbox"><input type="checkbox" name="Touch" value=10.00 onclick="this.form.total.value=calculateTotal(this);">    Yes<br />
</div></td>
<td colspan="2"><h4>Total cost for number of teams entered:</h4>
  <input type="hidden" name="calculatedTotal" value=0>
  <input type="hidden" name="previouslySelectedcheckboxButton" value=0>
<p>$10.00 per Entry:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="total" readonly onFocus="this.blur();"></p>
</td>
</tr>
</tbody>
</table>
</fieldset>
</div>
<!--end of set4-->
</div>
<div class="set5">
<fieldset>
<legend><strong>Administration details:</strong></legend>
<p>Please retain a copy of this form .</p>
<p></p>
<p>If this entry is incorrect or there are any related issues you should contact the NSWPSSA office immediately on 02&nbsp;9707&nbsp;6920.</p>
<h4>Sports Organiser:&nbsp;&nbsp;&nbsp;
<input type="text" name="organiser" class="s_org_name" value="Entry required" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Organisers's email:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="pemail" value="Entry required" /></h4>
<h4>Principal's name:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="principal" value="Entry required" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Principal's email:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="pemail" value="Entry required" /></h4>
<input id="submit" class="submit" type="submit" name="submit" value="Submit">
</fieldset>
<!--end of set5-->
</div>
</form>
<div id="footer" align="center"><img src="http://bytes.com/images/det_footer.png"></div>
</div>
</div>
</body>
</html>