Jump to:

23481 Posts in 18965 Topics by 2878 members

General Questions

SilverStripe Forums » General Questions » How to do insert data to table member in custom fields ?

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 2080 Views
  • jQuery.in.th
    Community Member
    7 Posts

    How to do insert data to table member in custom fields ? Link to this post


    I have created class RegisterMember and created register form please see image below.

    My class .


    * Page containing a registration form.
    * Uses Member::getMemberFormFields() to know what to ask of a user.
    class RegisterPage extends Page {
    static $db = array(
    "ThanksTitle" => "HTMLVarchar",
    "ThanksContent" => "HTMLText",

    function getCMSFields($cms) {
    $fields = parent::getCMSFields($cms);

    $fields->addFieldsToTab("Root.Content.Thanks", array(
    new TextField("ThanksTitle", "Title"),
    new HTMLEditorField("ThanksContent", "Content"),

    return $fields;


    class RegisterPage_Controller extends Page_Controller {
    * Return the edit form for the current user
    function Form() {
    // Get the fields from a new member - seems like a good default

    $businessArr = array(
    'Corporate reseller'=>'Corporate reseller',
    'System Integrator'=>'System Integrator',
    'Online Retailer'=>'Online Retailer',
    'Value Added Reseller'=>'Value Added Reseller'
    $marketSegmentArr = array(
    'End consumers'=>'End consumers',
    'Small office/ home office'=>'Small office/ home office',
    'Small and medium businesses'=>'Small and medium businesses',
    'Enterprise businesses'=>'Enterprise businesses',

    $member = new Member();
    $fields = new FieldSet(
    new TextField('FirstName','First Name'),
    new TextField('LastName','Last Name'),
    new TextField('CompanyName','Company Name'),
    new TextField('Address1','Address 1'),
    new TextField('Address2','Address 2'),
    new TextField('Town','Town'),
    new TextField('PostalCode','Postal Code'),
    new TextField('Country','Country'),
    new TextField('TelNumber','Tel Number'),
    new EmailField('EmailAddress','Email Address'),
    new DropdownField(
    $name = 'Business',
    $title = 'Please select the primary category that best describes your business.',
    new DropdownField(
    $name = 'MarketSegment',
    $title = 'Which of the following market segments does your organisation sell to?',

    $actions = new FieldSet(
    new FormAction('register', 'Register')

    $form = new Form($this, 'Form', $fields, $actions);

    return $form;

    * Save the profile details
    function register($data, $form) {
    // Create a new member and save the form into it
    $member = new Member();

    // Write to the databsae

    // To do: add a status message on the form, using the standard form message system

    // Return to the original form
    Director::redirect($this->Link() . 'thanks');

    function thanks() {
    return array(
    'Title' => $this->ThanksTitle,
    'Content' => $this->ThanksContent,
    'Form' => ' ',

    I have tested submit register form and I have view data in phpMyAdmin. In table member no has data.

    Database :

    Please help me.

Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.