Home / Questions / 342146
Accepted
Rafael Monroy Rodriguez
Asked: 2020-03-31 21:11:27 +0800 CST 2020-03-31 21:11:27 +0800 CST

Delete all data from a table

  • 772

Hello, I am trying to delete all the data from a table mysqlwith a button from my project laravel, I am doing it in the following way but it does not work for me, it comes out pagina expirada, the code of my controller is the following.

public function borrarDatos(){
      $marca=tbl_marca::all();
      $marca->delete();
      return back()->with('success', 'Datos Borrados Satisfactoriamente.'); 
    }

In my view I have the following

    <form action="{{ route('borrar') }}" class="form-horizontal" method="post" enctype="multipart/form-data">
      <button class="btn btn-danger" type="submit">Eliminar Datos</button>
   </form>

And my route is the following

Route::post('EliminarDatos', 'TestController@borrarDatos')->name('borrar');

How could I solve it? Thank you.

laravel

2 Answers

  1. It tokenis necessary that this action is reliable, you solve that with:

    @csrf

    Right after the opening form tag

    By the way the delete query can be reduced to

    tbl_marca::query()->delete();

    References

    • 2
  2. Best Answer

    As you have been told, you need the @csrf token, your code would look like this:

    <form action="{{ route('borrar') }}" class="form-horizontal" 
    method="POST" enctype="multipart/form-data">
    @csrf
 <button class="btn btn-danger" type="submit">EliminarDatos</button>
</form>

    edit:

    Another way to do it and faster:

    DB::table('tuTabla')->delete();

    I would do a check with a ->first(), to see if there is data in the table before doing the ->delete():

    $check = tbl_marca::first();
  if(! $check == null){
     $marca=tbl_marca::all();
     foreach($marca as $mar){
        $mar->delete();
     }
      return Response::json(array(
            'succes' => true,
            'errors' => ' Datos Borrados Satisfactoriamente. '
        ), 200);
  }else{
       return Response::json(array(
            'succes' => false,
            'errors' => ' No hay datos que borrar. '
        ), 400);
   }

    It is one of the ways to do it, like everything there are many more, for me the simplest. Hope this can help you

    • 1