echajoa/manage/car/brand_proc.php

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

	$cd_category  = trim(avoid_crack($_POST["cd_category"]));
	$nm_brand  = trim(avoid_crack($_POST["nm_brand"]));
	$cd_brand  = trim(avoid_crack($_POST["cd_brand"]));

	$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_brand SET
						nm_brand = '$nm_brand'
						, cd_category = '$cd_category'
						, ds_status = 'A0'
						, nm_cont = ''
						, 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_brand SET
						nm_brand = '$nm_brand'
						, cd_category = '$cd_category'
						, dt_update = now()
						, nm_update = '$cd_userid'
						, ds_delind = 'N'
					WHERE cd_brand = '$cd_brand'
			";

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

			$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?cd_category=$cd_category");
	break;
}
mysql_close($connect);
?>