How To Let A User Whose Logged in change his info!?

Shahlin · Post by **Shahlin** » Thu Feb 02, 2012 2:10 pm

This Page Is Currently Just For Updating Your Age!
When I Type An Age And Click On Update...It Doesn't Update In My Database! It's The SQL Query's Problem!
Please Help!
Thanks!

<?php

include_once 'config.php' ;

if (!isset($_SESSION['user_id'])&& empty ($_SESSION['user_id'])) {
	echo 'You must be logged in to edit your profile.';
	die () ;
} else {
if (isset ($_POST['submit'])) {
	$age = $_POST ['age'] ;
if (!empty ($age)) {
	$sql = "INSERT INTO `users` VALUES('','','','','','','','$age','','','')" ; //I WANT THE CHANGES SHOULD BE SAVED ONLY FOR THE USER WHO IS CURRENTLY LOGGED IN!
if ($sql_run = mysql_query ($sql)) {
	die ('Your profile has been updated.') ;
				} else {
					die ('There Was A problem Updating Profile.') ;
				}
			} else {
				echo 'Please Fill In Fields.' ;
		}
	} 	
}
?>

<form action="edit_profile.php" method="POST">
Age : <input type="text" name="age"><br><br>
<input type="submit" name="submit" value="Update!">

</form>

Post by **Temor** » Thu Feb 02, 2012 5:43 pm

INSERT INTO will insert a new row, not update one.
To update a users info you'll want to use UPDATE.

$sql = "UPDATE `users` SET `age` = {$age} WHERE `user_id` = {$user_id}

Shahlin · Post by **Shahlin** » Thu Feb 02, 2012 6:22 pm

What If I Have Many Optional Fields To Fill In?

Should I Use

$sql = "UPDATE `users` SET `age`='$age' AND `gender`='$gender' "

Is It Done That Way?

Post by **jacek** » Fri Feb 03, 2012 1:06 am

It should be a comma separated list of columns to update

UPDATE `table` SET `column` = 'value', `column2` = 'value2' WHERE `id`= 7

Shahlin · Post by **Shahlin** » Fri Feb 03, 2012 1:38 pm

jacek wrote:It should be a comma separated list of columns to update
UPDATE `table` SET `column` = 'value', `column2` = 'value2' WHERE `id`= 7

Thanks! I Tried! And It Works!

Shahlin · Post by **Shahlin** » Fri Feb 03, 2012 1:41 pm

One Last Question!

I Did What You Said...But Now What Happens Is If They Leave Age Empty And Their Next Field Empty...Their Age Updates And The Next Field Value Blanks Out From The Profile.

This is the current edit page!

<?php

include_once 'config.php' ;
include_once 'core.php' ;

$user_id = $_SESSION['user_id'] ;
if (!isset($_SESSION['user_id'])&& empty ($_SESSION['user_id'])) {
	echo 'You must be logged in to edit your profile.';
	die () ;
} else {
if (isset ($_POST['submit'])) {
	$age = $_POST ['age'] ;
    $status = $_POST ['status'] ;
if (!empty ($age)  || !empty ($status)) {
	$sql = "UPDATE `users` SET `age`='$age' , `status`='$status' WHERE `id`='$user_id'" ;
if ($sql_run = mysql_query ($sql)) {
	die ('Your profile has been updated.') ;
				} else {
					die ('There Was A Problem Updating Profile.') ;
				}
			} else {
				echo 'Please Fill In Fields.' ;
		}
	} 	
}
?>

<form action="edit_profile.php" method="POST">
Age   : <input type="text" name="age"><br><br>
Status: <input type="text" name="status"><br><br> 
<input type="submit" name="submit" value="Update!">

</form>

Post by **jacek** » Sat Feb 04, 2012 12:37 am

You could populate the form fields with default values from the table, that way they will just update to the current value if they don't change them.

Shahlin · Post by **Shahlin** » Sat Feb 04, 2012 12:09 pm

jacek wrote:You could populate the form fields with default values from the table, that way they will just update to the current value if they don't change them.

How To Set A Default Value?

Is It Just Like....Making A Variable Of What They Previously Added!?

lakc · Post by **lakc** » Sun Feb 05, 2012 7:49 pm

Why dont u read about the basic php on w3schools.com, there u may find answers to ure trivial questions

U write the code above this, to validate if empty or not in php or javascript.

<? $a="Default value"; ?>
<html><body>
<input name="test" type="text" value="<? echo $a ?>"/>
</body></html>

Hope this wht u want, displays the text when u run the page in the browser instantly.

Cheers.

BetterPHP

How To Let A User Whose Logged in change his info!?

How To Let A User Whose Logged in change his info!?

Re: How To Let A User Whose Logged in change his info!?

Re: How To Let A User Whose Logged in change his info!?

Re: How To Let A User Whose Logged in change his info!?

Re: How To Let A User Whose Logged in change his info!?

Re: How To Let A User Whose Logged in change his info!?

Re: How To Let A User Whose Logged in change his info!?

Re: How To Let A User Whose Logged in change his info!?

Re: How To Let A User Whose Logged in change his info!?