1Mar19 - Tips carousel
https://www.w3schools.com/howto/howto_js_quotes_slideshow.asp


https://github.com/yii2mod/yii2-cart
<?= Html::a('<i class="fa fa-fw fa-user"></i> Sign Up',['site/signup'], ['class' => 'btn btn-black', 'title' => 'Sign Up']) ?>

## Font sizing on ALL pages beginning with Index
box-content
	<p class="gcinc_font15">
################

Add Yii2 JUI
composer require --prefer-dist yiisoft/yii2-jui


##########
GII
https://getcentered.co.za/abc/index.php/gii/


@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
 
show create PROCEDURE `GetShortUrl`(longUrl text, urlLength int)
BEGIN
DECLARE shortUrl varchar(20) default '';
DECLARE count int;
DECLARE urlChar varchar(2);
DECLARE loopCount int default 0;
DECLARE randStatus int;


select floor(10000 * rand() + 100) into randStatus;
update short_key set status = randStatus where status = 0 limit 1;
select short_key into shortUrl from short_key where status = randStatus limit 1;
update short_key set status = 1 where status = randStatus limit 1;
insert into short_url(short_url, long_url, allocation_date, expiry_date) values (shortUrl, longUrl, now(), now() + interval 48 hour);

select shortUrl;
END