Skip to content

Instantly share code, notes, and snippets.

View nd3w's full-sized avatar

nd3w

1 follower · 1 following
View GitHub Profile
@nd3w
nd3w / php.ini for development
Created April 27, 2019 23:22
PHP configuration for development machine
; 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
@nd3w
nd3w / gist:dde9fa08b51b3b64c23c30c16038c125
Created August 3, 2019 09:12
Important query for MySQL
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 August 19, 2019 03:01
Linux Aliases to Switch Amongs PHP Versions
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 October 24, 2019 06:04
Dynamically binding params in prepared statment
<?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 October 29, 2019 09:00
Installing Wine 4.0 on Ubuntu 18.04 and Linux Mint 19
$ 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 December 5, 2019 01:06
Horizontally and vertically center div in a page
<!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 / install-gimp-ppa.txt
Last active June 3, 2020 00:58
Install GIMP 2.10 on Ubuntu 18.04
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
@nd3w
nd3w / Youtube Iframe
Created March 25, 2021 04:11
Iframe without right click, etc, could be work for Youtube addresses only.
<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%"
@nd3w
nd3w / multimedia-on-linux.md
Created July 29, 2021 01:16
Multimedia on Linux

Disabling webcam on Linux

sudo modprobe -r uvcvideo

Enabling webcam on Linux

sudo modprobe uvcvideo

@nd3w
nd3w / nginx-tips.md
Created October 22, 2021 01:20
Nginx Tips and Tricks

Version of Nginx

sudo nginx -v

Version and Enabled modules

sudo nginx -V

Configuration test