Skip to content

Instantly share code, notes, and snippets.

@nd3w
nd3w / php.ini for development
Created Apr 27, 2019
PHP configuration for development machine
View php.ini for development
; For dev only
expose_php=Off
log_errors=On
error_log=/var/log/httpd/php_scripts_error.log
file_uploads=On
;open_basedir="/var/www/html/"
error_reporting = E_ALL
; Should be 'off' on prod server
allow_url_fopen=On
View gist:dde9fa08b51b3b64c23c30c16038c125
Get how many rows in whole database
SELECT SUM(TABLE_ROWS)
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'db_name';
@nd3w
nd3w / gist:ff2b06464121d1aabec7287f37f00d1a
Last active Aug 19, 2019
Linux Aliases to Switch Amongs PHP Versions
View gist:ff2b06464121d1aabec7287f37f00d1a
Assuming I have three different PHP versions on my system:
1. PHP 5.6
2. PHP 7.1
3. PHP 7.2
To switch two between versions, add these aliases into your ~/.bashrc file:
alias php5671='sudo a2dismod php5.6 ; sudo a2enmod php7.1 ; sudo service apache2 restart ; echo 2 | sudo update-alternatives --config php'
alias php5672='sudo a2dismod php5.6 ; sudo a2enmod php7.2 ; sudo service apache2 restart ; echo 3 | sudo update-alternatives --config php'
@nd3w
nd3w / Binding_params.php
Last active Oct 24, 2019
Dynamically binding params in prepared statment
View Binding_params.php
<?php
$array = [1,2,3,4,5,6,7];
$count_array = count($array);
$placeholders = implode(',', array_fill(0, $count_array, '?'));
$query = $DB->Prepare('
SELECT id, name
FROM table_name
WHERE id IN (' . $placeholders . ')
');
@nd3w
nd3w / install-wine4-ubuntu18.04.txt
Last active Oct 29, 2019
Installing Wine 4.0 on Ubuntu 18.04 and Linux Mint 19
View install-wine4-ubuntu18.04.txt
$ sudo dpkg --add-architecture i386
$ sudo apt update
$ wget -qO- https://dl.winehq.org/wine-builds/Release.key | sudo apt-key add -
$ sudo apt-add-repository 'deb http://dl.winehq.org/wine-builds/ubuntu/ bionic main'
$ sudo apt update
@nd3w
nd3w / horizontal-vertical-center.html
Last active Dec 5, 2019
Horizontally and vertically center div in a page
View horizontal-vertical-center.html
<!DOCTYPE html>
<html>
<head>
<title>The Center </title>
<link href="https://fonts.googleapis.com/css?family=Open+Sans:400,700" rel="stylesheet">
<style>
html, body {
height: 100%;
}
@nd3w
nd3w / xfce-panel-icon-size.md
Last active May 31, 2020
How to change XFCE panel's of notify and audio icon size
View xfce-panel-icon-size.md

This is a way to change notify and audio icon size for XFCE panel:

Create or edit ~/.config/gtk-3.0/gtk.css, and add these two selectors:

#pulseaudio-button * {
        -gtk-icon-transform: scale(.55);
}

#xfce4-notification-plugin * {
@nd3w
nd3w / install-gimp-ppa.txt
Last active Jun 3, 2020
Install GIMP 2.10 on Ubuntu 18.04
View install-gimp-ppa.txt
Installing:
open a terminal and type:
sudo add-apt-repository ppa:otto-kesselgulasch/gimp
sudo apt-get update
sudo apt-get install gimp
Removing:
open a terminal and type:
sudo apt-get install ppa-purge
sudo ppa-purge ppa:otto-kesselgulasch/gimp
View My Linux Setting Collection
Turn on touchpad: xinput set-prop 15 "Device Enabled" 1
Turn off touchpad: xinput set-prop 15 "Device Enabled" 0
@nd3w
nd3w / Youtube Iframe
Created Mar 25, 2021
Iframe without right click, etc, could be work for Youtube addresses only.
View Youtube Iframe
<iframe
id="068a380a-add0-4954-b0fb-b25884efab81"
class="c-hero-media__video js-hero-player"
data-youtube-api="https://www.youtube.com/iframe_api"
data-youtube-id="-q7UBPU0MYI"
frameborder="0"
allowfullscreen="1"
allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture"
title="YouTube video player"
width="100%"