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
70/01/01 이렇게 나오는건 값이 들어가지 않아서 그런거고
if문은 몇번을 쓰건 상관이 없습니다.
저 코드를 테스트 하기위해서는 if문 마다 다 테스트를 해봐야 하기 때문에 일일이 테스트 해보셔야 할것같습니다.
우선 if문에서요 &&를 하나의 if문에 여러개 써보고
두개만 써보기도 하고 했는데 제대로 안먹히는지
엉뚱한 업체명에 값을 뿌리고 같은업체도 뿌리기도하고
엑셀에도 연관이 있을까요? 엑셀에 쓰이는 함수나 이런거요
그리고 검색은 값이안들어가져서 그렇다는데 제가 이해를
잘 못했어요