Uncaught Error: Cannot use object of type stdClass as array PHP

Question

I created this peace of PHP code to connect to googlew sheet and fill html file on my server:

 <?php

// Vaš Google Sheets API ključ
$api_key = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx';

// URL vašeg Google Sheet-a
$sheet_url = 'https://sheets.googleapis.com/v4/spreadsheets/xxxxxxxxxxxxx';

// Kreiranje URL-a za zahtev
$request_url = $sheet_url . '?key=' . $api_key;

// Povezivanje sa Google Sheets API-jem pomoću cURL
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $request_url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$response = curl_exec($ch);
curl_close($ch);

// Parsiranje JSON odgovora
$data = json_decode($response);

// Popunjavanje podataka u HTML dokument
$html = file_get_contents('test.html');
foreach ($data as $datapoint) {
    // Provjera da li se datum u koloni podudara sa trenutnim datumom
    if ($datapoint['datum'] == date('d.m')) {
        $html = str_replace('{{IME}}', $datapoint['Ime'], $html);
        $html = str_replace('{{PREZIME}}', $datapoint['Prezime'], $html);
        $html = str_replace('{{ULICA}}', $datapoint['Ulica'], $html);
        $html = str_replace('{{BROJ}}', $datapoint['E-mail'], $html);
    }
}

// Postavljanje HTTP zaglavlja za datoteku
header('Content-Disposition: attachment; filename="popunjeno.html"');

// Prikazivanje HTML dokumenta sa popunjenim podacima
echo $html;

?>

But I got this error: Fatal error: Uncaught Error: Cannot use object of type stdClass as array in /home/xxxxxxx/public_html/sheet2html.php:26 Stack trace: #0 {main} thrown in /home/xxxxxxx/public_html/sheet2html.php on line 26

This script should populate HTML file from google sheet on with data from today only.

Maybe because it is late, maybe my knowledge is limited, I googled couple og hours, but mainly found this errors in JSON calls for example. Any help appreciated

S. Imp · Accepted Answer · 2022-12-12 23:45:38Z

2

I'm not exactly sure what's in the google JSON response, but chances are it's being decoded into an instance of stdClass by this line:

$data = json_decode($response);

if $data is an instance of stdClass, you can' use foreach on it unless you cast it as an array. Fortunately, json_decode allows you to provide an additional second parameter, $associative to force it to decode the JSON object as associative arrays (see arrays ) instead of stdClass objects. The documentation:

associative

When true, JSON objects will be returned as associative arrays; when false, JSON objects will be returned as objects. When null, JSON objects will be returned as associative arrays or objects depending on whether JSON_OBJECT_AS_ARRAY is set in the flags.

So you could change your line of code to this:

$data = json_decode($response, TRUE);

And hopefully that will let you iterate through $data using the foreach construct.

answered Dec 12, 2022 at 23:45

S. Imp

2,87714 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ZeusDev Over a year ago

Great man, that was that, I really apreciate your help, kudos to you!

Jānis Elmeris Over a year ago

"if $data is an instance of stdClass, you can' use foreach on it" Actually, you can. php.net/manual/en/language.oop5.iterations.php The problem here was not that $data was an object but that $datapoint was an object.

Collectives™ on Stack Overflow

Uncaught Error: Cannot use object of type stdClass as array PHP

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related