<span style="color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">안녕하세요, 이번에 처음으로 APM을 독학하는 학생입니다.</span> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">검색을 하면서 mysql과 php를 연동한 로그인창 만들기를 하고 있는데요,</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">코드는 아래와 같은데 왜 올바른 아이디와 비밀번호를 입력해도 틀렸다고 하는 지 이해가 안 가서 질문을 하게 되었습니다.</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">(아래의 코드를 출력하면 ID/PW가 맞는데도 <span style="margin:0px;padding:0px;line-height:1.5;">"ID/PW가 틀렸습니다. -1"이 출력됩니다.)</span></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">어느 부분을 고쳐야 하는 지 알려주신다면 감사하겠습니다..</div> <div>(데이터베이스 이름은 animal_hospital이고 회원정보가 들어있는 테이블은 guest입니다.)</div> <div><br></div> <div><div style="text-align:left;"><img src="http://thimg.todayhumor.co.kr/upfile/201606/14650930328dcdd2c74275435b90820071e51bd955__mn522404__w646__h15__f3794__Ym201606.jpg" width="646" height="15" alt="캡처.JPG" style="border:none;" filesize="3794"></div></div> <div><br></div> <div><div><?php</div> <div><br></div> <div>session_start();</div> <div><br></div> <div>$db_host = "호스트명";</div> <div>$db_user = "아이디";</div> <div>$db_passwd = "비밀번호";</div> <div>$db_name = "animal_hospital";</div> <div>$conn = mysqli_connect($db_host, $db_user, $db_passwd, $db_name);</div> <div>$db_select = mysqli_select_db($conn, $db_name);</div> <div>$id = $_POST['id'];</div> <div>$pw = $_POST['pw'];</div> <div><br></div> <div>//$name = $_POST['name'];</div> <div><br></div> <div>if (!$conn)</div> <div>{</div> <div> die("Database connection failed: " . mysqli_error());</div> <div>}</div> <div><br></div> <div><br></div> <div>if (!$db_select) {</div> <div> die("Database selection failed: " . mysqli_error());</div> <div>}</div> <div><br></div> <div>if(!$id or !$pw)</div> <div>{</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>echo "<script>alert(\"ID/PW를 입력해 주세요.\");</script>";</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>echo "<script>history.back();</script>";</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>exit;</div> <div>}</div> <div><br></div> <div>$q = "SELECT * FROM guest WHERE ID='$id'";</div> <div>$result = mysqli_query($conn, $q);</div> <div><br></div> <div>if($result->num_rows==1)</div> <div>{</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>$row = $result -> fetch_array();</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>if($row['pw']==$pw)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>{</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>$_SESSION['id']=$row['id'];</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>echo "<meta http-equiv='refresh' content='0'; url='./ok_login.php'>";</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>}</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>else</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>{</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>echo "<script>alert(\"ID/PW가 틀렸습니다. -1\");</script>";</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>echo "<meta http-equiv='refresh' content='0'; url='./index.html'>";</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>exit;</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>}</div> <div>}</div> <div>else {</div> <div> echo "<script>alert(\"ID/PW가 틀렸습니다. -2\");</script>";</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>echo "<meta http-equiv='refresh' content='0'; url='./index.html'>";</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>exit;</div> <div>}</div> <div><br></div> <div>$mysqli->close();</div> <div>?></div></div>
<a href="http://activexxx.mooo.com/ouavatar/ouavatar_menu.php" target="_blank"><img src="http://activexxx.mooo.com/ouavatar/ouavatar.php?start=true&language=ko_kr&text_direction=ltr&mn=522404&about1=%ED%96%A5%EC%9D%84+%EC%8B%BC+%EC%A2%85%EC%9D%B4%EC%97%90%EC%84%9C%EB%8A%94+%ED%96%A5+%EB%83%84%EC%83%88%EA%B0%80+%EB%82%9C%EB%8B%A4&about2=%E2%97%95+%E2%97%A1+%E2%97%95&nick_icon=ribbon&star_color=0056ab&background_color=00023b&text_color=ffffff&about_color=94d2ff&body_num=1&body_color=00b594&oumark_color=ffffff&oumark_gloss_opacity=0&squid_num=2&squid_left_direction=down&squid_right_direction=down&skin_color=fcdba1&hair_num=6&hair_color=000000&blush_num=1&blush_color=ff6363&brow_num=1&brow_color=000000&eyes_num=7&eyes_color=FFFFFF&pupil_color=000000&glasses_num=0&glasses_border_color=000000&glasses_lens_color=ADD8E6&glasses_opacity=50&nose_num=2&nose_color=450000&mouth_num=8&mouth_color=7B220B&tongue_color=FF6B70&teeth_color=FFFFFF&bottom_color=ffffff&bottom_num=1&rotate=0&crop=0&hyperlink=http%3A%2F%2Factivexxx.mooo.com%2Fouavatar%2Fouavatar_menu.php&title=%EC%98%A4%EB%8A%98%EC%9D%98%EC%9C%A0%EB%A8%B8+%EC%95%84%EB%B0%94%ED%83%80+%EA%BC%AC%EB%A6%BF%EB%A7%90+%EC%84%9C%EB%B9%84%EC%8A%A4+by+ActiveXXX&end=true&isold&.png" alt="오늘의유머 아바타 꼬릿말 서비스 by ActiveXXX" title="오늘의유머 아바타 꼬릿말 서비스 by ActiveXXX"></a>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.