Post

[PHP] 회원정보수정

[PHP] 회원정보수정

/login/member_form_modify.php

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
<?
  session_start();
  @extract($_POST);
  @extract($_GET);
  @extract($_SESSION);
?>
<!DOCTYPE html>
<html lang="ko">
<head>
  <meta charset="UTF-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <title>Document</title>
  <link href="../css/common.css" rel="stylesheet" type="text/css" media="all">
  <link href="../css/member.css" rel="stylesheet" type="text/css" media="all">
  <script>
    function check_id() {
      window.open("check_id.php?id=" + document.member_form.id.value, "IDcheck", "left=200,top=200,width=250,height=100,scrollbars=no,resizable=yes");
    }
    
    function check_nick() {
      window.open("../member/check_nick.php?nick=" + document.member_form.nick.value, "NICKcheck", "left=200,top=200,width=250,height=100,scrollbars=no,resizable=yes");
    }
    
    function check_input() {
      if (!document.member_form.pass.value) {
        alert("비밀번호를 입력하세요");    
        document.member_form.pass.focus();
        return;
      }

      if (!document.member_form.pass_confirm.value) {
        alert("비밀번호확인을 입력하세요");    
        document.member_form.pass_confirm.focus();
        return;
      }

      if (!document.member_form.name.value) {
        alert("이름을 입력하세요");    
        document.member_form.name.focus();
        return;
      }

      if (!document.member_form.nick.value) {
        alert("닉네임을 입력하세요");    
        document.member_form.nick.focus();
        return;
      }

      if (!document.member_form.hp2.value || !document.member_form.hp3.value ) {
        alert("휴대폰 번호를 입력하세요");    
        document.member_form.nick.focus();
        return;
      }

      if (document.member_form.pass.value != document.member_form.pass_confirm.value) {
        alert("비밀번호가 일치하지 않습니다.\n다시 입력해주세요.");    
        document.member_form.pass.focus();
        document.member_form.pass.select();
        return;
      }

      document.member_form.submit();
    }
    
    function reset_form() {
      document.member_form.id.value = "";
      document.member_form.pass.value = "";
      document.member_form.pass_confirm.value = "";
      document.member_form.name.value = "";
      document.member_form.nick.value = "";
      document.member_form.hp1.value = "010";
      document.member_form.hp2.value = "";
      document.member_form.hp3.value = "";
      document.member_form.email1.value = "";
      document.member_form.email2.value = "";

      document.member_form.id.focus();

      return;
    }
  </script>
</head>
<?
  //$userid='aaa';

  include "../lib/dbconn.php";

  $sql = "select * from member where id='$userid'";
  $result = mysql_query($sql, $connect);

  $row = mysql_fetch_array($result);
  //$row[id]....$row[level]

  $hp = explode("-", $row[hp]);  //000-0000-0000
  $hp1 = $hp[0];
  $hp2 = $hp[1];
  $hp3 = $hp[2];

  $email = explode("@", $row[email]);
  $email1 = $email[0];
  $email2 = $email[1];

  mysql_close();
?>
<body>
  <div id="wrap">
    <div id="header"><? include "../lib/top_login2.php"; ?></div>  <!-- end of header -->

    <div id="menu"><? include "../lib/top_menu2.php"; ?></div>  <!-- end of menu --> 

    <div id="content">
      <div id="col1">
        <div id="left_menu"><? include "../lib/left_menu.php"; ?></div>
      </div>

      <div id="col2">
        <form  name="member_form" method="post" action="modify.php"> 
          <div id="title"><img src="../img/title_member_modify.gif"></div>

          <div id="form_join">
            <div id="join1">
              <ul>
                <li>* 아이디</li>
                <li>* 비밀번호</li>
                <li>* 비밀번호 확인</li>
                <li>* 이름</li>
                <li>* 닉네임</li>
                <li>* 휴대폰</li>
                <li>&nbsp;&nbsp;&nbsp;이메일</li>
              </ul>
            </div>
            
            <div id="join2">
              <ul>
                <li><?= $row[id] ?></li>
                <li><input type="password" name="pass" value=""></li>
                <li><input type="password" name="pass_confirm" value=""></li>
                <li><input type="text" name="name" value="<?= $row[name] ?>"></li>
                <li>
                  <div id="nick1"><input type="text" name="nick" value="<?= $row[nick] ?>"></div>
                  <div id="nick2" ><a href="#"><img src="../img/check_id.gif" onclick="check_nick()"></a></div>
                </li>
                <li>
                  <input type="text" class="hp" name="hp1" value="<?= $hp1 ?>"> -
                  <input type="text" class="hp" name="hp2" value="<?= $hp2 ?>"> -
                  <input type="text" class="hp" name="hp3" value="<?= $hp3 ?>">
                </li>
                <li>
                  <input type="text" id="email1" name="email1" value="<?= $email1 ?>"> @
                  <input type="text" name="email2" value="<?= $email2 ?>">
                </li>
              </ul>
            </div>

            <div class="clear"></div>
            <div id="must"> * 는 필수 입력항목입니다.^^</div>
          </div>

          <div id="button">
            <a href="#"><img src="../img/button_save.gif"  onclick="check_input()"></a>
            &nbsp;&nbsp;
            <a href="#"><img src="../img/button_reset.gif" onclick="reset_form()"></a>
          </div>
        </form>
      </div>
    </div>
  </div>
</body>
</html>

/login/modify.php

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
<?
  session_start();
  @extract($_POST);
  @extract($_GET);
  @extract($_SESSION);
?>
<meta charset="utf-8">
<?
  $hp = $hp1."-".$hp2."-".$hp3;
  $email = $email1."@".$email2;

  $regist_day = date("Y-m-d (H:i)");  // 현재의 '년-월-일-시-분'을 저장

  include "../lib/dbconn.php";       // dconn.php 파일을 불러옴

  $sql = "update member set pass=password('$pass'), name='$name' , ";
  $sql .= "nick='$nick', hp='$hp', email='$email', regist_day='$regist_day' where id='$userid'";

  mysql_query($sql, $connect);  // $sql 에 저장된 명령 실행

  //수정된 세션변수 이름과 닉네임을 바꾸어준
  $_SESSION['username'] = $name;
  //$_SESSION['username'] = $row[name];
  $_SESSION['usernick'] = $nick;
  //$_SESSION['usernick'] = $row[nick];


  mysql_close();                // DB 연결 끊기
  echo "
    <script>
      window.alert('회원정보가 수정되었습니다.');
      location.href = '../index.php';
    </script>
  ";
?>

modify.zip download

This post is licensed under CC BY 4.0 by the author.