professional way add data in database laravel 5.2

Question

what is the professional way insert record in database. i am using laravel 5.2. i'm new in laravel.

class students extends Controller
{

    public function index()
    {
         $insertData = array(
        "name"      =>  Input::get("name"),
        "detail"    =>  Input::get("detail"),
        "token_key" =>  Input::get("_token")
    ); 
    return view('student');
    }

    public function fees()
    {
         $record = array(
        "p_name"      =>  Input::get("name"),
        "p_fees" =>  Input::get("fees"),
        "p_detail"  =>  Input::get("detail")
    ); 

    return view('fee');
    }

}

stander able way?

you can got your solution from here laravel.com/docs/5.2/database — Ankur Tiwari
– Ankur Tiwari, Commented Apr 28, 2016 at 7:19

Alexey Mezenin · Accepted Answer · 2016-04-28 07:40:43Z

1

You should use mass assignment. Fill $fillable array inside your model and use this:

Model::create($insertData);

answered Apr 28, 2016 at 7:40

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

3 Comments

Ghulam Abbas Over a year ago

please explain it how do it corresponding the above given field one method pick you and solve this properly please....................

Ghulam Abbas Over a year ago

i have two controoler method insert record here is my model i have two table for insert record in db namespace App\models; use Illuminate\Database\Eloquent\Model; class Designation extends Model { protected $fillable = ['name',detail]; }

Ghulam Abbas Over a year ago

other is protected $fillable = ['name','detail',''fees]; table name public static $table = "student" ; others table public static $table = "fees" how to implement fees table for controller method fees .i have no idea how to implement please explain it and how to acces require table from model into controller method

Ahmed Noozan Ali · Accepted Answer · 2016-04-28 08:24:16Z

0

  public function store_student(Request $request)
    {
        $student = new Student;
        $student->name = $request->name;
        $student->detail = $request->details
        $student->save();
        return view('student');

    }

public function store_fee(Request $request)
    {
        $fee = new Fee;
        $fee->p_name = $request->name;
        $fee->p_fee = $request->fees;
        $fee->p_detail = $request->details
        $fee->save();
        return view('fee');

    }

answered Apr 28, 2016 at 8:24

Ahmed Noozan Ali

386 bronze badges

Comments

Claudio King · Accepted Answer · 2016-04-28 07:39:08Z

0

I suggest you to read this from Laravel official guide. However you can do it like this:

DB::table('tablename')->insert($insertData);

answered Apr 28, 2016 at 7:39

Claudio King

1,6161 gold badge11 silver badges12 bronze badges

Collectives™ on Stack Overflow

professional way add data in database laravel 5.2

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related