How to Insert Taking Data from FORM in Laravel 5.2?

Question

I’m looking at the Laravel documentation on dbquery, in the Insert case. I need to do Insert outside of the Resource method (manually.

Type:

DB::table('users')->insert(
    ['email' => '[email protected]', 'votes' => 0]
);

But I need to get the data from a form. How do I do this? I didn’t see it in the documentation.

Answer 1

You need to point your form to the route where the destination is the function you will be entering, for example;

Your form:

<form method="post" action="{{ route('cadastro/novo') }}">
...
</form>

Your Route:

Route::post('cadastro/novo', 'UsuariosController@create');

No Controller UsuariosController you can use the class User to manipulate BD data because every model is linked to a table in the MAS database in the plural, for example;

model user -> table users

model cat -> table cats

use App\User;

class UsuarioController extends Controller {

// A função Request tera todos os dados enviados via post.
public function create(Request $request) {

    // Pega os dados enviado atraves do POST exceto o input _token 
    // que é enviado por padrão atraves do form.
    $dados = $request->except('_token');

    // A inserção acontece aqui...
    User::create($dados);
}

To search the database you can continue using the model you want because it already has several methods to facilitate manipulation.

$user = User::find(1); // Busca o usuario com o ID 1
$user = User::where('nome', 'oNome'); // Busca o usuario onde o campo "nome" seja "oNome".

In the case of udpate you can do;

User::where('id', 999)->update(['sobrenome' => 'novoSobreNome']);
// Buscara e atualizara o usuário com ID 999 substituindo o campo sobrenome com "novoSobreNome"

OR

$user = User::where('id', 999);
$user->idade += 1;
$user->save();

You can consult all available methods accessing the page of Eloquent of the Laravel.

Answer 2

Controller:

$model = new Model;
$model->nome = $request->get('nome'); // Vem do Form
$model->email = $request->get('email'); // Vem do Form
$model->telefone = $request->get('telefone'); // Vem do Form

$model->save();