update database laravel code example
Example 1: laravel update from query
$affected = DB::table('users')
->where('id', 1)
->update(['votes' => 1]);
Example 2: laravel soft delete
/** in migrations this changes need to
add for table we want to add soft delete (LARAVEL)*/
/** The migrations. START */
public function up()
{
Schema::table('users', function(Blueprint $table)
{
$table->softDeletes();
});
}
/** The migrations. END */
/** after adding softdelete you need to
point that column in table related model (LARAVEL)*/
/** The Model. START */
use Illuminate\Database\Eloquent\SoftDeletes;
class User extends Model {
use SoftDeletes;
protected $dates = ['deleted_at'];
}
/** The Model. END */
Example 3: laravel db::query update
DB::table('user')->where('email', $userEmail)->update(array('member_type' => $plan));
Example 4: laravel find query
<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Model;
class Flight extends Model
{
/**
* The primary key associated with the table.
*
* @var string
*/
protected $primaryKey = 'flight_id';
}