Getting value from html inputs in Laravel app to send to mysql database?

Question

I just started learning Laravel and would like to make a dummy Account Manager. My first goal is to be able to add accounts to the mysql db via an html form/Eloquent model/controller/migration. Coming from JavaScript, I'm not really sure how to pass the data from the name or value attr to the correct method and on to the migration. Here's my code from the form:

<form method="POST" action="/addAccount">
    {{ csrf_field() }}
    <input class="inputs" type="text" name="fname" placeholder="First Name">
    <input class="inputs" type="text" name="lname" placeholder="Last Name">
    <input class="inputs" type="email" name="email" placeholder="Email">
    <h3>Account Types and ID's:</h3>
    <ul class="list">
        <li>Confirmation: 1</li>
        <li>Setup: 2</li>
        <li>Activated: 3</li> 
        <li>Deactivated: 4</li>
    </ul>
    <input class="inputs" type="number" name="ati" placeholder="Enter Account Type ID">
    <input class="inputs" type="checkbox" name="active"><p>Click to Activate!</p>
    <button class="button">Submit</button>
  </form>

web.php: Route::post('addAccount', 'AccountsController@store');

Code for AccountsController:

public function store(Request $request)
{

    $accounts = new Account;
    $accounts->first_name = $fname;
    $accounts->last_name = $lname;
    $accounts->email = $email;
    $accounts->account_type_id = $ati;
    $accounts->active = $active;

    $accounts->save();

    return redirect('/');
}

Currently getting an ErrorException of "Undefined variable: fname". Any hints would be greatly appreciated!

ankit patel · Accepted Answer · 2017-10-23 03:45:59Z

1

You just need to use

$request->fname

instead of

$fname

answered Oct 23, 2017 at 3:45

ankit patel

1,91813 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Miggy · Accepted Answer · 2017-10-23 02:52:34Z

0

In your form, please add :

{{ csrf_field() }}

Laravel checks if a form has a token to protect the application from CSRF attack. See link for more details. CSRF Protection

Also, add a name attr in your input types like so:

<input class="inputs" type="text" name="fname" placeholder="First Name">

In your web.php :

Route::post('addAccount', 'controllerName@controllerFunction');

In your controller:

function controllerFunction(Request $request){
   //$request contains all sent data.
   $fname= $request->input('fname'); #you can use this way
   $fname = $request->fname; #or this one

   ....

   //code for storing in DB using Eloquent

   $users= new Users;
   $users->first_name = $fname;
   ....

   $users->save();
}

Please check the document for using Laravel Eloquent

answered Oct 23, 2017 at 2:52

Miggy

8167 silver badges16 bronze badges

2 Comments

Matt Larsuma Over a year ago

Thanks! Getting an ErrorException of "Undefined variable: fname" in my controller.

Miggy Over a year ago

@MattLarson you forgot to get the data

//$request contains all sent data.    $fname= $request->input('fname'); #you can use this way    $fname = $request->fname; #or this one

Collectives™ on Stack Overflow

Getting value from html inputs in Laravel app to send to mysql database?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related