PHP edit profile code

 Php edit profile code



 <?
    include("include/common.php");

    if(!$loggedin){
        ob_start();
        header("Location: login.php");
    }
    include("include/header.php");
    include("include/accmenu.php");

    if($submit){
        $sql = "update users set
            password='$spassword',
            first_name='$sfirst_name',
            last_name='$slast_name',
            street='$sstreet',
            city='$scity',
            state='$sstate',
            zip='$szip',
            country='$scountry',
            email='$semail',
            cat='$scat',
            aboutme='$saboutme',
            relocate='$sreloc',
            telephone='$stelephone' WHERE uid='$myuid'";
        mysql_query($sql) or die( mysql_error()."<br>$sql" );
?>
        <h3>Edit your Account Details</h3>
        <form action=account.php method=post>
        <?=$table2?>
        <tr align=center>
            <td colspan=2>Your account details have been saved.</td>
        </tr>
<?
        if ($cpassword != $spassword) {
            echo "<tr align=center><td colspan=2>You will now need to logout <a href=logout.php>here</a> and then login again. Make sure you do not have multiple browser windows open with this site in them.</td></tr>"; 
        }
        echo "</table>";
    }else{
        $this->c=mysql_query("select * from users where uid='$myuid'");
        $this->d=mysql_fetch_object($this->c);
        if(is_object($this->d)) {
            $cusername = $this->d->username;
            $cpassword = $this->d->password;
            $cfirst_name = $this->d->first_name;
            $clast_name = $this->d->last_name;
            $cstreet = $this->d->street;
            $ccity = $this->d->city;
            $czip = $this->d->zip;
            $cstate = $this->d->state;
            $ccountry = $this->d->country;
            $cemail = $this->d->email;
            $ctelephone = $this->d->telephone;
            $clast_paid = $this->d->last_paid;
            $ccat = $this->d->cat;
            $csignup_date = $this->d->signup_date; 
            $caboutme=$this->d->aboutme;
            $creloc=$this->d->relocate;
        }
?>
        <h3>Edit your Account Details</h3>
        <form method=post>
        <?=$table2?>
        <tr align=center>
            <td colspan=2>Edit your account details and then click the submit button below.<p></td>
        </tr>
        <tr>
            <td align=right>Username:</td>
            <td><?=$cusername?></td></tr>
        <tr>
            <td align=right>Password:</td>
            <td><input type=text name=spassword size=35 maxlength=15 value='<?=$cpassword?>'></td></tr>
        <tr>
            <td align=right>First Name:</td>
            <td><input type=text name=sfirst_name size=35 maxlength=20 value='<?=$cfirst_name?>'></td></tr>
        <tr>
            <td align=right>Last Name:</td>
            <td><input type=text name=slast_name size=35 maxlength=30 value='<?=$clast_name?>'></td></tr>
        <tr>
            <td align=right>Street:</td>
            <td><input type=text name=sstreet size=35 maxlength=50 value='<?=$cstreet?>'></td></tr>
        <tr>
            <td align=right>City:</td>
            <td><input type=text name=scity size=35 maxlength=30 value='<?=$ccity?>'></td></tr>
        <tr>
            <td align=right>State/Province:</td>
            <td><input type=text name=sstate size=35 maxlength=30 value='<?=$cstate?>'></td></tr>
        <tr>
            <td align=right>Zip/Postal Code:</td>
            <td><input type=text name=szip size=35 maxlength=10 value='<?=$czip?>'></td></tr>
        <tr>
            <td align=right>Country:</td>
            <td><input type=text name=scountry size=35 maxlength=30 value='<?=$ccountry?>'></td></tr>
        <tr>
            <td align=right>Your Email:</td>
            <td><input type=text name=semail size=35 maxlength=75 value='<?=$cemail?>'></td></tr>
        <tr>
            <td align=right>Telephone:</td>
            <td><input type=text name=stelephone size=35 maxlength=12 value='<?=$ctelephone?>'></td></tr>
        <tr>
            <td align=right>Your Category:</td>
            <td><? buildCatBox("scat",$ccat) ?>       
        <tr>
            <td align=right>Willing To Relocate:</td>
            <td>
                <input type=radio name=sreloc value=1 <?if($creloc){echo "CHECKED";}?>>Yes
                <input type=radio name=sreloc value=0 <?if(!$creloc){echo "CHECKED";}?>>No
            </td>
        <tr>
            <td>Introduce yourself</td>
            <td>
                <textarea name=saboutme cols=50 rows=10><?=$caboutme?></textarea>
            </td>
        </tr>
        <tr>
            <td colspan=2>
                <input type=submit name=submit value='Submit Changes'>
            </td>
        </tr>
        </table>
        </form>
<?
    }
    include("include/footer.php");
?>
<?
    function buildCatBox($name,$sel=""){
?>
        <SELECT NAME="<?=$name?>">
            <option value="">-----
<?
            $qr1 = mysql_query("SELECT * FROM cats ORDER BY name ASC");
            while ($a = mysql_fetch_object($qr1)){
                if($sel == $a->id){
                    echo "<OPTION VALUE=\"{$a->id}\" SELECTED>{$a->name}</OPTION>\n"; 
                }else{
                    echo "<OPTION VALUE=\"{$a->id}\">{$a->name}</OPTION>\n"; 
                }
            }
?>
        </select>
<?
    }
    function getCat($cat){
        $qr1 = mysql_query("SELECT name FROM cats WHERE id='$cat'");
        $a = mysql_fetch_object($qr1);
        return $a->name;
    }
?>