본문 바로가기

BASIC

DB 데이터 갯수 카운트소스

<?
    $query5  = "select * from room where code='$sisul' ";
    $cnt       = "select count(*) from room where code='$sisul'";
    $result5  = mysql_query($query5);
    $total      = mysql_fetch_array(mysql_query($cnt));
    $no        =$total[0];

?>

 

          <table width="100%">

 

<?
    while($data5 = mysql_fetch_array($result5)) {
?>

          <tr bgcolor="#ffffff" align="center">
          <td><?=$no?></td>
          <td> &nbsp;<?=$data5[sisul]?></td>
          <td><?=$data5[rm_pyung]?></td>
          <td align="left"> &nbsp;<?=$data5[rm_type]?></td>
          <td align="left"> &nbsp;<?=$data5[rm_func]?></td> 
          <td><?=$data5[opt_num]?></td>
          <td><?=$data5[max_num]?></td>
          <td><?=$data5[food]?></td>
          <td><input type="checkbox" name="check"</td>
          </tr>

<?
  $no--;
}
   if (!$no) {
?>
    
           <tr bgcolor="#ffffff">
           <td align="center" colspan="10" style="padding:7"><font color="red">등록사항이 없습니다.</td>
           </tr>

<?
}
?>
           </table>

 

====================================================================================================

 

         <table width="100%" border="0" cellspacing="1" cellpadding="0" bgcolor="#cccccc">

<?
    $where = 1;

    if($rsv_log)   $where .= " and gubun='$data5[code_name]' ";
    if($area1)     $where .= " and area1='$data6[code_name]' ";
    if($area2)     $where .= " and area2='$data7[code_name]' ";

 

    $query4  = "select * from lodge where $where order by sisul asc ";
    $result4 = mysql_query($query4);
    while ($data4 = mysql_fetch_array($result4)) {
       global $cnt;
       $cnt += count($data4[no]);

?>

          <tr bgcolor="#ffffff" align="center">
          <td> <?=$cnt?> </td>
          <td> <?=$data4[no]?> </td>
          <td> <?=$data4[gubun]?> </td>
          <td> <?=$data4[area1]?> </td>
          <td> <?=$data4[area2]?> </td>
          <td align="left"> <?=$data4[sisul]?> </td>
          </tr>

<?}?>
<?
    if(!$cnt) {
?>

          <tr bgcolor="#ffffff" align="center">
          <td colspan="10">정보가 없습니다.</td>
          </tr>
<?
}
 else{
?>
          <tr bgcolor="#ffffff" align="center">
          <td colspan="10"> <?=$cnt?> 개의 정보가 있습니다.</td>
          </tr>
<? }?>


          </table>

==============================================================================================












'BASIC' 카테고리의 다른 글

체크박스 전체선택, 해제(삭제) 구문소스  (0) 2013.05.14
zip 코드 검색으로 주소창에 값 넣기  (0) 2013.05.14
checkbox 전체선택 해제, 일부선택 구문  (0) 2013.05.14
file Upload  (0) 2013.05.14
error_reporting(E_ALL)  (0) 2013.05.14