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 / My Linux Setting Collection
Last active December 21, 2022 23:58
Touchpad
Turn on touchpad: xinput set-prop 15 "Device Enabled" 1
Turn off touchpad: xinput set-prop 15 "Device Enabled" 0
Mount flashdisc
umask=0,nosuid,nodev,nofail,x-gvfs-show,x-gvfs-name=Kingston,noauto
Setup Linux Mint Screensaver
Disable Screensaver
@nd3w
nd3w / list-of-codec-playable-or-unplayable.txt
Created January 8, 2023 14:29
List of Codec that Playable or Unplayable on Cooca TV USB Media Player
Video (playable)
H264 MPEG-4 AVC (part 10) (avc1)
Audio (playable)
MPEG AAC Audio (mp4a)
Audio (unplayable)
A52 Audio (aka AC3)
@nd3w
nd3w / install-a-laravel-app-into-a-shared-hosting-per-openai.md
Last active March 20, 2023 03:20
Install a Laravel App into a Shared Hosting per OpenAI

Install a Laravel App into a Shared Hosting per OpenAI

When I asked ChatGPT how do I deploy a Laravel app into a shared hosting, here's its answer:

Here are the general steps to follow in order to install a Laravel application into a shared hosting:

  1. Prepare the Laravel Application: First, you need to prepare your Laravel application for deployment by running the following commands in your terminal:
composer install --optimize-autoloader --no-dev
@nd3w
nd3w / mysql-to-excel.md
Last active March 24, 2023 14:33
Export MySQL data to Excel file using phpSpreadsheet according Chat GPT

To export data from MySQL to Excel using phpSpreadsheet, you can follow the steps below:

  1. Connect to the MySQL database using PHP.
    $servername = "localhost";
    $username = "yourusername";
    $password = "yourpassword";
    $dbname = "yourdbname";

    // Create connection
@nd3w
nd3w / mysql-queries.md
Last active April 3, 2023 08:23
Collection of useful MySQL queries

List of table's names only

SELECT `COLUMN_NAME` 
FROM `INFORMATION_SCHEMA`.`COLUMNS` 
WHERE `TABLE_SCHEMA`='db name' 
    AND `TABLE_NAME`='table name';

Select all rows with the same value

SELECT e1.*

@nd3w
nd3w / javascript-to-check-double-click.md
Last active May 20, 2023 00:44
JavaScript to check for double click 
<input type="submit" name="value(submit)" value="Continue" onDblClick="fncDoubleOut();">
<input type="button" name="value(submit)" value="Cancel" onclick="cancel_onclick();" onDblClick="fncDoubleOut();">
function fncDoubleOut(){
   alert('Your transaction is being processed. Thank you.');
   return false;
}
@nd3w
nd3w / LibreOfficeCalcFormulasAndTips.md
Last active June 14, 2023 12:51
LibreOffice Calc Formulas and Tips

Calculate average value from B2 to B32 with B24 to B32 are blanks:

=SUM(B2:B32)/(ROWS(B2:B32)-COUNTBLANK(B2:B32))

or simply:

=AVERAGE(B2:B32)
@nd3w
nd3w / install-lapp-ubuntu-20.04.md
Last active December 11, 2023 04:00
Install Apache2, PostgreSQL and PHP-FPM on Ubuntu 20.04

Install Apache2, PostgreSQL and PHP-FPM 8.2 on Ubuntu 20.04

Install Apache

sudo apt install apache2

sudo ufw app list

sudo ufw allow in "Apache"
@nd3w
nd3w / php-snippets.md
Last active March 15, 2024 15:45
PHP Snippets

Dump all PHP variables

$all_vars = get_defined_vars();
print_r($all_vars);

Create an array for a range (e.g: array with number from 1 to 9)

$number = 9;

for ($i = 1; $i <= $number; ++$i) {

@nd3w
nd3w / linux-commands.txt
Last active April 2, 2024 07:40
A Collection of Useful Linux Commands
Backup with bunzip
tar cvfj file.tar.bz2 *
tar cvfj file.tar.bz2 /path/to/directory_to_backup/
Extract from bunzip to directory 'archive'
tar -xvf archive.tar.bz2 ./
Compress multi directories into each own compressed files
for i in */; do zip -r "${i%/}.zip" "$i"; done
for i in */; do tar -czvf "${i%/}.tar.gz" "$i"; done