Home / Questions / 330426
Accepted
Rafael Monroy Rodriguez
Asked: 2020-02-19 10:44:10 +0800 CST 2020-02-19 10:44:10 +0800 CST

Array to string conversion

  • 772

Hello, I am trying to enter a data to a field of my database in Laravel, the problem is that I get Array to string conversion , the code is as follows:

$credentials='Lab Catálisis';
    if ($credentials =='Lab Catálisis') {
        $lab = new tbl_lab();
        $lab->lab_ceco = $request->ceco;
        $lab->lab_direccion = $request->direccion;
        $lab->lab_lider = $request->lider;
        $lab->lab_usu_id = DB::select("SELECT max(usu_id) FROM tbl_usuario");
        $lab->save();
        return view('login');
    }

The DB brings me the data as an array, how could I convert that array that the query brings me to an integer to be able to enter it into my field.

Thanks.

laravel

2 Answers

  1. Best Answer

    You have forgotten to collect the data of your query to the database:

    $lab->lab_usu_id = DB::select("SELECT max(usu_id) FROM tbl_usuario");

    You must collect it as follows:

    $lab->lab_usu_id = DB::select("SELECT max(usu_id) FROM tbl_usuario")->first();

    Anyway, I advise you to use the laravel orm; eloquent , with eloquent it would be something like this:

    $lab->lab_usu_id = tbl_usuario::max('usu_id');
    • 1

  2. In this case it is not necessary to use a raw query , you can use the equivalent methods of the query builder:

    $lab->lab_usu_id = DB::table('tbl_usuario')->max('usu_id');

    If for some reason said method does not deliver the unique data, you can access the data with object or array syntax,

    • 1