게시물 불러오는 개수 변경하는거 알려주세요ㅜㅜ 채택완료
juyoony
11년 전
조회 4,196
현재 게시판에 게시물을 2개씩 불러오게 되어있는데요.(아래코드)
3개로 변경하려면 어떻게 해야하나요? 좀 도와주세요ㅠㅠ
</p><p><span style="font-size: 10pt; line-height: 1.5;"></span><span class="Apple-tab-span" style="white-space: pre;"> </span><?php</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>// 아래 함수는 게시판 이름과 동일한 테이블에서 컬럼 wr_content를 가져와</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>// 정규표현식으로 앵커와 img 태크만 존재하게 한다.</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>function img_layer($data) {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> if($data['bbs_name'] == 'community') {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>include_once('community.php');</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> <span class="Apple-tab-span" style="white-space:pre"> </span>return false;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> }</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if($data['bbs_name'] == 'clear_harry') {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>echo '<div style="clear:both;"></div><div style="width:100%;height:10px;"></div>';</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>return false;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>echo "<div class='".$data['class_name']."' id='".$data['bbs_name']."'>";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sql = " select wr_content from g5_write_".$data['bbs_name']." order by wr_id desc limit 0,3 ";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$result = sql_query($sql);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>while ($row = sql_fetch_array($result)) {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$row['wr_content'] = preg_replace('/( |<p>|<\/p>|<br.+>|<div.+div>)/', "", $row['wr_content']);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$row['wr_content'] = preg_replace('/(.*)(<a.+a>)(.*)/', "$2", $row['wr_content']);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span></p><p><span class="Apple-tab-span" style="white-space:pre"> </span>echo $row['wr_content'];</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>echo "</div>";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>// 데이터 순서는 중요!!!!! DIV id값 즉 게시판 이름과 DIV에 적용될 class</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>// bbs_name => clear_harry는 위 아래 레이어간 간격</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>// bbs_name => community 다른 게시물 불러옴</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>// 오타 방지 및 가독성을 위해 줄바꿈을 하는게 좋다.</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$img_layer_list = array(</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>array('bbs_name' => 'main_cover',<span class="Apple-tab-span" style="white-space:pre"> </span>'class_name' => 'harry7 margin_r'),</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> <span class="Apple-tab-span" style="white-space:pre"> </span> );</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>foreach($img_layer_list as $data) {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>img_layer($data);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><script></p><p><span class="Apple-tab-span" style="white-space:pre"> </span>function get_img_el(id) {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>var tmp_div = document.getElementById(id);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>var tmp_img = tmp_div.getElementsByTagName('img');</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>return tmp_img;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>function layer_init(tmp_img) {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>for(var i=0;i<tmp_img.length;i++) {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$(tmp_img[i]).css('display', 'none');</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>function harry_layer(tmp_img){</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>for(var i=0;i<tmp_img.length;i++) {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if($(tmp_img[i]).css('display') == 'none') {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$(tmp_img[i]).css('display', 'inline');</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>var tmp_index = i;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>for(var i=0;i<tmp_img.length;i++) {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if(tmp_index == i) {continue;}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$(tmp_img[i]).css('display', 'none');</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>return false;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>};</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>// 클로저 함수</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>function return_setInterval(data) {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>return setInterval(function(){harry_layer(get_img_el(data['bbs_name']));}, data['time']);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>// 데이터 순서는 상관없음 DIV id값 즉 게시판 이름과 이미지가 변경될 시간을 설정 1초 = 1000</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>var layer_list = [</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> {'bbs_name':'main_cover', 'time':1500},</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> ];</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>for (var index in layer_list) {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>layer_init(get_img_el(layer_list[index]['bbs_name']));</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>harry_layer(get_img_el(layer_list[index]['bbs_name']));</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>return_setInterval(layer_list[index]);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space: pre;"> </span></script><span style="font-size: 10pt; line-height: 1.5;"></span></p><p><span style="font-size: 10pt; line-height: 1.5;"> </span></p><p><span style="font-size: 10pt; line-height: 1.5;">
댓글을 작성하려면 로그인이 필요합니다.
답변 1개
답변을 작성하려면 로그인이 필요합니다.
로그인