mysql 질문입니다.

Jiah

프로필 보기 이 회원 글보기 이 회원의 댓글보기

2017-12-01 (금) 21:16:43 2,194

mysql.. 안만지면 헷갈려요 ㅠㅠ

photo_list_table 의 검색된 결과값이 없다면

36번째 줄에 있는 insert_sql_photo_info 문을 실행시키고 싶은데 어찌 해야 할까요;;;

답변 좀 부탁드립니다.

Copy

<?php

include_once('./_common.php');
include_once(G5_LIB_PATH.'/common.lib.php');
include_once(G5_LIB_PATH.'/build_thumbnail.lib.php');

$BUILD_ID    = $_POST['BUILD_ID'];
$BUILD_SEQ   = $_POST['BUILD_SEQ'];
$COMP_CD     = $_POST['COMP_CD'];


$PHOTO_BOARD_TABLE = " SELECT * FROM {$TB['BUILD_SALE_MST_DTL_PHOTO']} WHERE COMP_CD = '$COMP_CD' AND BUILD_ID = '$BUILD_ID' AND BUILD_SEQ = '$BUILD_SEQ' ";
$PHOTO_BOARD_ROW = sql_query($PHOTO_BOARD_TABLE);
$PHOTO_BOARD=sql_fetch_array($PHOTO_BOARD_ROW);

 if($PHOTO_BOARD['BUILD_SEQ']) {
  
//  $PHOTO_ID = $PHOTO_BOARD['BUILD_SEQ'];
  $PHOTO_LIST_TABLE = " SELECT * FROM {$TB['BUILD_SALE_MST_DTL_PHOTO_FILE']} WHERE COMP_CD = '$COMP_CD' AND BUILD_ID = '$BUILD_ID' AND BUILD_SEQ = '$BUILD_SEQ' and PHOTO_TYPE between '1' and '3' ";
  $PHOTO_LIST_ROW = sql_query($PHOTO_LIST_TABLE);

  //////////////////////////////////////////////////////////////////////////////////////////////////////////////  
  $ret = array();
    
   for($i=1; $row=sql_fetch_array($PHOTO_LIST_ROW); $i++)
    {
     $details = array();
     $details['COMP_CD']=$row['COMP_CD'];
     $details['BUILD_ID']=$row['BUILD_ID'];
     $details['BUILD_SEQ']=$row['BUILD_SEQ'];     
     $details['PHOTO_NO']=$row['PHOTO_NO'];
     $details['IN_OR_OUT']=$row['IN_OR_OUT'];
     $details['PHOTO_NAME']=$row['PHOTO_NAME'];
     $details['PHOTO_FILE']=$row['PHOTO_FILE'];
     $details['PHOTO_FILESIZE']=$row['PHOTO_FILESIZE'];
     $details['width']=$PHOTO_BOARD['PHOTO_IMAGE_WIDTH'];
     $details['height']=$PHOTO_BOARD['PHOTO_IMAGE_HEIGHT'];
    
     $ret[] = $details;
    }

//    $insert_sql_photo_info = " UPDATE  {$TB['BUILD_SALE_MST_DTL_PHOTO']} SET IS_PICTURE = 'N' WHERE COMP_CD = '2000' and BUILD_ID  = '1000' and BUILD_SEQ  = '12' ";
//    $insert_photo_info = sql_query($insert_sql_photo_info);  


  echo json_encode($ret);
  //////////////////////////////////////////////////////////////////////////////////////////////////////////////
 }
?>

mysql DB

답변 2개

채택된 답변

+20 포인트

플래토

프로필 보기 이 회원 글보기 이 회원의 댓글보기

2017-12-01 (금) 22:45:59

Copy

<?php
include_once('./_common.php');
include_once(G5_LIB_PATH.'/common.lib.php');
include_once(G5_LIB_PATH.'/build_thumbnail.lib.php');
$BUILD_ID    = $_POST['BUILD_ID'];
$BUILD_SEQ   = $_POST['BUILD_SEQ'];
$COMP_CD     = $_POST['COMP_CD'];

$PHOTO_BOARD_TABLE = " SELECT * FROM {$TB['BUILD_SALE_MST_DTL_PHOTO']} WHERE COMP_CD = '$COMP_CD' AND BUILD_ID = '$BUILD_ID' AND BUILD_SEQ = '$BUILD_SEQ' ";
$PHOTO_BOARD_ROW = sql_query($PHOTO_BOARD_TABLE);
$PHOTO_BOARD=sql_fetch_array($PHOTO_BOARD_ROW);
if($PHOTO_BOARD['BUILD_SEQ']) {

    //여기에 추가를 합니다.
    $PHOTO_LIST_TABLE_CNT = " SELECT count(*) cnt FROM {$TB['BUILD_SALE_MST_DTL_PHOTO_FILE']} WHERE COMP_CD = '$COMP_CD' AND BUILD_ID = '$BUILD_ID' AND BUILD_SEQ = '$BUILD_SEQ' and PHOTO_TYPE between '1' and '3' ";
    $photocnt = sql_fetch($PHOTO_LIST_TABLE_CNT);
    if ($photocnt[cnt] > 0) {  //Row가 존재할때 뭔가 수행
        //  $PHOTO_ID = $PHOTO_BOARD['BUILD_SEQ'];
        $PHOTO_LIST_TABLE = " SELECT * FROM {$TB['BUILD_SALE_MST_DTL_PHOTO_FILE']} WHERE COMP_CD = '$COMP_CD' AND BUILD_ID = '$BUILD_ID' AND BUILD_SEQ = '$BUILD_SEQ' and PHOTO_TYPE between '1' and '3' ";
        $PHOTO_LIST_ROW = sql_query($PHOTO_LIST_TABLE);
        //////////////////////////////////////////////////////////////////////////////////////////////////////////////  
        $ret = array();

        for($i=1; $row=sql_fetch_array($PHOTO_LIST_ROW); $i++)
        {
            $details = array();
            $details['COMP_CD']=$row['COMP_CD'];
            $details['BUILD_ID']=$row['BUILD_ID'];
            $details['BUILD_SEQ']=$row['BUILD_SEQ'];     
            $details['PHOTO_NO']=$row['PHOTO_NO'];
            $details['IN_OR_OUT']=$row['IN_OR_OUT'];
            $details['PHOTO_NAME']=$row['PHOTO_NAME'];
            $details['PHOTO_FILE']=$row['PHOTO_FILE'];
            $details['PHOTO_FILESIZE']=$row['PHOTO_FILESIZE'];
            $details['width']=$PHOTO_BOARD['PHOTO_IMAGE_WIDTH'];
            $details['height']=$PHOTO_BOARD['PHOTO_IMAGE_HEIGHT'];

            $ret[] = $details;
        }
    }    else {    //없으면 하고싶던 업데이트문 수행

        $insert_sql_photo_info = " UPDATE  {$TB['BUILD_SALE_MST_DTL_PHOTO']} SET IS_PICTURE = 'N' WHERE COMP_CD = '2000' and BUILD_ID  = '1000' and BUILD_SEQ  = '12' ";
        $insert_photo_info = sql_query($insert_sql_photo_info);  
    }

    echo json_encode($ret);
//////////////////////////////////////////////////////////////////////////////////////////////////////////////
}
?>

와 같이 변경해보세요

균이

프로필 보기 이 회원 글보기 이 회원의 댓글보기

2017-12-01 (금) 21:28:56

if(!$ret[0]){

$insert_~~~

}

그리고 10, 11행은 그누보드에서는 아래처럼 하면 됩니다

$PHOTO_BOARD=sql_fetch($PHOTO_BOARD_TABLE);

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

mysql 질문입니다.

답변 2개

공유하기