=8) {
echo "";
sleep(2);
header ("Location:/login/logout.php");
exit;
}
if(isset($_REQUEST["mode"])) //수정 버튼을 클릭해서 호출했는지 체크
$mode=$_REQUEST["mode"];
else
$mode="";
if(isset($_REQUEST["num"])) //수정 버튼을 클릭해서 호출했는지 체크
$num=$_REQUEST["num"];
else
$num="";
if(isset($_REQUEST["page"])) //수정 버튼을 클릭해서 호출했는지 체크
$page=$_REQUEST["page"];
else
$page=1;
if(isset($_REQUEST["search"])) //수정 버튼을 클릭해서 호출했는지 체크
$search=$_REQUEST["search"];
else
$search="";
if(isset($_REQUEST["find"])) //수정 버튼을 클릭해서 호출했는지 체크
$find=$_REQUEST["find"];
else
$find="";
if(isset($_REQUEST["process"])) //수정 버튼을 클릭해서 호출했는지 체크
$process=$_REQUEST["process"];
else
$process="전체";
$fromdate=$_REQUEST["fromdate"];
$todate=$_REQUEST["todate"];
if(isset($_REQUEST["regist_state"])) // 등록하면 1로 설정 접수상태
$regist_state=$_REQUEST["regist_state"];
else
$regist_state="1";
$year=$_REQUEST["year"]; // 년도 체크박스
require_once("../lib/mydb.php");
$pdo = db_connect();
try{
$sql = "select * from chandj.motor where num = ? ";
$stmh = $pdo->prepare($sql);
$stmh->bindValue(1,$num,PDO::PARAM_STR);
$stmh->execute();
$count = $stmh->rowCount();
$row = $stmh->fetch(PDO::FETCH_ASSOC); // $row 배열로 DB 정보를 불러온다.
if($count<1){
print "검색결과가 없습니다.
";
}else{
$con_num=$row["con_num"];
$outdate=$row["outdate"];
$indate=$row["indate"];
$outworkplace=$row["outworkplace"];
$orderman=$row["orderman"];
$outputplace=$row["outputplace"];
$receiver=$row["receiver"];
$phone=$row["phone"];
$comment=$row["comment"];
$root=$row["root"];
$delivery=$row["delivery"];
$regist_state=$row["regist_state"];
$out_control=$row["out_control"];
$in_control=$row["in_control"];
$inbox=$row["inbox"];
$casecover=$row["casecover"];
$switchset=$row["switchset"];
$which=$row["which"];
$motor220v_150k=$row["motor220v_150k"];
$motor220v_300k=$row["motor220v_300k"];
$motor220v_400k=$row["motor220v_400k"];
$motor220v_500k=$row["motor220v_500k"];
$motor220v_600k=$row["motor220v_600k"];
$motor220v_800k=$row["motor220v_800k"];
$motor220v_1000k=$row["motor220v_1000k"];
$motor220v_1500k=$row["motor220v_1500k"];
$motor220v_2000k=$row["motor220v_2000k"];
$motor380v_150k=$row["motor380v_150k"];
$motor380v_300k=$row["motor380v_300k"];
$motor380v_400k=$row["motor380v_400k"];
$motor380v_500k=$row["motor380v_500k"];
$motor380v_600k=$row["motor380v_600k"];
$motor380v_800k=$row["motor380v_800k"];
$motor380v_1000k=$row["motor380v_1000k"];
$motor380v_1500k=$row["motor380v_1500k"];
$motor380v_2000k=$row["motor380v_2000k"];
$bracket_150k=$row["bracket_150k"];
$bracket_screen300k=$row["bracket_screen300k"];
$bracket_300k=$row["bracket_300k"];
$bracket_500k=$row["bracket_500k"];
$bracket_800k=$row["bracket_800k"];
$bracket_1500k=$row["bracket_1500k"];
$bracket_2000k=$row["bracket_2000k"];
if($indate!="0000-00-00") $indate = date("Y-m-d", strtotime( $indate) );
else $indate="";
if($outdate!="0000-00-00") $outdate = date("Y-m-d", strtotime( $outdate) );
else $outdate="";
}
}catch (PDOException $Exception) {
print "오류: ".$Exception->getMessage();
}
?>