Jump to content

Archived

This topic is now archived and is closed to further replies.

rallokkcaz

help editing profiles.

Recommended Posts

i need help with the code i have for editing the profiles
cause everytime you choose to edit it any one can edit it
pleeze help!!

thanks

ps thanks for all the help with PHP

Share this post


Link to post
Share on other sites
Man you really need to learn proper spelling and grammar (yes I can see your only 13, I could care less). It will get you more responses. Can you post the code you are using now?

Share this post


Link to post
Share on other sites
[code]<?
include ("config.php");

if(isset($_GET['id']) && is_numeric($_GET['id']))
{
    $id = $_GET['id'];

    $sql = "SELECT * FROM maaking_users WHERE userid='$id'";

    $result = @mysql_query($sql) or die(mysql_error());

    $user = mysql_fetch_assoc($result);
    echo <<<HTMLFORM
<form action="{$_SERVER['PHP_SELF']}" method="post">
<table  cellpadding="2" cellspacing="1" width="400">
  <tr>
    <td wdith="35%">Username:</td>
    <td>{$user['username']}</td>
  </tr> 
  <tr>
    <td>Full Name:</td>
    <td><input type="text" name="fullname" value="{$user['fullname']}" /></td>
  </tr>
  <tr>
    <td>Email Address:</td>
    <td><input type="text" name="email" value="{$user['email']}" /></td>
  </tr>
  <tr>
    <td colspan="2">
      <input type="hidden" name="userid" value="{$user['userid']}" />
      <input type="submit" name="update" value="Update Profile">
    </td>
  </tr>
</table>
</form>
HTMLFORM;
}
elseif(isset($_POST['update']))
{
    foreach($_POST as $field_name => $field_value)
    {
        ${$field_name} = mysql_real_escape_string($field_value);
    }

    $sql = "UPDATE pokebash_users email='$email', fullname='$fullname' WHERE userid='$userid'";

    $result = mysql_query($sql) or die(mysql_error());

    echo "Successfully updated profile";

}
else
{
    //########REDIRECTS TO YOUR HOME PAGE IF UID IS NOT PRESENT IN THE URL#########
    echo '<meta http-equiv="refresh" content="0;URL=user.php" />';
  }

?>[/code]

Share this post


Link to post
Share on other sites
here's the erorr i get

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '='bob@aol.com', fullname='Aay' WHERE userid='6'' at line 1

Share this post


Link to post
Share on other sites
1 wrong and corrected
[code]
$sql = "UPDATE pokebash_users  set email='$email', fullname='$fullname' WHERE userid='$userid'";
[/code]

2 wrong corrected always use a diffrent query name from others
[code]
$sql2 = "UPDATE pokebash_users email='$email', fullname='$fullname' WHERE userid='$userid'";

    $result = mysql_query($sql2) or die(mysql_error());
[/code]


if your using sessions always have session_start() at the top of every page ok

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.