Reply to thread

Message

<blockquote data-quote="Zodiak" data-source="post: 278194" data-attributes="member: 9300">Edit username? you mean edit your own username or a staff editing someone elses username?If your referring to a user changing there name via account settings:Top of the page add:[PHP]&lt;?php$username = mysql_real_escape_string($_POST['username']);if($_POST['update']) {$checkuser = mysql_query(&quot;SELECT * FROM `users` WHERE `username` = '&quot;.$username.&quot;'&quot;);if(mysql_num_rows($checkuser) == 1){$error = &quot;Username taken&quot;;}else{mysql_query(&quot;UPDATE `users` SET `username` = &quot;.$username.&quot;'' WHERE `username` = '&quot;.$_SESSION['user']['username'].&quot;'&quot;);}}?&gt;[/PHP]And the form:[HTML]&lt;form method=&quot;post&quot;&gt;&lt;input type=&quot;text&quot; name=&quot;username&quot; placeholder=&quot;username&quot; value=&quot;&lt;?php echo $_SESSION['user']['username']; ?&gt;&quot;&gt;&lt;input type=&quot;submit&quot; name=&quot;update&quot; value=&quot;Update Account&quot;&gt;&lt;/form[/HTML]Not the most effecient way to code it but it should work, unless I've made a mistake which I may have considering I'm half asleep and rushed on it.Note: This won't work if your php is updated, as mysql was deprecated.</blockquote>

[QUOTE="Zodiak, post: 278194, member: 9300"] Edit username? you mean edit your own username or a staff editing someone elses username? If your referring to a user changing there name via account settings: Top of the page add: [PHP]<?php $username = mysql_real_escape_string($_POST['username']); if($_POST['update']) { $checkuser = mysql_query("SELECT * FROM `users` WHERE `username` = '".$username."'"); if(mysql_num_rows($checkuser) == 1) { $error = "Username taken"; } else { mysql_query("UPDATE `users` SET `username` = ".$username."'' WHERE `username` = '".$_SESSION['user']['username']."'"); } } ?>[/PHP] And the form: [HTML]<form method="post"> <input type="text" name="username" placeholder="username" value="<?php echo $_SESSION['user']['username']; ?>"> <input type="submit" name="update" value="Update Account"> </form[/HTML] Not the most effecient way to code it but it should work, unless I've made a mistake which I may have considering I'm half asleep and rushed on it. Note: This won't work if your php is updated, as mysql was deprecated. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members