How to put the features [closed]

I have been thinking how did they sign in without the need to sign up first. how did the dev team do that? is it need to create a mysql first or what ? like how did they make our password default then we will change it back ? can someone provide me with the code in php or something to refer to ? thanks in advance