Trouble using new whmcs sql helper functions

[hpk]

Hello,

 

I am trying to use new whmcs sql helper functions listed here:

 

http://docs.whmcs.com/SQL_Helper_Functions

 

However including the following directly in page:

 

<?php

require_once('/home/acct/public_html/whmcs/vendor/autoload.php');


use Illuminate\Database\Capsule\Manager as Capsule;

// Print all client first names using a simple select.

/** @var stdClass $client */
foreach (Capsule::table('tblclients')->get() as $client) {
   echo $client->firstname . PHP_EOL;
}

// Rename all clients named "John Deo" to "John Doe" using an update statement. 
try {
   $updatedUserCount = Capsule::table('tblclients')
       ->where('firstname', 'John')
       ->where('lastname', 'Deo')
       ->update(
           [
               'lastname' => 'Doe',
           ]
       );

   echo "Fixed {$updatedUserCount} misspelled last names.";
} catch (\Exception $e) {
   echo "I couldn't update client names. {$e->getMessage()}";
}

 

results in error:

 

Call to a member function connection() on a non-object in /home/acct/public_html/whmcs/vendor/illuminate/database/Illuminate/Database/Capsule/Manager.php on line 110

 

Any help?

 

Thanks a lot!

[sentq]

you did not make connection to DB, replace this line:

 

require_once('/home/acct/public_html/whmcs/vendor/autoload.php');

 

with this one:

 

require_once('/home/acct/public_html/whmcs/init.php');