i have a problem with saving data to database using LARAVEL

Question

this is all my codes after cliking on button doesn't save to database i try to change method of saving but not work

    use App\makereservations;
use Illuminate\Http\Request;

class reservationController extends Controller
{
    public function hreservation()
    {
        return view('hreservation');
    }
    public function reserve (Request $request)
    {
        $this->validate($request ,[
            'name' => 'required',
            'email' => 'required',
            'phone' => 'required|email',
            'date' => 'required',
            'time' => 'required',

        ]);
        $reservation  = new makereservations();
        $reservation  =  $request->input('name');
        $reservation  =  $request->input('email');
        $reservation  =  $request->input('phone');
        $reservation  =  $request->input('date');
        $reservation  =  $request->input('time');
        $reservation  =  $request->input('personne');
        $reservation -> statu =  false;
        $reservation -> save();
        return redirect()->back();
    }
}

this is the roote route::post('reserve', 'reservationController@reserve' )->name('reserv.sent');

what is the error

Nipun Tharuksha
– Nipun Tharuksha

2020-05-31 16:37:38 +00:00
Commented May 31, 2020 at 16:37 — Nipun Tharuksha
– Nipun Tharuksha, Commented May 31, 2020 at 16:37

Rafik Farhad · Accepted Answer · 2020-05-31 14:07:11Z

1

You missed the -> arrow sign.

$reservation  = new makereservations();
$reservation->name  =  $request->input('name');
$reservation->email  =  $request->input('email');
$reservation->phone  =  $request->input('phone');
$reservation->date  =  $request->input('date');
$reservation->time  =  $request->input('time');
$reservation->personne  =  $request->input('personne');
$reservation-> statu =  false;
$reservation-> save();
return redirect()->back();

answered May 31, 2020 at 14:07

Rafik Farhad

1,2022 gold badges14 silver badges21 bronze badges

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

2 Comments

Habib Ellah Over a year ago

i changed name of table but does'nt work how i can make old table works $inputs = $request->all(); $inputs['statu'] = false; $reservation = reservation::create($inputs); <=========== focus here return redirect()->back();

Rafik Farhad Over a year ago

In your reservation table, add this line, protected $table = 'new_table_name'; Now, reservation::create() will save in your new table.

Daniel Mesa · Accepted Answer · 2020-05-31 15:37:57Z

1

If in the MakeReservations model you have massively assignable fields

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class makereservations extends Model
{
    protected $table = "your_table_name"
    ...
    protected $fillable = [
        'name', 'email', 'phone', 'date', 'time', 'personne', 'status'
    ];
    ...
}

Your reserve method in reservationController it may be so:

<?php

namespace App\Http\Controllers;

use App\makereservations;
use Illuminate\Http\Request;

class reservationController extends Controller
{
    ...
    public function reserve (Request $request)
    {
        $this->validate($request ,[
            'name' => 'required',
            'email' => 'required|email',
            'phone' => 'required',
            'date' => 'required',
            'time' => 'required',

        ]);
        $inputs = $request->all();
        $inputs['status'] = false;
        $reservation = makereservations::create($inputs);
        return redirect()->back();
    }
}

I have detected that in your validation method you are trying to validate that the phone is an email

answered May 31, 2020 at 15:37

Daniel Mesa

5965 silver badges14 bronze badges

3 Comments

Habib Ellah Over a year ago

do i must create new table with the name makereservations becouse i allready have table named reservation

Habib Ellah Over a year ago

i changed name of table but does'nt work how i can make old table works $inputs = $request->all(); $inputs['statu'] = false; $reservation = reservation::create($inputs); <=========== focus here return redirect()->back();

Daniel Mesa Over a year ago

Oh yes, varname is statu, you must change it in $fillable array in your model

Akhtar Munir · Accepted Answer · 2020-05-31 17:38:43Z

0

You can do it more shortly and in a clean way, to optimize your code.

public function reserve (Request $request)
{
    $attributes = $this->validate($request ,[
        'name' => 'required',
        'email' => 'required|email',
        'phone' => 'required',
        'date' => 'required',
        'time' => 'required',
        'personne' => ''
    ]);

    $attributes['statu'] = false;

    makereservations::create($attributes);
    return redirect()->back();
}

In your model make sure these things

class makereservations extends Model
{
    protected $table = 'reservation';
    protected $guarded = []; //it means all data from request will be mass assignable
}

edited May 31, 2020 at 17:38

answered May 31, 2020 at 15:42

Akhtar Munir

1,7693 gold badges13 silver badges29 bronze badges

5 Comments

Habib Ellah Over a year ago

I tried but show me this message and the table name reservation if SQLSTATE[42S02]: Base table or view not found: 1146 Table 'restau_app.makereservations' doesn't exist (SQL: insert into makereservations (name, email, phone, date, time, personne, statu, updated_at, created_at) values (test, [email protected], 12345678, 5/7/2020, 12:30am, 1, 0, 2020-05-31 17:33:40, 2020-05-31 17:33:40))

Habib Ellah Over a year ago

i changed name of table but does'nt work how i can make old table works $inputs = $request->all(); $inputs['statu'] = false; $reservation = reservation::create($inputs); <=========== focus here return redirect()->back();

Akhtar Munir Over a year ago

can you tell me what is your table name in mysql and what is your model name for that table ? And you don't need to change your table name, look very simple, you have a table name reservation and you might have made a model for this table named makereservations, right ?

Habib Ellah Over a year ago

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list' (SQL: insert into contacts (name, email, subject, message, status, updated_at, created_at) values (test, [email protected], mytest, text text text text, 0, 2020-06-01 19:54:14, 2020-06-01 19:54:14))

Akhtar Munir Over a year ago

So you are having problem in another table now ?

Collectives™ on Stack Overflow

i have a problem with saving data to database using LARAVEL

3 Answers 3

2 Comments

3 Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

3 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related