$handle = new PDO( 'mysql:host=;dbname=', '', '');

$handle->beginTransaction();
// here you execute your query
$handle->commit();
$id = $handle->lasInsertId();