PHP form keeps looping -- designer needs quick help...
Posted: Mon Jun 22, 2009 11:59 pm
Hi, I can't figure out why this form keeps looping. I think I have my sections backward or something?? -- need help... trying to finish off this site and I'm stuck in a couple places...
Any help much appreciated.
Any help much appreciated.
Code: Select all
<? include("a_head.php"); ?>
<?
if($user_level!=1){
?>
<br />
<div id=wc500 class="boxStd rd alpha80">
<p align=center>Sorry, you are not authorized to access this section.<br />
<a href=../index.php>Return Home</a>
</p>
</div>
<?
}
else {?>
<?=caption("Edit Company Details")?>
<?=box_start()?>
<?
$co_id = 1;
if(!isset($_POST['submit'])) {
include("company_data_post.php");
$co_name = mysql_real_escape_string($co_name);
$co_address1 = mysql_real_escape_string($co_address1);
$co_address2 = mysql_real_escape_string($co_address2);
$co_city = mysql_real_escape_string($co_city);
$co_subdist = mysql_real_escape_string($co_subdist);
$co_dist = mysql_real_escape_string($co_dist);
$co_province = mysql_real_escape_string($co_province);
$co_zip = mysql_real_escape_string($co_zip);
$co_country = mysql_real_escape_string($co_country);
$co_phone1 = mysql_real_escape_string($co_phone1);
$co_phone2 = mysql_real_escape_string($co_phone2);
$co_fax = mysql_real_escape_string($co_fax);
$co_email = mysql_real_escape_string($co_email);
$co_web = mysql_real_escape_string($co_web);
$co_intro = mysql_real_escape_string($co_intro);
$co_detail = mysql_real_escape_string($co_detail);
$co_mission = mysql_real_escape_string($co_mission);
$co_groupid = mysql_real_escape_string($co_groupid);
$result = mysql_query("UPDATE company_info SET
co_name='$co_name',
co_address1='$co_address1',
co_address2='$co_address2',
co_city='$co_city',
co_subdist='$co_subdist',
co_dist='$co_dist',
co_province='$co_province',
co_zip='$co_zip',
co_phone1='$co_phone1',
co_phone2='$co_phone2',
co_fax='$co_fax',
co_email='$co_email',
co_web='$co_web',
co_intro='$co_intro',
co_detail='$co_detail',
co_mission='$co_mission',
co_groupid='$co_groupid'
WHERE id=$co_id");
if($result){
?>
<script>location.replace("index.php");</script>
<?
}else{
?>
Fail - <?=mysql_error()?>
<?
}
}else {
$result = mysql_query("SELECT * FROM company_info WHERE id='$co_id'");
$row = mysql_fetch_array($result);
?>
<form action="company_edit.php" method="post">
<script src="../lib/js/nicEdit.js"></script>
<script>bkLib.onDomLoaded(function() { nicEditors.allTextAreas() });</script>
<table>
<tr>
<td width=160>Company Name</td><td><input name="co_name" value="<?=stripslashes($row['co_name'])?>"></td>
</tr>
<tr>
<td width=160>Address 1</td><td><input name="co_address1" value="<?=stripslashes($row['co_address1'])?>"></td>
</tr>
<tr>
<td width=160>Address 2</td><td><input name="co_address2" value="<?=stripslashes($row['co_address2'])?>"></td>
</tr>
<tr>
<td width=160>City</td><td><input name="co_city" value="<?=stripslashes($row['co_city'])?>"></td>
</tr>
<tr>
<td width=160>Sub-district</td><td><input name="co_subdist" value="<?=stripslashes($row['co_subdist'])?>"></td>
</tr>
<tr>
<td width=160>District</td><td><input name="co_dist" value="<?=stripslashes($row['co_dist'])?>"></td>
</tr>
<tr>
<td width=160>Province/State</td><td><input name="co_province" value="<?=stripslashes($row['co_province'])?>"></td>
</tr>
<tr>
<td width=160>Postal Code / Zip</td><td><input name="co_zip" value="<?=stripslashes($row['co_zip'])?>"></td>
</tr>
<tr>
<td width=160>Country</td><td><input name="co_country" value="<?=stripslashes($row['co_country'])?>"></td>
</tr>
<tr>
<td width=160>Company Phone 1</td><td><input name="co_phone1" value="<?=stripslashes($row['co_phone1'])?>"></td>
</tr>
<tr>
<td width=160>Company Phone 2</td><td><input name="co_phone2" value="<?=stripslashes($row['co_phone2'])?>"></td>
</tr>
<tr>
<td width=160>Company Fax</td><td><input name="co_fax" value="<?=stripslashes($row['co_fax'])?>"></td>
</tr>
<tr>
<td width=160>Company E-mail</td><td><input name="co_email" value="<?=stripslashes($row['co_email'])?>"></td>
</tr>
<tr>
<td width=160>Company Web</td><td><input name="co_web" value="<?=stripslashes($row['co_web'])?>"></td>
</tr>
<tr>
<td width=160>Introduction</td><td><textarea name="co_intro" rows="4" cols="40"><?=stripslashes($row['co_intro'])?></textarea></td>
</tr>
<tr>
<td width=160>Detail</td><td><textarea name="co_detail" rows="8" cols="80"><?=stripslashes($row['co_detail'])?></textarea></td>
</tr>
<tr>
<td width=160>Mission</td><td><textarea name="co_mission" rows="8" cols="80"><?=stripslashes($row['co_mission'])?></textarea></td>
</tr>
<tr>
<td width=160>Group ID</td><td><input name="co_groupid" value="<?=stripslashes($row['co_groupid'])?>"></td>
</tr>
<tr>
<td width=160></td><td><input type="submit" class="submit" value="Submit"></td>
</tr>
</table>
</form>
<?
}
?>
<?=box_end()?>
<?
}
?>
<? include("a_foot.php"); ?>