arnisjuraga

apt update
apt install php-intl #needed by default
php-sqlite3 #needed by default configuration for tests - uses sqlite 

composer create-project codeigniter4/appstarter myfirstproject
cd myfirstproject
composer require myth/auth:1.*@dev

arnisjuraga

#
# Documented from https://stackoverflow.com/questions/9446783/remove-definer-clause-from-mysql-dumps
#

cat backupfile.sql | sed -e 's/DEFINER[ ]*=[ ]*[^*]*\*/\*/' | sed -e 's/DEFINER[ ]*=[ ]*[^*]*PROCEDURE/PROCEDURE/' | sed -e 's/DEFINER[ ]*=[ ]*[^*]*FUNCTION/FUNCTION/' > result.sql

#
#
#

arnisjuraga

/*

Function converts encoded HTML entities back to HTML tags in pure MySQL

-- Original method: https://stackoverflow.com/a/41460016/1720476 
-- @Balmiopour comment added https://stackoverflow.com/questions/3678980/is-there-a-mysql-function-to-decode-html-entities#comment71742861_41460016

Version history:

arnisjuraga

<?php

/*
Credits: https://stackoverflow.com/a/10872110/1720476 
e.g. I need to search, if given string suffix characters (starts with) "allowed" characters. 

$allowed = [ 'LV', 'LT' , 'IBAN' ];
$given = 'LViban8500';
*/

arnisjuraga

TODO: automated script

Regex search-replace

Static variables echo

# Strings

arnisjuraga

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console