Applications.ge

Night mode
Sign up
Login
Modules
- Basics of Programming
- Problem Solving
- Git
- HTML
- CSS
- Sass
- JavaScript
- PHP
- Laravel
Meetings
Challenges
Projects
Tutorials
Channels
Notes
Resources

Applications.ge
Modules
- Basics of Programming
- Problem Solving
- Git
- HTML
- CSS
- Sass
- JavaScript
- PHP
- Laravel
Meetings
Challenges
Projects
Tutorials
Channels
Notes
Resources

Results: 1580

Notes

Newest first
Oldest first
Newest first(All)
Oldest first(All)

Set table comment

Sets comment for the specified table to make it easy for other developers what the purpose of this table is

ALTER TABLE `the_table_name` comment 'Some text about the table'

by Valeri Tandilashvili

MySQL

Select table comment

Selects comment of

channels

table which exists in the

geiger

database

SELECT table_comment 
FROM INFORMATION_SCHEMA.TABLES 
WHERE table_schema='geiger' 
    AND table_name='channels'

by Valeri Tandilashvili

MySQL

Table comment

Set column comment

Sets new comment for

name

column in

channels

table

ALTER TABLE `channels` CHANGE `name` `name` varchar(255) COMMENT 'name of channel'

by Valeri Tandilashvili

MySQL

Column comment

Select column comment

Selects

is_optional

column comment which exists in

decorations

table using

information_schema

database

SELECT COLUMN_COMMENT 
FROM information_schema.COLUMNS 
WHERE TABLE_SCHEMA = 'geiger' 
    AND TABLE_NAME = 'decorations' 
    AND COLUMN_NAME = 'is_optional'

by Valeri Tandilashvili

MySQL

Column comment

Select column comment with some other column specifications

Shows details about each column from

decorations

table including column comments

SHOW FULL COLUMNS FROM decorations

by Valeri Tandilashvili

MySQL

Template literals CODE

Template literal syntax uses dollar sign

followed by curly brackets

${expression}

let name = 'George'
let age = 25

document.write(`My name is ${name} and I am ${age} years old!`)

by Valeri Tandilashvili

JavaScript

Template literals

The 10 Days of JavaScript

Shortest way to remove multiple members of array without loops

$arr = ['key0' => 'val0','key1' => 'val1', 'key2' => 'val2', 'key3' => 'val3'];
$removeKeys = ['key1', 'key2', 'key3'];

$arr = array_diff_key($arr, array_flip($removeKeys));

by გიორგი უზნაძე

PHP

Arrays

http / https

If the URL starts with

https

it will make a request on

$ch = curl_init("https://xdatavpn.example.com/Bank");

If it starts with

http

the request will use

port

$ch = curl_init("http://xdatavpn.example.com/Bank");

by Valeri Tandilashvili

PHP

Copy all files and folders to another directory

Copies all files and folders from

source_dir

destination_dir

cp -r /home/user/source_dir/. /var/www/html/destination_dir/

-r

- copies recursively (with subfolders and files)

- copies all files and folders inside the folder

by Valeri Tandilashvili

Linux

call file_get_content() function with headers

First we create an array with the headers

$opts = [
	"http" => [
		"method" => "GET",
		"header" => 
			"Channel-Name: ".CHANNEL."\r\n" .
			"Authorization: ".AUTHORIZATION."\r\n"
	]
];
// Then we create a stream
$context = stream_context_create($opts);

Then we pass the

$content

file_get_contents()

function as the

third

parameter

$result = file_get_contents($url, false, $context);

by Valeri Tandilashvili

PHP

functions

Results: 1580