Yes that’s possible as well, although in a bigger picture where SQL contains ALL the data for affiliates / casinos / bonuses via web forms reverting back to htaccess redirects becomes less beneficial. Also Adding a simple update line into the above code will also allow you to collect click information per link.
As with any solution there are many different ways to achieve the end result, it all depends on what you want to do 