HELP!
Before when using text are on of input fields our code was working fine but after changing some of the fields to dropdown boxes and radio button, the code does not continue to proceed to the command after the insert query.
Please help! I will attach the code
<h1><font color="black"><center>NEW RECORD</center></font></h1>
<form method="POST" action="add.php">
<table width="500px" class="table1" border='1'cellpadding='5' >
<tr>
<td>
Lead Section:
</td>
<td>
<input type ="radio" name= "ulead_sec" value="Backend">Backend
<input type ="radio" name= "ulead_sec" value="NMS">NMS
<!--<textarea name=ulead_sec rows=2 cols=45></textarea>-->
</td>
</tr>
<tr>
<td>
Activity Owner:
</td>
<td>
<select name='uact_own'>
<option value ="Core Network Planning and Engineering">Core Network Planning and Engineering</option>
<option value ="NetIT SysAd">NetIT SysAd</option>
<option value="Svcs Design">Svcs Design</option>
<option value="IPBB Planning">IPBB Planning</option>
<option value="Access Network Engineering">Access Network Engineering</option>
<option value="IT OSS">IT OSS</option>
<option value="IT Mediation">IT Mediation</option>
</select>
<!--<textarea name=uact_own rows=2 cols=45></textarea>-->
</td>
</tr>
<tr>
<td>
System:
</td>
<td>
<textarea name=usystem rows=2 cols=45></textarea>
</td>
</tr>
<tr>
<td>
Activity:
</td>
<td>
<textarea name=uactivity rows=2 cols=45></textarea>
</td>
</tr>
<tr>
<td>
Nature of Activity:
</td>
<td>
<textarea name=unature_act rows=2 cols=45></textarea>
</td>
</tr>
<tr>
<td>
Update Time (yyyy-mm-dd)(hh:mm:ss):
</td>
<td>
<textarea name=uupdate_time rows=2 cols=45></textarea>
</td>
</tr>
<tr>
<td>
Last Update:
</td>
<td>
<textarea name=ulast_update rows=15 cols=45></textarea>
</td>
</tr>
<tr>
<td>
Coordinated with:
</td>
<td>
<textarea name=ucwith rows=2 cols=45 ></textarea>
</td>
</tr>
<tr>
<td>
Activity Reference:
</td>
<td>
<textarea name=uact_ref rows=2 cols=45></textarea>
</td>
</tr>
<tr>
<td>
Remarks:
</td>
<td>
<textarea name=uremarks rows=10 cols=45></textarea>
</td>
</tr>
</table>
<div style="text-align: center; padding-top: 30px; padding-left:30px; padding-right:30px;">
<input type=submit align= center name=submit value=ADD>
</form></div>
<div style="text-align: center; padding-top: 0px; padding-left:30px; padding-right:30px;">
<form method="POST" action="view.php">
<input type=submit name=cancel value=CANCEL>
</form></div>
</div>
</div>
</div>
<?php
include('connection.php');
if(isset($_POST['submit'])){
$ulead_sec = mysql_real_escape_string(trim($_POST['ulead_sec']));
if(!empty($ulead_sec)){
$AddQuery = "INSERT INTO tasklist (lead_sec, act_own, system, activity, nature_act, update_time, last_update, cwith, act_ref, remarks)
VALUES ('$_POST[ulead_sec]','$_POST[uact_own]','$_POST[usystem]','$_POST[uactivity]','$_POST[unature_act]','$_POST[uupdate_time]','$_POST[ulast_update]','$_POST[ucwith]','$_POST[uact_ref]','$_POST[uremarks]')";
mysql_query($AddQuery);
header("Location:view.php");
}
else{
echo ("Empty Fields");
}
}
?>
</body>
</html>
Aucun commentaire:
Enregistrer un commentaire