php mysql 트랜잭션 사용

Transactions and auto-commit ¶

	//connect

	//트랜잭션 시작
	mysql_query("SET AUTOCOMMIT=0");
	mysql_query("BEGIN");

	//db 처리
	$sql = " insert into MEMBER_INFO
				set M_ID = '{$mb_id}',
				USR_IP = '{$_SERVER['REMOTE_ADDR']}',
				EXPIRE_DATE = DATE_ADD(now(), INTERVAL 1 MONTH)";
	
	$regist_result = mysql_query($sql);
	
	if(!$regist_result){
		mysql_query("ROLLBACK");
		echo "fail";
	}else{
		mysql_query("COMMIT");
		echo "success";
	}

	//connect close

	exit;