ErrorException htmlspecialchars() expects parameter 1 to be string, array given

Question

I want to get data "report_to" from database. But i got error when I try to print variable in my view page. It's said "ErrorException htmlspecialchars() expects parameter 1 to be string, array given".

This is my controller.

function editroledetails(Request $request)
    {
        $user = \Auth::user();
        $userphone = 0;
        $reportTo = DB::select(DB::raw("SELECT report_to FROM customer_type WHERE username='19331986' "));
        $data = [
            'editUsername' => $request->editUsername,
            'editNik' => $request->editNik,
            'editEmail' => $request->editEmail,
            'editRegIdentities' => $request->editRegIdentities,
            'editID' => $request->editID
        ];

        return view('editroledetails', compact('user', 'userphone', 'data', 'reportTo'));
    }

This is my view

<div class="alert alert-info">
            <h3>{{$reportTo}}</h3>
        </div>

I expect the view will display the variable that is "Name", but I got error htmlspecialchars() expects parameter 1 to be string, array given.

Well, the solution is in the error...you are passing an array instead of a string. — the.marolie, Apr 15 '19 at 06:58
`reportTo` is array, either iterate over it in template, or extract one value in controller. — u_mulder, Apr 15 '19 at 06:59
Can you share the content of $reportTo (Maybe via `dd($reportTo);`) — Koen Hollander, Apr 15 '19 at 07:29

score 0 · Answer 1 · answered Apr 15 '19 at 06:59

Change

$reportTo = DB::select(DB::raw("SELECT report_to FROM customer_type WHERE username='19331986' "));

to

$reportTo = DB::select(DB::raw("SELECT report_to FROM customer_type WHERE username='19331986' "))->get();

and now $reportTo is an array you may need to use @foreach or @for. or if you are sure you will get only one record, you can use first() like

$reportTo = DB::select(DB::raw("SELECT report_to FROM customer_type WHERE username='19331986' "))->first();

score 0 · Answer 2 · answered Apr 15 '19 at 07:00

0

it means and it is clear that $reportTo is a results set of the query, change your query to $reportTo = DB::select(DB::raw("SELECT report_to FROM customer_type WHERE username='19331986' "))->first(); and then access your DB column like $reportTo['colname']

answered Apr 15 '19 at 07:00

Danish Hakim Khan

253
1
11

I try that, and its show error "FatalErrorException Call to a member function first() on array" – Parama Abby Apr 15 '19 at 07:57

Parama Abby · Accepted Answer · 2019-04-23T07:28:09.583

0

[SOLVED] Thank you for the answer, Im already solved it.

This the code

<?php echo $reportTo[0]->report_to; ?>

This is print_r of $reportTo

This is my reference

edited Apr 23 '19 at 07:28

answered Apr 23 '19 at 07:22

Parama Abby

5
6

ErrorException htmlspecialchars() expects parameter 1 to be string, array given

3 Answers3