June 12th, 2003, 09:32 PM
|
|
Contributing User
|
|
Join Date: Apr 2003
Posts: 187
Time spent in forums: < 1 sec
Reputation Power: 6
|
|
|
the code
here thanks:
PHP Code:
<?php require_once('Connections/users.php'); ?>
<?php
mysql_select_db($database_users, $users);
$query_Recordset1 = "SELECT * FROM `session`, users";
$Recordset1 = mysql_query($query_Recordset1, $users) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
if($_POST['what'] == 'process')
{
if($_POST['strPassword'] == $_POST['strPasswordConfirm'])
{
$dbVars = new dbVars;
@$svrConn = mysql_connect($dbVars->strServer, $dbVars->strUser, $dbVars->strPass);
if($svrConn)
{
// Connected to the database server OK
$dbConn = mysql_select_db($dbVars->strDb, $svrConn);
if($dbConn)
{
$password = md5($_POST['strPassword']);
$strQuery = "INSERT INTO users WHERE username ='" . $_POST['strUserName'] . "'(";
$strQuery .= "`password`, `firstname`, `lastname`, `location`, `age`) VALUES (";
$strQuery .= "'$password', '{$_POST['strFirstName']}', '{$_POST['strLastName']}', '{$_POST['strLocation']}', '{$_POST['strAge']}')";
if(mysql_query($strQuery))
{
?>
<span class="title">Profile Updated!</span></span><br>
<br>You have successfully updated your Profile!<br>
<a href="index.php">Continue</a>
<?php } } } } else { ?>
<span class="title">Error</span><br><br>
Sorry, but the passwords you supplied did not match. Please use the link below to return.<br><br>
<a href="index.php?page=registration">Back</a>
<?php } } else {
function MatchUp()
{
$changeIt = @mysql_query("SELECT * FROM users WHERE userId ='" . $strMethod . "'") or die ("couldn't do it");
while ($changeRow = mysql_fetch_row($changeIt))
{ $changeIt2 = @mysql_query("SELECT * FROM `session` WHERE username = '" . $changeRow[1] . "'") or die ("couldn't do this");
while ($changeRow2 = mysql_fetch_row($changeIt2))
{ $strMethod2 = $changeRow2[1]; } }
header("Location: index.php?page=editprofile&strMethod=$strMethod2");
}
function NoMatchUp()
{
if ($_GET['strMethod'])
{
$verifyUser = @mysql_query("SELECT * FROM `session` WHERE sessionid = '" . $_GET['strMethod'] . "'");
while ($userRow = mysql_fetch_row($verifyUser))
{ $verifyUser2 = @mysql_query("SELECT * FROM users WHERE username = '" . $userRow[2] . "'");
while ($userRow2 = mysql_fetch_row($verifyUser2))
{ $handle = $userRow2[1];
$location = $userRow2[7];
$fname = $userRow2[4];
$lname = $userRow2[5];
$age = $userRow2[8];
$method = $userRow[6]; } }
?>
<span class="title">
<tr><td width='100%' bgcolor='#66B4F4'>Edit Profile</td></tr><br></span>
<table width="34%" border="0">
<!-- <a href="index.php?page=getfiles">*Upload a Picture*</a> -->
<form action=<?php "index.php?page=editprofile&strMethod='" . $method . "'" ?> method="post">
<input type="hidden" name="what" value="process">
<tr>
<td width="16%"><strong>UserName </strong></td>
<td><input type="text" name="strUserName" value="<?php echo $handle; ?>"></td>
</tr>
<tr>
<td width="16%"><strong>Password </strong></td>
<td width="84%"><input type="password" name="strPassword" value=""></td>
</tr>
<tr>
<td width="16%"><strong>Confirm Password </strong></td>
<td width="84%"><input type="password" name="strPasswordConfirm" value=""></td>
</tr>
<tr>
<td width="16%"><strong>Location </strong></td>
<td><input type="text" name="strLocation" value="<?php echo $location; ?>"></td>
</tr>
<tr>
<td width="16%"><strong>Age </strong></td>
<td><select name="strAge" value="<?php echo $age; ?>">
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30+">30+</option>
</select></td>
</tr>
<tr>
<td width="16%"><strong>First Name </strong></td>
<td><input type="text" name="strFirstName" value="<?php echo $fname; ?>"></td>
</tr>
<tr>
<td width="16%"><strong>Last Name </strong></td>
<td><input type="text" name="strLastName" value="<?php echo $lname; ?>"></td>
</tr>
<tr>
<td width="16%"></td>
<td><input type="submit" value="Edit"></td>
</tr>
</form>
<tr width='84%'><td width='100%'><font size="1">Note : Changing your password } } }
will delete your current
password and replace it with a new one. Be sure to remember it!</font></td>
<td width='84%'><font size="1">Note : Also be sure to enter your correct Username, or the profile will not update correctly!</td></tr></table>
<?php
if($IsLoggedIn)
{
$strMethod = $_GET['strMethod'];
$strEditMethod = $_GET['strEditMethod'];
switch($strEditMethod)
{
case "adminEdit":
MatchUp();
break;
default:
NoMatchUp();
break;
}
} else {
echo 'You are not authorized to view this page.
This is most likely due to not being
<a href="index.php?page=login">Logged In</a>.';
}
//mysql_free_result($Recordset1);
?>
thanks man
i hope this helps
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
