PHP form keeps looping -- designer needs quick help...

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
lucaslopatka
Forum Newbie
Posts: 4
Joined: Mon Jun 22, 2009 11:53 pm

PHP form keeps looping -- designer needs quick help...

Post by lucaslopatka »

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.

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"); ?>
User avatar
McInfo
DevNet Resident
Posts: 1532
Joined: Wed Apr 01, 2009 1:31 pm

Re: PHP form keeps looping -- designer needs quick help...

Post by McInfo »

Is this file named index.php?

I think your problem might be that, starting at line 19, your script says, "If $_POST['submit'] is not set, run this update query. Then if the query was successful, go to index.php."

Code: Select all

if(!isset($_POST['submit'])) {
Edit: This post was recovered from search engine cache.
Post Reply