autocommit( false ); $mysqli->query("INSERT INTO sometable VALUES ('test - $num')"); $mysqli->rollback(); $mysqli->close(); ?>