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!
[syntax=php]
<?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>[/syntax]
How To Let A User Whose Logged in change his info!?
How To Let A User Whose Logged in change his info!?
Just A PHP Beginner!
Re: How To Let A User Whose Logged in change his info!?
INSERT INTO will insert a new row, not update one.
To update a users info you'll want to use UPDATE.
[syntax=php]$sql = "UPDATE `users` SET `age` = {$age} WHERE `user_id` = {$user_id}[/syntax]
To update a users info you'll want to use UPDATE.
[syntax=php]$sql = "UPDATE `users` SET `age` = {$age} WHERE `user_id` = {$user_id}[/syntax]
Last edited by Temor on Fri Feb 03, 2012 6:47 am, edited 1 time in total.
Re: How To Let A User Whose Logged in change his info!?
What If I Have Many Optional Fields To Fill In?
Should I Use
[syntax=php]
$sql = "UPDATE `users` SET `age`='$age' AND `gender`='$gender' "
[/syntax]
Is It Done That Way?
Should I Use
[syntax=php]
$sql = "UPDATE `users` SET `age`='$age' AND `gender`='$gender' "
[/syntax]
Is It Done That Way?
Just A PHP Beginner!
Re: How To Let A User Whose Logged in change his info!?
It should be a comma separated list of columns to update
[syntax=sql]UPDATE `table` SET `column` = 'value', `column2` = 'value2' WHERE `id`= 7[/syntax]
[syntax=sql]UPDATE `table` SET `column` = 'value', `column2` = 'value2' WHERE `id`= 7[/syntax]
Re: How To Let A User Whose Logged in change his info!?
jacek wrote:It should be a comma separated list of columns to update
[syntax=sql]UPDATE `table` SET `column` = 'value', `column2` = 'value2' WHERE `id`= 7[/syntax]
Thanks! I Tried! And It Works!
Just A PHP Beginner!
Re: How To Let A User Whose Logged in change his info!?
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!
[syntax=php]
<?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>
[/syntax]
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!
[syntax=php]
<?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>
[/syntax]
Just A PHP Beginner!
Re: How To Let A User Whose Logged in change his info!?
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.
Re: How To Let A User Whose Logged in change his info!?
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!?
Just A PHP Beginner!
Re: How To Let A User Whose Logged in change his info!?
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.
[syntax=php]
<? $a="Default value"; ?>
<html><body>
<input name="test" type="text" value="<? echo $a ?>"/>
</body></html>
[/syntax]
Hope this wht u want, displays the text when u run the page in the browser instantly.
Cheers.
U write the code above this, to validate if empty or not in php or javascript.
[syntax=php]
<? $a="Default value"; ?>
<html><body>
<input name="test" type="text" value="<? echo $a ?>"/>
</body></html>
[/syntax]
Hope this wht u want, displays the text when u run the page in the browser instantly.
Cheers.