echajoa/manage/car/model_proc.php

<?php
	include $_SERVER['DOCUMENT_ROOT'].'/common/lib/comm.php';


	$cd_model = trim(avoid_crack($_POST["cd_model"]));
	$nm_model  = trim(avoid_crack($_POST["nm_model"]));
	$ds_status = trim(avoid_crack($_POST["ds_status"]));

	$ds_cate = trim(avoid_crack($_POST["ds_cate"]));
	if(!$ds_cate) $ds_cate='A0';

	$cd_userid = $_SESSION['admin_cd_userid'];
	$PageNo = trim(avoid_crack($_POST["PageNo"]));

	$ds_status = "A0";

	switch($mode) {

	//게시판 글쓰기
	case "Add" :
		include $_SERVER['DOCUMENT_ROOT'].ADMIN_PATH.'common/auth_chk.php';

		$RES = array('CODE'=>'9999', 'MSG'=>'');
		try {

			$sql = "insert into car_model SET
						cd_category = '$cd_category'
						, cd_brand = '$cd_brand'
						, nm_model = '$nm_model'
						, ds_status = 'A0'
						, dt_insert = now()
						, nm_insert = '$nm_procid'
						, dt_update = now()
						, nm_update = '$nm_procid'
						, ds_delind = 'N'
			";

			$result  = mysql_query($sql,$connect);

			if(!$result) {
				throw new Exception("입력 실패 하였습니다.", "9990");
			}


			$RES['CODE'] = "0000";
			$RES['MSG'] = "정상";

		}catch(Exception $e){
			$RES['CODE'] = $e->getCode();
			$RES['MSG'] = $e->getMessage();
		}
		@mysqli_close($connect);

		echo json_encode($RES);
		exit;

	break;

	//글수정
	case "Update":

		include $_SERVER['DOCUMENT_ROOT'].ADMIN_PATH.'common/auth_chk.php';

		$RES = array('CODE'=>'9999', 'MSG'=>'');
		try {

			$sql = "UPDATE car_model SET
						cd_category = '$cd_category'
						, cd_brand = '$cd_brand'
						, nm_model = '$nm_model'
						, dt_update = now()
						, nm_update = '$cd_userid'
						, ds_delind = 'N'
					WHERE cd_model = '$cd_model'
			";

			$result  = mysql_query($sql,$connect);

			if(!$result) {
				throw new Exception("수정 실패 하였습니다.", "9990");
			}

			$RES['CODE'] = "0000";
			$RES['MSG'] = "정상";

		}catch(Exception $e){
			$RES['CODE'] = $e->getCode();
			$RES['MSG'] = $e->getMessage();
		}
		@mysqli_close($connect);

		echo json_encode($RES);
		exit;

	break;

	//글삭제 처리
	case "Delete" :

		include $_SERVER['DOCUMENT_ROOT'].ADMIN_PATH.'common/auth_chk.php';

		$RES = array('CODE'=>'9999', 'MSG'=>'');
		try {

			$sql = "UPDATE car_model SET
						dt_update = now()
						, nm_update = '$cd_userid'
						, ds_delind = 'Y'
					WHERE cd_model = '$cd_model'
			";

			$result  = mysql_query($sql,$connect);

			if(!$result) {
				throw new Exception("삭제에 실패 하였습니다.", "9990");
			}

			$RES['CODE'] = "0000";
			$RES['MSG'] = "정상";

		}catch(Exception $e){
			$RES['CODE'] = $e->getCode();
			$RES['MSG'] = $e->getMessage();
		}
		@mysqli_close($connect);

		echo json_encode($RES);
		exit;
		

	break;

	default :
		AlertRedirect("지정되지않은 요청입니다","index.php&ds_cate=$ds_cate");
	break;
}
mysql_close($connect);
?>