those two code samples accomplish the same thing, they are the same code only written slightly different.
If the User ID is being passed to the BADGE_Registration using a url variable, then you should bind the foreign key to the URL Variable binding.
As long as the primary key column is set to be Numeric and Auto increment in the database, it will auto increment for you when a record is inserted.