Hide Email

MCP · 2007-06-06T00:29:12+01:00

Ok Here is the problem. Imputting all the changes as shown on the 'Hide Email' tutorial. But the only problem I have is it does not update the DB. Example. Once I put it on I changed the default (via phpMyAdmin) to yes. Then I went to editprofile.php and chose it to say no. Updated the profile and went back to members.php and it does not hide it. Nor does it show no selected on editprofile.php Below are the codes. Members.php <?php include('config.php'); // Query database $count_sql = 'SELECT * FROM members'; $count_result = mysql_query($count_sql); //gets the number $count = mysql_num_rows($count_result); $new = mysql_fetch_array(mysql_query("SELECT * FROM `members` ORDER BY `id` DESC LIMIT 0, 1")); // Gets the newest member echo "<strong>Newest member:</strong> " . $new; // displays the newest member ?> <br> <br> <?php session_start(); //allows session include "config.php"; echo "<left>"; if(isset($_GET)){ //if there trying to view a profile //gets the user name and makes it safe $username = addslashes($_GET); //querys the db to find the username $getuser = mysql_query("SELECT * FROM `members` WHERE `username` = '$username'"); //checks see if the username exists in the db $usernum = mysql_num_rows($getuser); //if it don't exist if ($usernum == 0) { //don't exist echo ("User Not Found"); } //if it does exist then show there profile else { $user = mysql_fetch_array($getuser); echo " <b>$user's Profile</b><br><br> <b>Email:</b> $user<br> <b>Location:</b> $user<br> <b>Sex:</b> $user<br> <b>Age:</b> $user<br> <b>About:</b> $user<br> <b>Interests:</b> $user<br> <b>MSN:</b> $user<br> <b>Skype:</b> $user<br> <b>AIM:</b> $user<br> <b>deviantART:</b> $user<br> <b>Yahoo:</b> $user<br> "; $user_rank = change_levels($user); //change level } } else { //gets all the members from the database $getusers = mysql_query("SELECT * FROM `members` ORDER BY `id` ASC") or die(mysql_error()); //loops there name out while ($user = mysql_fetch_array($getusers)) { echo "<a href='members.php?user=$user'>$user</a><br>"; } } echo "<left>"; ?> Editprofile.php <?php session_start(); //allows session include "config.php"; echo "<left>"; //checks see if there logged in if($logged) { if(isset($_GET)){ $email = addslashes(htmlspecialchars($_POST)); $ehidden = htmlspecialchars($_POST); $location = addslashes(htmlspecialchars($_POST)); $age = (int)addslashes(htmlspecialchars($_POST)); $sex = addslashes(htmlspecialchars($_POST)); $about = addslashes(htmlspecialchars($_POST)); $interests = addslashes(htmlspecialchars($_POST)); $msn = addslashes(htmlspecialchars($_POST)); $skype = addslashes(htmlspecialchars($_POST)); $aim = addslashes(htmlspecialchars($_POST)); $deviantart = addslashes(htmlspecialchars($_POST)); $yahoo = addslashes(htmlspecialchars($_POST)); //checks the sex if its ok if(($sex == "Male") || ($sex == "Female")){ //updates there profile in the db $update = mysql_query("UPDATE `members` SET `email` = '$email', `sex` = '$sex', `age` = '$age', location = '$location', ehidden = '$ehidden', `about` = '$about', `interests` = '$interests', `msn` = '$msn', `skype` = '$skype', `aim` = '$aim', `yahoo` = '$yahoo', `deviantart` = '$deviantart' WHERE `username` = '$logged'"); echo "Profile updated!<br> <a href=\"login.php\">Return to Member Area</a> or <a href=\"editprofile.php\">Continue Editing</a>"; } //if the sex is invalid else { echo "Invalid sex input!"; } } else { $getuser = mysql_query("SELECT * FROM `members` WHERE `username` = '$logged'"); $user = mysql_fetch_array($getuser); echo "<form action='editprofile.php?update' method='post'> <table width='350'> <tr> <td width='150'>Email:</td> <td width='200'><input type='text' name='email' size='30' maxlength='55' value='$user'></td> </tr> <tr> <td>Show Email?</td> <td><select name='ehidden'> <option selected='selected' value='yes'>Yes</option> <option value='no'>No</option> </select></td> </tr> <tr> <td>Location:</td> <td><input type='text' name='location' size='30' maxlength='40' value='$user'></td> </tr> <tr> <td>Age:</td> <td><input type='text' name='age' size='3' maxlength='3' value='$user'></td> </tr> <tr> <td>Sex:</td> <td><select size='1' name='sex' value='$user'> <option value='Male' "; if($user == Male) { echo "selected"; } echo "> Male </option> <option value='Female' "; if($user == Female) { echo "selected"; } echo "> Female </option> </select></td> </tr> <tr> <td>About:</td> <td><textarea name='about' cols='23.5' rows='7' maxlength='700' >$user</textarea></td> </tr> <tr> <td>Interests:</td> <td><input type='text' name='interests' size='30' maxlength='40' value='$user' /></td> </tr> <tr> <td>MSN:</td> <td><input type='text' name='msn' size='30' maxlength='40' value='$user' /></td> </tr> <tr> <td>Skype:</td> <td><input type='text' name='skype' size='30' maxlength='40' value='$user' /></td> </tr> <tr> <td>AIM:</td> <td><input type='text' name='aim' size='30' maxlength='40' value='$user' /></td> </tr> <tr> <td>deviantART:</td> <td><input type='text' name='deviantart' size='30' maxlength='40' value='$user' /></td> </tr> <tr> <td>Yahoo:</td> <td><input type='text' name='yahoo' size='30' maxlength='40' value='$user' /></td> </tr> <tr> <td colspan='2'><left> <input type='submit' value='Update'> </left></td> </tr> </table> </form>"; } } else { echo "You are not logged in."; } echo "<left>"; ?> Also are the queries I ran and changed. Original (from tut) ALTER TABLE `members` ADD `ehidden` CHAR( 3 ) NOT NULL DEFAULT 'no'; Changed to ALTER TABLE `members` ADD `ehidden` CHAR( 3 ) NOT NULL DEFAULT 'yes'; Any help is appreciated.

Posted on Tuesday 5th June 2007 at 10:36 PM

MCP

Wonderful. It works now.

Posted on Wednesday 6th June 2007 at 05:29 AM

SkillMaster
SkillMaster's Avatar

Its good.