genzedu777 Posted February 5, 2011 Share Posted February 5, 2011 Hi guys, Currently I am editing profiles online and get it updated in my database. And when user has successfully updated his/her profile, they will be directed to a link echo '<p>Your profile has been successfully updated. Would you like to <a href="viewprofile.php?tutor_id=' . $_GET[$row['tutor_id']] . '">view your profile</a>?</p>'; As you can see, I have set tutor_id=' . $_GET[$row['tutor_id']] . ', which I personally know is incorrect to code it in this manner. May I know how do I code in a way where I can achieve something like this... www.abc.com/viewprofile?tutor_id=12343 The value which currently I receive is www.abc.com/viewprofile?tutor_id='blank' <?php if (!$error) { if (!empty($tutor_id) && !empty($name) && !empty($nric) && !empty($dob_day) && !empty($dob_mth) && !empty($dob_year) && !empty($gender)) { // Only set the picture column if there is a new picture if (!empty($new_picture)) { $query = "UPDATE tutor_profile SET name = '$name', nric = '$nric', dob_day = '$dob_day', dob_mth = '$dob_mth', dob_year = '$dob_year', gender = '$gender', picture = '$new_picture' WHERE tutor_id = '$tutor_id' "; } else { $query = "UPDATE tutor_profile SET name = '$name', nric = '$nric', dob_day = '$dob_day', dob_mth = '$dob_mth', dob_year = '$dob_year', gender = '$gender' WHERE tutor_id = '$tutor_id' "; } mysqli_query($dbc, $query) or die(mysqli_error($dbc)); // Confirm success with the user echo '<p>Your profile has been successfully updated. Would you like to <a href="viewprofile.php?tutor_id=' . $_GET['tutor_id'] . '">view your profile</a>?</p>'; mysqli_close($dbc); exit(); ?> Quote Link to comment Share on other sites More sharing options...
fortnox007 Posted February 5, 2011 Share Posted February 5, 2011 Hi guys, Currently I am editing profiles online and get it updated in my database. And when user has successfully updated his/her profile, they will be directed to a link echo '<p>Your profile has been successfully updated. Would you like to <a href="viewprofile.php?tutor_id=' . $_GET[$row['tutor_id']] . '">view your profile</a>?</p>'; As you can see, I have set tutor_id=' . $_GET[$row['tutor_id']] . ', which I personally know is incorrect to code it in this manner. May I know how do I code in a way where I can achieve something like this... www.abc.com/viewprofile?tutor_id=12343 The value which currently I receive is www.abc.com/viewprofile?tutor_id='blank' <?php if (!$error) { if (!empty($tutor_id) && !empty($name) && !empty($nric) && !empty($dob_day) && !empty($dob_mth) && !empty($dob_year) && !empty($gender)) { // Only set the picture column if there is a new picture if (!empty($new_picture)) { $query = "UPDATE tutor_profile SET name = '$name', nric = '$nric', dob_day = '$dob_day', dob_mth = '$dob_mth', dob_year = '$dob_year', gender = '$gender', picture = '$new_picture' WHERE tutor_id = '$tutor_id' "; } else { $query = "UPDATE tutor_profile SET name = '$name', nric = '$nric', dob_day = '$dob_day', dob_mth = '$dob_mth', dob_year = '$dob_year', gender = '$gender' WHERE tutor_id = '$tutor_id' "; } mysqli_query($dbc, $query) or die(mysqli_error($dbc)); // Confirm success with the user echo '<p>Your profile has been successfully updated. Would you like to <a href="viewprofile.php?tutor_id=' . $_GET['tutor_id'] . '">view your profile</a>?</p>'; mysqli_close($dbc); exit(); ?> your $tutor_id doesn't get a value same is for $_GET['tutor_id'] if i look at the script above. so the whole script that starts with if (!empty($tutor_id)......etc will not be executed. Also the echo is outside the if statement, so it's not a confirmation of succes it's just an echo. Don't you have some more code besides the above? Quote Link to comment Share on other sites More sharing options...
fxuser Posted February 5, 2011 Share Posted February 5, 2011 echo '<p>Your profile has been successfully updated. Would you like to <a href="viewprofile.php?tutor_id=' . $_GET['tutor_id'] . '">view your profile</a>?</p>'; what if you change $_GET['tutor_id'] to $tutor_id? Quote Link to comment Share on other sites More sharing options...
fortnox007 Posted February 5, 2011 Share Posted February 5, 2011 would make indeed more sense, but still $tutor_id is empty Quote Link to comment Share on other sites More sharing options...
genzedu777 Posted February 5, 2011 Author Share Posted February 5, 2011 Hi fxuser, Thanks, you are right, just add in the $tutor_id will do. It works now! Hi fortnox007, Yeah, sorry i didnt post the entire code, cuz it will be too lengthy, thanks for you help too! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.