WHMCS documentation about database management is very essential and incomplete, lacking any real sample code.

WHMCS use Laravel framework's database component, and this is great if you yet know Laravel, otherwise realizing even a simple operation may be hard.

We'll give here few different samples of code to do various operations:

 

Get the domain name of the service id# 5 from table tblhosting

 

use Illuminate\Database\Capsule\Manager as Capsule;
$serviceid=5 ;
try {
    $servicename = Capsule::table('tblhosting')
        ->where("id", $serviceid)
        ->select('domain')
        ->first();
    echo   "<pre>"; print_r($servicename);     

} catch(\Illuminate\Database\QueryException $ex){
    echo $ex->getMessage();
} catch (Exception $e) {
    echo $e->getMessage();
}
$domainname=$servicename->domain ;

 

Edit the description of a to-do element in tbltodolist

 

use Illuminate\Database\Capsule\Manager as Capsule;
$newdescription = 'this is the new text for the to-do item n# 37';
$todoitemid = 37 ;
try {
    $update_data =  [
        'description' => $newdescription 
    ];
    Capsule::table('tbltodolist')
       ->where('id', '=', $todoitemid)
       ->update($update_data);
} catch(\Illuminate\Database\QueryException $ex){
    echo $ex->getMessage();
} catch (Exception $e) {
    echo $e->getMessage();
}

 

 

Found this article interesting?
Subscribe to DomainRegister´s newsletter!

You can unsubscribe at any time by simply clicking the link in the footer of our emails. For information about our privacy practices, please visit our website.

We use Mailchimp as our marketing platform. By clicking below to subscribe, you acknowledge that your information will be transferred to Mailchimp for processing. Learn more about Mailchimp s privacy practices here.

  • WHMCS
  • 2 Utenti hanno trovato utile questa risposta
Hai trovato utile questa risposta?

Articoli Correlati

 How to add a favicon in WHMCS

To add a favicon to your WHMCS install: copy your favicon (es. myfavicon.ico) in WHMCS folder...

 How to comment in template (.tpl) files

If you need to insert a comment in a .tpl file, or comment a block of code to disable it, you...

 How to insert a Youtube video in WHMCS knowledgebase article

To insert a YouTube video in an article of the WHMCS knowledge base, you need to insert following...

 How to disable a customer to pay invoices partly with credit balance

in WHMCS if a customer has not enough credit balance for full payment of an invoice, WHMCS allows...

 How to add a cookie bar to WHMCS

In order to add a cookie bar to your own installation of WHMCS: copy somewhere on your WHMCS...