[FastRoute] PHP 트랜잭션

1. 기존 PHP 코드에 트랜잭션 Commit과 Rollback 기능 추가 (pdo.php)

function test($param) {
	$pdo = pdoSqlConnect();
	$query = "SELECT * FROM User WHERE id = ?;";

	$st = $pdo->prepare($query);
	$st->execute([$param]);
	$st->setFetchMode(PDO::FETCH_ASSOC);
	$res = $st->fetchAll();

	$st=null;$pdo = null;

	return $res;
}

function test($param) {
	$pdo = pdoSqlConnect();

	try {
		$query = "SELECT * FROM User WHERE id = ?;";

		$st = $pdo->prepare($query);
		$pdo->beginTransaction();

		$st->execute([$param]);

		$pdo->commit();

		$st=null;$pdo = null;

		return true;

	} catch (Exception $e) {
		if ($pdo->inTransaction()) {
			$pdo->rollback();
		}
		throw $e;
		return false;
	}
}