Sunday, November 24, 2019

php 7.3 compact() undefined variable

If you have used compact and upgraded php to 7.3 you maybe noticed warnings when variable is not defined.
PHP 7.3 made compact function strict and it will throw warnings.

Quick dirty solution:
Replace
compact
with

@compact

Normal solution:

Replace compact with array. It will take time, so if you are in production use quick dirty solution to supress notice, and when you have time make changes.
Here gist https://gist.github.com/AucT/55340f911259fd7a6e9a76b766985c6c  you can use it on any php online website and decompact your function calls.

Sunday, August 11, 2019

Prevent / Defend Against XSS Attack in PHP

Include funtion e. This will escape malicious js stuff.

function e($value)
{
    return htmlspecialchars($value, ENT_QUOTES, 'UTF-8', false);
}

Call function e to the input you need to display. For example

<input type="text" value="<?=e($_GET['q']??'')?>">

Tuesday, August 6, 2019

Create symlink folder

For example we have our folder in /etc/nginx/sites-enabled/example.com
And to make virtual symlink folder here /etc/nginx/sites-available we run this

sudo ln -s /etc/nginx/sites-available/example.com /etc/nginx/sites-enabled/


Thursday, July 25, 2019

Windows cmd for each file in folder do smthing

for %f in (*.*) do echo %f
If there is space in files and you need to call some tool

for %f in (*.*) do call MyTool "%f"

Thursday, February 21, 2019

docker mysql

docker run --name my-mysql -e MYSQL_ALLOW_EMPTY_PASSWORD=yes -p 3306:3306 -d mysql

Tuesday, November 27, 2018

Saturday, November 24, 2018

Import 2G sql file to mysql database

edit my.cnf
my.cnf
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/

[mysqld]
innodb_buffer_pool_size=2048M (50% of your ram)
max_connections=100
key_buffer_size=256M
max_allowed_packet=256M

innodb_buffer_pool_size = 2G
innodb_log_buffer_size = 256M
innodb_log_file_size = 1G
innodb_write_io_threads = 16
innodb_flush_log_at_trx_commit = 0
then
mysql -uroot -p dbname < /var/www/mydb.sql


source: https://dba.stackexchange.com/a/83385/86553