php truncateTextByWords(string $string, int $maxWords = 10): string
return preg_replace(‘/((\w+\W*){‘ . ($maxWords – 1) . ‘}(\w+))(.*)/’, ‘${1}’, $string)
Category: dev
php locale month
var_dump((function (): string { setlocale(LC_TIME, ‘de_DE’); return date(‘F’, mktime(0, 0, 0, (int)date(‘m’))); })());
script src=”./path/to/assets/js/script.js”>
(function () { var randoms = Math.ceil(Math.random() * 1000000000); var someJs = “./path/to/assets/js/script.js?r=” + randoms; window.onload = function() { var script = document.createElement(‘script’); script.src = someJs; document.body.appendChild(script); } }());
SQL kill query via hint/comment directly in the query
— Kill the query after 1,000 milliseconds SELECT /*+ MAX_EXECUTION_TIME(1000) */ * FROM t1 INNER JOIN t2 WHERE … dev.mysql.com/blog-archive/server-side-select-statement-timeouts/
js strip tags
el = el.replace(/(]+)>)/gi, “”).trim();
load .env via .bashrc
if [ ! -f ~/.env ] then set -o allexport source ~/.env set +o allexport # export $(cat ~/.env | xargs) # alternative fi
show ip
$(ip route show | awk ‘/default/ {print $3}’)
javascript twitter export follow(ers/ing)
var ttResultsList = []; var currentPosition = -1; function exportTT() { let cList = []; if (currentPosition < window.scrollY) { window.scrollTo(0, document.body.scrollHeight); for (const d of document.querySelectorAll(‘div[data-testid=”UserCell”]’)) { let img = d.getElementsByTagName(‘img’)[0].src; let usr =…
last updated database / mysql
SELECT MAX(UPDATE_TIME) as lastUpdate, TABLE_SCHEMA FROM `TABLES` GROUP BY TABLE_SCHEMA