다시한번 질문드릴게요~! 채택완료
아무리 해봐도 적용이 안되어 다시한번 문의드려요 ㅠㅠ
인터넷 방송을 들으며 하고있지만 일주일동안 아무리이것저것해봐도 되지 않아 도움요청드려요
- 서버 image/profile안에 이미지는 정상적으로 저장되는데요
myadmin내에 g5_member -> profile(varchar 255) 데이터베이스로 저장이 되지않네요..
서버에는 이미지가 잘 저장이 되지만
데이터 베이스 저장에 저장이 되지않고 메인에 이미지 노출이되지않아요 ㅠㅠ
***아래에 outlogin.skin2.php 및 common.lib.php 에 기재한 함수있어요!
outlogin.skin2.php
</span></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"><div class="profile"></span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"><?php</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;">if(isset($_FILES['profile']) === true){</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> if(empty($_FILES['profile']['name']) === true) {</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> echo 'please choose a file!';</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> } else {</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> $allowed = array('jpg','jpeg','gif','png');</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> </span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> $file_name = $_FILES['profile']['name']; </span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> $file_extn = strtolower(end(explode('.', $file_name)));</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> $file_temp = $_FILES['profile']['tmp_name'];</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> </span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> if(in_array($file_extn, $allowed) === true){</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> change_profile_image($session_mb_id, $file_temp, $file_extn);</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> }else{</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> echo 'A';</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> echo implode(', ', $allowed);</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> }</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> </span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> }</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;">}</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> </span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> </span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;">if (empty($member['image']) === false) {</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> echo '<img src="', $member['image'], '" alt="', $member['mb_name'], '\'s Profile Image">';</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;">}</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;">?></span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"><form action="" method="post" enctype="multipart/form-data"></span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"><input type="file" name="profile"><input type="submit"></span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"></form></span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="background-color: rgb(255, 255, 255); font-size: 12px;"></span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"></div></span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px; background-color: rgb(255, 255, 255);">
common.lib.php
</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;">function change_profile_image($mb_id, $file_temp, $file_extn){</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> </span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> $file_path = 'images/profile/'. substr(md5(time()), 0, 10). '.' . $file_extn;</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> move_uploaded_file($file_temp, $file_path);</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> $sql = " update {$g5['member_table']} set image = '$file_path' where mb_id = '$mb_id' ";</span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;"> sql_query($sql);</span></font></p><p><span style="white-space: pre; font-size: 12px;"><font face="Dotum, AppleGothic, Helvetica, sans-serif"> </font></span></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="background-color: rgb(255, 255, 255); font-size: 12px;"></span></font></p><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px;">}</span></font></p><div>
</div><p><font face="Dotum, AppleGothic, Helvetica, sans-serif"><span style="font-size: 12px; background-color: rgb(255, 255, 255);">
답변 2개
image 필드 타입이 varchar 255 인데 $file_path 값이 255값을 넘어서 그럴수도 있습니다.
image 필드 타입을 변경해보세요
sql_query(" ALTER TABLE `{$g5['member_table']}` CHANGE `image` `image` TEXT ", true);
.
.
.
.
sql_query(" ALTER TABLE `{$g5['member_table']}` CHANGE `image` `image` TEXT ", true);
$sql = " update {$g5['member_table']} set image = '$file_path' where mb_id = '$mb_id' ";
답변에 대한 댓글 1개
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인
말씀해주신 답변대로 적용을 하니
ALTER TABLE `` CHANGE `image` `image` TEXT
1103 : Incorrect table name ''
error file : /index.php
이렇게 에러창이 나오는데요...!
혹시 무엇때문에 이런 에러가 나오는지 알수있을까요?