Home / Questions / 375849
Accepted
Alberto Julio Arce Escolar
Asked: 2020-07-24 18:14:32 +0800 CST 2020-07-24 18:14:32 +0800 CST

Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 2031

  • 772

I want to send a request all in laravel by a stored procedure but it gives me an error any idea how to do it

 public function store(Request $request)
    {
        return $data = DB::select('call InsertarUsuario(?, ?, ?, ?, ?)',$request->all());
    }

throws me the following error

Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 2031 (SQL: call InsertUsuario(Camilo, Pepe, [email protected], 2, ENABLE)) in file C:\laragon\www\innovar2\vendor\laravel \framework\src\Illuminate\Database\Connection.php on line 671

enter image description here

I send 5 items

mysql

2 Answers

  1. Best Answer

    Do this:

    $request->all();

    It would be sending us a structure like the following:

    {"_token":"dvj6GNzG5g0FygBlvT1ByPAoXvYmEuY9aU8CfBgB","clave":"valor","clave":"valor"}

    So you would have to do it like this:

    • Instead of passing as second argument $request->all()we pass an array
    • The array for your case will have 5 positions, where each one will indicate which key should be accessed$request->

    So it can be like this:

    DB::select('call InsertarUsuario(?, ?, ?, ?, ?)', [$request->clave1, $request->clave2, $request->clave3, $request->clave4, $request->clave5]);

    Where the so-called keys from 1 to 5 will be the ones that have to be renamed according to the values ​​that you expect

    • 1

  2. The indicated error (2031) indicates that some parameters have not been passed to the function.

    https://dev.mysql.com/doc/refman/8.0/en/client-error-reference.html#error_cr_params_not_bound

    It may be that some of the expected parameters are missing from InsertarUsuario()or the values ​​of all the parameters have not been passed in ?(in this case 5). Check the function definition and what values ​​the call is generating $request->all()(is it an array of 5 elements?).

    • 0