how would i store values in database using symfony?

Question

I am new to symfony, after going through several online tutorials and blogs, i am trying to create a simple project. I created some modules with command console. and now i have created a form using simple html and now i need to store the form values in database. I am trying to do it in a simple way, like i am getting an array of sfWebRequest $request and then i did something like:-

$name = $request->getPostParameters()['name'];
$email = $request->getPostParameters()['email'];
$password = $request->getPostParameters()['password'];

however I am perfectly able to store fields in database, but i am a bit confused about the way i am doing. is there any other better way to do the same. and if i have a single form with ten fields, and i want to store them in 2 tables, how can do that.

HERE GOES MY HTML CODE

 <form id="formElem" name="formElem" action="/register/register" method="post">
                    <fieldset class="step">
                        <legend>Account</legend>
                        <p>
                            <label for="username">User name</label>
                            <input id="username" name="username" />
                        </p>
                        <p>
                            <label for="email">Email</label>
                            <input id="email" name="email" placeholder="[email protected]" type="email" AUTOCOMPLETE=OFF />
                        </p>
                        <p>
                            <label for="password">Password</label>
                            <input id="password" name="password" type="password" AUTOCOMPLETE=OFF />
                        </p>
       ......
       ......

And here is my Action Function:-

public function executeRegister(sfWebRequest $request)
     {
       if ($request->isMethod('post'))
     echo $request->getParameter('password');exit;

         $this->redirect('user/login');
      }

FYI, the preferred way to retrieve request parameters is $request->getParameter( 'password' ); You can also pass a "dafault" second parameter to be returned if a request parameter by the name specified does not exist. — 0x6A75616E

prodigitalson prodigitalson · Accepted Answer · 2011-12-12T18:12:09

You should use sfForm to handle form validation. If you use Doctrine for your models then it will be even easier because you can generate all the basics based on the schema definition.

Regardless when using sfForm your action would look something like the following:

public function executeSave(sfRequest $request)
{
   $this->form = new MyFormThatExtendsSfForm();
   if($request->isMethod('post')){
      $this->form->bind($request->getParameter($this->form->getName()));
      if($this->form->isValid()){
         // the array of values passed in the form
         $values = $this->form->getValues();

         // do your save logic here
         // if its a doctrine form this logic will look simply like
         // $this->form->save();

         // redirect to your success action
         $this->redirect($successUrl);
      }
   }
}

how would i store values in database using symfony?

2 Answers