Code-Bin #334 - Membership

Membership
Posted by: Barry | July 23, 2009 @ 9:13pm

ColdFusion Code

<cfquery name="add_new" datasource="#APPLICATION.dataSource#">
	SELECT contactid, userlogin, userpassword
	FROM contact
</cfquery>

NewAccountPage.cfm
<cfif isDefined("form.userlogin") and form.userpassword neq "">
<cfform action="AccountAdded.cfm">

<cfset SESSION.auth = structNew()>
 <cfset SESSION.auth.contactID = add_new.contactID>
 
 <input type="hidden" name="userLogin_required">
 <input type="hidden" name="userPassword_required">
Username:

<cfinput 
 type="text"
 name="userLogin"
 size="20"
 value=""
 maxlength="100"
 required="Yes"
 message="Please type your Username first.">

Password:
 
  
 <cfinput 
 type="password"
 name="userPassword"
 size="12"
 value=""
 maxlength="100"
 required="Yes"
 message="Please type your Password first.">
 
 Add Captcha test here

<input type="Submit"
 value="Enter"
 title="Enter">
</cfform>
</cfif>

AccountAdded.cfm

<h1>Successful!</h1>
<cfinsert datasource="#APPLICATION.dataSource#"
tablename="contact">

AddPlayer.cfm

<cfform action="insert_ok.cfm">
					
    <h2>Insert New Player</h2>
     <input type="hidden" name="playerid"
value="<cfoutput>#SESSION.auth.contactid#</cfoutput>">

Name:

inserk_ok.cfm

<h1>Successful!</h1>
<cfinsert datasource="#APPLICATION.dataSource#"
tablename="players">

MyAccountPage.cfm

<cfquery name="get_mypage" datasource="#APPLICATION.dataSource#">
    SELECT playerid, name, contactid 
    FROM players
    WHERE	playerid = #SESSION.auth.contactID#
    ORDER BY playerid DESC  
</cfquery>

Registered Players
<br /><br />
<cfoutput query="get_mypage">
#name#<br />
</cfoutput>

Syntax Highlighting

[Open in new window]

Author Comments

none

Rating

4.44 / 8
93 Votes