<?php
	$d_id = $_POST['id'];
	$account = urldecode(htmlspecialchars($_POST['acc']));
	$pass = urldecode(htmlspecialchars($_POST['pass']));
	$mail = urldecode(htmlspecialchars($_POST['mail']));
	$sex = $_POST['sex'];
	$car = urldecode(htmlspecialchars($_POST['car']));
	$people = $_POST['people'];


	$con = mysql_connect("localhost","event","L523GpA");
	if(!$con){
		unset($con);
		unset($account,$pass,$mail,$sex);
		die("0");
	}
	$select_db = mysql_select_db("eventdb");
	if(!$select_db){
		unset($con,$select_db);
		unset($account,$pass,$mail,$sex);
		die("0");
	}
	unset($select_db);
	mysql_query("set names utf8");
	$sql = "select count(*) as cnt from account_tbl where id = ".$d_id;
	$res = mysql_query($sql);
	if(!$res){
		unset($con,$select,$spl,$res,$day,$bus);
		unset($account,$pass,$mail,$sex);
		die("0");
	}
	$row = mysql_fetch_array($res);
	mysql_free_result($res);
	$close = mysql_close($con);
	if(!$close){
		unset($con,$close,$day,$bus,$row,$sql,$close);
		unset($account,$pass,$mail,$sex);
		die("0");
	}
	unset($con,$sql,$close);

	$flag=0;
	//データがある場合
	if($row['cnt']!=0){
		$flag=1;
	}
	if($flag==1){
		$con = mysql_connect("localhost","event","L523GpA");
		if(!$con){
			unset($con,$close,$day,$bus,$row,$sql,$close);
			unset($account,$pass,$mail,$sex);
			die("0");
		}
		$select_db = mysql_select_db("eventdb");
		if(!$select_db){
			unset($con,$close,$day,$bus,$row,$sql,$close);
			unset($account,$pass,$mail,$sex);
			die("0");
		}
		unset($select_db);
		mysql_query("set names utf8");
		mysql_query("set autocommit = 0");
		mysql_query("begin");
		$res=mysql_query("update account_tbl set account='".$account."',pass='".$pass."',mail='".$mail."',sex=".$sex.",car='".$car."',people=".$people." where id=".$d_id);
		//echo "update account_tbl set account='".$account."',pass='".$pass."',mail='".$mail."',sex=".$sex.",car='".$car."',people=".$people." where id=".$d_id;
		if($res === true){
			mysql_query("commit");
		}else{
			mysql_query("rollback");
		}
		$close= mysql_close($con);
		if(!$close){
			unset($con,$close,$day,$bus,$row,$sql,$close);
			unset($account,$pass,$mail,$sex);
			die("0");
		}
		echo $d_id;
	}else{
		echo "0";
	}
	unset($con,$close,$day,$d_id,$row,$sql,$close);
	unset($account,$pass,$mail,$sex,$car,$people);
?>