I have been looking into prepared statement and how to use them but my question is when is it best to use them or use a mysqli statement. As I was read up on prepared statement someone stated that you should never use prepared statement for something like a login form as this is only a form you will use once per time you visit a website.
Is this true or is it best to use prepared statement all the time as it stops SQL injection?