anyone hlep me with this code?

Posted on Saturday 30th August 2008 at 08:06 PM

peza

I am trying to create a user profiles and this si my first, i have created the page that lets you view them it all works, but i am stuck on the edit profile page it wont send to the db and change it. Im only trying to get nationality to work at the momment but i have tried with all the php coding for them all. Im not sure wether its a basic thing as my php knowledge isn't great.

PHP Code

<?
 
session_start();
include "../includes/config.php";
include "../includes/functions.php";
logincheck();
 
$username=$_SESSION['username'];
$fetch=mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$username'"));
 
if (strip_tags($_POST['Submit']) && strip_tags($_POST['nationality']) && strip_tags($_POST['location']) && strip_tags($_POST['age']) && strip_tags($_POST['website']) && strip_tags($_POST['gender']) && strip_tags($_POST['msn']) && strip_tags($_POST['aim']) && strip_tags($_POST['steam']) && strip_tags($_POST['xfire']) && strip_tags($_POST['email']) && strip_tags($_POST['favdj']) && strip_tags($_POST['favplayer']) && strip_tags($_POST['favweapon']) && strip_tags($_POST['qoute']) && strip_tags($_POST['extra']) && strip_tags($_POST['favmap'])){
 
$editprofile = mysql_query("UPDATE users SET nationality='$nationality', location='$location', age='$age', website='$website', gender='$gender', msn='$msn', aim='$aim', steam='$steam', xfire='$xfire', favweapon='$favweapon', favplayer='$favplayer', favdj='$favdj', favmap='$favmap', quote='$quote', WHERE username='$username'");
 
echo "Your proflie has been updated";
echo "<meta http-equiv="refresh" content="0;URL=editprofile.php">";
 
}
 
 
?>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="https://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Edit Profile</title>
<link href="epro.css" rel="stylesheet" type="text/css" />
</head>
<style type="text/css">
.epro {
	font-family: verdana;
	font-size: 12px;
	font-style: normal;
}
</style>
<body>
<form name="form1" method="post" action="">
<div class="epro" id="epro">
  <table width="600" border="1" align="center">
    <tr>
      <td colspan="2" align="center"><strong>Edit Profile</strong></td>
    </tr>
    <tr>
      <td colspan="2" align="center"><a href="changepw.php">Change Password </a></td>
    </tr>
    <tr>
      <td colspan="2" align="center">Personal Information </td>
    </tr>
    <tr>
      <td width="300">Nationality:
         <input name="nationality" id="nationality" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->nationality"; ?>" /></td>
      <td width="284">Age:
        <input type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" name="username" /></td>
    </tr>
    <tr>
      <td>Location:
        <input type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" name="username" /></td>
      <td>Website:
        <input type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" name="username" /></td>
    </tr>
    <tr>
      <td>Gender:
        <input type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" name="username" /></td>
      <td>Email:
        <input type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" name="username" /></td>
    </tr>
    <tr>
      <td colspan="2" align="center">Contact</td>
    </tr>
    <tr>
      <td>MSN:
        <input type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" name="username" /></td>
      <td>Steam:
        <input type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" name="username" /></td>
    </tr>
    <tr>
      <td>AIM:
        <input type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" name="username" /></td>
      <td>Xfire:
        <input type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" name="username" /></td>
    </tr>
    <tr>
      <td><input type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" name="username" /></td>
      <td><input type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" name="username" /></td>
    </tr>
    <tr>
      <td colspan="2" align="center"><input name="submit" type="submit" id="submit" value="Submit"></td>
    </tr>
  </table>
</div>
</form>
</body>
</html>

anyone see what wrong?

Posted on Sunday 31st August 2008 at 12:43 AM

VicVance

Urrm I think

name="form1"

should be

name="form"

Posted on Sunday 31st August 2008 at 04:10 PM

peza

hmm ive tried that nothing still happens

Posted on Sunday 31st August 2008 at 06:26 PM

peza

i now have this thiknig it might work now but still no luck =[

PHP Code

<?
 
session_start();
include "../includes/config.php";
include "../includes/functions.php";
logincheck();
 
$username=$_SESSION['username'];
$fetch=mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$username'"));
 
if (strip_tags($_POST['submit']) && strip_tags($_POST['nationality']) && strip_tags($_POST['location']) && strip_tags($_POST['age']) && strip_tags($_POST['website']) && strip_tags($_POST['gender']) && strip_tags($_POST['msn']) && strip_tags($_POST['aim']) && strip_tags($_POST['steam']) && strip_tags($_POST['xfire']) && strip_tags($_POST['email']) && strip_tags($_POST['favdj']) && strip_tags($_POST['favplayer']) && strip_tags($_POST['favweapon']) && strip_tags($_POST['quote']) && strip_tags($_POST['extra']) && strip_tags($_POST['gender']) && strip_tags($_POST['favmap'])){
$nationality=strip_tags($_POST['nationality']);
$location=strip_tags($_POST['location']);
$age=strip_tags($_POST['age']);
$website=strip_tags($_POST['website']);
$age=strip_tags($_POST['age']);
$gender=strip_tags($_POST['gender']);
$msn=strip_tags($_POST['msn']);
$aim=strip_tags($_POST['aim']);
$steam=strip_tags($_POST['steam']);
$xfire=strip_tags($_POST['xfire']);
$email=strip_tags($_POST['email']);
$favdj=strip_tags($_POST['favdj']);
$favplayer=strip_tags($_POST['favplayer']);
$favweapon=strip_tags($_POST['favweapon']);
$quote=strip_tags($_POST['quote']);
$extra=strip_tags($_POST['extra']);
$favmap=strip_tags($_POST['favmap']);
 
mysql_query("UPDATE users SET nationality='$nationality', location='$location', gender='$gender', website='$website', age='$age', msn='$msn', aim='$aim', steam='$steam', xfire='$xfire', favweapon='$favweapon', favplayer='$favplayer', favdj='$favdj', favmap='$favmap', quote='$quote', WHERE username='$username'");
 
echo "Your proflie has been updated";
echo "<meta http-equiv="refresh" content="0;URL=editprofile.php">";
}
 
?>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="https://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Edit Profile</title>
<link href="epro.css" rel="stylesheet" type="text/css" />
</head>
<style type="text/css">
.epro {
	font-family: verdana;
	font-size: 12px;
	font-style: normal;
}
</style>
<body>
<form name="form" method="post" action="">
<div class="epro" id="epro">
  <table width="600" border="1" align="center">
    <tr>
      <td colspan="2" align="center"><strong>Edit Profile</strong></td>
    </tr>
    <tr>
      <td colspan="2" align="center"><a href="changepw.php">Change Password </a></td>
    </tr>
    <tr>
      <td colspan="2" align="center">Personal Information </td>
    </tr>
    <tr>
      <td width="300">Nationality:
         <input name="nationality" id="nationality" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->nationality"; ?>" /></td>
      <td width="284">Age:
        <input name="age" id="age" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->age"; ?>" /></td>
    </tr>
    <tr>
      <td>Location:
        <input name="location" id="location" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->location"; ?>" /></td>
      <td>Website:
        <input name="website" id="website" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->website"; ?>" /></td>
    </tr>
    <tr>
      <td>Gender:
<select size='1' name='gender' value='gender'>
<option value="male">Male</option> 
<option value="female">Female</option>
</select>
        </td>
      <td>Email:
        <input name="email" id="email" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->email"; ?>" /></td>
    </tr>
    <tr>
      <td colspan="2" align="center">Contact</td>
    </tr>
    <tr>
      <td>MSN:
        <input name="msn" id="msn" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->msn"; ?>" /></td>
      <td>Steam:
        <input name="steam" id="steam" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->steam"; ?>" /></td>
    </tr>
    <tr>
      <td>AIM:
        <input name="aim" id="aim" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->aim"; ?>" /></td>
      <td>Xfire:
        <input name="xfire" id="xfire" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->xfire"; ?>" /></td>
    </tr>
    <tr>
      <td colspan="2" align="center">Other</td>
    </tr>
	<tr>
      <td>Favourite DJ:
        <input name="favdj" id="favdj" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->favdj"; ?>" /></td>
      <td>Favourite Weapon:
        <input name="favweapon" id="favweapon" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->favweapon"; ?>" /></td>
    </tr>
	<tr>
      <td>Favourite Player:
        <input name="favplayer" id="favplayer" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->favplayer"; ?>" />
        </td>
      <td>Favourite Map:
        <input name="favmap" id="favmap" type="favmap" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->favmap"; ?>" /></td>
    </tr>
	<tr>
      <td>Quote:
      <input name="quote" id="quote" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="&quot;<?php echo "$fetch->quote"; ?>&quot;" /></td>
      <td>&nbsp;</td>
    </tr>
	<tr>
      <td height="18" colspan="2" align="center">Extra</td>
    </tr>
	<tr>
      <td colspan="2">
	  <label></label>
	  <textarea name="textarea" cols="96" rows="10"><?php echo "$fetch->extra"; ?></textarea></td>
    </tr>
    <tr>
      <td colspan="2" align="center"><input name="submit" type="submit" id="submit" value="Submit"></td>
    </tr>
  </table>
</div>
</form>
</body>
</html>

Posted on Sunday 31st August 2008 at 07:28 PM

VicVance

Are you meant to have that text " at the bottom where it says
""

Posted on Sunday 31st August 2008 at 10:53 PM

peza

yes i think its for the users quote and u cant put " next to one in the html so its ""

Posted on Sunday 31st August 2008 at 11:51 PM

ShadowMage
ShadowMage's Avatar

PHP Code

<? 
session_start(); 
include "../includes/config.php"; 
include "../includes/functions.php"; 
logincheck(); 
 
$username=$_SESSION['username']; 
$fetch=mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$username'")); 
 
if ($_POST['IHAZBEENSUBMITTED']){ 
$nationality=strip_tags($_POST['nationality']); 
$location=strip_tags($_POST['location']); 
$age=strip_tags($_POST['age']); 
$website=strip_tags($_POST['website']); 
$age=strip_tags($_POST['age']); 
$gender=strip_tags($_POST['gender']); 
$msn=strip_tags($_POST['msn']); 
$aim=strip_tags($_POST['aim']); 
$steam=strip_tags($_POST['steam']); 
$xfire=strip_tags($_POST['xfire']); 
$email=strip_tags($_POST['email']); 
$favdj=strip_tags($_POST['favdj']); 
$favplayer=strip_tags($_POST['favplayer']); 
$favweapon=strip_tags($_POST['favweapon']); 
$quote=strip_tags($_POST['quote']); 
$extra=strip_tags($_POST['extra']); 
$favmap=strip_tags($_POST['favmap']); 
 
mysql_query("UPDATE users SET nationality='$nationality', location='$location', gender='$gender', website='$website', age='$age', msn='$msn', aim='$aim', steam='$steam', xfire='$xfire', favweapon='$favweapon', favplayer='$favplayer', favdj='$favdj', favmap='$favmap', quote='$quote', WHERE username='$username'") or die(mysql_error()); 
 
echo "Your proflie has been updated"; 
echo "<meta http-equiv="refresh" content="0;URL=editprofile.php">"; 
} 
 
?> 
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
<html xmlns="https://www.w3.org/1999/xhtml"> 
<head> 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> 
<title>Edit Profile</title> 
<link href="epro.css" rel="stylesheet" type="text/css" /> 
</head> 
<style type="text/css"> 
.epro { 
    font-family: verdana; 
    font-size: 12px; 
    font-style: normal; 
} 
</style> 
<body> 
<form name="form" method="post" action=""> 
<div class="epro" id="epro"> 
  <table width="600" border="1" align="center"> 
    <tr> 
      <td colspan="2" align="center"><strong>Edit Profile</strong></td> 
    </tr> 
    <tr> 
      <td colspan="2" align="center"><a href="changepw.php">Change Password </a></td> 
    </tr> 
    <tr> 
      <td colspan="2" align="center">Personal Information </td> 
    </tr> 
    <tr> 
      <td width="300">Nationality: 
         <input name="nationality" id="nationality" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->nationality"; ?>" /></td> 
      <td width="284">Age: 
        <input name="age" id="age" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->age"; ?>" /></td> 
    </tr> 
    <tr> 
      <td>Location: 
        <input name="location" id="location" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->location"; ?>" /></td> 
      <td>Website: 
        <input name="website" id="website" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->website"; ?>" /></td> 
    </tr> 
    <tr> 
      <td>Gender: 
<select size='1' name='gender' value='gender'> 
<option value="male">Male</option>  
<option value="female">Female</option> 
</select> 
        </td> 
      <td>Email: 
        <input name="email" id="email" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->email"; ?>" /></td> 
    </tr> 
    <tr> 
      <td colspan="2" align="center">Contact</td> 
    </tr> 
    <tr> 
      <td>MSN: 
        <input name="msn" id="msn" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->msn"; ?>" /></td> 
      <td>Steam: 
        <input name="steam" id="steam" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->steam"; ?>" /></td> 
    </tr> 
    <tr> 
      <td>AIM: 
        <input name="aim" id="aim" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->aim"; ?>" /></td> 
      <td>Xfire: 
        <input name="xfire" id="xfire" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->xfire"; ?>" /></td> 
    </tr> 
    <tr> 
      <td colspan="2" align="center">Other</td> 
    </tr> 
    <tr> 
      <td>Favourite DJ: 
        <input name="favdj" id="favdj" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->favdj"; ?>" /></td> 
      <td>Favourite Weapon: 
        <input name="favweapon" id="favweapon" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->favweapon"; ?>" /></td> 
    </tr> 
    <tr> 
      <td>Favourite Player: 
        <input name="favplayer" id="favplayer" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->favplayer"; ?>" /> 
        </td> 
      <td>Favourite Map: 
        <input name="favmap" id="favmap" type="favmap" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="<?php echo "$fetch->favmap"; ?>" /></td> 
    </tr> 
    <tr> 
      <td>Quote: 
      <input name="quote" id="quote" type="text" style="background-color:#FFFFFF; border:1px solid #000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;" value="&quot;<?php echo "$fetch->quote"; ?>&quot;" /></td> 
      <td>&nbsp;</td> 
    </tr> 
    <tr> 
      <td height="18" colspan="2" align="center">Extra</td> 
    </tr> 
    <tr> 
      <td colspan="2"> 
      <label></label> 
      <textarea name="textarea" cols="96" rows="10"><?php echo "$fetch->extra"; ?></textarea></td> 
    </tr> 
    <tr> 
      <td colspan="2" align="center"><input name="IHAZBEENSUBMITTED" type="submit" id="submit" value="Submit"></td> 
    </tr> 
  </table> 
</div> 
</form> 
</body> 
</html>

Try That

failure i sense

Posted on Monday 1st September 2008 at 12:09 AM

peza

thanks

Topic is locked