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

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

김쩔짱 9년 전 조회 2,365

</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 = '        &amp;nbsp;&lt;br /&gt;&lt;br /&gt;</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;"> &lt;style type=&quot;text/css&quot;&gt;</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;">&lt;/style&gt;</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;"> &lt;div id=&quot;autosourcing_1&quot;&gt;&lt;div class=&quot;view-img&quot;&gt;&lt;/div&gt;&lt;div class=&quot;view-content&quot; itemprop=&quot;de&amp;#115;&amp;#99;ription&quot;&gt;&lt;a href=&quot;<a href="<a href="http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg&quot;" target="_blank" rel="noopener noreferrer">http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg&quot;</a>"><span style="font-size: 9pt;"><a href="http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg&quot;" target="_blank" rel="noopener noreferrer">http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg&quot;</a></span></a> target=&quot;_blank&quot; data-lightbox=&quot;view-lightbox&quot;&gt;&lt;img  name=&#039;target_resize_image[]&#039; onclick=&#039;image_window(this)&#039; style=&#039;cursor:pointer;&#039; title=&quot;&quot; class=&quot;img-tag&quot; alt=&quot;&quot; src=&quot;<a href="<a href="http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg&quot;" target="_blank" rel="noopener noreferrer">http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg&quot;</a>"><span style="font-size: 9pt;"><a href="http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg&quot;" target="_blank" rel="noopener noreferrer">http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg&quot;</a></span></a> itemprop=&quot;image&quot; c&amp;#111;&amp;#110;tent=&quot;<a href="<a href="http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg&quot;" target="_blank" rel="noopener noreferrer">http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg&quot;</a>"><span style="font-size: 9pt;"><a href="http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg&quot;" target="_blank" rel="noopener noreferrer">http://www.buldog.co.kr/data/file/gallery/237243179__878e8fc5e155d103b171b9a25f55ec9152f9e8d0.jpeg&quot;</a></span></a> / &gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;a href=&quot;<a href="<a href="http://www.buldog.co.kr/data/file/gallery/237243179__4b24eebc9090fcae31beea41f9b96b5020e4bf8a.jpeg&quot;" target="_blank" rel="noopener noreferrer">http://www.buldog.co.kr/data/file/gallery/237243179__4b24eebc9090fcae31beea41f9b96b5020e4bf8a.jpeg&quot;</a>"><span style="font-size: 9pt;"><a href="http://www.buldog.co.kr/data/file/gallery/237243179__4b24eebc9090fcae31beea41f9b96b5020e4bf8a.jpeg&quot;" target="_blank" rel="noopener noreferrer">http://www.buldog.co.kr/data/file/gallery/237243179__4b24eebc9090fcae31beea41f9b96b5020e4bf8a.jpeg&quot;</a></span></a> target=&quot;_blank&quot; data-lightbox=&quot;view-lightbox&quot;&gt;&lt;img  name=&#039;target_resize_image[]&#039; onclick=&#039;image_window(this)&#039; style=&#039;cursor:pointer;&#039; title=&quot;&quot; class=&quot;img-tag&quot; alt=&quot;&quot; src=&quot;<a href="<a href="http://www.buldog.co.kr/data/file/gallery/237243179__4b24eebc9090fcae31beea41f9b96b5020e4bf8a.jpeg&quot;" target="_blank" rel="noopener noreferrer">http://www.buldog.co.kr/data/file/gallery/237243179__4b24eebc9090fcae31beea41f9b96b5020e4bf8a.jpeg&quot;</a>"><span style="font-size: 9pt;"><a href="http://www.buldog.co.kr/data/file/gallery/237243179__4b24eebc9090fcae31beea41f9b96b5020e4bf8a.jpeg&quot;" target="_blank" rel="noopener noreferrer">http://www.buldog.co.kr/data/file/gallery/237243179__4b24eebc9090fcae31beea41f9b96b5020e4bf8a.jpeg&quot;</a></span></a> / &gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;위가 원본&lt;br /&gt;&lt;br /&gt;아래가 밝기 조절한 거&lt;br /&gt;&lt;/div&gt;&lt;/div&gt;&lt;div class=&quot;view-good-box&quot;&gt;&lt;span class=&quot;view-nogood&quot;&gt;&lt;a href=&quot;<a href="<a href="http://haezuk.com/bbs/board.php?bo_table=culture&amp;wr_id=106813&amp;page=1#&quot;" target="_blank" rel="noopener noreferrer">http://haezuk.com/bbs/board.php?bo_table=culture&amp;wr_id=106813&amp;page=1#&quot;</a>"><span style="font-size: 9pt;"><a href="http://haezuk.com/bbs/board.php?bo_table=culture&amp;wr_id=106813&amp;page=1#&quot;" target="_blank" rel="noopener noreferrer">http://haezuk.com/bbs/board.php?bo_table=culture&amp;wr_id=106813&amp;page=1#&quot;</a></span></a> target=&quot;_blank&quot;&gt;&lt;br /&gt;&lt;/a&gt;&lt;/span&gt;',</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년 전
불량학생님 // 대댓글이 왜 안달아지는건지 모르겠네요 ㅠㅠ

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

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

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

로그인