Problem running DB queries using PHP in WordPress

Is it possible to run PHP code in a WordPress HTML block? Or does WordPress only allow PHP via the use of snippet plugins?
I want to save form data to the WP Db on clicking a HTML submit button (and can’t get it to work or even show an error message) is that something that should be achievable?