Monday, February 6, 2017

Clear Laravel configuration cache

php artisan config:clear 

Wednesday, January 4, 2017

Redis stop Redis start

if you have properly installed redis as server just run
sudo systemctl restart redis

If not casually:
to stop redis
redis-cli shutdown 
to start redis
redis-server

Saturday, December 31, 2016

Laravel insert ignore check if inserted (affected rows for insert ignore)

Halo guys!
if you break your head for finding solution to check if row is inserted here is the way

$query = "INSERT INTO table (id) VALUES (?)";
    try {
        DB::insert($query, array($value));
        return 1;
    } catch (\Exception $e) {
        return 0;
    }

The solution is simle - not use insert ignore. So we are catching exception instead of fatal erroring and know if it did or not.
You can even do query builder insert instead of raw query.

Thursday, December 22, 2016

Sunday, November 13, 2016

SQL select where join not existed; Select where can't join

SELECT t1.ID
FROM Table1 t1
    LEFT JOIN Table2 t2 ON t1.ID = t2.ID
WHERE t2.ID IS NULL
source: http://stackoverflow.com/a/4076157/1767461

Wednesday, October 5, 2016

Installing mail (sendmail) Ubuntu 16

sudo apt-get install sendmail
And now you can send mails easy with tls enabled without any other bullshit configs