1 <?php
 2 include_once(‘../sys/config.php‘);
 3 if (isset($_POST[‘submit‘]) && !empty($_POST[‘username‘]) ) {
 4 
 5     if (strlen($_POST[‘username‘])>16) {
 6         $_SESSION[‘error_info‘] = ‘用户名過長（用戶名長度<=16）‘;
 7         header(‘Location: edit.php‘);
 8         exit;
 9     }
10 
11     $clean_username = clean_input($_POST[‘username‘]);
12     $clean_user_id = clean_input($_POST[‘id‘]);
13     
14     //判断用户名已是否存在
15     $query = "SELECT * FROM users WHERE user_name = ‘$clean_username‘";
16     $data = mysql_query($query, $conn);
17     if (mysql_num_rows($data) == 1) {
18         $_SESSION[‘error_info‘] = ‘用户名已存在‘;
19         header(‘Location: edit.php‘);
20         exit;
21     }
22     
23     $query = "UPDATE users SET user_name = ‘$clean_username‘ WHERE user_id = ‘$clean_user_id‘";
24     mysql_query($query, $conn) or die("update error!");
25     mysql_close($conn);
26     //刷新缓存
27     $_SESSION[‘username‘] = $clean_username;
28     header(‘Location: edit.php‘);
29 }
30 else {
31     not_find($_SERVER[‘PHP_SELF‘]);
32 }
33 ?>