테스트 사이트 - 개발 중인 베타 버전입니다

희한하네요.. sql_query 시 이미지 경로를 바꿔버리네요 채택완료

김쩔짱 9년 전 조회 2,366

</span></p><p><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">$sql = " INSERT INTO</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">g5_write_gallery</span></p><p><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">SET</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_num = '-176',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_reply = '',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_comment = 0,</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">ca_name = '',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_option = '',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_subject = '신민아 몸매 실루엣  ',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_content = '         

</span><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">		</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;"> <style type="text/css"></span><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">		</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">div.autosourcing-stub { position:absolute; z-index:-9999; }</span><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">		</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">div.autosourcing-stub-extra { position:absolute; opacity:0 }</span><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">		</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;"></style></span><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">		</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;"> </span><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">		</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;"> </span><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;"> </span><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;"> <div id="autosourcing_1"><div class="view-img"></div><div class="view-content" itemprop="de&#115;&#99;ription"><a href="<a href="<a href="http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg"" target="_blank" rel="noopener noreferrer">http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg"</a>"><span style="font-size: 9pt;"><a href="http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg"" target="_blank" rel="noopener noreferrer">http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg"</a></span></a> target="_blank" data-lightbox="view-lightbox"><img  name='target_resize_image[]' onclick='image_window(this)' style='cursor:pointer;' title="" class="img-tag" alt="" src="<a href="<a href="http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg"" target="_blank" rel="noopener noreferrer">http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg"</a>"><span style="font-size: 9pt;"><a href="http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg"" target="_blank" rel="noopener noreferrer">http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg"</a></span></a> itemprop="image" c&#111;&#110;tent="<a href="<a href="http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg"" target="_blank" rel="noopener noreferrer">http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg"</a>"><span style="font-size: 9pt;"><a href="http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg"" target="_blank" rel="noopener noreferrer">http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg"</a></span></a> / ></a>

<a href="<a href="<a href="http://www.buldog.co.kr/data/file/gallery/237243179__4b24eebc9090fcae31beea41f9b96b5020e4bf8a.jpeg"" target="_blank" rel="noopener noreferrer">http://www.buldog.co.kr/data/file/gallery/237243179__4b24eebc9090fcae31beea41f9b96b5020e4bf8a.jpeg"</a>"><span style="font-size: 9pt;"><a href="http://www.buldog.co.kr/data/file/gallery/237243179__4b24eebc9090fcae31beea41f9b96b5020e4bf8a.jpeg"" target="_blank" rel="noopener noreferrer">http://www.buldog.co.kr/data/file/gallery/237243179__4b24eebc9090fcae31beea41f9b96b5020e4bf8a.jpeg"</a></span></a> target="_blank" data-lightbox="view-lightbox"><img  name='target_resize_image[]' onclick='image_window(this)' style='cursor:pointer;' title="" class="img-tag" alt="" src="<a href="<a href="http://www.buldog.co.kr/data/file/gallery/237243179__4b24eebc9090fcae31beea41f9b96b5020e4bf8a.jpeg"" target="_blank" rel="noopener noreferrer">http://www.buldog.co.kr/data/file/gallery/237243179__4b24eebc9090fcae31beea41f9b96b5020e4bf8a.jpeg"</a>"><span style="font-size: 9pt;"><a href="http://www.buldog.co.kr/data/file/gallery/237243179__4b24eebc9090fcae31beea41f9b96b5020e4bf8a.jpeg"" target="_blank" rel="noopener noreferrer">http://www.buldog.co.kr/data/file/gallery/237243179__4b24eebc9090fcae31beea41f9b96b5020e4bf8a.jpeg"</a></span></a> / ></a>

위가 원본

아래가 밝기 조절한 거
</div></div><div class="view-good-box"><span class="view-nogood"><a href="<a href="<a href="http://haezuk.com/bbs/board.php?bo_table=culture&wr_id=106813&page=1#"" target="_blank" rel="noopener noreferrer">http://haezuk.com/bbs/board.php?bo_table=culture&wr_id=106813&page=1#"</a>"><span style="font-size: 9pt;"><a href="http://haezuk.com/bbs/board.php?bo_table=culture&wr_id=106813&page=1#"" target="_blank" rel="noopener noreferrer">http://haezuk.com/bbs/board.php?bo_table=culture&wr_id=106813&page=1#"</a></span></a> target="_blank">
</a></span>',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_link1 = '',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_link2 = '',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_link1_hit = 0,</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_link2_hit = 0,</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_hit = 581,</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_good = 37,</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_nogood = 0,</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">mb_id = 'snbz734j',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_password = '*2F27BF41351B81B326B820CA4B4B6D2B49326852',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_name = '백합',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_email = '',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_homepage = '',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_datetime = '2016-07-04 02:00:35',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_last = '2016-07-04 02:00:35',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_ip = '14.36.11.43',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_1 = '766081',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_2 = '',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_3 = '',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_4 = '',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_5 = '',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_6 = '',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_7 = '',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_8 = '',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_9 = '',</span></p><p><span class="Apple-tab-span" style="white-space: pre; font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">	</span><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">wr_10 = ''</span></p><p><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">";</span></p><p><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">sql_query($sql);</span></p><div><span style="font-size: 9pt; font-family: 돋움체, dotumche, applegothic;">
서버는 우분투 16.04, php7 이용하고 있습니다.
위의 코드를 실행하면, 이미지 src 부분이 자기 마음대로 바뀌어버리네요
phpmyadmin 에서 저 쿼리 실행시키면 정확하게 들어가는데,
영카트의 sql_query($sql); 로 실행하면 이미지 src 부분이
이런 식으로 바껴버리네요... 이거 왜이러는건가요 ㅠㅠ
댓글을 작성하려면 로그인이 필요합니다.

답변 2개

채택된 답변
+20 포인트

위에 보여지는 코드에서 일단 $sql 문이 어떻게 되는지 확인하고 db에 들어가 있는걸 확인하고

보통은 $sql문과 db에 입력된 문장이 같잖아요 이게 달라진다면 db에서 http에대한 변경이 있는것이겠죠 

로그인 후 평가할 수 있습니다

댓글을 작성하려면 로그인이 필요합니다.

write_update.php 페이지에서 echo($sql);

해보세요 안바뀌어있는지  

로그인 후 평가할 수 있습니다

답변에 대한 댓글 3개

김쩔짱
9년 전
DB로 직접 쏘는거라서 페이지를 들리지를 않습니다..
그냥 쿼리로 곧바로 DB로 직행하는 부분인데 희한하게도 자꾸 입력되는 값이 DB들어갈떄는 바껴서
들어가네요 ㅠㅠ
불량학생
9년 전
그렇다면 다른부분을 빼고 주소 한줄만 넣어보세요 같은 현상인지요
김쩔짱
9년 전
불량학생님 // 대댓글이 왜 안달아지는건지 모르겠네요 ㅠㅠ

일단은 별짓을 다 해봤는데 결론은 안돼네요 ㅠㅠ

댓글을 작성하려면 로그인이 필요합니다.

답변을 작성하려면 로그인이 필요합니다.

로그인