echajoa/manage/car/grade_proc.php

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


	$cd_model_sub = trim(avoid_crack($_POST["cd_model_sub"]));
	$cd_grade  = trim(avoid_crack($_POST["cd_grade"]));
	$nm_grade  = trim(avoid_crack($_POST["nm_grade"]));
	$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_grade SET
						cd_model_sub = '$cd_model_sub'
						, nm_grade = '$nm_grade'
						, ds_status = 'A0'
						, dt_insert = now()
						, nm_insert = '$cd_userid'
						, dt_update = now()
						, nm_update = '$cd_userid'
						, 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_grade SET
						cd_model_sub = '$cd_model_sub'
						, nm_grade = '$nm_grade'
						, dt_update = now()
						, nm_update = '$cd_userid'
						, ds_delind = 'N'
					WHERE cd_grade = '$cd_grade'
			";

			$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_grade SET
						dt_update = now()
						, nm_update = '$cd_userid'
						, ds_delind = 'Y'
					WHERE cd_grade = '$cd_grade'
			";

			$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);
?>