const firstName = 'Giorgi';
const job = 'Doctor';
const birthdayYear = 1991;
const currentDate = new Date();
const currentYear = currentDate.getFullYear()

//same results but different syntax

const giorgisInfo = "I'm " + firstName + ', a ' + (currentYear - birthdayYear) + ' year old ' + job + '!';
console.log(giorgisInfo)
//----------------
const giorgisInfoNew = `I'm ${firstName}, a ${currentYear - birthdayYear} year old ${job}!`
console.log(giorgisInfoNew)

//SPREAD, because on RIGHT side of =
const arr = [1, 2, ...[3, 4]]

//REST because on LEFT side of =
const [a, b, ...others] = [1, 2, 3, 4, 5];

console.log(a, b, others);   //result: 1 2 (3)[3, 4, 5]

console.log('---- OR ----');
console. log(3 || 'Jonas');     //result:3
console.log('' || 'Jonas');     //result:Jonas
console.log(true || 0);         //result:true
console.log(undefined || null); //result:null

console.log(undefined || 0 || '' || 'Hello' || 23 || null); //result:Hello
console.log('---- AND ----');
console. log(0 && 'Jonas');     //result:0
console. log(7 && 'Jonas');     //result:Jonas

console.log('Hello' && 23 && null && 'Jonas'); //result:null

SELECT table_schema "database", sum(data_length + index_length)/1024/1024/1024 "size in GB"
FROM information_schema.TABLES GROUP BY table_schema;

SELECT table_schema 'database', ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
FROM information_schema.tables
GROUP BY table_schema;

SELECT table_schema,
ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
FROM information_schema.tables WHERE table_schema='DB_NAME'
GROUP BY table_schema ;

SELECT TABLE_SCHEMA AS DB_Name, count(TABLE_SCHEMA) AS Total_Tables, 
SUM(TABLE_ROWS) AS Total_Tables_Row, 
ROUND(sum(data_length + index_length)/1024/1024) AS "DB Size (MB)", ROUND(sum( data_free )/ 1024 / 1024) AS "Free Space (MB)"
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'DB_NAME'
GROUP BY TABLE_SCHEMA ;

SELECT 
    COUNT(*)
FROM
    customers;

SELECT 
    'customers' tablename, 
     COUNT(*) rows
FROM
    customers 
UNION 
SELECT 
    'orders' tablename, 
     COUNT(*) rows
FROM
    orders;

$users

"score"

$users = array(
    [
        'id' => 1, 
        'name' => 'vighac tipovichi', 
        'score' => 90
    ],
    [
        'id' => 2, 
        'name' => 'sxva tipson', 
        'score' => 100
    ],

);

array_sort($users, 'score', SORT_DESC)

function array_sort($array, $on, $order=SORT_ASC){
    $new_array = array();
    $sortable_array = array();

    if (count($array) > 0) {
        foreach ($array as $k => $v) {
            if (is_array($v)) {
                foreach ($v as $k2 => $v2) {
                    if ($k2 == $on) {
                        $sortable_array[$k] = $v2;
                    }
                }
            } else {
                $sortable_array[$k] = $v;
            }
        }


        switch ($order) {
            case SORT_ASC:
                asort($sortable_array);
            break;
            case SORT_DESC:
                arsort($sortable_array);
            break;
        }

        foreach ($sortable_array as $k => $v) {
            $new_array[$k] = $array[$k];
        }
    }
  return $new_array;
}

usort

function custom_sort_users($a, $b) {
        if ($a['score'] == $b['score']) {
                return 0;
        }
        return ($a['score'] > $b['score']) ? -1 : 1;
}
usort($users, "custom_sort_users");

usort($users, function($a, $b){
    if ($a['score'] == $b['score']) {
            return 0;
    }
    return ($a['score'] > $b['score']) ? -1 : 1;
});

db_backup.sql

public_html/

zip -r db_backup.sql public_html/

zipped.zip

unzip zipped.zip

sql.zip

/var/www/

use.ge

root

scp sql.zip root@use.ge:/var/www/

scp /var/www/sql.zip root@use.ge:/var/www/

scp /var/www/sql.zip root@167.172.187.21:/var/www/

root

testdirectory

sudo mkdir testdirectory

file.zip

some_folder

sudo mv file.zip some_folder/

file.zip

some_folder