So, we’ve covered the basics. We’ve covered the parts of the schema and some of the day to day queries. Now, let’s take a look at some more day to day queries, operations you’ll likely want to run on a daily basis. Deletes, >s, grabbing the number of rows, even some other small laravel magic.
I’ll be honest, my inbox is always full. No, really, it can be a nightmare. I sort through it every few minutes/hours, I have some aggressive filtering going on (forum posts, system notifications from dozens of servers, etc). My mailbox is always sitting with 10-15 messages unread, it’s crazy. If you’re like me (and many are), you can identify with the problem very quickly.
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.
Communicating with your clients through WHMCS can be tough. How many times in the past few months have you had to give this response to your clients? Be honest!
We sent you an email (invoice, support response, etc), please check your spam folder if it’s not received!
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.
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.