CRUD

Question 1

Get All In laravel

Answer 1

$posts= DB::table('posts')->get();
//      foreach ($posts as $post){
//          echo $post->title;
//      }

Question 2

Insert in laravel

Question 3

soft delete

Answer 3

In Model class file
class User{
use SoftDeletes;
}
IN Migration file
$table->softDeletes( );

get soft delete data
$users = User::onlyTrashed( )->latest( );

Question 4

Insert Data With Query Builder

Answer 4

use Illumiante/facades/DB

public function store( ) {

$data -> array( );
$data[“name”] = $request ->name;
$data[“user_id”] = Auth::user( )->id;
DB::table( “users”)->insert($data );

}

Question 5

Query Builder update and edit

Answer 5

get single data first
$category =DB::table(‘categories’)->where(‘id’,$id)->first( );

$data -> array( );
$data[“name”] = $request ->name;
$data[“user_id”] = Auth::user( )->id;
DB::table( “users”)->where(‘id’,$id)->update($data );

Question 6

restore data and permanant delete

Answer 6

public function Restore($id){
$delete = User::withTrashed( )->find($id)->restore()
}

$delete = User::onlyTrashed( )->find($id)->forceDelete()