Skip to content

Instantly share code, notes, and snippets.

View theking2's full-sized avatar
🎯
contemplating the odds

Johannes kingma theking2

🎯
contemplating the odds
View GitHub Profile
@theking2
theking2 / array-replace.json
Created March 25, 2023 09:02
replace array() wih []
[{
"command": "array.replace",
"args": {
"info": "replace array() with []",
"find": "([\s\r\n])array\(([\s\r\n]*[^()\s](?:[^()]*[^()\s])?[\s\r\n]*)\)",
"replace": "$1[$2]",
"all": true,
"reg": true,
"flag": "gm"
}
@theking2
theking2 / docker-compose.yaml
Created March 25, 2023 09:13
Wordpress on mysql 5.6
version: "3"
# Defines which compose version to use
services:
# Services line define which Docker images to run. In this case, it will be MySQL server and WordPress image.
db:
image: mysql:5.7
# image: mysql:5.7 indicates the MySQL database container image from Docker Hub used in this installation.
restart: always
environment:
MYSQL_ROOT_PASSWORD: MyR00tMySQLPa$$5w0rD
@theking2
theking2 / docker-compose.yaml
Created March 25, 2023 15:49
Wordpress mit mariadb latest
version: "3"
# Defines which compose version to use
services:
# Services line define which Docker images to run. In this case, it will be MySQL server and WordPress image.
db:
image: mariadb:latest
restart: always
environment:
MYSQL_ROOT_PASSWORD: MyR00tMySQLPa$$5w0rD
MYSQL_DATABASE: MyWordPressDatabaseName
@theking2
theking2 / gist:f12f45afb40209e8262ac583032ebdea
Created April 3, 2023 11:37
wordpress-mariadb-phpmyadmin
version: "3"
# Defines which compose version to use
services:
# Services line define which Docker images to run. In this case, it will be MySQL server and WordPress image.
db:
image: mariadb:10.4
restart: always
environment:
MARIADB_ROOT_PASSWORD: MyR00tMySQLPa$$5w0rD
MYSQL_DATABASE: wordpress
/* DEVSENSE */
"[php]": {
"editor.defaultFormatter": "DEVSENSE.phptools-vscode"
},
"php.format.codeStyle": "PSR-2",
"php.format.rules.arrayInitializersNewLineAfterLastElement": true,
"php.format.rules.callParametersNewLineBeforeRightParen": true,
"php.format.rules.spaceBeforeColonInControlStatements": true,
const style = document.createElement('style');
document.haad.appendChild(style);
const styleSheet = style.sheet;
styleSheet.insertRule('h1{font-size:123px;}');
@theking2
theking2 / gist:fe206ad6377cfed97b92b6a2ae336051
Created January 1, 2024 19:39
Calculate storage of DECIMAL(m,d)
Storage of `DECIMAL(_m_,_d_)` can be calculated with this function:
```sql
DELIMITER $$
CREATE FUNCTION `fn_DECIMAL_SIZE`(`M` INT, `D` INT) RETURNS int(11)
DETERMINISTIC
BEGIN
set @m = m;
set @d = d;
@theking2
theking2 / notify.js
Last active September 29, 2024 13:35
JS Notification
/**
* class NotificationAlert asks for notification
* permission and shows notifications or alerts
*/
class NotificationAlert {
#title
constructor(title) {
this.#title = title;
this.#askNotificationPermission();
}
@theking2
theking2 / settings.inc.php
Created January 27, 2024 16:14
php settings
<?php
if( !defined( 'ROOT' ) ) {
define( 'ROOT', $_SERVER[ 'DOCUMENT_ROOT'] . '/' );
}
if(!defined( 'SETTINGS_FILE' ) ) {
define('SETTINGS_FILE', ROOT . 'settings.ini' );
}
if( !defined( 'SETTINGS') ) {
@theking2
theking2 / gist:c31ba732ccc7c8bc8bc08b037d40c4f3
Created February 5, 2024 19:30
HTTP - Responses Methods
| method | response code | reason |
| - | - | - |
| * | 500 | internal error, the request is not processd, the response paylood might include more detail |
| * | 502 | request validated but upstream service were not available. Request was not fullfilled|
| * | 405 | request not validated or allowed |
| * | 403 | the request validated but was not allwowed, reason in payload |
| HEAD | 200 | success |
| POST | 201 | rsourcce created,payload contains the id and a identifying url |
| POST | 303 | resource is availabel unique url|