Laravel Guarded code example
Example 1: laravel delete where
DB::table('users')->where('id', $id)->delete();
Example 2: laravel fillable
/**
* The attributes that are mass assignable.
*/
protected $fillable = [
'title',
'slug',
'body',
'image',
'published',
'comments_open'
];
Example 3: 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 4: 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 5: laravel eloquent remove from db
$res=User::where('id',$id)->delete();
Example 6: laravel eloquent remove from db
public function destroy($id){
$res=User::find($id)->delete();
if ($res){
$data=[
'status'=>'1',
'msg'=>'success'
];
}else{
$data=[
'status'=>'0',
'msg'=>'fail'
];
return response()->json($data);