login system, how to go from controller to view to model

[eluser]Colin Williams[/eluser]
Obviously, all the code isn't there, but I think you're on the right path. Although you definitely want to escape $username and $password before querying the database. Also, you should consider encrypting the passwords, whether it utilizes CI's encryption class, or uses md5/sha1. This will change your process a bit. The difference between the CI encryption class and md5/sha1 method is that you can decode passwords created through the encryption class. This means you can have passwords revealed back to users who forget. Otherwise, you have to do one-time login URLs or randomly generated passwords to get the user's password reset.