Articles & Snippets - negraru - Designer Edmonton

Useful library repository

Posted by Cătălin on Thu, 26 Jan 2017

Useful CDN Javascript and CSS library repository

CDNJS* is a library repository which hosted on cloudflare.com. It’s freely available CDN for common Javascript and CSS libraries. Currently there are 2756 libraries, check it out at: https://cdnjs...

code

Encrypt sensitive data with PHP

Posted by Cătălin on Sat, 7 Jan 2017

Encrypt sensitive data with PHP and MySQL

Class created with construct now add methods to encrypt and decrypt: class Encryption { const CIPHER = MCRYPT_RIJNDAEL_128; // Rijndael-128 is AES const MODE = MCRYPT_MODE_CBC; ...

code

GST/HST calculator

Posted by Cătălin on Tue, 8 Nov 2016

GST/HST calculator to find out the amount of tax that applies to sales in Canada.

Province or territory SelectAlbertaBritish ColumbiaManitobaNew BrunswickNewfoundland and LabradorNorthwest TerritoriesNova ScotiaNunavutOntarioPrince Edward IslandQuebecSaskatchewanYukon...

code

Script to Backup Mysql Databases

Posted by Cătălin on Mon, 31 Oct 2016

Shell Script to Backup Mysql Databases, you can keep as many versions as you like

Create a cron with this script to backup your databases: #!/bin/sh # List of databases to be backed up separated by space dblist="DATABASE1 DATABASE2 DATABASE3" # Directory for backups backupdir=/PATH/FOR/MYSQL/BACKUPS/gz ...

code

Archive with tar excluding certain files/folders

Posted by Cătălin on Wed, 26 Oct 2016

Here is how to run the tar command with the --exclude functionality

Here is how to run the tar command with the --exclude functionality tar -czvf backup.tar.gz /path/site.com --exclude='/path/site.com/uploads'

code

Find files containing specific text on Linux?

Posted by Cătălin on Mon, 24 Oct 2016

How to find all files containing specific text on Linux?

How to find all files containing specific text on Linux? grep -rnw '/path/to/folder/' -e "string"

code