ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Double action on registration form? How to post to two different databases?

July 16, 2009 1:31pm

Subscribe [2]
  • #1 / Jul 16, 2009 1:31pm

    Ludvik Herrera

    31 posts

    Here it goes:

    I have created a registration form with the basic fields.

    -username
    -screen name
    -password
    -email

    First. I’d like to know how I could create the screen name based on two fields: First Name + Last Name

    Second. I want to provide access to a secure area based on ExpressionEngine, but this form needs to feed a marketing companies DB, they already gave me their form with all the fields they want published. They’re about 15 fields.

    How can I post in one template form to EE Membership Registration, and to other form? Is this possible? I am using the User Module from Solspace, but I can use EE only modules as well.

    I’d appreciate script examples if possible, I am not really a hardcore programmer, I can figure things out, but visual code helps me better.

    Thank you very much.

    Here is some of the code:

    {exp:user:register id="register" form_name="register" return="register/sent_email" require_key="no" key_email_match="no" onsubmit="return submit_validation();" }
    <ul>
    <li><span>Email (Username): <input type="text" id="username" name="username" class="input" size="30" /></span></li>
    <li><span>Screen Name: <input type="text" id="screen_name" name="screen_name" class="input" size="30" /></span></li>
    
    <li><span>Password: <input type="password" id="password" name="password" class="input" size="30" /></span></li>
    <li><span>Confirm Password: <input type="password" id="password_confirm" name="password_confirm" class="input" size="30" /></span></li>
    
    <li id="terms"><span>Terms of Service:</span><textarea readonly="readonly" rows="10" cols="80">All messages posted at this site express the views of the author, and do not necessarily reflect the views of the owners and administrators of this site.
    
    By registering at this site you agree not to post any messages that are obscene, vulgar, slanderous, hateful, threatening, or that violate any laws.   We will permanently ban all users who do so.   
    
    We reserve the right to remove, edit, or move any messages for any reason.
    </textarea></li>
    <li id='accept_terms'>
    
    {if captcha}
    <span>Submit the word you see below</span>
    {captcha}
    <input type="text" value="" name="captcha" maxlength="20" style="width:140px;" /></p>
    <input type="hidden" value="{captcha_word}" id="pbj_captcha_word" name="captcha_word" maxlength="20" style="width:140px;" />
    {/if}
    
    <input id="input_accept" type="checkbox" name="accept_terms" value="y" /> <span class='important'>I agree to the terms of service</span>
    
    <input type="submit" value="submit" id="reg_submit" class="submit"/></p></li>
    </ul>
    {/exp:user:register}

    Here is the form connection that the third-party, second DB should populate.

    <form name="SurveyInput_IYLMUSVC15" method="post" action="http://gw.vtrenz.net/?method=cSurveyWebservice.submit&dkey=IYLMUSVC15&questionIDList=91445,91446,91447,1,2,15,14,16,5,6,88160,84601,88159,84614&mode=live">
    <input type="hidden" name="formRelocateURL" value="">
    <input type="hidden" name="clicksource" value="">
    <input type="hidden" name="iMarketingSyncID" value="">
    <input type="hidden" name="WebSyncID" value="">
    <label>Registration Username</label>
    
    <input type="text" name="q91445" value="" alt="Registration Username" size="25" maxlength="200"><BR >
    <label>Registration Passwords</label>
    
    <input type="text" name="q91446" value="" alt="Registration Passwords" size="25" maxlength="200"><BR >
    <label>Screen Name</label>
    
    <input type="text" name="q91447" value="" alt="Screen Name" size="25" maxlength="200"><BR >
    <label>First Name</label>
    
    <input type="text" name="q1" value="" alt="First Name" size="20" maxlength="50"><BR >
    <label>Last Name</label>
    
    <input type="text" name="q2" value="" alt="Last Name" size="20" maxlength="50"><BR >
    <label>Company Name</label>
    
    <input type="text" name="q15" value="" alt="Company Name" size="20" maxlength="100"><BR >
    <label>Email Address</label>
    
    <input type="text" name="q14" value="" alt="Email Address" size="20" maxlength="85"><BR >
    <label>Work Phone</label>
    
    <input type="text" name="q16" value="" alt="Work Phone" size="15" maxlength="25"><BR >
    <label>City</label>
    
    <select name="q84614">
        <option value="">Please Choose..</option>
        <option value="Agent">Yes</option><option value="Prospect">No</option>
    </select>
    
    
    <input name="Submit" type="submit" value="Submit">
    </form>
  • #2 / Jul 17, 2009 5:56am

    Ryan Irelan

    444 posts

    The best way to approach this is by creating an extension that does the submission to the third-party web service. I would look at the member_member_register hook and go from there. It gives you an array of data about the new member, which you could possibly use to send to the third-party web service.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases