PHP $_POST not sending data from form -


i'm trying send data form database can't seem reason. have tried bunch of stuff, troubleshooting know, guess beyond scope of database knowledge -- month or 2 in. these 2 files trying send data between, no avail. can please explain going on?! much!

maintenancereps.php

<html> <head> <title>maintenance : reps</title> <style type="text/css"> .style1 {     margin-top: 114px; } .style2 {     border-width: 0px; } .style3 {     color: #000080;     font-size: 26pt;     font-family: calibri; } .auto-style1 {     text-align: right; } .auto-style2 {     text-align: center; } .auto-style3 {     border: 1px solid #000000;     background-color: #c0c0c0; } </style> </head> <body> <center><a href="http://acadweb1.salisbury.edu/~vg7308/premiereproductshome.html"> <span class="style3"> <img alt="" src="img2.gif" width="100" height="100" style="float: left" class="style2">    </span></a><span class="style3">rep maintenance<hr></span></center></body> <table align="center" class="auto-style3">     <tr>         <td class="auto-style1">rep num:</td>         <td> <input type="text" maxlength="32" name="repnum" value="< =$_post['rep_num']?>"></td>     </tr>     <tr>         <td class="auto-style1">last name:</td>         <td> <input type="text" maxlength="32" name="lastname" value="<?=$_post['last_name']?>"></td>     </tr>     <tr>         <td class="auto-style1">first name:</td>         <td> <input type="text" maxlength="32" name="firstname" value="<?=$_post['first_name']?>"></td>     </tr>     <tr>         <td class="auto-style1">street:</td>         <td> <input type="text" maxlength="32" name="street" value="<?=$_post['street']?>"></td>     </tr>     <tr>         <td class="auto-style1">city</td>         <td> <input type="text" maxlength="32" name="city"  value="<?=$_post['city']?>"></td>     </tr>     <tr>         <td class="auto-style1">state:</td>         <td> <input type="text" maxlength="32" name="state"  value="<?=$_post['state']?>"></td>     </tr>     <tr>         <td class="auto-style1">zip:</td>         <td> <input type="text" maxlength="32" name="zip" value="<?=$_post['zip']?>"></td>     </tr>     <tr>         <td class="auto-style1">commission:</td>         <td> <input type="text" maxlength="32" name="commission" value="<?=$_post['commission']?>"></td>     </tr>     <tr>         <td class="auto-style1">rate:</td>         <td> <input type="text" maxlength="32" name="rate"  value="<?=$_post['rate']?>"></td>     </tr>     <tr>         <td class="auto-style2" colspan="2">              <?php var_dump($_post); ?>              <form action="" method="post" enctype="multipart/form-data">                 <input type = "submit" name ="insert" value = "insert" />                 <input type = "submit" name = "search" value = "search" />                 <input type = "submit" name = "modify" value = "modify" />                 <input type = "submit" name = "delete" value = "delete" onclick="return confirm('are     sure want delete rep?')" />             </form>         </td>     </tr> </table>   <?php include "repsadd.php"; ?> </body> </html> 

repsadd.php

<html> <head> <title>maintenance : reps</title> </head> <?php session_start();   //address error handling  ini_set('display_errors',1); error_reporting(e_all & ~e_notice); //define rep number php variable name  //attempt connect  if($connection = @mysql_connect ('localhost', 'username','password')){ //print '<p>succesfully connected mysql.</p>'; } else{ die('<p>could not connect mysql because: <b>' .mysql_error() .'</b></p>'); } if (@mysql_select_db("giuliana_premiere",$connection)){ //print '<p>the giuliana_premiere database has been selected.</p>'; } else { die('<p>could not select giuliana_premiere database because: <b>'.mysql_error().'</b></p>'); }  //output resulting query table if(isset($_post['insert'])){ if(empty($_request['repnum']) || empty($_request['lastname']) || empty($_request['firstname']) || empty($_request['street']) || empty($_request['city']) || empty($_request['state']) || empty($_request['zip']) || empty($_request['commission']) || empty($_request['rate'])){     print "there information missing form."; } else{     $repnum = $_post['repnum'];     $lastname = $_post['lastname'];     $firstname = $_post['firstname'];     $street = $_post['street'];     $city = $_post['city'];     $state = $_post['state'];     $zip = $_post['zip'];     $commission = $_post['commission'];     $rate = $_post['rate'];      $query = mysql_query("insert rep values ('$repnum', '$lastname', '$firstname', '$street', '$city', '$state', '$zip', '$commission', '$rate')");     print "succesfully inserted rep";      $query2 = "select * rep rep_num = '$repnum'";     if($r = mysql_query($query2)){         while ($row = mysql_fetch_array($r)){             print "{$row['last_name']}, {$row['first_name']}<br>";             print "{$row['street']} {$row['city']}, {$row['state']} {$row['zip']}<br>";             print "<b>{$row['rep_num']}</b> | $ {$row['commission']} | {$row['rate']}<br>";         }     } } } if(isset($_post['modify'])){     if(empty($_request['repnum']) || empty($_request['lastname']) || empty($_request['firstname']) || empty($_request['street']) || empty($_request['city']) || empty($_request['state']) || empty($_request['zip'])  || empty($_request['commission'])  || empty($_request['rate'])){     print "there information missing form."; } else{        $repnum = $_post['repnum'];     $lastname = $_post['lastname'];     $firstname = $_post['firstname'];     $street = $_post['street'];     $city = $_post['city'];     $state = $_post['state'];     $zip = $_post['zip'];     $commission = $_post['commission'];     $rate = $_post['rate'];      $query = mysql_query("update rep set rep_num = '$repnum',last_name = '$lastname', first_name = '$firstname',street = '$street', city = '$city', state = '$state',zip = '$zip', commission = '$commission',rate = '$rate' rep_num = '$repnum'");     print "succesfully modified rep";      $query2 = "select * rep rep_num = '$repnum'";     if($r = mysql_query($query2)){         while ($row = mysql_fetch_array($r)){             print "{$row['last_name']}, {$row['first_name']}<br>";             print "{$row['street']} {$row['city']}, {$row['state']} {$row['zip']}<br>";             print "<b>{$row['rep_num']}</b> | $ {$row['commission']} | {$row['rate']}<br>";         }     } } } if(isset($_post['delete'])){ if(empty($_request['repnum'])){     print "there information missing in form."; } else{     $repnum= $_post['repnum'];     $query = mysql_query("delete rep rep_num = '$repnum'");     print"succesfully deleted rep"; } } ?>  </body> </html> 

all input elements should in form tag, use html

<html> <head> <title>maintenance : reps</title> <style type="text/css"> .style1 {     margin-top: 114px; } .style2 {     border-width: 0px; } .style3 {     color: #000080;     font-size: 26pt;     font-family: calibri; } .auto-style1 {     text-align: right; } .auto-style2 {     text-align: center; } .auto-style3 {     border: 1px solid #000000;     background-color: #c0c0c0; } </style> </head> <body> <center>     <a href="http://acadweb1.salisbury.edu/~vg7308/premiereproductshome.html"> <span class="style3"> <img alt="" src="img2.gif" width="100" height="100" style="float: left" class="style2"> </span></a><span class="style3">rep maintenance     <hr>     </span> </center> </body> <?php var_dump($_post); ?> <form action="" method="post" enctype="multipart/form-data">     <table align="center" class="auto-style3">         <tr>             <td class="auto-style1">rep num:</td>             <td><input type="text" maxlength="32" name="repnum" value="< =$_post['rep_num']?>"></td>         </tr>         <tr>             <td class="auto-style1">last name:</td>             <td><input type="text" maxlength="32" name="lastname" value="<?=$_post['last_name']?>"></td>         </tr>         <tr>             <td class="auto-style1">first name:</td>             <td><input type="text" maxlength="32" name="firstname" value="<?=$_post['first_name']?>"></td>         </tr>         <tr>             <td class="auto-style1">street:</td>             <td><input type="text" maxlength="32" name="street" value="<?=$_post['street']?>"></td>         </tr>         <tr>             <td class="auto-style1">city</td>             <td><input type="text" maxlength="32" name="city"  value="<?=$_post['city']?>"></td>         </tr>         <tr>             <td class="auto-style1">state:</td>             <td><input type="text" maxlength="32" name="state"  value="<?=$_post['state']?>"></td>         </tr>         <tr>             <td class="auto-style1">zip:</td>             <td><input type="text" maxlength="32" name="zip" value="<?=$_post['zip']?>"></td>         </tr>         <tr>             <td class="auto-style1">commission:</td>             <td><input type="text" maxlength="32" name="commission" value="<?=$_post['commission']?>"></td>         </tr>         <tr>             <td class="auto-style1">rate:</td>             <td><input type="text" maxlength="32" name="rate"  value="<?=$_post['rate']?>"></td>         </tr>         <tr>             <td class="auto-style2" colspan="2"><input type = "submit" name ="insert" value = "insert" />                 <input type = "submit" name = "search" value = "search" />                 <input type = "submit" name = "modify" value = "modify" />                 <input type = "submit" name = "delete" value = "delete" onclick="return confirm('are     sure want delete rep?')" /></td>         </tr>     </table> </form> <?php     include "repsadd.php"; ?> </body> </html> 

Comments

Popular posts from this blog

Android layout hidden on keyboard show -

google app engine - 403 Forbidden POST - Flask WTForms -

c - Why would PK11_GenerateRandom() return an error -8023? -