update table laravel code example

Example 1: update column value laravel

Page::where('id', $id)->update(array('image' => 'asdasd'));

Example 2: laravel update from query

$affected = DB::table('users')
              ->where('id', 1)
              ->update(['votes' => 1]);

Example 3: laravel create model and migration

# If you would like to generate a database migration when you 
# generate the model, you may use the --migration or -m option:

php artisan make:model Flight --migration
php artisan make:model Flight -m

Example 4: laravel fillable

/**
     * The attributes that are mass assignable.
     */
    protected $fillable = [
      					   'title',
                           'slug',
                           'body',
                           'image',
                           'published',
                           'comments_open'
                          ];

Example 5: laravel create or update

// If there's a flight from Oakland to San Diego, set the price to $99.
// If no matching model exists, create one.
$flight = App\Models\Flight::updateOrCreate(
    ['departure' => 'Oakland', 'destination' => 'San Diego'],
    ['price' => 99, 'discounted' => 1]
);

Example 6: create model for existing table in laravel

Yes, you can create a create a model php artisan make:model Profile and then create its controller to handle CRUD operations. (Rememer the name of the model should be singular, not plural so that automatically the name of the table becomes the pluraliza name.) That is, Model: User, Table: users Model: Order, Table: orders etc

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Profile extends Model
{
    protected $guarded = [];
}