글 저장시 <br> 도 같이 저장되게 하려면 어떻게 해야하나요.. 채택완료

cheditor5 사용하게 되면...

가

나

다

이렇게 입력하고 저장했을 시에... 데이터 베이스 들어가면

가

나

다

라고 저장되어있더라고요.

근데 view.php 에서 보면은

가

나

다

만 출력되고요..

cheditor5 사용 안하고 그냥 사용하면서도</p><p>저렇게 표현되게 할수 있나요?</p><p><textarea ... > 은... </p><p>가</p><p>나</p><p>다</p><p>라고 저장하면.. 데이터 베이스에 그냥</p><p>가</p><p>나</p><p>다</p><p>만 저장되드라고요ㅠㅠㅠ  </p> </div> <!-- Meta Information --> <div class="mb-6"> <div class="flex items-center gap-2 text-sm"> <i class="fa fa-tag text-gray-500"></i> <a href="https://new-sir.gnuboard.net/questions?s_tag=%EA%B7%B8%EB%88%84%EB%B3%B4%EB%93%9C4" class="inline-block px-2 py-1 bg-qa-btn-primary-bg-light dark:bg-qa-btn-primary-bg-dark text-qa-btn-primary-text-light dark:text-qa-btn-primary-text-dark rounded hover:bg-qa-btn-primary-hover-light dark:bg-qa-btn-primary-hover-dark transition-colors"> #그누보드4 </a> </div> </div> <!-- Attached Files --> <!-- Question Actions --> <div class="flex items-center justify-between pt-4 border-t border-gray-200 dark:border-gray-700"> <div class="flex items-center gap-2"> <!-- Vote Buttons --> <div class="flex items-center gap-2"> <button id="vote-good-btn" class="px-3 py-2 rounded-lg transition-colors disabled:opacity-50 disabled:cursor-not-allowed bg-qa-btn-secondary-bg-light dark:bg-qa-btn-secondary-bg-dark text-qa-btn-secondary-text-light dark:text-qa-btn-secondary-text-dark hover:bg-qa-badge-adopted-bg-light dark:hover:bg-qa-badge-adopted-bg-dark hover:text-qa-badge-adopted-text-light dark:hover:text-qa-badge-adopted-text-dark" data-wr-id="43946" data-count="0" > <i class="fa fa-heart mr-1"></i> <span class="vote-good-text">좋아요</span> <span class="vote-good-count">0</span> </button> <button id="vote-nogood-btn" class="px-3 py-2 rounded-lg transition-colors disabled:opacity-50 disabled:cursor-not-allowed bg-qa-btn-secondary-bg-light dark:bg-qa-btn-secondary-bg-dark text-qa-btn-secondary-text-light dark:text-qa-btn-secondary-text-dark hover:bg-qa-btn-danger-bg-light dark:hover:bg-qa-btn-danger-bg-dark hover:text-qa-btn-danger-text-light dark:hover:text-qa-btn-danger-text-dark" data-wr-id="43946" data-count="0" > <i class="fa fa-thumbs-down mr-1"></i> <span class="vote-nogood-text">싫어요</span> <span class="vote-nogood-count">0</span> </button> </div> <!-- Scrap Button --> <button id="scrap-btn" class="px-3 py-2 rounded-lg transition-colors bg-qa-btn-secondary-bg-light dark:bg-qa-btn-secondary-bg-dark text-qa-btn-secondary-text-light dark:text-qa-btn-secondary-text-dark hover:bg-qa-badge-pending-bg-light dark:hover:bg-qa-badge-pending-bg-dark hover:text-qa-badge-pending-text-light dark:hover:text-qa-badge-pending-text-dark" data-wr-id="43946" data-count="0"> <i class="fa fa-bookmark-o mr-1"></i> <span class="scrap-text">스크랩</span> <span class="scrap-count">(0)</span> </button> </div> <!-- Share and Report Buttons --> <div class="flex items-center gap-2"> <button id="share-btn" class="px-3 py-2 bg-qa-btn-primary-bg-light dark:bg-qa-btn-primary-bg-dark text-qa-btn-primary-text-light dark:text-qa-btn-primary-text-dark rounded-lg hover:bg-qa-btn-primary-hover-light dark:bg-qa-btn-primary-hover-dark transition-colors"> <i class="fa fa-share-alt mr-1"></i> <span>공유</span> </button> </div> </div> <!-- Comments for Question --> <!-- 질문 댓글 작성 폼 --> <div class="mt-4 border-t border-gray-200 dark:border-gray-700 pt-4"> <div class="text-sm text-gray-500 dark:text-gray-400"> 댓글을 작성하려면 <a href="/login" class="text-blue-600 hover:text-blue-800">로그인</a>이 필요합니다. </div> </div> </div> </div> <!-- Answers --> <div class="mt-12 space-y-6" id="qa_answer"> <div class="flex items-center justify-between mb-6 pb-3 border-b-2 border-gray-200 dark:border-gray-700"> <h3 class="text-2xl font-bold flex items-center text-gray-900 dark:text-white"> <svg class="w-7 h-7 mr-3 text-blue-500" fill="none" stroke="currentColor" viewBox="0 0 24 24"> <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M8 12h.01M12 12h.01M16 12h.01M21 12c0 4.418-4.03 8-9 8a9.863 9.863 0 01-4.255-.949L3 20l1.395-3.72C3.512 15.042 3 13.574 3 12c0-4.418 4.03-8 9-8s9 3.582 9 8z"></path> </svg> <span>답변</span> <span class="ml-3 px-3 py-1 bg-qa-btn-primary-bg-light dark:bg-qa-btn-primary-bg-dark text-qa-btn-primary-text-light dark:text-qa-btn-primary-text-dark rounded-full text-sm font-medium">3개</span> </h3> <!-- 답변 정렬 --> <div class="flex items-center gap-3"> <label for="qa_sort_select" class="text-sm font-medium text-gray-700 dark:text-gray-300">정렬:</label> <select name="qa_sort_select" id="qa_sort_select" class="px-3 py-1.5 text-sm border border-gray-300 dark:border-gray-600 rounded-lg bg-white dark:bg-gray-700 text-gray-900 dark:text-white focus:ring-2 focus:ring-indigo-500 focus:border-transparent"> <option value="wr_votes" >좋아요순</option> <option value="lastet" selected>최근순</option> <option value="old" >오래된순</option> </select> </div> </div> <div class="space-y-6"> <div id="answer_43953" class="bg-white dark:bg-gray-800 rounded-xl shadow-sm hover:shadow-lg transition-all duration-300 overflow-hidden ring-2 ring-green-500 ring-offset-2 dark:ring-offset-gray-900"> <!-- 채택된 답변 헤더 --> <div class="bg-gradient-to-r from-green-50 to-emerald-50 dark:from-green-900/20 dark:to-emerald-900/20 px-6 py-3 border-b border-green-200 dark:border-green-800"> <div class="flex items-center justify-between"> <div class="flex items-center space-x-2"> <svg class="w-5 h-5 text-green-600 dark:text-green-400" fill="currentColor" viewBox="0 0 20 20"> <path fill-rule="evenodd" d="M10 18a8 8 0 100-16 8 8 0 000 16zm3.707-9.293a1 1 0 00-1.414-1.414L9 10.586 7.707 9.293a1 1 0 00-1.414 1.414l2 2a1 1 0 001.414 0l4-4z" clip-rule="evenodd"></path> </svg> <span class="font-bold text-green-700 dark:text-green-300">채택된 답변</span> </div> <span class="text-sm text-green-600 dark:text-green-400">+20 포인트</span> </div> </div> <div class="p-6"> <!-- 답변 작성자 정보 --> <div class="flex items-center justify-between mb-5"> <div class="flex items-center space-x-4"> <div class="relative inline-block" style="width: 48px; height: 48px;"> <!-- SVG 아바타 사용 (기본값) --> <svg width="48" height="48" viewBox="0 0 100 100" xmlns="http://www.w3.org/2000/svg" class="rounded-full"> <!-- 배경 원 (그라데이션) --> <defs> <linearGradient id="grad-avatar-69168366d34688.27175130" x1="0%" y1="0%" x2="100%" y2="100%"> <stop offset="0%" style="stop-color:hsl(196, 76%, 57%);stop-opacity:1" /> <stop offset="100%" style="stop-color:hsl(226, 76%, 52%);stop-opacity:1" /> </linearGradient> </defs> <circle cx="50" cy="50" r="50" fill="url(#grad-avatar-69168366d34688.27175130)" /> <!-- 닉네임 첫 글자 --> <text x="50" y="50" font-size="45" fill="white" text-anchor="middle" dy=".35em" font-weight="bold" font-family="sans-serif"> 알 </text> </svg> </div> <div> <div class="flex items-center space-x-2"> <a href="https://new-sir.gnuboard.net/profile/4f44ee49-bd40-40a9-ab08-144d43210d14" class="font-semibold text-gray-900 dark:text-white hover:text-blue-600 dark:hover:text-blue-400 transition-colors"> 알찬돌삐 </a> </div> <div class="text-sm text-gray-500 dark:text-gray-400">11년 전</div> </div> </div> <!-- 답변 액션 버튼들 --> <div class="flex items-center space-x-2"> </div> </div> <!-- 답변 내용 --> <div class="prose prose-lg max-w-none dark:prose-invert text-gray-800 dark:text-gray-200 leading-relaxed mb-6 qa-content"> <p>입력된 데이터를 디비에서 phpmyadmin 이나 다른 디비툴로</p><p>접근해서 엑셀로 넘기시려나봅니다.</p><p> </p><p>그런 용도로 쓰시려면</p><p>A. html 푸시고,</p><p>    write_update.php 에서 nl2br($wr_content) 로 해서 저장하시던가,</p><p> </p><p>소스 건드리지 싫으시면</p><p>B. 쿼리에서 조회하실때</p><p>SELECT REPLACE(wr_content, "\n", " ") FROM 테이블명;</p><p> </p><p>이런 식으로 하세요 ^^</p> </div> <!-- 좋아요/싫어요 및 액션 버튼 --> <div class="flex items-center justify-between pt-4 border-t border-gray-200 dark:border-gray-700"> <div class="flex items-center space-x-4"> <div class="text-sm text-gray-500 dark:text-gray-400"> 로그인 후 평가할 수 있습니다 </div> </div> </div> </div> <!-- 댓글 섹션 (답변 카드 안에 포함) --> <div class="mx-6 mb-6"> <div class="relative"> <!-- 연결선 표시 --> <div class="absolute -top-3 left-8 w-px h-6 bg-gradient-to-b from-gray-300 to-transparent dark:from-gray-600"></div> <div class="px-6 py-4 bg-gray-50 dark:bg-gray-900/50 rounded-lg border border-gray-200 dark:border-gray-700"> <!-- 댓글 목록 --> <!-- 디버깅: 답변 43953의 전체 댓글 구조 --> <!-- 댓글 작성 폼 --> <div class="text-center py-3"> <p class="text-sm text-gray-500 dark:text-gray-400"> 댓글을 작성하려면 <a href="/login" class="text-blue-600 hover:text-blue-800 dark:text-blue-400 dark:hover:text-blue-300">로그인</a>이 필요합니다. </p> </div> </div> </div> </div> </div> <div id="answer_43949" class="bg-white dark:bg-gray-800 rounded-xl shadow-sm hover:shadow-lg transition-all duration-300 overflow-hidden border border-gray-200 dark:border-gray-700"> <div class="p-6"> <!-- 답변 작성자 정보 --> <div class="flex items-center justify-between mb-5"> <div class="flex items-center space-x-4"> <div class="relative inline-block" style="width: 48px; height: 48px;"> <!-- SVG 아바타 사용 (기본값) --> <svg width="48" height="48" viewBox="0 0 100 100" xmlns="http://www.w3.org/2000/svg" class="rounded-full"> <!-- 배경 원 (그라데이션) --> <defs> <linearGradient id="grad-avatar-69168366d38a37.77094699" x1="0%" y1="0%" x2="100%" y2="100%"> <stop offset="0%" style="stop-color:hsl(12, 72%, 45%);stop-opacity:1" /> <stop offset="100%" style="stop-color:hsl(42, 72%, 40%);stop-opacity:1" /> </linearGradient> </defs> <circle cx="50" cy="50" r="50" fill="url(#grad-avatar-69168366d38a37.77094699)" /> <!-- 닉네임 첫 글자 --> <text x="50" y="50" font-size="45" fill="white" text-anchor="middle" dy=".35em" font-weight="bold" font-family="sans-serif"> 쟁 </text> </svg> </div> <div> <div class="flex items-center space-x-2"> <a href="https://new-sir.gnuboard.net/profile/628957d4-08a0-4349-ad54-77b0b3b956e8" class="font-semibold text-gray-900 dark:text-white hover:text-blue-600 dark:hover:text-blue-400 transition-colors"> 쟁반짜장 </a> </div> <div class="text-sm text-gray-500 dark:text-gray-400">11년 전</div> </div> </div> <!-- 답변 액션 버튼들 --> <div class="flex items-center space-x-2"> </div> </div> <!-- 답변 내용 --> <div class="prose prose-lg max-w-none dark:prose-invert text-gray-800 dark:text-gray-200 leading-relaxed mb-6 qa-content"> <p>echo str_replace("\r\n","<br />",$view['wr_content']);</p><p>이런 식으로 하면 개행 문자가 로 표시는 됩니다. </p> </div> <!-- 좋아요/싫어요 및 액션 버튼 --> <div class="flex items-center justify-between pt-4 border-t border-gray-200 dark:border-gray-700"> <div class="flex items-center space-x-4"> <div class="text-sm text-gray-500 dark:text-gray-400"> 로그인 후 평가할 수 있습니다 </div> </div> </div> </div> <!-- 댓글 섹션 (답변 카드 안에 포함) --> <div class="mx-6 mb-6"> <div class="relative"> <!-- 연결선 표시 --> <div class="absolute -top-3 left-8 w-px h-6 bg-gradient-to-b from-gray-300 to-transparent dark:from-gray-600"></div> <div class="px-6 py-4 bg-gray-50 dark:bg-gray-900/50 rounded-lg border border-gray-200 dark:border-gray-700"> <!-- 댓글 목록 --> <!-- 디버깅: 답변 43949의 전체 댓글 구조 --> <!-- 댓글 수: 1, 대댓글 그룹 수: 0 --> <div class="mb-4"> <div class="flex items-center gap-2 mb-4"> <svg class="w-4 h-4 text-gray-600 dark:text-gray-400" fill="none" stroke="currentColor" viewBox="0 0 24 24"> <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M7 8h10M7 12h4m1 8l-4-4H5a2 2 0 01-2-2V6a2 2 0 012-2h14a2 2 0 012 2v8a2 2 0 01-2 2h-5l-4 4z"></path> </svg> <h4 class="text-sm font-semibold text-gray-700 dark:text-gray-300">답변에 대한 댓글 1개</h4> </div> <div class="space-y-3"> <div id="c_43950" class="relative "> <div class="bg-white dark:bg-gray-800 rounded-lg border border-gray-100 dark:border-gray-700 hover:border-gray-300 dark:hover:border-gray-600 transition-all duration-200"> <div class="p-4"> <div class="flex items-start justify-between mb-3"> <div class="flex items-center gap-3"> <div class="w-8 h-8 bg-gradient-to-br from-blue-500 to-purple-600 rounded-full flex items-center justify-center text-white text-sm font-medium"> � </div> <div> <div class="font-medium text-sm text-gray-900 dark:text-white"> 윤쓰양 </div> <div class="text-xs text-gray-500 dark:text-gray-400" title="2014-10-16 (목) 23:23:23"> 11년 전 </div> </div> </div> </div> <div class="text-sm text-gray-700 dark:text-gray-300 comment-content leading-relaxed"> 압 ! 왕계란 님이시군요! 흑흑ㅠ 그냥 표시되는것만으로는 부족하고.. 딱 디비에.. <br>이 글 내용과 같이 저장이 되어야 엑셀로 뽑았을때 서로 다른 칸에 쏙쏙 들어가있는것같아요ㅠㅠㅠ </div> <!-- 댓글 액션 버튼 --> <div class="flex items-center gap-2 mt-3 pt-2 border-t border-gray-100 dark:border-gray-700"> </div> <!-- 댓글 수정 폼 (숨김) --> <div class="comment-edit-form hidden mt-3"> <textarea class="w-full px-3 py-2 border border-gray-300 dark:border-gray-600 rounded-lg focus:ring-2 focus:ring-blue-500 dark:bg-gray-700 dark:text-white text-sm resize-none" rows="3" placeholder="댓글을 수정하세요...">압 ! 왕계란 님이시군요! 흑흑ㅠ 그냥 표시되는것만으로는 부족하고.. 딱 디비에.. <br>이 글 내용과 같이 저장이 되어야 엑셀로 뽑았을때 서로 다른 칸에 쏙쏙 들어가있는것같아요ㅠㅠㅠ