WHMCS Database tips and tricks – The queries

So, we’ve covered the basics. We’ve covered the parts of the schema. Now, it’s time to go through the database itself, the queries that you’ll likely use on a day to day basis.

We’ll continue working on our ‘mynewaddon’ addon. This won’t really show much, but at the end of the tips and tricks guide, you’ll have a functioning addon that will serve as an example of how addons should be created, and what they can do from there.

WHMCS Database tips and tricks – The schema

If you’re following along, I covered the database basics yesterday. So, today, for today’s WHMCS Database tips and tricks entry, we’ll take a look at the database schema when working with WHMCS. This is a slight bit more complicated. If you didn’t go through the schema link from yesterday, I strongly encourage you to do so now. This will help you out a good bit, and provides a bit of reference material for you to go with. Make sure you take a look through the schema link, for the types of columns you can use in Laravel.

WHMCS Database tips and tricks – The basics

I’ve been involved with php and MySQL based programming for quite some time. Starting with mysql_xx (now deprecated), I moved to mysqli-> due to the familiarity of things. This was a great choice, but when it came time to get serious about WHMCS development, well, it was time to learn (again).  Hopefully this series will be a bit of help to someone else. My goal is to gain and pass as much knowledge on to you, as the WHMCS documentation (as usual) doesn’t really cover much here. It barely even covers the basic ‘howto’ of doing things.