prepare($sql);
$stmh->bindValue(1,$num,PDO::PARAM_STR);
$stmh->execute();
$count = $stmh->rowCount();
if($count<1){
print "검색결과가 없습니다.
";
}else{
$row = $stmh->fetch(PDO::FETCH_ASSOC);
$item_subject = $row["subject"];
$item_content = $row["content"];
$item_file_0 = $row["file_name_0"];
$item_file_1 = $row["file_name_1"];
$item_file_2 = $row["file_name_2"];
$copied_file_0 = $row["file_copied_0"];
$copied_file_1 = $row["file_copied_1"];
$copied_file_2 = $row["file_copied_2"];
$content="";
$content="";
$condate="";
$condate1="";
$condate2="";
$estimate1="";
$estimate2="";
$estimate3="";
$estimate4="";
$bill1="";
$bill2="";
$bill3="";
$bill4="";
$bill5="";
$bill6="";
$billdate1="";
$billdate2="";
$billdate3="";
$billdate4="";
$billdate5="";
$billdate6="";
$deposit1="";
$deposit2="";
$deposit3="";
$deposit4="";
$deposit5="";
$deposit6="";
$claimamount1="";
$claimamount2="";
$claimamount3="";
$claimamount4="";
$claimamount5="";
$claimamount6="";
$claimamount7="";
$claimdate1="";
$claimdate2="";
$claimdate3="";
$claimdate4="";
$claimdate5="";
$claimdate6="";
$claimbalance1="";
$claimbalance2="";
$claimbalance3="";
$claimbalance4="";
$claimbalance5="";
$claimbalance6="";
$claimbalance7="";
$claimfix1="";
$claimfix2="";
$claimfix3="";
$claimfix4="";
$claimfix5="";
$claimfix6="";
$claimfix7="";
$claimperson="";
$claimtel="";
$depositdate1="";
$depositdate2="";
$depositdate3="";
$depositdate4="";
$depositdate5="";
$depositdate6="";
$receivable="";
$workplacename=$row["workplacename"];
$chargedperson=$row["chargedperson"];
$address=$row["address"];
$firstord=$row["firstord"];
$firstordman=$row["firstordman"];
$firstordmantel=$row["firstordmantel"];
$secondord=$row["secondord"];
$secondordman=$row["secondordman"];
$secondordmantel=$row["secondordmantel"];
$worklist=$row["worklist"];
$motormaker=$row["motormaker"];
$power=$row["power"];
$workday=$row["workday"];
$worker=$row["worker"];
$endworkday=$row["endworkday"];
$cableday=$row["cableday"];
$cablestaff=$row["cablestaff"];
$endcableday=$row["endcableday"];
$asday="";
$asorderman="";
$asordermantel="";
$aslist="";
$asresult="";
$ashistory="";
$comment="";
$totalbill="";
$accountnote="";
$asproday="";
$asendday="";
$asman="";
$subject="";
$work_state="";
$as_state="";
$sum_bill=0;
$sum_receivable=0;
$sum_deposit=0;
$sum_claimamount=0;
$sum_estimate=0;
$as_refer="";
$change_worklist="";
$checkbox="";
$checkstep="없음";
$asfee="";
$asfee_estimate="";
$promiseday="";
$as_check="";
$outputmemo="";
$aswriter="";
$setdate="";
if($workday!="0000-00-00") $workday = date("Y-m-d", strtotime( $workday) );
else $workday="";
if($cableday!="0000-00-00") $cableday = date("Y-m-d", strtotime( $cableday) );
else $cableday="";
if($endworkday!="0000-00-00") $endworkday = date("Y-m-d", strtotime($endworkday) );
else $endworkday="";
if($endcableday!="0000-00-00") $endcableday = date("Y-m-d", strtotime($endcableday) );
else $endcableday="";
$subject=$workplacename;
}
}catch (PDOException $Exception) {
print "오류: ".$Exception->getMessage();
}
}
?>