Advertisement
Guest User

Untitled

a guest
May 21st, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <!--- Get user record from the database --->
  2. <cfquery name="userVerify" datasource="CFMLX">
  3.     SELECT adminID, userName, passWord
  4.     FROM AdminLogin
  5. @H@ WHERE userName = <cfqueryparam value="#user_name#" cfsqltype="cf_sql_varchar" />
  6. @H@ AND passWord = <cfqueryparam value="#hash(user_pass,'SHA-256')#" cfsqltype="cf_sql_varchar" />
  7. </cfquery>
  8.  
  9. <cfif userVerify.RecordCount>
  10.     <cfset session.allowin = "True">
  11.     <cfset session.user_id = userVerify.adminID>
  12.     <script>
  13.          alert("Welcome user, you have been successfully logged in!");
  14.          self.location="admin.cfm";
  15.     </script>
  16.     <cfelse>
  17.     <script>
  18.         alert("Your credentials could not be verified, please try again!!!");
  19.         self.location="Javascript:history.go(-1)";
  20.     </script>
  21. </cfif>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement