게시판목록에 해당 작성자가 쓴글만 나오게 하는방법 있나요? 정보
게시판목록에 해당 작성자가 쓴글만 나오게 하는방법 있나요?본문
여기서 받아쓴 병원예약 빌더를
아무것도 모르는제가 꾸역꾸역 해서 거의다 했는데
예약완료 후 보여지는 목록을 아무나 다 볼 수 있게 해놨드라구요
심지어 다른 사람이 예약취소 까지..;;
예약확인 목록에 들어가면 내가쓴 글만 보이게 하는 방법은 없나요?
리스트 뿌리는 소스는
<?
$sql_common = " from g4_write_B74 ";
if(!$is_admin)
$sql_search = " where mb_id = '$member[mb_id]'";
else
$sql_search = "";
if (!$sst) {
$sst = "wr_id";
$sod = "desc";
}
$sql_order = " order by $sst $sod ";
$sql = " select count(*) as cnt
$sql_common
$sql_search
$sql_order ";
$row = sql_fetch($sql);
$total_count = $row[cnt];
$rows = $config[cf_page_rows];
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
if (!$page) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
$sql = " select *
$sql_common
$sql_order
limit $from_record, $rows ";
$result = sql_query($sql);
?>
<script type="text/javascript" src="/reserve/skin/script.js"></script>
<!--- 타이틀--->
<form id="list" name="fboardlist" method="post">
<input type="hidden" name="sw" value="" />
<div style="width:680px; height:32px; padding:10px 0 0 10px;" align="left">
<img src="../images/reserve/dot01.gif" align="absmiddle" /><font color="#8058d2">고객님들의 온라인 예약 처리현황입니다. 내용을 클릭하시면 상세한 정보를 보실 수 있습니다.</font></div>
<!---예약확인리스트 항목--->
<div style="margin:12px 0 5px 9px; width:665px;" align="left" class="txt02"> 총 <b><?=$total_count?>개</b> | <?=$page?>/<?=$total_page?> 페이지</div>
<!--- 게시판 리스트--->
<div align="center">
<table width="680" border="0" cellspacing="0" cellpadding="0">
<thead>
<tr>
<td width="3" background="img/barb.jpg"><img src="img/bar1.jpg" width="5"></td><td background="img/barb.jpg" style="background-repeat:repeat-x;" align="center"><input type="checkbox" onclick="if(this.checked) all_checked(true);else all_checked(false);" onfocus="this.blur();" /></td>
<td background="img/barb.jpg" style="background-repeat:repeat-x;" align="center">번호</td>
<td background="img/barb.jpg" style="background-repeat:repeat-x;" align="center">이름</td>
<td background="img/barb.jpg" style="background-repeat:repeat-x;" align="center">휴대폰</td>
<td background="img/barb.jpg" style="background-repeat:repeat-x;" align="center">진료과목</td>
<td background="img/barb.jpg" style="background-repeat:repeat-x;" align="center">예약일자</td>
<td background="img/barb.jpg" style="background-repeat:repeat-x;" align="center">예약시간</td>
<td background="img/barb.jpg" style="background-repeat:repeat-x;" align="center">예약상태</td>
<td width="3"><img src="img/bar3.jpg"></td>
</tr>
</thead>
<?
for ($i=0; $row=sql_fetch_array($result); $i++)
{
$num = $total_count - ($page - 1) * $board[bo_page_rows] - $i;
?>
<tr>
<td width="3" height="25"></td>
<td align="center"><input type="checkbox" name="chk_wr_id[]" value="<?=$row[wr_id]?>" onfocus="this.blur();" /></td>
<td align="center"><a href="reserv_ok_info.html?page=<?=$page?>&wr_id=<?=$row[wr_id]?>" class="board"><?=$num?></a></td>
<td align="center"><a href="reserv_ok_info.html?page=<?=$page?>&wr_id=<?=$row[wr_id]?>" class="board"><?=$row[mb_name]?></a></td>
<td align="center"><a href="reserv_ok_info.html?page=<?=$page?>&wr_id=<?=$row[wr_id]?>" class="board"><?=$row[mb_hp]?></a></td>
<td align="center"><a href="reserv_ok_info.html?page=<?=$page?>&wr_id=<?=$row[wr_id]?>" class="board"><?=$row[reserv_clinic]?></a></td>
<td align="center"><a href="reserv_ok_info.html?page=<?=$page?>&wr_id=<?=$row[wr_id]?>" class="board"><?=$row[reserv_date]?> <?=$row[reserv_time]?></a></td>
<td align="center"><a href="reserv_ok_info.html?page=<?=$page?>&wr_id=<?=$row[wr_id]?>" class="board"><?=substr($row[regdate], 0, -3);?></a></td>
<td align="center"><a href="reserv_ok_info.html?page=<?=$page?>&wr_id=<?=$row[wr_id]?>" class="board"><?=$row[status]?></a></td>
<td width="3" height="25"></td>
</tr>
<tr>
<td colspan="10" width="650" height="1" bgcolor="#e7e7e7"></td>
</tr>
<?
}
?>
<tfoot>
<tr>
<td colspan="9" style="padding:21px 0 11px 0;" align="center" class="txt02">
<!---페이지 표시--->
<table width="680" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="560" align="center" style="padding-left:100px;">
<?
$write_pages = get_paging($config[cf_write_pages], $page, $total_page, "?$qstr&page=");
// 기본으로 넘어오는 페이지를 아래와 같이 변환하여 이미지로도 출력할 수 있습니다.
//echo $write_pages;
$write_pages = str_replace("처음", "<img src='/images/reserve/arrowbtn_first.gif' alt='처음' align='absmiddle' />", $write_pages);
$write_pages = str_replace("이전", "<img src='/images/reserve/arrowbtn_prev.gif' alt='이전 10개' align='absmiddle' />", $write_pages);
$write_pages = str_replace("다음", "<img src='/images/reserve/arrowbtn_next.gif' alt='다음 10개' align='absmiddle' />", $write_pages);
$write_pages = str_replace("맨끝", "<img src='/images/reserve/arrowbtn_end.gif' alt='마지막' align='absmiddle' />", $write_pages);
$write_pages = preg_replace("/<span>([0-9]*)<\/span>/", "<b><span style=\"color:#B3B3B3; font-size:12px;\">$1</span></b>", $write_pages);
$write_pages = preg_replace("/<b>([0-9]*)<\/b>/", "<b><span style=\"color:#4D6185; font-size:12px; text-decoration:underline;\">$1</span></b>", $write_pages);
?>
<?=$write_pages?>
</td>
</tr>
<tr>
<td align="center">
<?php if($is_admin){ ?><a href="#none" onclick="selectFinish();" onfocus="this.blur();"><img src="img/b_finish.gif" alt="예약완료" /></a><?php } ?>
<a href="#none" onclick="select_delete();" onfocus="this.blur();"><img src="img/b_delete.gif" alt="예약취소" /></a>
<a href="/reserve/reserv_ok.html" onfocus="this.blur();"><img src="img/b_write.gif" alt="예약하기" /></a>
</td>
</tr>
</table> </td>
</tr>
</tfoot>
</table>
</div>
</form>
</div>
이겁니다..도움좀 주세요 ㅠㅠㅠ
아무것도 모르는제가 꾸역꾸역 해서 거의다 했는데
예약완료 후 보여지는 목록을 아무나 다 볼 수 있게 해놨드라구요
심지어 다른 사람이 예약취소 까지..;;
예약확인 목록에 들어가면 내가쓴 글만 보이게 하는 방법은 없나요?
리스트 뿌리는 소스는
<?
$sql_common = " from g4_write_B74 ";
if(!$is_admin)
$sql_search = " where mb_id = '$member[mb_id]'";
else
$sql_search = "";
if (!$sst) {
$sst = "wr_id";
$sod = "desc";
}
$sql_order = " order by $sst $sod ";
$sql = " select count(*) as cnt
$sql_common
$sql_search
$sql_order ";
$row = sql_fetch($sql);
$total_count = $row[cnt];
$rows = $config[cf_page_rows];
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
if (!$page) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
$sql = " select *
$sql_common
$sql_order
limit $from_record, $rows ";
$result = sql_query($sql);
?>
<script type="text/javascript" src="/reserve/skin/script.js"></script>
<!--- 타이틀--->
<form id="list" name="fboardlist" method="post">
<input type="hidden" name="sw" value="" />
<div style="width:680px; height:32px; padding:10px 0 0 10px;" align="left">
<img src="../images/reserve/dot01.gif" align="absmiddle" /><font color="#8058d2">고객님들의 온라인 예약 처리현황입니다. 내용을 클릭하시면 상세한 정보를 보실 수 있습니다.</font></div>
<!---예약확인리스트 항목--->
<div style="margin:12px 0 5px 9px; width:665px;" align="left" class="txt02"> 총 <b><?=$total_count?>개</b> | <?=$page?>/<?=$total_page?> 페이지</div>
<!--- 게시판 리스트--->
<div align="center">
<table width="680" border="0" cellspacing="0" cellpadding="0">
<thead>
<tr>
<td width="3" background="img/barb.jpg"><img src="img/bar1.jpg" width="5"></td><td background="img/barb.jpg" style="background-repeat:repeat-x;" align="center"><input type="checkbox" onclick="if(this.checked) all_checked(true);else all_checked(false);" onfocus="this.blur();" /></td>
<td background="img/barb.jpg" style="background-repeat:repeat-x;" align="center">번호</td>
<td background="img/barb.jpg" style="background-repeat:repeat-x;" align="center">이름</td>
<td background="img/barb.jpg" style="background-repeat:repeat-x;" align="center">휴대폰</td>
<td background="img/barb.jpg" style="background-repeat:repeat-x;" align="center">진료과목</td>
<td background="img/barb.jpg" style="background-repeat:repeat-x;" align="center">예약일자</td>
<td background="img/barb.jpg" style="background-repeat:repeat-x;" align="center">예약시간</td>
<td background="img/barb.jpg" style="background-repeat:repeat-x;" align="center">예약상태</td>
<td width="3"><img src="img/bar3.jpg"></td>
</tr>
</thead>
<?
for ($i=0; $row=sql_fetch_array($result); $i++)
{
$num = $total_count - ($page - 1) * $board[bo_page_rows] - $i;
?>
<tr>
<td width="3" height="25"></td>
<td align="center"><input type="checkbox" name="chk_wr_id[]" value="<?=$row[wr_id]?>" onfocus="this.blur();" /></td>
<td align="center"><a href="reserv_ok_info.html?page=<?=$page?>&wr_id=<?=$row[wr_id]?>" class="board"><?=$num?></a></td>
<td align="center"><a href="reserv_ok_info.html?page=<?=$page?>&wr_id=<?=$row[wr_id]?>" class="board"><?=$row[mb_name]?></a></td>
<td align="center"><a href="reserv_ok_info.html?page=<?=$page?>&wr_id=<?=$row[wr_id]?>" class="board"><?=$row[mb_hp]?></a></td>
<td align="center"><a href="reserv_ok_info.html?page=<?=$page?>&wr_id=<?=$row[wr_id]?>" class="board"><?=$row[reserv_clinic]?></a></td>
<td align="center"><a href="reserv_ok_info.html?page=<?=$page?>&wr_id=<?=$row[wr_id]?>" class="board"><?=$row[reserv_date]?> <?=$row[reserv_time]?></a></td>
<td align="center"><a href="reserv_ok_info.html?page=<?=$page?>&wr_id=<?=$row[wr_id]?>" class="board"><?=substr($row[regdate], 0, -3);?></a></td>
<td align="center"><a href="reserv_ok_info.html?page=<?=$page?>&wr_id=<?=$row[wr_id]?>" class="board"><?=$row[status]?></a></td>
<td width="3" height="25"></td>
</tr>
<tr>
<td colspan="10" width="650" height="1" bgcolor="#e7e7e7"></td>
</tr>
<?
}
?>
<tfoot>
<tr>
<td colspan="9" style="padding:21px 0 11px 0;" align="center" class="txt02">
<!---페이지 표시--->
<table width="680" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="560" align="center" style="padding-left:100px;">
<?
$write_pages = get_paging($config[cf_write_pages], $page, $total_page, "?$qstr&page=");
// 기본으로 넘어오는 페이지를 아래와 같이 변환하여 이미지로도 출력할 수 있습니다.
//echo $write_pages;
$write_pages = str_replace("처음", "<img src='/images/reserve/arrowbtn_first.gif' alt='처음' align='absmiddle' />", $write_pages);
$write_pages = str_replace("이전", "<img src='/images/reserve/arrowbtn_prev.gif' alt='이전 10개' align='absmiddle' />", $write_pages);
$write_pages = str_replace("다음", "<img src='/images/reserve/arrowbtn_next.gif' alt='다음 10개' align='absmiddle' />", $write_pages);
$write_pages = str_replace("맨끝", "<img src='/images/reserve/arrowbtn_end.gif' alt='마지막' align='absmiddle' />", $write_pages);
$write_pages = preg_replace("/<span>([0-9]*)<\/span>/", "<b><span style=\"color:#B3B3B3; font-size:12px;\">$1</span></b>", $write_pages);
$write_pages = preg_replace("/<b>([0-9]*)<\/b>/", "<b><span style=\"color:#4D6185; font-size:12px; text-decoration:underline;\">$1</span></b>", $write_pages);
?>
<?=$write_pages?>
</td>
</tr>
<tr>
<td align="center">
<?php if($is_admin){ ?><a href="#none" onclick="selectFinish();" onfocus="this.blur();"><img src="img/b_finish.gif" alt="예약완료" /></a><?php } ?>
<a href="#none" onclick="select_delete();" onfocus="this.blur();"><img src="img/b_delete.gif" alt="예약취소" /></a>
<a href="/reserve/reserv_ok.html" onfocus="this.blur();"><img src="img/b_write.gif" alt="예약하기" /></a>
</td>
</tr>
</table> </td>
</tr>
</tfoot>
</table>
</div>
</form>
</div>
이겁니다..도움좀 주세요 ㅠㅠㅠ
댓글 전체
$sql = " select *
$sql_common
$sql_order
limit $from_record, $rows "; <== 여기에 $sql_search 가 빠졌네요
고치면 ~
$sql = " select *
$sql_common $sql_search
$sql_order
limit $from_record, $rows ";
$sql_common
$sql_order
limit $from_record, $rows "; <== 여기에 $sql_search 가 빠졌네요
고치면 ~
$sql = " select *
$sql_common $sql_search
$sql_order
limit $from_record, $rows ";
정말 감사합니다 잘 해결됐습니다^_^