if문 조건함수 다중으로 써도 상관없는건가요? 채택완료
엑셀게시판에서 엑셀파일 등록할 때 소스에서 if문을 사용하려고 하는데요
예를들어,
if($wr_2 == "업체명A" && $wr_3 == "BBB" && $wr_4 == "CCC" && $wr_5 == "DDD" && 대략 5개 더 있음) {
//생략
}
if($wr_2 == "업체명A" && $wr_3 == "BBB" && $wr_4 == "EEE" && $wr_5 == "FFF" && 대략 5개 더 있음) {
//생략
}
if($wr_2 == "업체명B" && $wr_3 == "BBB" && $wr_4 == "CCC" && $wr_5 == "DDD" && 대략 5개 더 있음) {
//생략
}
이런식으로 하다보니 DB저장할 때 제대로 되는 것도 있고 엉뚱한 값이 저장되기도 하고
그러더라구요~~ 혹시 제가 잘못 사용하고 있는 건지 해서요
그리고 엑셀 게시판 검색이 안되서요~원본 스킨 그대로 쓰고 소스도 건들것 없이 바로 적용해서
테스트해보는데 일자별 말고 필드검색을 할때 한줄이 뜨는데 날짜도 70/01/01이렇게 뜨고 필드값들은
다 보여주지가 않더라구요..원인을 못찾겠어요...소스도 원본 그대로이고 mysql_num_rows를 sql_num_row로 바꿔봐도 결과치는 같거든요..
고수님들의 도움이 너무 절실히 필요합니다.ㅠㅠ
if문 사용되는 소스를 아래에 적구요 첨부파일로는 엑셀게시판 검색시 보여주는 캡쳐화면을 첨부하겠습니다.
-- excel_up2.php --
for ($i = 2; $i <= $data->sheets[0]['numRows']; $i++) { //$i == 몇번째 라인부터 등록할건지 $total_count++;
if($_POST[ex_type] == "2"){ $wr_id = addslashes($data->sheets[0]['cells'][$i][1]); //wr_id $wr_subject = addslashes($data->sheets[0]['cells'][$i][4]); //필드1 $wr_1 = addslashes($data->sheets[0]['cells'][$i][2] - 25569) * 86400; $date = date("Y-m-d", $wr_1); $wr_2 = addslashes($data->sheets[0]['cells'][$i][3]); //필드2 $wr_3 = addslashes($data->sheets[0]['cells'][$i][5]); //필드3 $wr_4 = addslashes($data->sheets[0]['cells'][$i][6]); //필드4 $wr_5 = addslashes($data->sheets[0]['cells'][$i][7]); //필드5 $wr_6 = addslashes($data->sheets[0]['cells'][$i][8]); //필드6 $wr_7 = addslashes($data->sheets[0]['cells'][$i][9]); //필드7 $wr_8 = addslashes($data->sheets[0]['cells'][$i][10]); //필드8 $wr_9 = addslashes($data->sheets[0]['cells'][$i][11]); //필드9 $wr_10 = addslashes($data->sheets[0]['cells'][$i][12]); //필드10 $wr_11 = addslashes($data->sheets[0]['cells'][$i][13]); //필드10 $wr_12 = addslashes($data->sheets[0]['cells'][$i][14]); //필드10 $wr_13 = addslashes($data->sheets[0]['cells'][$i][15]); //필드10 $wr_14 = addslashes($data->sheets[0]['cells'][$i][16]); //필드10 $wr_15 = addslashes($data->sheets[0]['cells'][$i][17]); //필드10 $wr_16 = addslashes($data->sheets[0]['cells'][$i][18]); //필드10 $wr_17 = addslashes($data->sheets[0]['cells'][$i][19]); //필드10
$sql = " update {$write_table} set wr_subject = '$wr_subject', wr_1 = '$date', wr_2 = '$wr_2', wr_3 = '$wr_3', wr_4 = '$wr_4', wr_5 = '$wr_5', wr_6 = '$wr_6', wr_7 = '$wr_7', wr_8 = '$wr_8', wr_9 = '$wr_9', wr_10 = '$wr_10', wr_11 = '$wr_11', wr_12 = '$wr_12', wr_13 = '$wr_13', wr_14 = '$wr_14', wr_15 = '$wr_15', wr_16 = '$wr_16', wr_17 = '$wr_17', wr_18 = '$wr_18', wr_19 = '$wr_19', wr_20 = '$wr_20', wr_21 = '$wr_21', wr_22 = '$wr_22', wr_23 = '$wr_23', wr_24 = '$wr_24', wr_25 = '$wr_25', wr_26 = '$wr_26', wr_27 = '$wr_27', wr_28 = '$wr_28', wr_29 = '$wr_29', wr_30 = '$wr_30' where wr_id = '$wr_id' "; sql_query($sql); }else{
$uni1 = "UNl-단면"; $uni2 = "UNl-양면"; $Flying = "Flying Probe"; $fly1 = "PNL"; $fly4 = "PNL4"; $fly5 = "PNL2"; $fly6 = "PNL1";
$fa1 = "1종"; $fa2 = "2종 조합"; $fa3 = "3종 조합"; $fa4 = "4종 조합이상";
$lay1 = "1 층"; $lay2 = "2 층"; $lay4 = "4 층"; $lay8 = "8 층"; $lay10 = "10 층"; $lay12 = "12 층이상"; $mil100 = "100 Mil"; $mil70 = "70 Mil"; $mil50 = "50 Mil";
$mb_id = $member['mb_id']; $wr_name = $member['mb_nick']; $wr_password = $member['mb_password']; $wr_email = $member['mb_email']; $wr_homepage = $member['mb_homepage']; $wr_num = get_next_num($write_table); $wr_reply = ''; $wr_id = addslashes($data->sheets[0]['cells'][$i][1]); //no $wr_subject = addslashes($data->sheets[0]['cells'][$i][4]); //모델명 $wr_1 = addslashes($data->sheets[0]['cells'][$i][2] - 25569) * 86400; $date = date("Y-m-d", $wr_1);
$wr_2 = addslashes($data->sheets[0]['cells'][$i][3]);
$wr_3 = addslashes($data->sheets[0]['cells'][$i][5]);
$wr_4 = addslashes($data->sheets[0]['cells'][$i][6]); $wr_5 = addslashes($data->sheets[0]['cells'][$i][7]); $wr_6 = addslashes($data->sheets[0]['cells'][$i][8]); $wr_7 = addslashes($data->sheets[0]['cells'][$i][9]); $wr_8 = addslashes($data->sheets[0]['cells'][$i][10]);
$wr_9 = addslashes($data->sheets[0]['cells'][$i][11]); $wr_10 = addslashes($data->sheets[0]['cells'][$i][12]); $wr_11 = addslashes($data->sheets[0]['cells'][$i][13]);
$wr_12 = addslashes($data->sheets[0]['cells'][$i][14]); $wr_13 = addslashes($data->sheets[0]['cells'][$i][15]);
$wr_14 = addslashes($data->sheets[0]['cells'][$i][16]); $wr_15 = addslashes($data->sheets[0]['cells'][$i][17]); $wr_16 = addslashes($data->sheets[0]['cells'][$i][18]); $wr_17 = addslashes($data->sheets[0]['cells'][$i][19]);
if($wr_2 == "업체명A") {
if(($wr_4 == $fa1) && ($wr_5 == $lay2) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "신 규")) { $wr_18 = number_format("20000"); $wr_20 = "0.25"; }
elseif(($wr_4 == $fa1) && ($wr_5 == $lay2) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "기 존")) { $wr_18 = number_format("10000"); $wr_20 = "0.25"; }
elseif(($wr_4 == $fa1) && ($wr_5 == $lay2) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "재 검")) { $coun2 = "15"; if($wr_17 >= $coun2) { $wr_18 = number_format("5000"); } else { $wr_18 = ""; } $wr_20 = "0.25"; }
elseif(($wr_4 == $fa1) && ($wr_5 == $lay4) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "신 규")) { $wr_18 = number_format("25000"); $wr_20 = "0.3"; }
elseif(($wr_4 == $fa1) && ($wr_5 == $lay4) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "기 존")) { $wr_18 = number_format("10000"); $wr_20 = "0.3"; }
elseif(($wr_4 == $fa1) && ($wr_5 == $lay4) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "재 검")) { $coun2 = "15"; if($wr_17 >= $coun2) { $wr_18 = number_format("5000"); } else { $wr_18 = ""; } $wr_20 = "0.25"; }
elseif(($wr_4 == $fa1) && ($wr_5 == $lay6) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "신 규")) { $wr_18 = number_format("25000"); $wr_20 = "0.3"; }
elseif(($wr_4 == $fa1) && ($wr_5 == $lay6) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "기 존")) { $wr_18 = number_format("10000"); $wr_20 = "0.3"; }
elseif(($wr_4 == $fa1) && ($wr_5 == $lay6) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "재 검")) { $coun2 = "15"; if($wr_17 >= $coun2) { $wr_18 = number_format("5000"); } else { $wr_18 = ""; } $wr_20 = "0.25"; }
elseif(($wr_4 == $fa1) && ($wr_5 == $lay8) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "신 규")) { $wr_18 = number_format("25000"); $wr_20 = "0.3"; }
elseif(($wr_4 == $fa1) && ($wr_5 == $lay8) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "기 존")) { $wr_18 = number_format("10000"); $wr_20 = "0.3"; }
elseif(($wr_4 == $fa1) && ($wr_5 == $lay8) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "재 검")) { $coun2 = "15"; if($wr_17 >= $coun2) { $wr_18 = number_format("5000"); } else { $wr_18 = ""; } $wr_20 = "0.25"; }
elseif(($wr_4 == $fa1) && ($wr_5 == $lay10) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "신 규")) { $wr_18 = number_format("30000"); $wr_20 = "0.35"; }
elseif(($wr_4 == $fa1) && ($wr_5 == $lay10) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "기 존")) { $wr_18 = number_format("10000"); $wr_20 = "0.35"; }
elseif(($wr_4 == $fa1) && ($wr_5 == $lay10) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "재 검")) { $coun2 = "15"; if($wr_17 >= $coun2) { $wr_18 = number_format("5000"); } else { $wr_18 = ""; } $wr_20 = "0.25"; }
elseif(($wr_4 == $fa1) && ($wr_5 == $lay12) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "신 규")) { $wr_18 = number_format("30000"); $wr_20 = "0.35"; }
elseif(($wr_4 == $fa1) && ($wr_5 == $lay12) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "기 존")) { $wr_18 = number_format("10000"); $wr_20 = "0.35"; }
elseif(($wr_4 == $fa1) && ($wr_5 == $lay12) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "재 검")) { $coun2 = "15"; if($wr_17 >= $coun2) { $wr_18 = number_format("5000"); } else { $wr_18 = ""; } $wr_20 = "0.25"; }
if(($wr_4 == $fa2) && ($wr_5 == $lay2) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "신 규")) { $wr_18 = number_format("20000"); $wr_20 = "0.25"; }
elseif(($wr_4 == $fa2) && ($wr_5 == $lay2) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "기 존")) { $wr_18 = number_format("10000"); $wr_20 = "0.25"; }
elseif(($wr_4 == $fa2) && ($wr_5 == $lay2) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "재 검")) { $coun2 = "15"; if($wr_17 >= $coun2) { $wr_18 = number_format("5000"); } else { $wr_18 = ""; } $wr_20 = "0.25"; }
elseif(($wr_4 == $fa2) && ($wr_5 == $lay4) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "신 규")) { $wr_18 = number_format("25000"); $wr_20 = "0.3"; }
elseif(($wr_4 == $fa2) && ($wr_5 == $lay4) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "기 존")) { $wr_18 = number_format("10000"); $wr_20 = "0.3"; }
elseif(($wr_4 == $fa2) && ($wr_5 == $lay4) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "재 검")) { $coun2 = "15"; if($wr_17 >= $coun2) { $wr_18 = number_format("5000"); } else { $wr_18 = ""; } $wr_20 = "0.25"; }
elseif(($wr_4 == $fa2) && ($wr_5 == $lay6) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "신 규")) { $wr_18 = number_format("25000"); $wr_20 = "0.3"; }
elseif(($wr_4 == $fa2) && ($wr_5 == $lay6) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "기 존")) { $wr_18 = number_format("10000"); $wr_20 = "0.3"; }
elseif(($wr_4 == $fa2) && ($wr_5 == $lay6) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "재 검")) { $coun2 = "15"; if($wr_17 >= $coun2) { $wr_18 = number_format("5000"); } else { $wr_18 = ""; } $wr_20 = "0.25"; }
elseif(($wr_4 == $fa2) && ($wr_5 == $lay8) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "신 규")) { $wr_18 = number_format("25000"); $wr_20 = "0.3"; }
elseif(($wr_4 == $fa2) && ($wr_5 == $lay8) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "기 존")) { $wr_18 = number_format("10000"); $wr_20 = "0.3"; }
elseif(($wr_4 == $fa2) && ($wr_5 == $lay8) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "재 검")) { $coun2 = "15"; if($wr_17 >= $coun2) { $wr_18 = number_format("5000"); } else { $wr_18 = ""; } $wr_20 = "0.25"; }
elseif(($wr_4 == $fa2) && ($wr_5 == $lay10) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "신 규")) { $wr_18 = number_format("30000"); $wr_20 = "0.35"; }
elseif(($wr_4 == $fa2) && ($wr_5 == $lay10) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "기 존")) { $wr_18 = number_format("10000"); $wr_20 = "0.35"; }
elseif(($wr_4 == $fa2) && ($wr_5 == $lay10) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "재 검")) { $coun2 = "15"; if($wr_17 >= $coun2) { $wr_18 = number_format("5000"); } else { $wr_18 = ""; } $wr_20 = "0.25"; }
elseif(($wr_4 == $fa2) && ($wr_5 == $lay12) && ($wr_6 == $Flying) && ($wr_7 == $fly1) && ($wr_8 == "신 규")) { $wr_18 = number_format("30000"); $wr_20 = "0.35"; }
}
이하 동일로 업체명2,업체명3 등이 더 있습니다.ㅠㅠ
답변 2개
70/01/01 이렇게 나오는건 값이 들어가지 않아서 그런거고
if문은 몇번을 쓰건 상관이 없습니다.
저 코드를 테스트 하기위해서는 if문 마다 다 테스트를 해봐야 하기 때문에 일일이 테스트 해보셔야 할것같습니다.
댓글을 작성하려면 로그인이 필요합니다.
우선 if문에서요 &&를 하나의 if문에 여러개 써보고
두개만 써보기도 하고 했는데 제대로 안먹히는지
엉뚱한 업체명에 값을 뿌리고 같은업체도 뿌리기도하고
엑셀에도 연관이 있을까요? 엑셀에 쓰이는 함수나 이런거요
그리고 검색은 값이안들어가져서 그렇다는데 제가 이해를
잘 못했어요
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인