Getting a weird php error when im trying to connect to google sheets api

Question

So I am getting this weird error whenever I try to connect to google sheets using php. I tried googling it but I cant figure it out. Does anyone have some suggestions?

Edit: Thanks for the quick replies, I just added the code.I don't know why it's throwing an error because I literally just copied and pasted this from the google documentation.

CODE:

<?php
require __DIR__ . '/vendor/autoload.php';

if (php_sapi_name() != 'cli') {
    throw new Exception('This application must be run on the command line.');
}

/**
 * Returns an authorized API client.
 * @return Google_Client the authorized client object
 */
function getClient()
{
    $client = new Google_Client();
    $client->setApplicationName('Google Sheets API PHP Quickstart');
    $client->setScopes(Google_Service_Sheets::SPREADSHEETS_READONLY);
    $client->setAuthConfig('credentials.json');
    $client->setAccessType('offline');
    $client->setPrompt('select_account consent');

    // Load previously authorized token from a file, if it exists.
    // The file token.json stores the user's access and refresh tokens, and is
    // created automatically when the authorization flow completes for the first
    // time.
    $tokenPath = 'token.json';
    if (file_exists($tokenPath)) {
        $accessToken = json_decode(file_get_contents($tokenPath), true);
        $client->setAccessToken($accessToken);
    }

    // If there is no previous token or it's expired.
    if ($client->isAccessTokenExpired()) {
        // Refresh the token if possible, else fetch a new one.
        if ($client->getRefreshToken()) {
            $client->fetchAccessTokenWithRefreshToken($client->getRefreshToken());
        } else {
            // Request authorization from the user.
            $authUrl = $client->createAuthUrl();
            printf("Open the following link in your browser:\n%s\n", $authUrl);
            print 'Enter verification code: ';
            $authCode = trim(fgets(STDIN));

            // Exchange authorization code for an access token.
            $accessToken = $client->fetchAccessTokenWithAuthCode($authCode);
            $client->setAccessToken($accessToken);

            // Check to see if there was an error.
            if (array_key_exists('error', $accessToken)) {
                throw new Exception(join(', ', $accessToken));
            }
        }
        // Save the token to a file.
        if (!file_exists(dirname($tokenPath))) {
            mkdir(dirname($tokenPath), 0700, true);
        }
        file_put_contents($tokenPath, json_encode($client->getAccessToken()));
    }
    return $client;
}


// Get the API client and construct the service object.
$client = getClient();
$service = new Google_Service_Sheets($client);

// Prints the names and majors of students in a sample spreadsheet:
// https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit
$spreadsheetId = '1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms';
$range = 'Class Data!A2:E';
$response = $service->spreadsheets_values->get($spreadsheetId, $range);
$values = $response->getValues();

if (empty($values)) {
    print "No data found.\n";
} else {
    print "Name, Major:\n";
    foreach ($values as $row) {
        // Print columns A and E, which correspond to indices 0 and 4.
        printf("%s, %s\n", $row[0], $row[4]);
    }
}

Error:

PHP Warning:  count(): Parameter must be an array or an object that implements Countable in C:\Users\Desktop\Payment Website\vendor\guzzlehttp\guzzle\src\Handler\CurlFactory.php on line 67
PHP Fatal error:  Uncaught GuzzleHttp\Exception\RequestException: cURL error 60: SSL certificate problem: unable to get local issuer certificate (see http://curl.haxx.se/libcurl/c/libcurl-errors.html) in C:\Users\\Desktop\Payment Website\vendor\guzzlehttp\guzzle\src\Handler\CurlFactory.php:187
Stack trace:
#0 C:\Users\\Desktop\Payment Website\vendor\guzzlehttp\guzzle\src\Handler\CurlFactory.php(150): GuzzleHttp\Handler\CurlFactory::createRejection()
#1 C:\Users\\Desktop\Payment Website\vendor\guzzlehttp\guzzle\src\Handler\CurlFactory.php(103): GuzzleHttp\Handler\CurlFactory::finishError()
#2 C:\Users\\Desktop\Payment Website\vendor\guzzlehttp\guzzle\src\Handler\CurlHandler.php(43): GuzzleHttp\Handler\CurlFactory::finish()
#3 C:\Users\\Desktop\Payment Website\vendor\guzzlehttp\guzzle\src\Handler\Proxy.php(28): GuzzleHttp\Handler\CurlHandler->__invoke()
#4 C:\Users\\Desktop\Payment Website\vendor\guzzlehttp\guzzle\src\Handler\Proxy.php(51): in C:\Users\\Desktop\Payment Website\vendor\guzzlehttp\guzzle\src\Handler\CurlFactory.php on line 187

The error indicates that something that should be an array is something else. — Barmar, Jul 28 '20 at 01:46
What line are you getting the error at? (where line 67 corresponds to?) — Iamblichus, Jul 28 '20 at 09:24
@lamblichus i managed to fix it, i believe the error was being thrown outside of my code but inside some other framework file i had downloaded, because i was trying to connect up to google sheets. — RAT, Jul 28 '20 at 14:25

score 1 · Answer 1 · answered Jul 28 '20 at 02:25

1

This error occurs because the curl verifies and makes a secure connection request using self-signed certificate. When it does not find the valid certificate, it throws an error. To fix this error, follow the steps below:

Open http://curl.haxx.se/ca/cacert.pem
Copy the entire page and save it as a "cacert.pem"
Open your php.ini file and insert or update the following line.

curl.cainfo = "[pathtofile]cacert.pem"

answered Jul 28 '20 at 02:25

Max

21
2

can i insert that anywhere into the php.ini file – RAT Jul 28 '20 at 02:32
@ItIsN3RD Search for curl.cainfo in the php.ini file and you will find it .Thanks. – Max Jul 28 '20 at 02:39
i didnt see it. – RAT Jul 28 '20 at 02:40
says cant find curl – RAT Jul 28 '20 at 02:40
You need to enable the curl extension. – Max Jul 28 '20 at 02:41

score 0 · Accepted Answer · edited Jul 28 '20 at 05:13

0

I figured it out if you follow this, it should help. Personally i didn't use apache or anything like that.

Unable to find the wrapper "https" - did you forget to enable it when you configured PHP?

edited Jul 28 '20 at 05:13

Dharman

30,962
25
85
135

answered Jul 28 '20 at 05:07

RAT

121
1
14

Getting a weird php error when im trying to connect to google sheets api

2 Answers2