All pastes #167294 Raw Edit

Mine

public text v1 · immutable
·published 2006-09-11 21:14 UTC
rendered paste body
<img src="img/edyp.gif" alt="Edit profile" />
<?php
	$do = $_GET['do'];
	$db->Query("SELECT  * FROM gr_users WHERE user_id='".$_SESSION['user_id']."'","userinfo");
	$userinfo = mysql_fetch_assoc($db->res['userinfo']);
	
	if ($do == 11)
	{
		$firstname = mysql_real_escape_string($_POST['firstname']);
		$lastname = mysql_real_escape_string($_POST['lastname']);
		$homepage = mysql_real_escape_string($_POST['homepage']);
		$msn = mysql_real_escape_string($_POST['msn']);
		$yahoo = mysql_real_escape_string($_POST['yahoo']);
		$aim = mysql_real_escape_string($_POST['aim']);
		$age = mysql_real_escape_string($_POST['age']);
		$location = mysql_real_escape_string($_POST['location']);
		$email = mysql_real_escape_string($_POST['email']);
		// $avatarpath = mysql_real_escape_string($_POST['avatarpath']);
		$profile_text = mysql_real_escape_string($_POST['profile_text']);
		$hw_connection = mysql_real_escape_string($_POST['hw_connection']);
		$hw_os = mysql_real_escape_string($_POST['hw_os']);
		$hw_monitor = mysql_real_escape_string($_POST['hw_monitor']);
		$hw_graphics_card = mysql_real_escape_string($_POST['hw_graphics_card']);
		$hw_motherboard = mysql_real_escape_string($_POST['hw_motherboard']);
		$hw_cpu = mysql_real_escape_string($_POST['hw_cpu']);
		$hw_memory = mysql_real_escape_string($_POST['hw_memory']);
		$hw_soundcard = mysql_real_escape_string($_POST['hw_soundcard']);
		$hw_storage = mysql_real_escape_string($_POST['hw_storage']);
		
		$db->Query("UPDATE gr_users SET firstname='$firstname',lastname='$lastname',homepage='$homepage',msn='$msn',yahoo='$yahoo',
		aim='$aim',age='$age',location='$location',email='$email',profile_text='$profile_text',hw_connection='$hw_connection',
		hw_os='$hw_os',hw_monitor='$hw_monitor',hw_graphics_card='$hw_graphics_card',hw_motherboard='$hw_motherboard',hw_cpu='$hw_cpu',
		hw_memory='$hw_memory',hw_soundcard='$hw_soundcard',hw_storage='$hw_storage' WHERE user_id='".$_SESSION['user_id']."'");
		echo "<p style=\"font-size: 12px;\"><br /><b>Your profile is now updated.</b></p><br />\n";
		print_r($_POST);
	}
?>
<img src="img/roster_personalinfo.gif" alt="Personal information" />

<form action="index.php?module=profile&do=11" method="post">
<table width="553">
	<tr>
		<td style="font-size: 12px; font-family: Verdana, sans">Firstname</td>
		<td class="forumbackground_desc" align="right"><input type="text" style="border: 1px solid #e9e9e9" name="firstname" value="<?php echo $userinfo['firstname']; ?>" /></td>
	</tr>
	
	<tr>
		<td style="font-size: 12px; font-family: Verdana, sans">Lastname</td>
		<td class="forumbackground_desc" align="right"><input type="text" style="border: 1px solid #e9e9e9" name="lastname" value="<?php echo $userinfo['lastname']; ?>" /></td>
	</tr>
	
	<tr>
		<td style="font-size: 12px; font-family: Verdana, sans">Homepage</td>
		<td class="forumbackground_desc" align="right"><input type="text" style="border: 1px solid #e9e9e9" name="homepage" value="<?php echo $userinfo['homepage']; ?>" /></td>
	</tr>
	
	<tr>
		<td style="font-size: 12px; font-family: Verdana, sans">Email</td>
		<td class="forumbackground_desc" align="right"><input type="text" style="border: 1px solid #e9e9e9" name="email" value="<?php echo $userinfo['email']; ?>" /></td>
	</tr>
	
	<tr>
		<td style="font-size: 12px; font-family: Verdana, sans">Age</td>
		<td class="forumbackground_desc" align="right"><input type="text"  style="border: 1px solid #e9e9e9" name="age" value="<?php echo $userinfo['age']; ?>" /></td>
	</tr>
	
	<tr>
		<td style="font-size: 12px; font-family: Verdana, sans">Location</td>
		<td class="forumbackground_desc" align="right"><input type="text" style="border: 1px solid #e9e9e9" name="location" value="<?php echo $userinfo['location']; ?>" /></td>
	</tr>
	
	<tr>
		<td style="font-size: 12px; font-family: Verdana, sans">MSN</td>
		<td class="forumbackground_desc" align="right"><input type="text" style="border: 1px solid #e9e9e9" name="msn" value="<?php echo $userinfo['msn']; ?>" /></td>
	</tr>
	
	<tr>
		<td style="font-size: 12px; font-family: Verdana, sans">Yahoo</td>
		<td class="forumbackground_desc" align="right"><input type="text" style="border: 1px solid #e9e9e9" name="yahoo" value="<?php echo $userinfo['yahoo']; ?>" /></td>
	</tr>
	
	<tr>
		<td style="font-size: 12px; font-family: Verdana, sans">AIM</td>
		<td class="forumbackground_desc" align="right"><input type="text" style="border: 1px solid #e9e9e9" name="aim" value="<?php echo $userinfo['aim']; ?>" /></td>
	</tr>
	
	<tr>
		<td colspan="2"><img src="img/phardware.gif" alt="Hardware" /></td>
	</tr>
	
	<tr>
		<td style="font-size: 12px; font-family: Verdana, sans">Line connection</td>
		<td align="right"><input type="text" name="hw_connection" style="border: 1px solid #e9e9e9" value="<?php echo $userinfo['hw_connection']; ?>" /></td>
	</tr>
	
	<tr>
		<td style="font-size: 12px; font-family: Verdana, sans">Operating system</td>
		<td align="right"><input type="text" name="hw_os" style="border: 1px solid #e9e9e9" value="<?php echo $userinfo['hw_os']; ?>" /></td>
	</tr>
	
	<tr>
		<td style="font-size: 12px; font-family: Verdana, sans">Monitor</td>
		<td align="right"><input type="text" name="hw_monitor" style="border: 1px solid #e9e9e9" value="<?php echo $userinfo['hw_monitor']; ?>" /></td>
	</tr>
	
	<tr>
		<td style="font-size: 12px; font-family: Verdana, sans">Graphics card</td>
		<td align="right"><input type="text" name="hw_graphics_card" style="border: 1px solid #e9e9e9" value="<?php echo $userinfo['hw_graphics_card']; ?>" /></td>
	</tr>
	
	<tr>
		<td style="font-size: 12px; font-family: Verdana, sans">Motherboard</td>
		<td align="right"><input type="text" name="hw_motherboard" style="border: 1px solid #e9e9e9" value="<?php echo $userinfo['hw_motherboard']; ?>" /></td>
	</tr>
	
	<tr>
		<td style="font-size: 12px; font-family: Verdana, sans">CPU</td>
		<td align="right"><input type="text" name="hw_cpu" style="border: 1px solid #e9e9e9" value="<?php echo $userinfo['hw_cpu']; ?>" /></td>
	</tr>
	
	<tr>
		<td style="font-size: 12px; font-family: Verdana, sans">RAM/Memory</td>
		<td align="right"><input type="text" name="hw_memory" style="border: 1px solid #e9e9e9" value="<?php echo $userinfo['hw_memory']; ?>" /></td>
	</tr>
	
	<tr>
		<td style="font-size: 12px; font-family: Verdana, sans">Soundcard</td>
		<td align="right"><input type="text" name="hw_soundcard" style="border: 1px solid #e9e9e9" value="<?php echo $userinfo['hw_soundcard']; ?>" /></td>
	</tr>
	
	<tr>
		<td style="font-size: 12px; font-family: Verdana, sans">Storage</td>
		<td align="right"><input type="text" name="hw_storage" style="border: 1px solid #e9e9e9" value="<?php echo $userinfo['hw_storage']; ?>" /></td>
	</tr>
	
	<tr>
		<td colspan="2"><b style="font-size: 12px; font-family: Verdana, sans">Profile text<br /></b><textarea name="profile_text" style="border: 1px solid #e9e9e9; width: 543px; height: 200px"><?=$userinfo['profile_text'];?></textarea></td>
	</tr>
	
	<tr>
		<td>&nbsp;</td>
		<td align="right"><input type="submit" style="border: 1px solid #e9e9e9" value="Save profile" /></td>
	</tr>
</table>
</form>